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.
Reconciling Bank Account won't zero out
Moderators: Moderators, Tech Support
Re: Reconciling Bank Account won't zero out
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?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.
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.
Using PC+ since 1999.
-
- Posts: 16
- Joined: Tue Jan 21, 2020 8:39 am
Re: Reconciling Bank Account won't zero out
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.
I'm to the point where I want to delete all the transactions and start all over again.
-
- Posts: 16
- Joined: Tue Jan 21, 2020 8:39 am
Re: Reconciling Bank Account won't zero out
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.
-
- Tech Support
- Posts: 3105
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Reconciling Bank Account won't zero out
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.
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.
-
- Posts: 16
- Joined: Tue Jan 21, 2020 8:39 am
Re: Reconciling Bank Account won't zero out
Thank you so much for your help!!! I have spent hours trying to find my problem and it was something simple.