ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Accounting >> Bank Rec Balance changed & no uncleared checks
http://www.istechforum.com/YaBB.pl?num=1444158790

Message started by JereC on 10/06/15 at 12:13:10

Title: Bank Rec Balance changed & no uncleared checks
Post by JereC on 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'

Title: Re: Bank Rec Balance changed & no uncleared checks
Post by David Waldmann on 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).

Title: Re: Bank Rec Balance changed & no uncleared checks
Post by JereC on 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'

Title: Re: Bank Rec Balance changed & no uncleared checks
Post by David Waldmann on 10/07/15 at 08:10:05

JereC wrote:

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.

Title: Re: Bank Rec Balance changed & no uncleared checks
Post by Lynn_Pantic on 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.

Title: Re: Bank Rec Balance changed & no uncleared checks
Post by 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 reconciliation,

Jere

Title: Re: Bank Rec Balance changed & no uncleared checks
Post by David Waldmann on 10/07/15 at 13:01:52

JereC wrote:

Sounds like it.

JereC wrote:

...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.

Title: Re: Bank Rec Balance changed & no uncleared checks
Post by JereC on 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