Most people know by now, that you can paste into NAV pages from Excel, and typically this is used for populating journals, but a further use for this is for importing electronic bank statements when you can’t be bothered to go through all the faff of setting it up formally. Here a quick how to guide as to how to do this:
- Copy a blank line out of the Bank Statement side of the Bank Reconciliation page into Excel to make a template,
- Download your bank statement in csv format and open in Excel,
- Copy the columns from the statement into the right place on your template
- Copy the data and Paste Rows into your Bank Reconciliation.
Simple and effective!