Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
unidentified user
blackfoot1221
Posts: 1
Registered: 02-01-2012
0

Bank Reconciliations

I need help importing transactions into MAS500 from a bank download, specifically clearing checks.  Every time I try to import a file I get an error message.  Has anyone had any success with this?  Currently we have to manually reconcile them which takes a lot of time due to the volume of checks to clear.

 

Also has anyone had any success reconciling bank accounts on a daily basis?

 

Thanks,

Contributor
snolte
Posts: 30
Registered: 08-03-2011
0

Re: Bank Reconciliations

I can't comment for importing transactions, but we do reconcile our bank account daily.  When we set up the batch at the beginning of the month, we put the ending date for the month in as the Post and Ending Statement dates, so that we see all required transactions.  Each day, we update the ending balance to match our online banking, post any new transactions for fees, customer receipts, etc, and then go in and check off the cleared cheques, etc.  If there's a variance we make a note of the item that is missing and keep a folder of them for review.  At the end of the month we're only reconciling a day.

 

Good luck!


Sarah

unidentified user
Shin
Posts: 1
Registered: 02-16-2012
0

Re: Bank Reconciliations

Instruction for importing is found at http://www.blytheco.com/pdf/bes/bes_v6.1/manuals/Data_Import.pdf. (see chapter 9)

 

I followed the instruction and was able to "import" but no transactions were matched.

I made sure to follow all the instructions and transaction numbers do match with what's in the system but no luck as of yet.