Balance Sheet does not match with bank statement

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
koofah
Posts: 5
Joined: Wed Oct 08, 2008 12:41 pm
Location: COLUMBUS

Balance Sheet does not match with bank statement

Post by koofah »

Hi folks,
I have reconciled my accounts records with the bank statement. however when i run a balance sheet report, there is a difference. Now the difference amounts exactly to the unreconciled checks that have not been presented at the bank and therefore not in the statement. I need your help to fix this issue. Thanks
All Nations Baptist Church
Columbus.
PowerChurch User Since 2009

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Balance Sheet does not match with bank statement

Post by JohnDMeyers »

I think you're okay.

If your PowerChurch checking balance is $3,000.00, and you have cut $500.00 in checks that haven't cleared the bank, and there are no outstanding deposits, your bank statement should show $3,500.00.

When you reconcile in PowerChurch, you would show this:

Bank statement balance: $3,500.00
- outstanding checks: $500.00
+ outstanding deposits $0.00
---------------------------------
Adjusted bank balance $3,000.00
Account 1110 balance $3,000.00
------------------------------------
To balance $0.00

Note: Your bank statement shows $3,500 and your 1110 balance shows $3,000, and you are all set.

unless...

I misunderstood what you were asking.
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

Kristi
Posts: 133
Joined: Tue Feb 10, 2004 9:24 am
Location: Lea Joyner UMC Monroe, LA
Contact:

Re: Balance Sheet does not match with bank statement

Post by Kristi »

After you reconcile; when you run your balance sheet, run it for the next month.
Example:
You reconcile October;then run your Bank Reconciliation Report (will be for Oct), Check Register (Unreconciled checks: Jan-the date you Rec.'d, ie 1/1-11/6 on mine) & your Nov. Balance Sheet.

Your Adjusted bank balance on your Bank Rec. should match:
Check Register (Unrec.'d) Ending Balance
Balance Sheet Checking Account Balance

I hope this helps you,
Kristi
"Trust in the Lord with all your heart and lean not on your own understanding." Proverbs 3:5

Post Reply