Reconciliation Redo

[yoknox]

All previous reconciliations through 11/16 have reconclled accurately. December's however presents a huge problem. I have gone over it redoing about 11-12 times and the to balance figure remains the same. I have checked, doubled checked and on for errors but the data is accurate. I spoke with tech support and was given the same problem solving ideas I already have tried. Every void at the top has a corresponding entry at the bottom. I have converted this to a spreadsheet and by setting the voids aside am able to come to the correct amount in the debits and credits on the bank statement. Therefore I am at a loss at what to do or why it won't reconcile. I have even reinstalled the program thinking the program was at fault. I have reindexed also. The tech told me I can reconcile more than once so I went back to previous entries where the entry date was in another month and a void was done The entries did appear there so I can redo in that month as opposed to December whatever good that will do; however, I can't use the original bank statement ending balance as this throws off the to balance figure. The same things occurs if 0 is used. In addition to above issues, what bank balance is used. Thank you.

[NeilZ]

All previous reconciliations through 11/16 have reconclled accurately. December's however presents a huge problem. I have gone over it redoing about 11-12 times and the to balance figure remains the same. I have checked, doubled checked and on for errors but the data is accurate. I spoke with tech support and was given the same problem solving ideas I already have tried. Every void at the top has a corresponding entry at the bottom. I have converted this to a spreadsheet and by setting the voids aside am able to come to the correct amount in the debits and credits on the bank statement. Therefore I am at a loss at what to do or why it won't reconcile. I have even reinstalled the program thinking the program was at fault. I have reindexed also. The tech told me I can reconcile more than once so I went back to previous entries where the entry date was in another month and a void was done The entries did appear there so I can redo in that month as opposed to December whatever good that will do; however, I can't use the original bank statement ending balance as this throws off the to balance figure. The same things occurs if 0 is used. In addition to above issues, what bank balance is used. Thank you.

OK ... lets just work on December. Before you do anything, MAKE A BACKUP of the Accounting files using the Powerchurch backup utility, then

1. Clear all the checks and deposits that appear on the statement, DO NOT reconcile any original check if it was voided. From what you said, this should balance to zero.

2. Then start with the first void, clear it from the top of the screen, then do down to the check portion and clear the original check. Each time you clear the void and the matching original, your balance should be zero.
If at any time this does not happen, click on POSTPONE, then go to View Posted Transactions and look up the original check, then the void. Make sure that the amounts are the same, and the debits and credits on the original check, are reversed on the void. From the sound of it, there is an amount mismatch somewhere.

Let us know what you find.

[tborgal]

The other possibility is that there is a bank fee or credit that is on the statement that has not been entered into PC+. There is also the remote chance that the bank has made a mistake with one of your deposits or checks.

[tborgal]

Just saw your post about a problem with payroll. Could this be related to the reconciliation issue you are having?

[bjsbrown65]

Thanks for your replies. No don't believe connected to the payroll issue as it is only for $134. The difference in the reconciliation is 4844.78. I've had problems reconciling before but nothing this difficult. Doesn't seem to be a bank error. I can add the figures on the reconciliation screen at top to match the appropriate entries at the bottom. Everything at the top matches the bottom included voids. I can actually come up with the bank's debit and credit figures on the bank statement. I have matched the system's bank account report with the reconciliation and it matches with what was cleared and what is pending(not cashed). I've used the check register to compare and found nothing there. I m stumped.

P.S. if anyone notices the sign in name is different, had to use a different account.

[NeilZ]

Thanks for your replies. No don't believe connected to the payroll issue as it is only for $134. The difference in the reconciliation is 4844.78. I've had problems reconciling before but nothing this difficult. Doesn't seem to be a bank error. I can add the figures on the reconciliation screen at top to match the appropriate entries at the bottom. Everything at the top matches the bottom included voids. I can actually come up with the bank's debit and credit figures on the bank statement. I have matched the system's bank account report with the reconciliation and it matches with what was cleared and what is pending(not cashed). I've used the check register to compare and found nothing there. I m stumped.

P.S. if anyone notices the sign in name is different, had to use a different account.

OK ..
1. Everything matches both top and bottom
2. The bank's statement date and end-of-month balanced was entered properly


I take it that you removed the checkbox from the Only show items dated before statement date and there's nothing there that would account for the $4,844.78.

[bjsbrown65]

I went thru as you suggested and checked off everything on bank statement, credits and debits. The figures at the bottom of the screen for the credits and debit were exactly as the bank statement; however the figures at the left bottom did not show 0. I believe this is the key. Why wouldn't it show 0. I proceeded to check off the voids which matched perfectly at the top and bottom with the balance continuing to show the 4844.78.

[NeilZ]

I went thru as you suggested and checked off everything on bank statement, credits and debits. The figures at the bottom of the screen for the credits and debit were exactly as the bank statement; however the figures at the left bottom did not show 0. I believe this is the key. Why wouldn't it show 0. I proceeded to check off the voids which matched perfectly at the top and bottom with the balance continuing to show the 4844.78.

Did you remove the checkmark from the top of the window?

Is this amount over what the bank lists, or under? In other words, does the bank show more and the system shows less, or vice versa? Were there any transfers made from fund to fund, say from a savings in one fund to the checking in operations?

As this happened for the first time this month, it may behoove you to wait until the end of January's bank reconciliation to see what happens at that time.

[bjsbrown65]

what area are you referencing about the bank showing more or system less, etc. not quite understanding. There were some transfers made but they add up to the corresponding entries correctly. An example is that we pay the salary of the preschool director and then transfer the $ from her account which is maintained as a separate fund acccount. Both the salary and the payment entry agree.

[NeilZ]

what area are you referencing about the bank showing more or system less, etc. not quite understanding. There were some transfers made but they add up to the corresponding entries correctly. An example is that we pay the salary of the preschool director and then transfer the $ from her account which is maintained as a separate fund acccount. Both the salary and the payment entry agree.

What I'm asking is this ... you're saying that the To balance does not equal zero. Just above that you'll see the Account 1110 Balance and the Adjusted balance.

The adjusted balance is the bank balance minus any outstanding checks, and any outstanding deposits. If the account 1110 balance is over the adjusted balance, then Powerchurch is showing more money than what has actually been spent, which usually means there is a check missing from the system. If the bank shows more money than the Account 1110 balance, then there's a deposit missing.

Which is it?

[bjsbrown65]

the account 110 balance is over the adjusted balance. I have searched many times and not able to locate the discrepancy. If I make an adjustment with checking and unrestricted net assets, what will it affect other than to balance.

[NeilZ]

the account 110 balance is over the adjusted balance. I have searched many times and not able to locate the discrepancy. If I make an adjustment with checking and unrestricted net assets, what will it affect other than to balance.

So the system is showing more than the bank does. I would not do any type of adjustment until you try the reconciliation next month. I've often seen a fix done to correct a imbalance one month, mess up the reconciliation the next month.

That said, I would look VERY closely at any funds transfers between funds that may or may not have been correctly formatted.

[yoknox]

Neil - if I go back to the first reconciliation, there is a large to balance. Is this figure for the month I'm looking at or the total amount to balance throughout the coming months?

[NeilZ]

Neil - if I go back to the first reconciliation, there is a large to balance. Is this figure for the month I'm looking at or the total amount to balance throughout the coming months?

FWIW ... if the previous months are reconciled and cleared properly, you shouldn't have to go back to touch them. May I ask why you are doing this?

[bjsbrown65]

just looking to try to determine problem. restoring backup afterwards