Welcome, Guest. Please Login.
06/03/25 at 00:03:18
News:
Home Help Search Login


Pages: 1
Send Topic Print
Bank Reconcilition Mishap (Read 605 times)
springproducts
Browser
*




Posts: 8
Gender: female
Bank Reconcilition Mishap
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)?
Back to top
 
 

Kristi G.
Email   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Bank Reconcilition Mishap
Reply #1 - 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
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
springproducts
Browser
*




Posts: 8
Gender: female
Re: Bank Reconcilition Mishap
Reply #2 - 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?
Back to top
 
 

Kristi G.
Email   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Bank Reconcilition Mishap
Reply #3 - 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
 
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
Pages: 1
Send Topic Print