Bank Rec Import

Hello,

I am a new user of SAGE and have just started working as  a Controller for a small company.  The current practice in our business is to reconcile the bank everyday.  In that we download all of our bank transactions and then one by one go through and do those transactions in SAGE.  Manual Checks, Cash Receipts, Ledger Entries, etc.  I come from a very large company, used to using Oracle, but either way, I cannot imagine we are doing this the most efficient way.  Spending 20 minutes each morning to do a bank rec on 5 or 6 transactions seems crazy to me.  In addition to this we maintain a separate spreadsheet to make sure the balance of our bank account in Sage matches up with that of our bank.  

I really am looking for some sort of benchmark process.  Is it possible to import transactions from a bank as opposed to manually entering them one by one?  Can one of you who has a good process maybe give me some insights into what it is that you do that makes it run smoothly? 

Thank you in advance for the feedback. 

  • 0
    Bank rec in Sage is a mess, really not well done. I've written something in Access for one of my clients to help reconcile. It imports the bank info and matches up automatically as best it can. Checks of course are no problem (they don't even use Sage's Auto Check Rec) , and most deposits match up automatically. The usual problem with deposits is if UPS collected a bad check or the cash receipts entry clerk didn't enter the credit card receipts for the day as one batch.

    The end result after the auto matching is usually a list of all the bank drafts that get done by different vendors or scheduled payments our bank makes. That list tells shows all the bank wire transactions they have to enter to get caught up. It took a lot of work to get to this point but the Access program has taken 90% of the time and work out of it.