How to import a bank statement?
To import a bank statement, please follow the steps provided below:
- Go to the Banking tab and select the appropriate bank account.
- Click Import Statement button in the bank transaction list page
- Select the Choose File option and select your file to be uploaded. You can import the statements in seven file formats - CSV, TSV, XLS, OFX, QIF, CAMT.053 and PDF.
- Click the dropdown under the Amount Column Type section:
- Select Double Column if your import file has two different columns recording deposits and withdrawals in it.
- Select Single Column and Amount Type if your import file has a single column indicating a debit (withdrawal) or a credit (deposit) transaction and a separate column for the amount.
- Select Single Column with Negative Values if your import file has just one column where positive values indicate deposits and negative values indicate withdrawals.
- Select the encoding of your choice and click Next.
- Match the fields with the Import File Headers and hit Next.
If a file has two columns:
If a file has one column and amount type:
If a file has one column and negative values:
- Check the preview and select Import.