Import bank statements
The bank's statement lines come into Finday, ready to reconcile.
Before you start
- A bank account in Cash & Bank.
- The statement from internet banking as CSV, Excel or PDF.
Steps
Step 1: Open the Bank statements tab
In Cash & Bank, open the bank account, choose the Bank statements tab, then click Upload statement.
Screenshot coming soon
The Bank statements tab of a bank account with the Upload statement button.
Step 2: Choose the statement file
In the Import bank statement dialog, click Choose file and pick one or more CSV, Excel or PDF files. Download template is there for the CSV format.
Screenshot coming soon
The Import bank statement dialog with the upload box and the Download template button.
Step 3: Click Apply import
The statement lines appear in the list. Continue to the Reconciliation tab to match them.
Screenshot coming soon
The list of bank statement lines after the import.
When you are done
- Lines from CSV and Excel appear straight away. PDFs are read in the background; follow them in the import history.
- The statement lines are ready to match in the Reconciliation tab.
Common problems
The file type is not supported
Use CSV, XLS, XLSX or PDF. For a bank format that is not read, copy the lines into the CSV template.
A PDF shows Needs attention
Open the import history and click Retry extraction, or delete the import and upload a CSV or Excel file.
Something still unclear?
Ask us on WhatsApp. The Finday team replies during office hours and can walk you through it in your own account.