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:

 

Just:

  • 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!