What is a CSV file?
CSV stands for Comma-Separated Values. It's a simple file format used to store tabular data, like a spreadsheet, in plain text. Each line in the file represents a row, and each value is separated by a comma.
Can I use a CSV file from Internet Banking?
Unfortunately, each bank formats their CSVs differently, so you will need to open it up in Excel or Google Sheets to re-format it the way payPod expects.
We recommend you use an OFX export from your internet banking when available - most banks provide this. The OFX import does not require manual processing, unlike CSV.
Expected CSV format:
To import transactions into the system, your CSV file must follow this exact format, with the first row as headers:
date,description,amount
13-02-2025,Product purchase,-333.03
12-05-2025,Customer payment,20000.00
- date – The transaction date in DD-MM-YYYY format.
- description – A short description of the transaction.
- amount – The transaction amount. Use a negative number for purchases/payments and a positive number for income. Use a period (full stop) to designate the cents.
Exporting to CSV from a Spreadsheet (Without Quotes or Extra Formatting)
From Microsoft Excel
- Format your sheet with the column headers: date, description, amount
- Go to File > Save As
- Choose a save location
- In Save as type, select: CSV (Comma delimited) (*.csv)
- Click Save
From Google Sheets
- Format your sheet with the column headers: date, description, amount
- Click File > Download > Comma-separated values (.csv, current sheet)