Importing a Bank Statement

Before you can reconcile a bank account, its bank statement lines need to be in Aedon.Accounting. There are three ways to get them in:

• Automated bank feed: if the bank account is connected to a bank feed, statement lines come in automatically at around 8am, 11am and 3pm every day. Feeds are available for current accounts, credit cards and PayPal. The feed times can be changed, but this is a job for your Salesforce administrator, as it means adjusting the scheduled Apex jobs that collect the feed.
• Import a file: download a CSV from your online banking, convert it to the Aedon template and import it.
• Add a line manually: for the odd line that is missing from a feed or file.

Each statement line comes in separately, and the bank account’s Statement Balance is the total of all its lines.

Import a bank statement file

1. Prepare the file

1. Download the statement from your online banking as a CSV file.
2. In Aedon, open Aedon.Bank, click Bank Accounts, open the bank account and click the Bank Feeds tab.
3. Click Import, then click Download Aedon Template⁽¹⁾.
4. Copy your bank’s data into the template so that it has exactly these five columns: Date, Code, Description, Receipt and Payment.

2. Import the file

1. In the Import Bank Statement window, check the Bank Account Name, Sort Code and Account Number are for the right account.
2. Click Browse⁽²⁾ and choose your CSV file.
3. Click Import⁽³⁾.
4. Check the new lines on the Bank Feeds tab, and check that the Statement Balance equals the closing balance on your bank statement.

Only import each statement once. Importing the same lines again creates duplicates, and the Statement Balance will no longer agree with your bank.

Add a statement line manually

1. On the bank account’s Bank Feeds tab, click New.
2. Enter the Date, Code and Description exactly as they appear on the bank statement, and the amount in either Receipt or Payment⁽¹⁾.
3. Click Save⁽²⁾.

Lines added manually show Manual in the Source column, so they can be told apart from imported lines.

If the import doesn’t work

• Check that the column headings are exactly Date, Code, Description, Receipt, Payment.
• Check the dates are DD/MM/YYYY and the amounts have no commas, currency symbols or zeros in the empty column.
• Check the file is saved as a CSV and not an Excel workbook.

Still not importing? If you have checked the file and it still won’t import, please raise a case, attaching the file you are trying to import, and our support team will help.

Setting up a new bank account? The opening balance is entered separately. Please raise a case and our support team will help you add it.

Related articles

• Bank Statements
• Bank Reconciliation Process
• Bank Account