Bank Statement Import from Excel and CSV
Statement import reads the Excel or CSV file that the bank exports, one account at a time, so nothing is retyped. Duplicate lines from overlapping date ranges are ignored.
Where the file comes from
Every bank exports a slightly different sheet, and the file is read as it comes, so nobody reformats columns before matching begins. The current account, the overdraft account and each branch account are loaded separately, and each keeps its own record of what went in and when.
What the import does
Before the first statement goes in
Set-up is done on the client’s own months of statements, and not on a demonstration company with figures that were made up for the purpose.
- Three months of old statements, read to write the matching rules
- Opening unmatched items decided one by one with the accountant
- Each bank account mapped to the ledger name the books use
- Every import logged with the name of whoever ran it
Frequently asked questions
Can it pull the statement from the bank by itself?
No, not on its own. A live feed needs the bank’s own corporate arrangement, which many small firms do not have. Where one exists, reading it is a separate integration. Otherwise the downloaded file works with any bank.
Will a file with a heading block and merged cells read?
Usually. The heading rows are skipped once the layout is mapped at set-up. If the bank changes its export later, the mapping is updated and the download stays the same.
Can two years of old statements be loaded?
Yes, as far back as they can be downloaded. Somebody still has to decide what the old unmatched lines were, and that decision belongs to the accountant.
Tell us what you need.
Share your requirements and one of our engineers will come back to you within one business day.
- No obligation
- A reply within one business day
- Your details stay private
Start with your requirements
Seven short steps that tell us what you need. An engineer reads them before getting in touch.
Share your requirements