Bank rec discrepancy

[whfpc]

I have an issue with a discrepancy on a check. The check was written (and shows recorded in PC in payroll on the report) for $1479.17, the bank statement also shows the correct amount $1479.17 but in the bank rec in powerchurch it shows $1479.67. Am I missing something?

Robin

[NeilZ]

I have an issue with a discrepancy on a check. The check was written (and shows recorded in PC in payroll on the report) for $1479.17, the bank statement also shows the correct amount $1479.17 but in the bank rec in powerchurch it shows $1479.67. Am I missing something?

Robin

Did you look at the Posted Transactions for this check? Does it show 1479.67? I suspect something changed after the posting from Payroll to Funds Accounting.

[whfpc]

yes it shows the $1479.67? How was it changed?

Robin

[NeilZ]

yes it shows the $1479.67? How was it changed?

Robin

The only way this could have been done is if someone edited it, the system does not change data by itself.

[whfpc]

where would this editing be done? I am really new to all of this and I am not even sure how I would have done it, then how would I correct it on reconciliation, I am drawing a blank, probably making it too difficult in my own head

[NeilZ]

where would this editing be done? I am really new to all of this and I am not even sure how I would have done it, then how would I correct it on reconciliation, I am drawing a blank, probably making it too difficult in my own head

It would have been done in the Modify Unposted Transactions function under Funds Accounting.

What I would do is this:
1. Verify what Payroll says SHOULD be on the check (deductions, etc)
2. Reverse the exiting payroll transaction in Funds Accounting from the View Posted Transactions function. You will get a notice about the transaction coming from Payroll, and you should fix it there (something like that). Since Payroll is right, click on YES as you want to reverse it here. Enter in the note area WHY you have reversed the transaction, give as much information as possible for your auditor.
3. If you can screen print the entire transaction do so, as most of those entries are correct, you just need to find the one that is wrong.
4. Enter a new transaction using the reversed one as an example and correct the amount that made the check incorrect, use the SAME check number as the reversed one. In the note area of the transaction, again include as much information as possible.

When you then go back to do the reconcile, you will have TWO check listings at the bottom of the reconcile window, and ONE void in the Deposits, check them all and you should balance to zero.