How to Reconcile Bank Error

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
Eden Whitehead
Posts: 290
Joined: Tue Aug 21, 2007 5:59 pm
Location: Old Hickory Presbyterian Church Old Hickory, TN

How to Reconcile Bank Error

Post by Eden Whitehead »

The bank recorded a deposit in an amount 6 cents less than what was actually deposited. :( The bank told me that for that small an amount they would not make a correction. :(

What do I do to make my statement reconcile in PC+?

Thanks.
*Still* learning... and gratefully so!

Matt
Authorized Teaching Consultant
Authorized Teaching Consultant
Posts: 733
Joined: Fri Dec 05, 2003 4:04 pm
Location: Jacksonville, AL

Post by Matt »

Eden,

Enter the following transaction in Fund Accounting:

Debit Contribution Income $.06
Credit Checking Account $.06

On the bank reconciliation in PC+ this $.06 will show up as a check. Clear both the $.06 and the original deposit against what the bank recorded to reconcile the records.

Eden Whitehead
Posts: 290
Joined: Tue Aug 21, 2007 5:59 pm
Location: Old Hickory Presbyterian Church Old Hickory, TN

Post by Eden Whitehead »

matt wrote: Enter the following transaction in Fund Accounting:

Debit Contribution Income $.06
Credit Checking Account $.06

On the bank reconciliation in PC+ this $.06 will show up as a check. Clear both the $.06 and the original deposit against what the bank recorded to reconcile the records.
Matt,

I entered the transaction as you instructed above. The bank statement reconciled perfectly. However, now my Cash Management Report is off by $0.06! (It may be that I didn't make clear in my original post that the correct amount of the contribution deposit had been debited to the checking account.) So, how do I get the Cash Management Report to balance with the checkbook register?

Thanks once again.
*Still* learning... and gratefully so!

Eden Whitehead
Posts: 290
Joined: Tue Aug 21, 2007 5:59 pm
Location: Old Hickory Presbyterian Church Old Hickory, TN

Post by Eden Whitehead »

Ummm, I think I've got it.

The church really did deposit 6 cents more than the bank says it did, but it's such a tiny amount that the church just writes it off/ignores it and I adjust the checkbook register to show a balance 6 cents less than what it shows now.

Is that the solution?

(I'll take a "no answer" as meaning this is correct.)

Grace and peace.
*Still* learning... and gratefully so!

Matt
Authorized Teaching Consultant
Authorized Teaching Consultant
Posts: 733
Joined: Fri Dec 05, 2003 4:04 pm
Location: Jacksonville, AL

Post by Matt »

Yes. You must be keeping an offline check register because I tested this situation in the program and couldn't figure out how you were getting the result you described.

Eden Whitehead
Posts: 290
Joined: Tue Aug 21, 2007 5:59 pm
Location: Old Hickory Presbyterian Church Old Hickory, TN

Post by Eden Whitehead »

Yes. Sorry I didn't make clear from the beginning that I was talking about an offline checkbook register. Thanks for taking the time to reply. I can stop grieving now over this tiny little discrepancy. :roll:
*Still* learning... and gratefully so!

Post Reply