Beginning Bank Reconciliation

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
tstar
Posts: 4
Joined: Fri Dec 07, 2007 11:24 pm

Beginning Bank Reconciliation

Post by tstar »

During accounting setup, I entered the beginning checking account balance (as per bank statement). My first attempt to perform a bank reconciliation is leaving me with a non-zero "To Balance" total. I'm quite confident in my data entry and ending balances (using an established Quicken file). I need to adjust this out of balance total without effecting net equity for that particular bank account such that I achieve a zero "To Balance" value in Bank Reconciliation. Thanks

tstar
Posts: 4
Joined: Fri Dec 07, 2007 11:24 pm

Post by tstar »

After much detective work, I have discovered three checks written in 2006 but not cashed! They total the exact amount of my "To Balance" amount. I still need a correcting entry which does not affect the actual working account balance, but will "erase" the value of these lost checks. Thanks.

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

Post by Matt »

In Fund Accounting enter the 3 checks from 2006, one at a time. Debit an expense account and credit the checking account. Then, enter a deposit for the sum of the 3 checks in Fund Accounting and debit the checking account and credit the same expense account. Post the transactions. Then, go into the bank recon in PC+ and reconcile the deposit entry only. This should bring your bank recon back into balance. The net equity balance in Fund Accounting will be unaffected as the debits and credits will cancel each other out.

Post Reply