Page 1 of 1

Duplicated and posted duplicate check number

Posted: Sat Mar 03, 2018 12:31 pm
by trinityfinance
I have entered two checks with the same check number which I didn't realize until doing bank rec. How can I fix this? The checks have cleared the bank. Only one shows on the Check Register report. I am guessing I would need to delete one then enter as a JE. Is there a better way?

Re: Duplicated and posted duplicate check number

Posted: Sat Mar 03, 2018 1:03 pm
by NeilZ
pattyvons wrote:I have entered two checks with the same check number which I didn't realize until doing bank rec. How can I fix this? The checks have cleared the bank. Only one shows on the Check Register report. I am guessing I would need to delete one then enter as a JE. Is there a better way?
I'm going to assume that you're using v11.1/11.5 or V12, and you enter the check via Accounts Payable.
You say only one appears in the check register are you talking about the Bank Listing, or the list in the Reconciliation window? If you dont' see the check in the Reconciliation windows, what does it show in the Posted Transactions? Have you checked the VENDOR record in question to see what the HISTORY says about the check. If you indeed see the additional check listed in the ReconciliationWindow, Posted Transactions, and in the VENDOR history then ..

You can do the following, again before you do anything, make a backup of the ACCOUNTING files using the Powerchurch backup system. This way you can roll back any changes if they do not appear correct:

1. Go into Accounts Payable -> Void a Check
2. Enter the number of the check in question, and click the NEXT button
3. You will probably see both checks listed, the good one and the one using the same number.
4. Select the check that is using the wrong number and VOID it.
5. Go into Manual Checks, you wlll see the voided check with the check number and -VOID next to it (IE: 333-VOID)
Write down the vendor ID, amount, and accounts used, then ADD a new Manual Check.
6 For the REFERENCE you're going to use the ACTUAL check number that was sent to the vendor. That is if the voided check number was 333, and the one you actually sent was 334, enter 334. Then fill in the rest of the information. Use the SAME DATE as the date of the original check. Then save it.
7. Post both MANUAL CHECKS to Funds Accounting.
8. Then post both of these Unposted Transactions to the correct month. If the checks were written in February, post to February.
9. Then open up the Reconciliation function. You should see both checks in the bottom half along with the added manual check, you'll also see the void in the top half of the window (IE: 333-VOID). Make sure you select both when you reconcile as they cancel out each other, and adjust the system properly.

If you DO NOT see the duplicate check anywhere in Powerchurch, then that's a different issue. Let us know what you see.