Welcome, Guest. Please Login.
05/14/25 at 08:34:50
News:
Home Help Search Login


Pages: 1
Send Topic Print
Bank Rec Balance changed & no uncleared checks (Read 1902 times)
JereC
Member
**


I Love EvoERP!

Posts: 100
Bank Rec Balance changed & no uncleared checks
10/06/15 at 12:13:10
 
In doing Sept. reconciliation I see that my last months uncleared checks are not showing up and my beginning balance does not match the bank statement beginning balance.  It is off exactly the amount of the uncleared checks. If i change the balance in AD-B to the bank rec beginning balance then how do I get the uncleared checks back on the reconciliation to clear off when they go through the bank?   Please advise on how to correct this.
 
Thanks
 
Jere'
Back to top
 
« Last Edit: 10/06/15 at 15:04:44 by JereC »  
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Bank Rec Balance changed & no uncleared checks
Reply #1 - 10/07/15 at 04:59:58
 
If you print a Check Register, does it show those checks as Cleared? There should be either a "T" or nothing on the right hand side under "Cleared?".
 
Assuming they are not Cleared, are you leaving the "From" date at 00/00/00 on the opening screen where you pick the bank account? Or at least before the date of the oldest check?  
 
I always use 00/00/00 as the beginning date to make sure I'm catching everything. I also go at least one business day past the statement date in case some transactions actually happened the day before we expected them (most often that's CC deposits, especially Amx, which we expect to take 3 days but sometimes only takes 2).
 
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
JereC
Member
**


I Love EvoERP!

Posts: 100
Re: Bank Rec Balance changed & no uncleared checks
Reply #2 - 10/07/15 at 07:57:47
 
Thanks, forgot to check the register.  These checks are showing as cleared but they should be on the reconciliation for this month.  Have no idea how I did this but need to get it fixed.
 
Jere'
Back to top
 
 
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Bank Rec Balance changed & no uncleared checks
Reply #3 - 10/07/15 at 08:10:05
 
Quote from JereC on 10/06/15 at 12:13:10:
It is off exactly the amount of the uncleared checks.

 
I think this will work... adjust the "Statement Ending Balance" by that amount. Then you will be at 0, and since the checks were already cleared last month you should be good from here on out.  
 
The only thing I'm not 100% on is that since you'll be saying that the Ending Balance is different, next month the Beginning Balance may be off. However, I think at that time you can correct it by going into AD-B.
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: 5663
Re: Bank Rec Balance changed & no uncleared checks
Reply #4 - 10/07/15 at 08:13:09
 
David is correct, change the Bank Balance in AD-B to match the bank statement ending balance that you have reconciled to so the starting balance for next month is correct.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
JereC
Member
**


I Love EvoERP!

Posts: 100
Re: Bank Rec Balance changed & no uncleared checks
Reply #5 - 10/07/15 at 12:36:29
 
The remaining problem is there are two checks that show cleared however they are not cleared yet.  When they do clear eventually I am assuming I will have to adjust the balance again since I can't get them back on the reconciliation,  
 
Jere
Back to top
 
 
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: Bank Rec Balance changed & no uncleared checks
Reply #6 - 10/07/15 at 13:01:52
 
Quote from JereC on 10/07/15 at 12:36:29:
The remaining problem is there are two checks that show cleared however they are not cleared yet.  When they do clear eventually I am assuming I will have to adjust the balance again since I can't get them back on the reconcilliation...

 
Sounds like it.
 
Quote from JereC on 10/07/15 at 12:36:29:
...and they will show up on my aging report as not paid???

 
You've lost me now. Unless you've voided the check(s) the corresponding invoices should not be on your aging report. Whether a check has been reconciled or not has no effect on aging, because as far as AP goes, those invoices have been paid.
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
JereC
Member
**


I Love EvoERP!

Posts: 100
Re: Bank Rec Balance changed & no uncleared checks
Reply #7 - 10/07/15 at 13:22:42
 
Sorry, I realized they would not be on the aging.  However, they will eventually show up on my bank rec to be cleared and they will not be on my DBA rec.  
 
Jere
Back to top
 
 
  IP Logged
Pages: 1
Send Topic Print