Welcome, Guest. Please Login.
10/31/24 at 17:01:19
News:
Home Help Search Login


Pages: 1
Send Topic Print
What is my real bank balance? (Read 753 times)
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
What is my real bank balance?
04/03/15 at 08:20:26
 
I've struggled with this general question ever since we started using DBA.
 
This year our accountant found something funny and it turned out that a transaction had been entered in GL-B to our cash account, but it was entered as a type GJ so it never showed up on the check register. The reason it didn't red flag us initially is that when it came time to reconcile the check register that month and we couldn't find it, I just assumed the transaction hadn't been entered at all, so it got reentered as a type CD.
 
My accountant was not very thrilled that such a thing could happen. And, considering it, I had to agree. Why are you allowed to make GL Journal entries to the cash account that will not show up on the check register? At least a warning, like it does if you try to select your AP or AR GL Account.
 
Anyways, I made some changes so that the above situation is much less likely to occur.
 
However, just today I found another problem. Haven't figured out where it is yet, but our online bank balance is more than the current GL cash account shows, and there is over $10k of outstanding checks.
 
So, a couple questions:
1. How do I go about trying to find this? We always use the Reconcile feature in Evo at the end of every month. I just reconciled the March statement and it is all balanced.
2. How do others find out what the "current" balance is of a cash account? Printing a check register doesn't do any good - it assumes a 0 balance at the beginning of whatever period you pick.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: What is my real bank balance?
Reply #1 - 04/03/15 at 15:20:34
 
GL-I, Uncleared only, date range 00/00/00 through today, all types will have a beginning balance that matches your reconciled balance from the last reconciled bank statement and then list all your outstanding checks and deposits since the reconciliation resulting in a correct ending balance.  You must be running it some other way if you don't have a beginning balance that ties back to the reconciliation.  You have to use a 00/00/00 start date to get any old uncleared items.  Same thing when you reconcile, you need to use 00/00/00 through statement ending date.    
 
I agree, at least a warning in GL-B when entering a GJ as opposed to CD or CR would be a good idea.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: What is my real bank balance?
Reply #2 - 05/27/15 at 04:57:07
 
Interesting. I never would have guessed that using those options would give me the desired results.
 
Thanks!
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Pages: 1
Send Topic Print