How to Prepare a CSV to Import Transactions into payPod

← Back to Resources

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)

Next Steps

Once you have your CSV file ready, head over to our guide on How to Import & Reconcile a Bank Statement in payPod