Advanced Filter

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries

So this post is the 2nd part of my recent post on how Excel can automate data entry to your accounting system.  See here for Part A.  This example concerns automating entries on your bank statement you can reliably identify.  In my case it was to record bank transfers from my cheque account to an interest …

Save time using Excel Templates to upload to your accounting software – Part B Using Autofilter for bank entries Read More »