Difference in check register and balance sheet

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
Shelley
Posts: 51
Joined: Wed Apr 09, 2008 12:01 pm
Location: Clovis, NM

Difference in check register and balance sheet

Post by Shelley »

I am not an accountant and don't know where to look for discrepancies to correct errors. I am setting up PowerChurch Plus v11. The plan is to compare my data with our previous accountant's data to see that I can run Power Church plus properly and I am decently trained. The other system and bookkeeper are not in the building nor is the other system Power Church Plus. I need some direction in where to look for a difference in report numbers.

The previous accounting system balance sheet shows a checking account balance that matches with my Power Church plus register balance for the same month. Good so far. When I run a Balance Sheet in PowerChurch Plus for the same month, the checking account amount shows $527.51 LESS than the ending amount in the register. What would be causing this? The "total liab & capital" on the previous system balance sheet is $527.51 higher than the 'Total Liabilities and Equity" on the PowerChurch Plus balance sheet. Trying to figure out what is happening, so I can fix it.

I know the previous system was not using pass-thru contributions. Would this account for the difference in the checkbook register and the balance sheet report total? My pass-thru contributions only total $331.60, so I am uncertain if that is a contributing factor or not.

Blessings,
Shelley

Zorak
Tech Support
Tech Support
Posts: 3111
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Difference in check register and balance sheet

Post by Zorak »

The difference between the Check Register and most other Fund Accounting reports is that the Check Register pulls solely by the date of the transaction, whereas almost all others, including the Balance Sheet look solely at the posting month of the transaction.

You can enter a transaction dated 3/9/2011 and post it to February 2011's business.

Look through your posted transactions in that particular month and you will find one or more transactions where the date and month do not line up and add up to $527.51

Shelley
Posts: 51
Joined: Wed Apr 09, 2008 12:01 pm
Location: Clovis, NM

Re: Difference in check register and balance sheet

Post by Shelley »

That was so totally awesome! Thanks. Found two transactions. It is amazing what a little accounting knowledge will do. I feel so less inadequate. :)

Post Reply