Bank Reconciliation

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
Monica_S
Posts: 6
Joined: Thu May 20, 2021 3:10 pm

Bank Reconciliation

Post by Monica_S »

Hi,
I am having trouble with the bank reconciliation.

I forgot that I was reconciling a previous month and went ahead and posted the transactions for the next month.

Now I have two months under reconciliation, and even though the numbers match the bank statement, when I want to reconcile for ONE month, I have outstanding checks, deposits, and an amount to balance because there's two months or "statements" in there.

I thought I could reconcile either way, but it gives me a message: "WARNING: your reconciliation is not in balance"

is there any way to fix this? :(

NeilZ
Posts: 10464
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Bank Reconciliation

Post by NeilZ »

Monica_S wrote:
Wed Dec 22, 2021 4:59 pm
Hi,
I am having trouble with the bank reconciliation.

I forgot that I was reconciling a previous month and went ahead and posted the transactions for the next month.

Now I have two months under reconciliation, and even though the numbers match the bank statement, when I want to reconcile for ONE month, I have outstanding checks, deposits, and an amount to balance because there's two months or "statements" in there.

I thought I could reconcile either way, but it gives me a message: "WARNING: your reconciliation is not in balance"

is there any way to fix this? :(
Do you have the checkbox at the top of the Reconciling window checked ?? The one next to the Only show items dated before the statement date label?

If not, you'll get all those transactions dated after the statement date.

It really doesn't hurt to post those transactions if they have been finalized (IE: deposited, checks mailed, etc) as long as that box is checked on the reconcile screen.
Neil Zampella

Using PC+ since 1999.

Monica_S
Posts: 6
Joined: Thu May 20, 2021 3:10 pm

Re: Bank Reconciliation

Post by Monica_S »

Thank you so much for your response.

Yes, the box is checked.

So, if I go ahead and post, will the month reflect those outstanding balances, or will it show as nothing left to balance?

My main concern is that it'll show on the reconciliation of accounts when I finalize and print.

NeilZ
Posts: 10464
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Bank Reconciliation

Post by NeilZ »

Monica_S wrote:
Thu Dec 23, 2021 11:00 am
Thank you so much for your response.

Yes, the box is checked.

So, if I go ahead and post, will the month reflect those outstanding balances, or will it show as nothing left to balance?

My main concern is that it'll show on the reconciliation of accounts when I finalize and print.
Posting this month's transactions will not affect the reconciliation for last month's statement. Just make sure you enter the date of the statement (IE: 2021-11-30) in the opening reconciliation window. With the box checked, only those transactions dated before the statement date will appear. You can then process the statement, the bottom line labeled Difference should always be zero when done. If not, you may have accidentally checked off something so you should verify all the data.
Neil Zampella

Using PC+ since 1999.

Post Reply