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.
- 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.
- 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.
- 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.
- 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.
- 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.”
- Import any missing “AdventistGiving” deposits using the “Import from a File” method.
- Enter any other missing transactions. The memo
should give the actual date of the transaction. Example: “Unentered
2/2/24 Evangelism Allocations”
- Once you achieve a zero difference, Click “OK √” and then “Yes” to
print.
- 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.
WARNING: If you added any offering deposits
(including AdventistGiving) from a previous calendar year, you must
contact tech support for assistance. IRS regulations require that you
provide accurate donation receipts.
Click here for more
topics related to Bank Reconciliation
The original version of this page was provided to Jewel by the
Georgia-Cumberland Conference Audit Team. Created by Linda McCabe.