Bank statements, rules and recording lines
Import your bank's statement file in any common format, let rules record the regular lines, and turn a line into a payment or entry in one click.
This is part of bank reconciliation (the Professional plan and above). Open it from Cash & Bank › Reconcile.
Import a statement
Click Import statement and choose the file you downloaded from online banking:
- Excel or CSV: you tell which column is which once. It is remembered for that bank.
- OFX / QFX: the open financial exchange format, offered by most banks.
- QIF: choose the date order (day or month first) if the dates look wrong.
- CAMT.053: the ISO 20022 XML statement of banks in Europe and elsewhere.
- MT940: the SWIFT statement many banks offer.
These are read for you. Click Check to see the first lines, then Import. Lines already imported are skipped. Lines are matched with your entries by amount, date and reference.
Rules
Some lines have nothing in your books to match: bank charges, interest, card fees, standing orders for rent. A rule records them for you.
- Click Rules and add one. Give a word or two from the description (for example SMS CHARGES), money in or out, and the account it goes to (for example Bank Charges).
- New lines that fit a rule are recorded and matched as they are imported. Apply rules does the same for lines already imported.
- Each rule makes a journal between the bank account and the account you chose, on the line's date.
Record a line
For a line with nothing to match, click Record:
- To an account: for charges, interest or a transfer. Tick Remember to make it a rule, so next month's line is recorded by itself. Numbers like dates and references are left out of the remembered text, because they change every month.
- A customer's payment (money in) or A payment to a supplier (money out): choose them. A payment is recorded that settles their oldest open invoices or bills first. One deposit can settle several invoices, and anything left over stays as an advance.
The line is matched to what you recorded, ready for the reconciliation.