If there is a deposit more than a month old but is still on the bank reconciliation page in Jewel, there is a good chance it is a duplicate. To verify this, check the “Deposit Report” (Reports and Graphs/Deposit) for several weeks surrounding the deposit time period. If you see two deposits that are alike, even if they are not close to each other on the report, (they might even be in different months) you have a duplicate.
NOTE: Duplicate offerings are a problem, because Jewel treats them as legitimate offering deposits, creating duplicate amounts on donor receipts and duplicate tithes and offerings on remittance payments, which your church won’t get back unless the offering is reversed. Because of this, we need to avoid creating them, or fix them as soon as possible when we discover them.
Even if you discover the duplicate before you close a month, you cannot completely delete it on your own, but it can be deleted by your tech support, which is by far the easiest way to fix it. Please ask for help.
Once the month has been closed and reports have been printed and submitted to the board, duplicate offerings need to be reversed, not deleted, which is more time-consuming, but must be done. You can ask for help, but if you wish to reverse it yourself, here are the steps.
Time saving tip #1: Before you start, go to File/File Transfer/Send to Auditor so that you have a backup to revert to in case you have problems and need to start over.
Time saving tip #2: Use your cell phone to take snapshots of each envelope in the offering you are reversing, then enter the reversal names and accounts into Jewel from these snapshots. This will ensure that the reversal is identical to the original.
The next time you reconcile, make sure you check off the duplicate offering and the reversal (minus) offering in the same month. They will cancel each other out and will then disappear from the bank rec page when you finish the reconciliation.
Pro tip: If you need to reverse an Adventist Giving deposit, the easiest way is to import that offering again. Even though Jewel will tell you it is already imported, say “Yes” you want to do it again. Then edit the offering total to be a negative number. Go into “Edit Deposit Slip” and put a minus in front of every check. Then do the same with every amount on every envelope. Once every number is a minus number, you should get the message that the amounts equal the total. Then you can follow #15, 16 and 17 to finish and close.
NOTE: It is much easier to avoid duplicates than to reverse them. Jewel will let you know if you are about to enter an offering with the same total as one you have already entered. If you see that message, don’t just ignore it and keep going. Click on “No” and go figure out if it is, in fact, a duplicate.
Click here for more topics related to Making Corrections
The original version of this page was provided to Jewel by the Georgia-Cumberland Conference Audit Team. Created by Linda McCabe.