Reconciling When Months Behind

Catching up on bank reconciliations when you are months behind is really not any different than the usual monthly reconciliation process. You just need to reconcile repeatedly, once for each month.

NOTE: You should not attempt to reconcile by combining several months in one bank rec. Each month is to be reconciled separately, chronologically, from the first one all the way up to the current month. Follow these steps carefully. Being very systematic and deliberate will save time in the long run, as will reconciling each month before you close, once you are caught up.

1. Go to the Jewel Home Screen, then choose “Reconcile”. Next, double-click on the bank account you need to reconcile.
   • The "Last Reconciliation" box tells you the date of the most recent bank reconciliation. The next month to reconcile, will be one month after that Last Reconciliation date.
2. Enter the correct “ENDING DATE” from the next Bank Statement to be reconciled. Edit the date in Jewel if it is not the correct final day of the month that is next to be reconciled.
3. Double check the “BEGINNING BALANCE” for the month you are reconciling, on the statement, then in Jewel, to verify that they match. If they do not, verify that you have the correct bank statement. If they still don't match, contact your support person for assistance.
4. Find the “ENDING BALANCE” on the bank statement and enter it in Jewel. Sometimes the statement calls it “Current Balance” or “Final Balance” or something similar, but it will be in the top section of the statement where the month’s checks and deposits are summarized.
5. Using the correct Bank Statement, reconcile each “behind” month as you normally would.
   • Enter missed checks into the current month, even though they were originally dated in a previous month. Put the original check date in the memo line.
   • Adjust any checks or deposits that don’t match the statement.
   • If you find an offering deposit that has been missed, follow instructions here. Do not enter it as a “General Journal Entry.” Then, if the missed offering is in a previous calendar year, contact tech support for assistance.
   • Import any missing “AdventistGiving” deposits using the “Import from a File” method. Then, if the missed offering is in a previous calendar year, contact tech support for assistance.
   • Enter any other missing transactions. The memo should give the actual date of the transaction. Example: “Unentered 2/2/24 Evangelism Allocations”
6. Once you achieve a zero difference, Click “OK √” and then “Yes” to print.
7. Double-click on the account you need to reconcile again, and continue reconciling each month, one by one, using the above instructions, until you are caught up. Any missing transactions from those previous months will show up in the current month “Check” or “Deposit Reports.”

If you are unsure of your skill level, contact your support person for assistance.

NOTE: The entries you make as you are catching up (such as missed offerings or AdventistGiving Reports) might add to your current month remittance. Jewel will take care of it automatically. Just remit as usual when it is time.