Reconciling Bank Account won't zero out

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
Jesus Rules
Posts: 16
Joined: Tue Jan 21, 2020 8:39 am

Reconciling Bank Account won't zero out

Post by Jesus Rules »

We are new to PC and i'm trying to reconcile for January however I can't get it to zero out and I don't know what I'm doing wrong.
We have PC Plus version 12.

NeilZ
Posts: 10435
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Reconciling Bank Account won't zero out

Post by NeilZ »

Jesus Rules wrote:We are new to PC and i'm trying to reconcile for January however I can't get it to zero out and I don't know what I'm doing wrong.
We have PC Plus version 12.
Quick question .. how much are you off? Are you seeing more in Powerchurch or more in the bank? Are you sure you've posted everything from Accounts Payable, Contributions, and Payroll?

OK ... the first step is to use a paper copy of the bank statement, then check off every check and deduction you see in the Powerchurch reconciliation screen, then do the same with your deposits. Verify each amount to make sure it is what the bank shows as clearing.

Then see if there's anything listed on the bank statement which was not seen in Powerchurch. One of the things often seen is that if the bank charges any kind of service charge, that has not been entered into Powerchurch.
Neil Zampella

Using PC+ since 1999.

Jesus Rules
Posts: 16
Joined: Tue Jan 21, 2020 8:39 am

Re: Reconciling Bank Account won't zero out

Post by Jesus Rules »

I'm off by $2903.27 Looking at the balances on the bottom, I have the bank statement balance, the outstanding checks and no outstanding deposits. I have the adjustments, PC Balance and the difference. The book states if they don't match to go to the Check Register by Fund report. I did that and I don't know what to do with it. I have checked all the debits and credits and the numbers all seem correct.

I'm to the point where I want to delete all the transactions and start all over again.

Jesus Rules
Posts: 16
Joined: Tue Jan 21, 2020 8:39 am

Re: Reconciling Bank Account won't zero out

Post by Jesus Rules »

I just found where the difference is, it was my outstanding checks from December that I cleared. We started with January so in the set up I put in my balance for December and also put in outstanding checks for December. Now the balance showing is those cleared December checks. Do you know a way to get them off? I don't want to carry them over forever. I already closed out December.

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

Re: Reconciling Bank Account won't zero out

Post by Zorak »

You can enter an adjusting transaction to adjust the balance up (or down) in that account by $2903.27. Since it is a problem with the beginning balance that was entered, the offsetting debit or credit in the transaction would be the unrestricted equity (AKA fund balance/net assets) 3110 account.

To add to the bank balance, the transaction would look something like this:

01-1110-000 Checking (Debit) $2903.27
01-3110-000 Unrestricted Equity (Credit) $2903.27

To lower the balance, the debit and credit would be reversed.

Jesus Rules
Posts: 16
Joined: Tue Jan 21, 2020 8:39 am

Re: Reconciling Bank Account won't zero out

Post by Jesus Rules »

Thank you so much for your help!!! I have spent hours trying to find my problem and it was something simple.

Post Reply