twelve days of tes mass (5)

Day 9 –


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!