ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Bank Reconcilition Mishap
http://www.istechforum.com/YaBB.pl?num=1179345585

Message started by springproducts on 05/16/07 at 12:59:45

Title: Bank Reconcilition Mishap
Post by springproducts on 05/16/07 at 12:59:45

The company I work for has been using DBA Classic since 2002. Originally they had their bank account with Sterling, but now have an account through Compass. The bank reconciliations have never been done in DBA.

I just started working here in April and this is my first time using DBA, so please, bear with me. I might be asking a simple question, but I have been searching for an answer and have not found one - that's why I'm here.

When you pull up the check register to show the Sterling account - a lot of the Compass checks/deposits show up as Sterling transactions. When you pull up the check register to show the Compass account, obviously a lot of transactions are missing.

How can I accurately reconcile these two accounts? I have not attempted anything in DBA yet, because I have assumed that once I do one reconciliation, my beginning/ending balances (for bank statement purposes) will be saved.

Is there any way to go back and change the bank account (for the transactions that should have been posted to Compass but posted to Sterling instead)?

Title: Re: Bank Reconcilition Mishap
Post by JNAPIER on 05/16/07 at 13:52:47

You can change the accounts in a couple of ways. You can use Maintain DataBase on BKGLCHK and change the field for account number to the correct account. You can also make entries in GL-B to type 2 or 3 to move the monies from one account to the other. Don't use a type 1 for this. Yhose do not get posted to the reconcile file.

John

Title: Re: Bank Reconcilition Mishap
Post by springproducts on 05/16/07 at 14:22:54

Thank you for such a quick reply!

I am quickly learning with DBA to always double check . . .

If I change everything to the correct account under Maintain Database - BKGLCHK, is this the only location or is there any other file that I would also need to correct the information in?

Title: Re: Bank Reconcilition Mishap
Post by JNAPIER on 05/17/07 at 15:24:59

If the wrong account was used for a cash receipt or dispersment, your GL cash account balance will be off also. If that is the case, I would do a GL-B to move monies into the proper GL account.

The bank account # is used in many files and keyed for reports. Using MDB for a lot of transactions would be a bad idea.

John