Bank G/L & S/L do not agree

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
LPBC
Posts: 1
Joined: Wed Mar 11, 2015 11:01 am

Bank G/L & S/L do not agree

Post by LPBC »

We have just started using PowerChurch accounting system. I set up all the accounts with zero balances and then entered a j/e for the beginning balances based on auditor's trial balance report. At the end of January (yes I'm re-entering 2015 data to ensure it matches our old system) the trial balance shows a bank balance of $52,235.28 (G/L) but on the bank rec it shows the account balance as $53,972.69 (S/L) a difference of $1,763.31. Any idea how to trace this difference. A manual bank rec agrees to the G/L balance.

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

Re: Bank G/L & S/L do not agree

Post by Matt »

I have a feeling that this difference is because you have some deposits and/or checks posted in PowerChurch with a date that is later than the date you are using when running the bank reconciliation. For example, there is a check dated February 3 that has been posted but you are using January 31 as the date to run the reconciliation. To get the two numbers to agree uncheck the "Only show items dated before statement date" checkbox when running the reconciliation.

Post Reply