Jewel - User contributions [en]

Offering Deposit Corrections in Auditor

2026-05-01T03:37:59Z

Myla: /* Cancel an Unfinished Offering */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then click on a donation that's included in the deposit you're correcting, or
# Deposit report, click on the deposit you're correcting, then on Make Corrections (bottom center of the window).

'''If the treasurer uses the Deposit Slip feature,''' click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

'''If the treasurer does not use the Deposit Slip feature,''' check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that may be acceptable.

==Cancel an Unfinished Offering==
Treasurers can cancel an unfinished offering themselves, following the instructions [[Correcting Offering Deposits In the Current Month|here]].

Or you can go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:36:03Z

Myla: /* Reversing a Deposit */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then click on a donation that's included in the deposit you're correcting, or
# Deposit report, click on the deposit you're correcting, then on Make Corrections (bottom center of the window).

'''If the treasurer uses the Deposit Slip feature,''' click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

'''If the treasurer does not use the Deposit Slip feature,''' check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that may be acceptable.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:34:35Z

Myla: /* Incorrect Deposit Account, or Memo */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then click on a donation that's included in the deposit you're correcting, or
# Deposit report, click on the deposit you're correcting, then on Make Corrections (bottom center of the window).

'''If the treasurer uses the Deposit Slip feature,''' click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

'''If the treasurer does not use the Deposit Slip feature,''' check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:34:26Z

Myla: /* Incorrect Deposit Account, Date, or Memo */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then click on a donation that's included in the deposit you're correcting, or
# Deposit report, click on the deposit you're correcting, then on Make Corrections (bottom center of the window).

'''If the treasurer uses the Deposit Slip feature,''' click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

'''If the treasurer does not use the Deposit Slip feature,''' check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:33:21Z

Myla: /* Incorrect Deposit Totals */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then click on a donation that's included in the deposit you're correcting, or
# Deposit report, click on the deposit you're correcting, then on Make Corrections (bottom center of the window).

'''If the treasurer uses the Deposit Slip feature,''' click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

'''If the treasurer does not use the Deposit Slip feature,''' check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, Date, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:32:43Z

Myla: /* Incorrect Deposit Totals */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then click on a donation that's included in the deposit you're correcting, or
# Deposit report, click on the deposit you're correcting, then on Make Corrections (bottom center of the window).

===If the treasurer uses the Deposit Slip feature===
Click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

===If the treasurer does not use the Deposit Slip feature===
Check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, Date, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:31:53Z

Myla: /* Incorrect Deposit Totals */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then click on a donation that's included in the deposit you're correcting, or
# Deposit report, click on the deposit you're correcting, then on Make Corrections (bottom center of the window).

Now, you need to know whether you use Jewel's Deposit Slip feature. If you enter the number of coins and bills in each deposit, then you do use this feature. If you simply enter the total amount of the deposit, you do not use the Deposit Slip feature.

===If you use the Deposit Slip feature===
Click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

===If you do not use the Deposit Slip feature===
Check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, Date, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:31:24Z

Myla: /* Incorrect Deposit Totals */

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then go to either:
# Contribution report, then clicking on a donation that's included in the deposit you're correcting, or
# Deposit report, clicking on the deposit you're correcting, then Make Corrections (bottom center of the window).

Now, you need to know whether you use Jewel's Deposit Slip feature. If you enter the number of coins and bills in each deposit, then you do use this feature. If you simply enter the total amount of the deposit, you do not use the Deposit Slip feature.

===If you use the Deposit Slip feature===
Click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

===If you do not use the Deposit Slip feature===
Check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, Date, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-05-01T03:29:29Z

Myla:

As always, remember to do your best to leave an audit trail. Keeping donor receipts correct is important, so that's a common exception to the "don't make corrections in closed months" rule. But memos should still be added/edited or notes written on printed reports whenever possible.

==Incorrect Offering Date==
If the correction is in the current month, use the front end. Or teach the treasurer to do it themselves in Jewel.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then either:
# Contribution report, then clicking on a donation that's included in the deposit you're correcting, or
# Deposit report, clicking on the deposit you're correcting, then Make Corrections (bottom center of the window).

Now, you need to know whether you use Jewel's Deposit Slip feature. If you enter the number of coins and bills in each deposit, then you do use this feature. If you simply enter the total amount of the deposit, you do not use the Deposit Slip feature.

===If you use the Deposit Slip feature===
Click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

===If you do not use the Deposit Slip feature===
Check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, Date, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Send/Receive Issues in Auditor

2026-05-01T02:26:04Z

Myla: /* Database Uploads from Auditor to Wrong Server */

==Auditor Can't Access the Server==
Assuming your internet connection is not the problem, you most likely need to go to Maintenance / Properties / Internet tab and enter your Auditor username and password. If you don't know your username and/or password, ask your conference treasurer, who will either provide it to you or get it for you from Jewel's conference tech support. If you are a Jewel Tech Support contractor and don't know your password, contact Myla.

==Database Uploads from Auditor to Wrong Server==
This is not an issue for conference users, but only for Jewel Tech Support contractors who use the "Universal" version of Auditor and can access servers for various conferences. If a database from a conference with a Jewel contract defaults to the Universal server, the EntityID needs to be set. See [[Beginning Balances and Other Setup Issues]].

There are a few users whose EntityIDs direct them to a specific conference's server, but that conference no longer has a contract with Jewel (NV-UT is the most common culprit). The solution is to a) remove the EntityID as it really doesn't do any good when not connected to a particular conference anyway, or b) be careful to change the server setting from NV-UT to Universal every time you upload. If it gets sent to the NV-UT server, the treasurer cannot download it, so they will receive an older file and then panic because all their information is "lost".

==File Sent By Treasurer Isn't On the Server==
If a treasurer has sent their file and received confirmation that the file was received by the Jewel server, but you don't see it, then the file is on a different server. Ask the treasurer what conference name they see in the lower left corner of their Jewel Home Page, just above their church name. If there is no conference name there, they have the "Universal" version of Jewel, which is correct if their conference does not have a contract with Jewel. If their conference does have a contract with Jewel, then it should have their conference's name.

Treasurers who have the wrong version of Jewel should get the correct version as soon as possible, so that their backup files and remittance reports go to the correct conference. The old version will need to be uninstalled, then the correct version installed. This shouldn't affect the database, but always back up just in case.

Send/Receive Issues in Auditor

2026-05-01T02:25:13Z

Myla: /* File Sent By Treasurer Isn't On the Server */

==Auditor Can't Access the Server==
Assuming your internet connection is not the problem, you most likely need to go to Maintenance / Properties / Internet tab and enter your Auditor username and password. If you don't know your username and/or password, ask your conference treasurer, who will either provide it to you or get it for you from Jewel's conference tech support. If you are a Jewel Tech Support contractor and don't know your password, contact Myla.

==Database Uploads from Auditor to Wrong Server==
This is not an issue for conference users, but for Jewel Tech Support contractors who use the "Universal" version of Auditor and can access servers for various conferences. If a database from a conference with a Jewel contract defaults to the Universal server, the EntityID needs to be set. See [[Beginning Balances and Other Setup Issues]].

There are a few users whose EntityIDs direct them to a specific conference's server, but that conference no longer has a contract with Jewel (NV-UT is the most common culprit). The solution is to a) remove the EntityID as it really doesn't do any good when not connected to a particular conference anyway, or b) be careful to change the server setting from NV-UT to Universal every time you upload. If it gets sent to the NV-UT server, the treasurer cannot download it, so they will receive an older file and then panic because all their information is "lost".

==File Sent By Treasurer Isn't On the Server==
If a treasurer has sent their file and received confirmation that the file was received by the Jewel server, but you don't see it, then the file is on a different server. Ask the treasurer what conference name they see in the lower left corner of their Jewel Home Page, just above their church name. If there is no conference name there, they have the "Universal" version of Jewel, which is correct if their conference does not have a contract with Jewel. If their conference does have a contract with Jewel, then it should have their conference's name.

Treasurers who have the wrong version of Jewel should get the correct version as soon as possible, so that their backup files and remittance reports go to the correct conference. The old version will need to be uninstalled, then the correct version installed. This shouldn't affect the database, but always back up just in case.

Send/Receive Issues in Auditor

2026-05-01T01:46:50Z

Myla: /* Can't Access the Server */

==Auditor Can't Access the Server==
Assuming your internet connection is not the problem, you most likely need to go to Maintenance / Properties / Internet tab and enter your Auditor username and password. If you don't know your username and/or password, ask your conference treasurer, who will either provide it to you or get it for you from Jewel's conference tech support. If you are a Jewel Tech Support contractor and don't know your password, contact Myla.

==Database Uploads from Auditor to Wrong Server==
This is not an issue for conference users, but for Jewel Tech Support contractors who use the "Universal" version of Auditor and can access servers for various conferences. If a database from a conference with a Jewel contract defaults to the Universal server, the EntityID needs to be set. See [[Beginning Balances and Other Setup Issues]].

There are a few users whose EntityIDs direct them to a specific conference's server, but that conference no longer has a contract with Jewel (NV-UT is the most common culprit). The solution is to a) remove the EntityID as it really doesn't do any good when not connected to a particular conference anyway, or b) be careful to change the server setting from NV-UT to Universal every time you upload. If it gets sent to the NV-UT server, the treasurer cannot download it, so they will receive an older file and then panic because all their information is "lost".

==File Sent By Treasurer Isn't On the Server==
If a treasurer has sent their file, and received confirmation in Jewel that the file was received by the Jewel server, but you don't see it, then the file is on a different server. Ask the treasurer what conference name they see in the lower left corner of their Jewel Home Page, just above their church name. If there is no conference name there, they have the "Universal" version of Jewel, which is correct if their conference does not have a contract with Jewel. If their conference does have a contract with Jewel, then it should have their conference's name. Treasurers who have the wrong version of Jewel should get the correct version as soon as possible. The old version will need to be uninstalled, then the correct version installed. This shouldn't affect the database, but always back up just in case.

Send/Receive Issues in Auditor

2026-05-01T01:46:34Z

Myla: /* Sent File Isn't On the Server */

==Can't Access the Server==
Assuming your internet connection is not the problem, you most likely need to go to Maintenance / Properties / Internet tab and enter your Auditor username and password. If you don't know your username and/or password, ask your conference treasurer, who will either provide it to you or get it for you from Jewel's conference tech support. If you are a Jewel Tech Support contractor and don't know your password, contact Myla.

==Database Uploads from Auditor to Wrong Server==
This is not an issue for conference users, but for Jewel Tech Support contractors who use the "Universal" version of Auditor and can access servers for various conferences. If a database from a conference with a Jewel contract defaults to the Universal server, the EntityID needs to be set. See [[Beginning Balances and Other Setup Issues]].

There are a few users whose EntityIDs direct them to a specific conference's server, but that conference no longer has a contract with Jewel (NV-UT is the most common culprit). The solution is to a) remove the EntityID as it really doesn't do any good when not connected to a particular conference anyway, or b) be careful to change the server setting from NV-UT to Universal every time you upload. If it gets sent to the NV-UT server, the treasurer cannot download it, so they will receive an older file and then panic because all their information is "lost".

==File Sent By Treasurer Isn't On the Server==
If a treasurer has sent their file, and received confirmation in Jewel that the file was received by the Jewel server, but you don't see it, then the file is on a different server. Ask the treasurer what conference name they see in the lower left corner of their Jewel Home Page, just above their church name. If there is no conference name there, they have the "Universal" version of Jewel, which is correct if their conference does not have a contract with Jewel. If their conference does have a contract with Jewel, then it should have their conference's name. Treasurers who have the wrong version of Jewel should get the correct version as soon as possible. The old version will need to be uninstalled, then the correct version installed. This shouldn't affect the database, but always back up just in case.

Send/Receive Issues in Auditor

2026-05-01T01:46:13Z

Myla: /* Database Uploads to Wrong Server */

==Can't Access the Server==
Assuming your internet connection is not the problem, you most likely need to go to Maintenance / Properties / Internet tab and enter your Auditor username and password. If you don't know your username and/or password, ask your conference treasurer, who will either provide it to you or get it for you from Jewel's conference tech support. If you are a Jewel Tech Support contractor and don't know your password, contact Myla.

==Database Uploads from Auditor to Wrong Server==
This is not an issue for conference users, but for Jewel Tech Support contractors who use the "Universal" version of Auditor and can access servers for various conferences. If a database from a conference with a Jewel contract defaults to the Universal server, the EntityID needs to be set. See [[Beginning Balances and Other Setup Issues]].

There are a few users whose EntityIDs direct them to a specific conference's server, but that conference no longer has a contract with Jewel (NV-UT is the most common culprit). The solution is to a) remove the EntityID as it really doesn't do any good when not connected to a particular conference anyway, or b) be careful to change the server setting from NV-UT to Universal every time you upload. If it gets sent to the NV-UT server, the treasurer cannot download it, so they will receive an older file and then panic because all their information is "lost".

==Sent File Isn't On the Server==
If a treasurer has sent their file, and received confirmation in Jewel that the file was received by the Jewel server, but you don't see it, then the file is on a different server. Ask the treasurer what conference name they see in the lower left corner of their Jewel Home Page, just above their church name. If there is no conference name there, they have the "Universal" version of Jewel, which is correct if their conference does not have a contract with Jewel. If their conference does have a contract with Jewel, then it should have their conference's name. Treasurers who have the wrong version of Jewel should get the correct version as soon as possible. The old version will need to be uninstalled, then the correct version installed. This shouldn't affect the database, but always back up just in case.

Send/Receive Issues in Auditor

2026-05-01T01:45:30Z

Myla:

==Can't Access the Server==
Assuming your internet connection is not the problem, you most likely need to go to Maintenance / Properties / Internet tab and enter your Auditor username and password. If you don't know your username and/or password, ask your conference treasurer, who will either provide it to you or get it for you from Jewel's conference tech support. If you are a Jewel Tech Support contractor and don't know your password, contact Myla.

==Database Uploads to Wrong Server==
This is not an issue for conference users, but for Jewel Tech Support contractors who use the "Universal" version of Auditor and can access servers for various conferences. If a database from a conference with a Jewel contract defaults to the Universal server, the EntityID needs to be set. See [[Beginning Balances and Other Setup Issues]].

There are a few users whose EntityIDs direct them to a specific conference's server, but that conference no longer has a contract with Jewel (NV-UT is the most common culprit). The solution is to a) remove the EntityID as it really doesn't do any good when not connected to a particular conference anyway, or b) be careful to change the server setting from NV-UT to Universal every time you upload. If it gets sent to the NV-UT server, the treasurer cannot download it, so they will receive an older file and then panic because all their information is "lost".

==Sent File Isn't On the Server==
If a treasurer has sent their file, and received confirmation in Jewel that the file was received by the Jewel server, but you don't see it, then the file is on a different server. Ask the treasurer what conference name they see in the lower left corner of their Jewel Home Page, just above their church name. If there is no conference name there, they have the "Universal" version of Jewel, which is correct if their conference does not have a contract with Jewel. If their conference does have a contract with Jewel, then it should have their conference's name. Treasurers who have the wrong version of Jewel should get the correct version as soon as possible. The old version will need to be uninstalled, then the correct version installed. This shouldn't affect the database, but always back up just in case.

Beginning Balances and Other Setup Issues

2026-04-30T21:34:45Z

Myla:

==Correcting Beginning Balances==
There are two ways to correct beginning balances. If the correction is simple, click Auditor, then go to View Journal, select the Beginning Balances (usually right at the top, always dated 12/1/1994), and make your corrections.

If you need to add additional lines to the Beginning Balance transaction, it is often easier to delete the beginning balances (select it in View Journal and type Delete on your keyboard), then add new beginning balances. Go to Tables / GeneralInfo, and change the NextStep column to "3". Close back out to the front end, click the NextStep "Enter Beginning Balances", and enter the new Beginning Balance transaction.

However, it is possible to add account lines to a beginning balance transaction in the back end. First, go to Auditor / View Journal, find the Beginning Balances, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the Beginning Balances. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount. Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

'''''Note:''' If you change the beginning balance of a '''bank account,''' you must also go to Tables / BankRecs and correct the beginning balance there.''

==Entering the EntityID==
For Jewel tech support and others who have the "universal" (non-conference-specific) version of Auditor, the EntityID controls which server a database automatically uploads to, so having it entered correctly can help avoid uploading it to the wrong server accidentally.

If a church's EntityID is not entered in the database, there are two ways to enter it:
# If you have Auditor for a specific conference, go to Maintenance / Properties / Church Info tab, and select the church from the list. Click OK to save.
# If you have the "universal" version of Auditor, then look up the church's EntityID on eAdventist. Be very, very sure you get the right church! Then click Auditor, and go to Tables / GeneralInfo. Carefully enter the EntityID in the proper column, and click OK. Auditor will throw an error and close, but just re-open it and continue working.

==Jewel Password Issues==
If a treasurer has set a password for Jewel, it can be viewed by clicking Auditor, then Tables / GeneralInfo, under the Window column.

Send/Receive Issues in Auditor

2026-04-30T21:24:15Z

Myla: Created page with "Can't access the server Database uploads to wrong server Treasurer sent, but it isn't on the server"

Can't access the server

Database uploads to wrong server

Treasurer sent, but it isn't on the server

Jewel Auditor

2026-04-30T21:23:23Z

Myla:

Jewel Auditor is a Jewel product Designed specifically to assist in:
1. Auditing
2. Jewel tech support for the end user
3. Manage Jewel Monthly Backups etc.

Jewel Auditor is a powerful auditing and Jewel database correction tool. Auditor can access both the conference Auditor server (where databases go when a treasurer "Sends to Auditor") and the conference backup server (where Jewel's month-end backups go when the treasurer "Sends Backup to Conference"). Databases can be downloaded, modified, then uploaded for the treasurer to "Receive from Auditor".

Auditor can do everything that Jewel does. The "front end" of Auditor looks just like Jewel, and can be used in all the same ways that Jewel can, plus more. This is the part of Auditor that should be used whenever possible. For example, while Jewel users are restricted to the current month, Auditor users can also edit transactions in previous months.

The "back end" of Auditor, accessed by clicking "Auditor" in the center of the Home Page, is a powerful database editing tool. The back end allows you to delete or edit any transaction in any month, change Jewel's current month, adjust the NextStep button, change beginning balances, add/remove transactions from bank reconciliations, and so on.

[[Installing or Upgrading Auditor]]

[[Front End Added Features]]

[[Back End Overview]]

[[Using Auditor to Make Corrections]]

[[Send/Receive Issues in Auditor]]

Beginning Balances and Other Setup Issues

2026-04-30T21:22:20Z

Myla: /* Entering the EntityID */

Beginning Balances and Other Setup Issues

2026-04-30T21:20:02Z

Myla:

==Correcting Beginning Balances==
There are two ways to correct beginning balances. If the correction is simple, click Auditor, then go to View Journal, select the Beginning Balances (usually right at the top, always dated 12/1/1994), and make your corrections.

If you need to add additional lines to the Beginning Balance transaction, it is often easier to delete the beginning balances (select it in View Journal and type Delete on your keyboard), then add new beginning balances. Go to Tables / GeneralInfo, and change the NextStep column to "3". Close back out to the front end, click the NextStep "Enter Beginning Balances", and enter the new Beginning Balance transaction.

However, it is possible to add account lines to a beginning balance transaction in the back end. First, go to Auditor / View Journal, find the Beginning Balances, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the Beginning Balances. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount. Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

'''''Note:''' If you change the beginning balance of a '''bank account,''' you must also go to Tables / BankRecs and correct the beginning balance there.''

==Entering the EntityID==
If a church's EntityID is not entered in the database, there are two ways to enter it:
# If you have Auditor for a specific conference, go to Maintenance / Properties / Church Info tab, and select the church from the list. Click OK to save.
# If you have the "universal" (non-conference-specific) version of Auditor, then look up the church's EntityID on eAdventist. Be very, very sure you get the right church! Then click Auditor, and go to Tables / GeneralInfo. Carefully enter the EntityID in the proper column, and click OK. Auditor will throw an error and close, but just re-open it and continue working.

Maintaining and Customizing Jewel

2026-04-30T21:15:08Z

Myla: /* Pro Tips */

__NOTOC__
==Edit Names==
:[[Managing Your Names List - Quick Start]] - Add, Delete, Edit "Active" Status, Combine Names
:[[Edit Names - How To and When Not To]]
:[[Avoid Creating Duplicate Names]]

==Edit Accounts==
:[[Managing Your Accounts List - Quick Start]] - Add, Delete, Edit "Active" Status, Close, Statement Frequency
:[[Trust Funds 101]]
:[[Add New Bank Account]]
:[[Debit Account Setup]]
:[[Petty Cash Setup and Usage]]
:[[Opening and Setting Up a Revolving Fund Account]]
:[[Entering Other Transaction Types#Credit Cards|Credit Card Setup]]
:[[Setting Up and Reconciling a CD Account]]
:[[Opening a New Bank Account]] - What to take to the bank

==Properties==
:[[Properties Quick Start]]
:[[Allow Checks Dated in Next Month]]

==Cleaning Up and Ensuring Accuracy==
:[[Cleaning Up the Bank Rec]]
:[[AdventistGiving Mapping Accuracy]]

:[[Avoid Creating Duplicate Offerings]]
:[[Avoid Creating Duplicate Payments]]

:[[Zero Month-end Negative Balances]]
:[[Zero Year-end Negative Balances]]

==Pro Tips==
:[[Six Things You Don't Need to Do]]
:[[Electronic Payments - Timing, Dates, Memos]]
:[[Payroll Tips for Treasurers]]
:[[Account Journal|Account Journal - Your Secret Weapon]]
:[[Check Options - Print or Write]]
:[[Memo Writing Tips]]
:[[Printing Reports to PDF]]
:[[Send to Auditor Tips]]
:[[Moving or Spending|Am I Moving Money or Spending It?]]
:[[Simplified Entry for Complicated Payments / Reimbursements]]
:[[Creating Excellent Reports for the Church Board]]

-----
[[Jewel Handbook|Return to main page of Jewel Handbook]]

Maintaining and Customizing Jewel

2026-04-30T20:57:30Z

Myla: /* Pro Tips */

__NOTOC__
==Edit Names==
:[[Managing Your Names List - Quick Start]] - Add, Delete, Edit "Active" Status, Combine Names
:[[Edit Names - How To and When Not To]]
:[[Avoid Creating Duplicate Names]]

==Edit Accounts==
:[[Managing Your Accounts List - Quick Start]] - Add, Delete, Edit "Active" Status, Close, Statement Frequency
:[[Trust Funds 101]]
:[[Add New Bank Account]]
:[[Debit Account Setup]]
:[[Petty Cash Setup and Usage]]
:[[Opening and Setting Up a Revolving Fund Account]]
:[[Entering Other Transaction Types#Credit Cards|Credit Card Setup]]
:[[Setting Up and Reconciling a CD Account]]
:[[Opening a New Bank Account]] - What to take to the bank

==Properties==
:[[Properties Quick Start]]
:[[Allow Checks Dated in Next Month]]

==Cleaning Up and Ensuring Accuracy==
:[[Cleaning Up the Bank Rec]]
:[[AdventistGiving Mapping Accuracy]]

:[[Avoid Creating Duplicate Offerings]]
:[[Avoid Creating Duplicate Payments]]

:[[Zero Month-end Negative Balances]]
:[[Zero Year-end Negative Balances]]

==Pro Tips==
:[[Six Things You Don't Need to Do]]
:[[Electronic Payments - Timing, Dates, Memos]]
:[[Payroll Tips for Treasurers]]
:[[Account Journal|Account Journal - Your Secret Weapon]]
:[[Check Options - Print or Write]]
:[[Memo Writing Tips]]
:[[Printing Reports to PDF]]
:[[Send to Auditor Tips]]
:[[Moving or Spending|Am I Moving Money or Spending It?]]
:[[Simplified Entry for Complicated Payments / Reimbursements]]
:[[Creating Excellent Reports for the Church Board]]
:[[Finding Missing Contributions]]

-----
[[Jewel Handbook|Return to main page of Jewel Handbook]]

Bank Reconciliation Corrections in Auditor

2026-04-30T20:54:53Z

Myla: /* Bank Rec Beginning Balance */

Fixing Remittance Issues in Auditor

2026-04-30T20:49:45Z

Myla: /* Duplicate Remittance Checks */

==Correcting Remittance Checks==
Remittance checks can only be corrected in the back end, even in Auditor, even if the month is not yet closed.

Most corrections can be made by going to Auditor, then View Journal. You can correct the '''date, check number''' (SeqN column), or '''Memo''' in the top Journal section. The '''amount''' of the check and its splits can be corrected in the bottom Journal Items section.

If the check is just plain '''wrong''', or if you need to '''add account lines''', it's usually easiest to delete the check (select it in View Journal, then press Delete on your keyboard), then go back to the front end and write a new check via Accounting / Make Manual Remittance.

However, it is possible to add account lines to a check in the back end. First, go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the check. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount (the amount will generally be negative). Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

If you need to '''change the bank account,''' go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Change the account in the lower Journal Items section. Then go to Tables / Accounts and find the AccountID of the bank account the check should be from. Go to Tables / Journal, use the JournalID to find the check, then change the zSingleAccountID column to the correct AccountID.

==Stale Date Remittance Checks==
Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

====Duplicate Remittance Checks====
When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

Once you have found both checks, ensure that the correct check, the one written out of conference funds, got cleared on the bank reconciliation, and the check written out of local funds is marked outstanding (see section on [[Bank Reconciliation Corrections in Auditor|Marking Transactions Cleared/Uncleared]]). Then you can void the outstanding check. If all goes well, the balance of the local fund used for remittances will be $0 when you're done. If not, use Reports & Graphs / Account Journal to find problematic transactions.

====Non-duplicate Remittance Checks====
If the stale-dated remittance check is not a duplicate, more research will be needed. Two options are to check bank statements to see if the check cleared, or contact the conference office to see if the check was received. For Jewel tech support, use your judgement regarding whether you do the research yourself or if you ask the treasurer to handle it and get back to you.

If the remittance funds are still owed to the conference, then the stale-dated check should be voided. Jewel will automatically add the unpaid funds to the next remittance submission. If a separate remittance submission is desired, then tech support can re-send an ACH request (see Re-Sending a Remittance Report below). Or, if the conference prefers, treasurers can go to Accounting / Make Manual Remittance and write a paper check to replace the stale-dated check.

If the remittance funds are '''not''' owed to the conference, then void the stale-dated remittance check, and Transfer Funds from the affected conference funds into a local fund like Church Budget. Obviously, since tithe funds are sacred, this should only be done when you are very sure that the funds really weren't owed, and with the support/approval of the conference office. Also be sure to use the memos on the transfer and the voiding transaction to connect the transactions for an audit trail.

==Re-Sending a Remittance Report==
To re-send a remittance report, use Auditor to open the month whose remittance report needs to be re-sent, with the NextStep button set to Remit to Conference. Go to Accounting / Void a Check, and void the remittance check for that month. (The reason for voiding the original check is that, generally, it saves editing the remittance check.) Click Remit to Conference, and verify that everything on the check is correct. If it's not, click Edit Check and fix it. Click OK, then click the NextStep "Send Remittance Report" and confirm.

:'''''Note:''' Remember that for churches who have signed up for ACH, the Remittance Report '''is''' the ACH authorization. This is why it is so important to avoid sending duplicate reports to the conference, as duplicate reports can result in duplicate ACH withdrawals, and that just upsets everyone involved!

Fixing Remittance Issues in Auditor

2026-04-30T20:48:29Z

Myla: /* Duplicate Remittance Checks */

==Correcting Remittance Checks==
Remittance checks can only be corrected in the back end, even in Auditor, even if the month is not yet closed.

Most corrections can be made by going to Auditor, then View Journal. You can correct the '''date, check number''' (SeqN column), or '''Memo''' in the top Journal section. The '''amount''' of the check and its splits can be corrected in the bottom Journal Items section.

If the check is just plain '''wrong''', or if you need to '''add account lines''', it's usually easiest to delete the check (select it in View Journal, then press Delete on your keyboard), then go back to the front end and write a new check via Accounting / Make Manual Remittance.

However, it is possible to add account lines to a check in the back end. First, go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the check. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount (the amount will generally be negative). Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

If you need to '''change the bank account,''' go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Change the account in the lower Journal Items section. Then go to Tables / Accounts and find the AccountID of the bank account the check should be from. Go to Tables / Journal, use the JournalID to find the check, then change the zSingleAccountID column to the correct AccountID.

==Stale Date Remittance Checks==
Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

====Duplicate Remittance Checks====
When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

Once you have found both checks, ensure that the correct check, the one written out of conference funds, got cleared on the bank reconciliation, and the check written out of local funds is marked outstanding (see section on [[Bank Reconciliation Corrections in Auditor|Marking Transactions Cleared/Uncleared]]). Then you can void the outstanding check.

====Non-duplicate Remittance Checks====
If the stale-dated remittance check is not a duplicate, more research will be needed. Two options are to check bank statements to see if the check cleared, or contact the conference office to see if the check was received. For Jewel tech support, use your judgement regarding whether you do the research yourself or if you ask the treasurer to handle it and get back to you.

If the remittance funds are still owed to the conference, then the stale-dated check should be voided. Jewel will automatically add the unpaid funds to the next remittance submission. If a separate remittance submission is desired, then tech support can re-send an ACH request (see Re-Sending a Remittance Report below). Or, if the conference prefers, treasurers can go to Accounting / Make Manual Remittance and write a paper check to replace the stale-dated check.

If the remittance funds are '''not''' owed to the conference, then void the stale-dated remittance check, and Transfer Funds from the affected conference funds into a local fund like Church Budget. Obviously, since tithe funds are sacred, this should only be done when you are very sure that the funds really weren't owed, and with the support/approval of the conference office. Also be sure to use the memos on the transfer and the voiding transaction to connect the transactions for an audit trail.

==Re-Sending a Remittance Report==
To re-send a remittance report, use Auditor to open the month whose remittance report needs to be re-sent, with the NextStep button set to Remit to Conference. Go to Accounting / Void a Check, and void the remittance check for that month. (The reason for voiding the original check is that, generally, it saves editing the remittance check.) Click Remit to Conference, and verify that everything on the check is correct. If it's not, click Edit Check and fix it. Click OK, then click the NextStep "Send Remittance Report" and confirm.

:'''''Note:''' Remember that for churches who have signed up for ACH, the Remittance Report '''is''' the ACH authorization. This is why it is so important to avoid sending duplicate reports to the conference, as duplicate reports can result in duplicate ACH withdrawals, and that just upsets everyone involved!

Bank Reconciliation Corrections in Auditor

2026-04-30T20:47:59Z

Myla: /* Transaction Cleared on Wrong Bank Rec */

Fixing Remittance Issues in Auditor

2026-04-30T20:46:52Z

Myla: /* Non-duplicate Remittance Checks */

==Correcting Remittance Checks==
Remittance checks can only be corrected in the back end, even in Auditor, even if the month is not yet closed.

Most corrections can be made by going to Auditor, then View Journal. You can correct the '''date, check number''' (SeqN column), or '''Memo''' in the top Journal section. The '''amount''' of the check and its splits can be corrected in the bottom Journal Items section.

If the check is just plain '''wrong''', or if you need to '''add account lines''', it's usually easiest to delete the check (select it in View Journal, then press Delete on your keyboard), then go back to the front end and write a new check via Accounting / Make Manual Remittance.

However, it is possible to add account lines to a check in the back end. First, go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the check. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount (the amount will generally be negative). Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

If you need to '''change the bank account,''' go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Change the account in the lower Journal Items section. Then go to Tables / Accounts and find the AccountID of the bank account the check should be from. Go to Tables / Journal, use the JournalID to find the check, then change the zSingleAccountID column to the correct AccountID.

==Stale Date Remittance Checks==
Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

====Duplicate Remittance Checks====
When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

Once you have found both checks, ensure that the correct check, the one written out of conference funds, got cleared on the bank reconciliation, and the check written out of local funds is marked outstanding (see section on '''Marking Transactions Cleared/Uncleared'''). Then you can void the outstanding check.

====Non-duplicate Remittance Checks====
If the stale-dated remittance check is not a duplicate, more research will be needed. Two options are to check bank statements to see if the check cleared, or contact the conference office to see if the check was received. For Jewel tech support, use your judgement regarding whether you do the research yourself or if you ask the treasurer to handle it and get back to you.

If the remittance funds are still owed to the conference, then the stale-dated check should be voided. Jewel will automatically add the unpaid funds to the next remittance submission. If a separate remittance submission is desired, then tech support can re-send an ACH request (see Re-Sending a Remittance Report below). Or, if the conference prefers, treasurers can go to Accounting / Make Manual Remittance and write a paper check to replace the stale-dated check.

If the remittance funds are '''not''' owed to the conference, then void the stale-dated remittance check, and Transfer Funds from the affected conference funds into a local fund like Church Budget. Obviously, since tithe funds are sacred, this should only be done when you are very sure that the funds really weren't owed, and with the support/approval of the conference office. Also be sure to use the memos on the transfer and the voiding transaction to connect the transactions for an audit trail.

==Re-Sending a Remittance Report==
To re-send a remittance report, use Auditor to open the month whose remittance report needs to be re-sent, with the NextStep button set to Remit to Conference. Go to Accounting / Void a Check, and void the remittance check for that month. (The reason for voiding the original check is that, generally, it saves editing the remittance check.) Click Remit to Conference, and verify that everything on the check is correct. If it's not, click Edit Check and fix it. Click OK, then click the NextStep "Send Remittance Report" and confirm.

:'''''Note:''' Remember that for churches who have signed up for ACH, the Remittance Report '''is''' the ACH authorization. This is why it is so important to avoid sending duplicate reports to the conference, as duplicate reports can result in duplicate ACH withdrawals, and that just upsets everyone involved!

Fixing Remittance Issues in Auditor

2026-04-30T20:45:53Z

Myla: /* Re-Sending a Remittance Report */

==Correcting Remittance Checks==
Remittance checks can only be corrected in the back end, even in Auditor, even if the month is not yet closed.

Most corrections can be made by going to Auditor, then View Journal. You can correct the '''date, check number''' (SeqN column), or '''Memo''' in the top Journal section. The '''amount''' of the check and its splits can be corrected in the bottom Journal Items section.

If the check is just plain '''wrong''', or if you need to '''add account lines''', it's usually easiest to delete the check (select it in View Journal, then press Delete on your keyboard), then go back to the front end and write a new check via Accounting / Make Manual Remittance.

However, it is possible to add account lines to a check in the back end. First, go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the check. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount (the amount will generally be negative). Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

If you need to '''change the bank account,''' go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Change the account in the lower Journal Items section. Then go to Tables / Accounts and find the AccountID of the bank account the check should be from. Go to Tables / Journal, use the JournalID to find the check, then change the zSingleAccountID column to the correct AccountID.

==Stale Date Remittance Checks==
Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

====Duplicate Remittance Checks====
When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

Once you have found both checks, ensure that the correct check, the one written out of conference funds, got cleared on the bank reconciliation, and the check written out of local funds is marked outstanding (see section on '''Marking Transactions Cleared/Uncleared'''). Then you can void the outstanding check.

====Non-duplicate Remittance Checks====
If the stale-dated remittance check is not a duplicate, more research will be needed. Two options are to check bank statements to see if the check cleared, or contact the conference office to see if the check was received. For Jewel tech support, use your judgement regarding whether you do the research yourself or if you ask the treasurer to handle it and get back to you.

If the remittance funds are still owed to the conference, then the stale-dated check should be voided. Jewel will automatically add the unpaid funds to the next remittance submission. Tech support can re-send an ACH request (see Re-Sending a Remittance Report below). Or, if the conference prefers, treasurers can go to Accounting / Make Manual Remittance and write a paper check to replace the stale-dated check.

If the remittance funds are '''not''' owed to the conference, then void the stale-dated remittance check, and Transfer Funds from the affected conference funds into a local fund like Church Budget. Obviously, since tithe funds are sacred, this should only be done when you are very sure that the funds really weren't owed, and with the support/approval of the conference office. Also be sure to use the memos on the transfer and the voiding transaction to connect the transactions for an audit trail.

==Re-Sending a Remittance Report==
To re-send a remittance report, use Auditor to open the month whose remittance report needs to be re-sent, with the NextStep button set to Remit to Conference. Go to Accounting / Void a Check, and void the remittance check for that month. (The reason for voiding the original check is that, generally, it saves editing the remittance check.) Click Remit to Conference, and verify that everything on the check is correct. If it's not, click Edit Check and fix it. Click OK, then click the NextStep "Send Remittance Report" and confirm.

:'''''Note:''' Remember that for churches who have signed up for ACH, the Remittance Report '''is''' the ACH authorization. This is why it is so important to avoid sending duplicate reports to the conference, as duplicate reports can result in duplicate ACH withdrawals, and that just upsets everyone involved!

Changing the NextStep Button

2026-04-30T20:44:55Z

Myla: /* Forgotten Offerings */

To change the NextStep button, click Auditor, and select the desired option from the NextStep dropdown menu. In general, try to avoid re-opening closed months, unless it was very recently closed. Exceptions can be made if there's a good reason, of course. Remind treasurers to reprint their month-end reports and/or write notes on the previous reports to clarify the changes for the auditor.

==Forgotten Offerings==
This is the usual reason for changing the NextStep button, and the solution depends on the current NextStep.

'''Remit to Conference:''': Direct the treasurer to go to Offerings (at the top of the Jewel Home Screen), then Start New Offering. Confirm that a new offering in the current month is desired.

'''Send Remittance Report:''' Void (or delete) the conference check, and change the NextStep button back to Start New Offering. The treasurer can then proceed as usual, writing a new conference check and closing the month as usual.

'''Reconcile Bank Statements''' or any other post-remittance step: This is tricky because backing treasurers up to Start New Offering allows them to submit a second remittance for the month, which is often confusing to the conference office. Jewel tech support generally asks the treasurer to call back once they've entered the deposit so that we can move them back to where they were. Then Jewel will automatically include any additional remittance in the next remittance check. If the additional remittance is unusually large, you can contact the conference to see if they prefer a second remittance.

:'''''Note:''' Remember that for churches who have signed up for ACH, the Remittance Report '''is''' the ACH authorization. This is why it is so important to avoid sending duplicate reports to the conference, as duplicate reports can result in duplicate ACH withdrawals, and that just upsets everyone involved!

'''Start New Offering''' for a future month: Ask the treasurer to go ahead and enter the offering in their current month. Once they've done that, they can send the database to Auditor, and tech support can [[Offering Deposit Corrections in Auditor|correct the date]]. Jewel will automatically include any additional remittance in the next remittance check.

==Beginning Balances==
On the rare occasion that you need one of the "setting up a new database" NextStep options, click Auditor, then Tables / GeneralInfo, and change the NextStep column to the desired number. See [[Beginning Balances and Other Setup Issues]].

Fixing Remittance Issues in Auditor

2026-04-30T20:44:00Z

Myla: /* Stale Date Remittance Checks */

==Correcting Remittance Checks==
Remittance checks can only be corrected in the back end, even in Auditor, even if the month is not yet closed.

Most corrections can be made by going to Auditor, then View Journal. You can correct the '''date, check number''' (SeqN column), or '''Memo''' in the top Journal section. The '''amount''' of the check and its splits can be corrected in the bottom Journal Items section.

If the check is just plain '''wrong''', or if you need to '''add account lines''', it's usually easiest to delete the check (select it in View Journal, then press Delete on your keyboard), then go back to the front end and write a new check via Accounting / Make Manual Remittance.

However, it is possible to add account lines to a check in the back end. First, go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the check. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount (the amount will generally be negative). Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

If you need to '''change the bank account,''' go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Change the account in the lower Journal Items section. Then go to Tables / Accounts and find the AccountID of the bank account the check should be from. Go to Tables / Journal, use the JournalID to find the check, then change the zSingleAccountID column to the correct AccountID.

==Stale Date Remittance Checks==
Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

====Duplicate Remittance Checks====
When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

Once you have found both checks, ensure that the correct check, the one written out of conference funds, got cleared on the bank reconciliation, and the check written out of local funds is marked outstanding (see section on '''Marking Transactions Cleared/Uncleared'''). Then you can void the outstanding check.

====Non-duplicate Remittance Checks====
If the stale-dated remittance check is not a duplicate, more research will be needed. Two options are to check bank statements to see if the check cleared, or contact the conference office to see if the check was received. For Jewel tech support, use your judgement regarding whether you do the research yourself or if you ask the treasurer to handle it and get back to you.

If the remittance funds are still owed to the conference, then the stale-dated check should be voided. Jewel will automatically add the unpaid funds to the next remittance submission. Tech support can re-send an ACH request (see Re-Sending a Remittance Report below). Or, if the conference prefers, treasurers can go to Accounting / Make Manual Remittance and write a paper check to replace the stale-dated check.

If the remittance funds are '''not''' owed to the conference, then void the stale-dated remittance check, and Transfer Funds from the affected conference funds into a local fund like Church Budget. Obviously, since tithe funds are sacred, this should only be done when you are very sure that the funds really weren't owed, and with the support/approval of the conference office. Also be sure to use the memos on the transfer and the voiding transaction to connect the transactions for an audit trail.

==Re-Sending a Remittance Report==
To re-send a remittance report, use Auditor to open the month whose remittance report needs to be re-sent, with the NextStep button set to Remit to Conference. Go to Accounting / Void a Check, and void the remittance check for that month. (The reason for voiding the original check is that, generally, it saves editing the remittance check.) Click Remit to Conference, and verify that everything on the check is correct. If it's not, click Edit Check and fix it. Click OK, then click the NextStep "Send Remittance Report" and confirm.

'''''Note:''' Remember that for churches who have signed up for ACH, the Remittance Report '''is''' the ACH authorization. This is why it is so important to avoid sending duplicate reports to the conference, as duplicate reports can result in duplicate ACH withdrawals, and that just upsets everyone involved!

Bank Reconciliation Corrections in Auditor

2026-04-30T20:39:10Z

Myla:

Bank Reconciliation Corrections in Auditor

2026-04-30T20:38:40Z

Myla: /* Cleaning Up the Bank Rec in Auditor */

Fixing Remittance Issues in Auditor

2026-04-30T20:38:09Z

Myla: Created page with "==Correcting Remittance Checks== Remittance checks can only be corrected in the back end, even in Auditor, even if the month is not yet closed. Most corrections can be made by going to Auditor, then View Journal. You can correct the '''date, check number''' (SeqN column), or '''Memo''' in the top Journal section. The '''amount''' of the check and its splits can be corrected in the bottom Journal Items section. If the check is just plain '''wrong''', or if you need to..."

==Correcting Remittance Checks==
Remittance checks can only be corrected in the back end, even in Auditor, even if the month is not yet closed.

Most corrections can be made by going to Auditor, then View Journal. You can correct the '''date, check number''' (SeqN column), or '''Memo''' in the top Journal section. The '''amount''' of the check and its splits can be corrected in the bottom Journal Items section.

If the check is just plain '''wrong''', or if you need to '''add account lines''', it's usually easiest to delete the check (select it in View Journal, then press Delete on your keyboard), then go back to the front end and write a new check via Accounting / Make Manual Remittance.

However, it is possible to add account lines to a check in the back end. First, go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Close View Journal, and go to Tables / Accounts and find the AccountID of the account you need to add to the check. Go to Tables / JournalItems, and in the last line, type in the JournalID, AccountID, and Amount (the amount will generally be negative). Leave the JournalItemID blank. Then go back to the front end and verify that you did what you intended to do.

If you need to '''change the bank account,''' go to Auditor / View Journal, find the check, and find its JournalID by hovering over the left-hand column. Change the account in the lower Journal Items section. Then go to Tables / Accounts and find the AccountID of the bank account the check should be from. Go to Tables / Journal, use the JournalID to find the check, then change the zSingleAccountID column to the correct AccountID.

==Stale Date Remittance Checks==
Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

====Duplicate Remittance Checks====
When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

Once you have found both checks, ensure that the correct check, the one written out of conference funds, got cleared on the bank reconciliation, and the check written out of local funds is marked outstanding (see section on '''Marking Transactions Cleared/Uncleared'''). Then you can void the outstanding check.

====Non-duplicate Remittance Checks====
If the stale-dated remittance check is not a duplicate, more research will be needed. Two options are to check bank statements to see if the check cleared, or contact the conference office to see if the check was received. For Jewel tech support, use your judgement regarding whether you do the research yourself or if you ask the treasurer to handle it and get back to you.

If the remittance funds are still owed to the conference, then the stale-dated check should be voided. Jewel will automatically add the unpaid funds to the next remittance submission. Tech support can re-send an ACH request (see below). Or, if the conference prefers, treasurers can go to Accounting / Make Manual Remittance and write a paper check to replace the stale-dated check.

To re-send an ACH request, use Auditor to open the month whose remittance report needs to be re-sent, with the NextStep button set to Remit to Conference. Go to Accounting / Void a Check, and void the remittance check for that month. (The reason for voiding the original check is that, generally, it saves editing the remittance check.) Click Remit to Conference, and verify that everything on the check is correct. If it's not, click Edit Check and fix it. Click OK, then click the NextStep "Send Remittance Report" and confirm.

If the remittance funds are '''not''' owed to the conference, then void the stale-dated remittance check, and Transfer Funds from the affected conference funds into a local fund like Church Budget. Obviously, since tithe funds are sacred, this should only be done when you are very sure that the funds really weren't owed, and with the support/approval of the conference office. Also be sure to use the memos on the transfer and the voiding transaction to connect the transactions for an audit trail.

Check or Electronic Payment Corrections in Auditor

2026-04-30T20:34:35Z

Myla: /* Remittance Checks */

==Making Corrections==
For most changes, go to Reports & Graphs / Checks. Click on the check you wish to correct, then click Edit Check. Make your changes, and click OK to finish.

If you need to change the date in a previous month, or from one month to another, go to the back end. Click Auditor, click View Journal, and find the check you wish to correct. Change both the AccountingDate and the Date to the correct values. Click Close twice to return to the front end.

If you need to correct a check number, that can usually be done in the front end. Duplicate numbers can be entered in View Journal in the back end if necessary. And the back end is generally easier when changing multiple numbers at once.

==Duplicate Checks or Electronic Payments==
Duplicate checks/payments can be deleted in the back end. Go to Auditor, then View Journal. Select the check you wish to delete, and press Delete on your keyboard. However, remember that deleting leaves no audit trail, so it should generally only be done when the check was recently written. Otherwise, they should be voided as below.

If the duplicate check uses a check number that you wish to use for a real check, then go to Reports & Graphs / Checks. Click on the check whose number you need to re-use, then click Edit Check. Check the Electronic Payment box, and click OK to save the change. Then continue to Void a Check (below) to void the duplicate.

If your duplicate is an electronic payment or if you do not need to re-use the check number, simply go to Accounting / Void a Check to void the duplicate.

==Erroneously Voided Check==
If a check was voided by accident, "unvoiding" can be accomplished by deleting the voiding entry (see Duplicate Checks above), and then editing the memo of the voided check to remove the "void" notation. However, this leaves no audit trail, so should generally only be done when the void happened recently.

Otherwise, re-enter the voided check as an electronic payment. Use the memo to reference both the original check number and the voiding entry number. This creates an audit trail.

==Remittance Checks==
See [[Fixing Remittance Issues in Auditor]]

Using Auditor to Make Corrections

2026-04-30T20:33:45Z

Myla:

Auditor is a powerful tool to correct Jewel databases. Therefore it must be used with extreme caution. Jewel locks down all but the current month, so that treasurers cannot make changes to closed months. There are important reasons for this, such as preserving an audit trail, and not changing reports that have been accepted by the church board. Auditor users must exercise care to not change closed months unnecessarily, and to leave an audit trail for necessary changes.

Additionally, Jewel includes safeguards that keep the database in balance. The "front end" of Auditor, the part that looks like Jewel, also includes these safeguards. But when you click Auditor and go into the "back end", those safeguards are gone. '''Do not make changes to a database in the back end of Auditor unless you are 100% sure you know what you are doing.''' If you are not completely confident, ensure that you have a backup accessible so you can use it to undo your changes, if necessary.

There is a lot of "use your best judgement" involved in deciding how to make corrections. When a month has been recently closed, it's usually fine to directly edit the incorrect transaction(s) and reprint the affected monthly reports. Please thoroughly familiarize yourself with [[Making Corrections]] in the Jewel Handbook for general guidelines on how to edit transactions. Note that the Current Month instructions often also work for Previous Months when you're using Auditor. Always use the front end of Auditor whenever possible, as it's much easier to use and harder to make mistakes. When it is necessary to make a change in a closed month, utilize the memo to leave an audit trail as well as a record of who made the change.

[[Beginning Balances and Other Setup Issues]]

[[Changing the NextStep Button]]

[[Offering Deposit Corrections in Auditor]]

[[Check or Electronic Payment Corrections in Auditor]]

[[General Journal or Transfer Corrections in Auditor]]

[[Fixing Remittance Issues in Auditor]]

[[Bank Reconciliation Corrections in Auditor]]

Bank Reconciliation Corrections in Auditor

2026-04-30T20:32:55Z

Myla: /* Bank Rec Ending Date */

==Bank Rec Ending Date==
In the back end, go to Tables / BankRecs. The Date column is the date the reconciliation was completed in Jewel. A Date of 1/1/1990 is assigned to Beginning Balances. A Date of 12/1/1994 is assigned to bank recs that have been "undone".

Correct the EndingDate column of the bank rec(s) that are incorrect.

==Bank Rec Beginning Balance==
Jewel uses the ending balance for the previous bank reconciliation as the beginning balance for the next bank rec. "Previous" is defined as the first-completed bank rec on the latest possible date. This can cause problems when treasurers accidentally save reconciliations with future ending dates and then try to correct the problem themselves.

If a beginning balance is incorrect, compare the Date column to the EndingDate column to ensure that everything makes sense. There shouldn't be any Ending Dates that are after the Date of reconciliation, such as the 4/30/26 reconciliation done on 4/7/26. And there shouldn't be any duplicate Ending Dates. If you find an error or duplicate, simply type in the correct Ending Date. Duplicates can be separated by changing the date by one day, so you have 4/29/26 and 4/30/26 instead of two 4/30/26's. This also resolves a known issue with the Bank Rec report, where only one reconciliation per date can be viewed.

==Cleaning Up the Bank Rec in Auditor==
Clearing old transactions out of the bank reconciliation is essential to generating correct reports. Generally, eposits, transfers, and electronic payments over a month old should be investigated and cleared, as should checks over about six months old. Start by reading [[Cleaning Up the Bank Rec]] in the Jewel Handbook.

===Stale Date Checks and Electronic Payments===
By the time tech support gets involved, outstanding checks are often several years old, so can simply be voided and cleared, without any real need for investigation. The exception is remittance checks, see below.

If the treasurer is frequently entering duplicate checks or electronic payments, they may need help finding a better system.

===Stale Date Remittance Check===
Stale dated remittance checks must be handled with care, because if they are voided, Jewel will reverse the check and add the "unpaid" remittance to the next remittance check. This may occasionally be appropriate, but usually remittance checks end up with stale dates because they were duplicated in Jewel.

====Duplicate Remittance Checks====
When you see an old, uncleared remittance check, always check to see if it's a duplicate. Usually, the duplicate check will be entered early in the next month, and written out of local funds. To look for duplicates, go to Reports & Graphs / Check, choose a large date range around the date of the remittance, and sort by Payee. Another option is to go into the back end, to Tables / JournalItems, and sort by amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

Once you have found both checks, ensure that the correct check, the one written out of conference funds, got cleared on the bank reconciliation, and the check written out of local funds is marked outstanding (see section on '''Marking Transactions Cleared/Uncleared'''). Then you can void the outstanding check.

====Non-duplicate Remittance Checks====
If the stale-dated remittance check is not a duplicate, more research will be needed. Two options are to check bank statements to see if the check cleared, or contact the conference office to see if the check was received. For Jewel tech support, use your judgement regarding whether you do the research yourself or if you ask the treasurer to handle it and get back to you.

If the remittance funds are still owed to the conference, then the stale-dated check should be voided. Jewel will automatically add the unpaid funds to the next remittance submission. Tech support can re-send an ACH request (see below). Or, if the conference prefers, treasurers can go to Accounting / Make Manual Remittance and write a paper check to replace the stale-dated check.

To re-send an ACH request, use Auditor to open the month whose remittance report needs to be re-sent, with the NextStep button set to Remit to Conference. Go to Accounting / Void a Check, and void the remittance check for that month. (The reason for voiding the original check is that, generally, it saves editing the remittance check.) Click Remit to Conference, and verify that everything on the check is correct. If it's not, click Edit Check and fix it. Click OK, then click the NextStep "Send Remittance Report" and confirm.

If the remittance funds are '''not''' owed to the conference, then void the stale-dated remittance check, and Transfer Funds from the affected conference funds into a local fund like Church Budget. Obviously, since tithe funds are sacred, this should only be done when you are very sure that the funds really weren't owed, and with the support/approval of the conference office. Also be sure to use the memos on the transfer and the voiding transaction to connect the transactions for an audit trail.

==Offering Deposit==
Stale-dated offering deposits are often duplicate entries. Often one entry is near the end of the month, and the other is near the beginning of the next month. To look for duplicates, go to Reports & Graphs / Deposit, and choose a large date range around the date of the outstanding deposit. Another option is to go into the back end, to Tables / JournalItems, and sort by amount or search for the amount. Note the JournalIDs of the duplicate entries (not the JournalItemID, but the JournalID), then go to View Journal and find the specific transactions. The JournalID is shown in the left-hand column when you hover over it with the mouse.

If you confirm that the deposit is a duplicate, then it can be deleted, reversed one envelope at a time, or reversed with a General Journal Entry. Which option you choose will depend mostly on how long ago the duplicate happened. Deleting is by far the easiest option, and is appropriate when the duplicate happened recently. If the deposit is old enough that donor receipts have already been issued and examined by the donors, then reversing with a General Journal may be appropriate, since it's a lot easier. But if the deposit is in that magical "too old to delete, but new enough that people want a correct receipt" range, then it must be reversed with a negative offering deposit, envelope by envelope. As always, use your best judgement.

If the offering deposit is not a duplicate, it still needs to be reversed as above. But now you have to worry about '''why''' there's a deposit that never made it to the bank. Jewel tech support may report questionable activity to the conference office, but is not under obligation to do so.

==Transfers and General Journal Entries==
The basic idea for these transactions is to manually enter a reversing transaction. Always write a good memo so the auditor can follow what happened.

Outstanding transfers between bank accounts should be thoroughly investigated, as treasurers often enter these incorrectly. The usual incorrect method is to write a check out of one account (from a local fund), and then deposit the money into the other account (into a local fund). Sometimes the local funds aren't the same on both ends. And sometimes only the check or only the deposit gets entered. The deposit might be included in an offering deposit. So verify that a) the funds didn't get unintentionally moved from one local fund to another, and b) both bank accounts show the correct balance. Use Transfer Funds and/or Make General Journal Entry to get everything where it belongs. And as always, write good memos, referencing original dates and transaction numbers, to preserve an audit trail. Encourage treasurers to use [[Transfer Funds Quick Start|Transfer Funds]] or [[Transferring by Writing a Check]] in the future. They often also need help understanding [[How Jewel Works|why transferring funds from Savings doesn't increase local funds.]]

==Transaction Cleared on Wrong Bank Rec==
To clear a transaction on a specific bank reconciliation, click Auditor to get into the back end. Go to View Journal and select the transaction. Note its JournalID by hovering over the left-hand column. Then the BankRecID column at bottom left gives the number of the bank reconciliation the transaction is currently cleared on, but cannot be edited.

Go to Tables / BankRecs and find the BankRecID of the correct bank rec, using the Ending Date and AccountID. If necessary, go to Tables / Accounts to find the correct AccountID. Remember you can sort by clicking on column headings, so clicking on the Name column sorts the accounts alphabetically.

Finally, to edit the BankRecID, go to Tables/JournalItems, find the affected transaction by its JournalID, make sure you're on the line with the correct AccountID, and type the number of the correct bank rec under ClearedBankRecID. Or if a transaction should not be cleared at all, delete the bank rec ID.

Program Installation and Database Setup Instructions

2026-04-30T20:31:53Z

Myla: /* Installation */

Welcome to Jewel! We are excited to have your church on board.

==Acquiring a Jewel Install File==
First, check if your conference has provided you with a link to download a Jewel Install File. If not, contact [mailto:sales@jewelsda.com sales@jewelsda.com] and they can help you out. If you are a Seventh-day Adventist church, please include your church name and conference in your email.

== Installation ==
Double-click on the Jewel Install file you have received. Once the Jewel Setup screen has appeared, follow the prompts to complete installation.

Sometimes antivirus software interferes with the download or installation of Jewel. If this is the case, you may need to click "run anyway", "keep", "see more" or similar to tell the antivirus software that you trust Jewel. Or you may need to temporarily disable the antivirus software while you complete the installation. If your downloaded file is named "unconfirmed...", then rename it to "Jewel Install.exe", and confirm that you really do want to change the file's extension.

== Setting Up Your Database ==
After installing Jewel, you will enter some basic information about your church. You will need (from your existing financial records) a balance sheet showing the ending balances of all church accounts, both bank accounts and local funds like Church Budget. [[The NextStep Button - Your Guide|The NextStep Button]] will guide you through the setup process. Many of you will be able to complete the process simply by reading the on-screen instructions. But if you need more details at any step, they are given below.

=== Church Name ===
Your first step in setting up Jewel is to tell it who you are! Enter your church name, as you would like it to appear on printed reports, checks, and receipts. This name will also be used by tech support and conference auditors to identify your database, so including your location is helpful (ex: "Anytown New Life SDA Church" instead of just "New Life SDA Church").

=== Add Accounts ===
Your next step is to add the accounts you will be using. Many of the most commonly used accounts are already set up in Jewel, such as Sabbath School Expense, Church Expense, and Tithe. If Jewel is being used by your conference, you will also have your most commonly-used conference accounts already in Jewel. You will need to add in your other local accounts. Use whatever account numbering system is best for you. When you first open the Add Accounts screen, you will notice an account (account #8001) named 'Checking' and another (#8002) named 'Savings'. You will need to EDIT these accounts to put in your bank information, and ADD any other savings or checking accounts your church may be using. It is recommended that you put in your checking and savings accounts first. Then, add any other accounts/funds your church uses that are not already in the accounts list that came with Jewel. If Tithe is not included in your Conference Funds list, [[Adding a Tithe Account|click here for instructions]]. The steps for adding a Bank Account are below. For more detailed instructions regarding adding or editing accounts, [[Managing Your Accounts List - Quick Start|click here]].

[[File:Edit_Accounts_screen.png|center|600px]]

Follow these instructions when entering your bank account information:

::'''''NOTE:''' If you do not plan to use Jewel to print checks at this time, you need only complete steps 1-3. You can come back later to complete the rest.''

# ''Type:'' Select Bank Account as the account type.
# ''ID:'' Select the number you would like your bank account ID to be. Bank account ID numbers should be numbered near the existing numbers, in the low 8000's.
# ''Name:'' Type the name of your bank account, including whether it is a checking or savings account. For example: “First Union Checking.”
# ''Bank Name:'' Type the exact name of your bank. This is the name that will print out on the checks and must be your legal bank name.
# ''Routing #:'' This is "routing transit number" or "fractional bank number" that is sometimes printed in small print on the upper right corner of checks, as a backup to the routing number at the bottom. If your bank still uses this number, enter it here. Otherwise, you may leave it blank.
# ''Address:'' Type in your bank's mailing address, using the same number of lines as a normal address label.
# ''Check MICR Line:'' This line consists of your account number, routing number, and check number and can be seen on the bottom of your checks in bold black type along with some unusual symbols. Key in the number and symbols (use the guidelines provided to type the symbols) exactly as is seen on your checks, with the exception of the last 4 digits – type “nnnn” instead of the numbers seen on the check.
# ''Deposit Slip MICR Line:'' If you plan to print deposit slips from Jewel to take to your bank, copy the MICR line from a pre-printed deposit slip, or ask your bank for the numbers and symbols to enter.
# ''Statement Frequency:'' Choose how often you receive a bank statement for this account. Your selection will be used to remind you when to reconcile.

[[File:Check_picture.png|center|600px]]
<br>
''Can I change account numbers and/or account names later?''<br />
Yes. But see instructions and cautions [[Managing Your Accounts List - Quick Start#Edit an Account|here]].

=== Beginning Balances ===
Your first big decision regarding Jewel setup is whether you will begin entering data starting with the current month, or from January 1. The advantage of beginning Jewel from the beginning of the year is that you will only have ONE set of books to keep up with through the rest of the year. It may take a little more time at the beginning, but it will save you time and trouble in the long run to have all your books for the year in one place. If you decide to start with the beginning of the current month, you will need to refer both to Jewel AND the accounting system you used up to this point. When bringing up reports (specifically year-to-date) you will have to refer to both sets of numbers. You will also need to send out two contribution receipts for each donor at the end of the year - one from Jewel and one from your previous accounting system.

Once you have decided at which point in time to start your bookkeeping, you can enter your beginning balances. Those beginning balances will be the ending balances from the last month of your old system, after remitting to the conference at the end of that month. When selecting accounts, you may either type in the account (by account number OR account name) or you may click the down arrow to the right of the Account field and select from the list. Accounts are listed here alphabetically and then by account number. If you find that you need to edit an account or add another account, you can click on the (+) to the right of the Account field, which will take you back to the "Edit Accounts" page. When you have finished entering the numbers, make sure that the amount in your Bank Account(s) and Local Funds are equal to each other. Jewel will not let you continue if the bank account and local funds totals don’t agree. Jewel also will not accept any Conference fund balances. Jewel assumes that these are remitted each month, so if you have Conference fund balances you will need to remit them before entering your beginning balances, or add them to a new local fund account called Conference Payable. Then when you remit those conference funds, the Conference Payable account will be left with a zero balance. Confirm that your figures are correct by clicking "OK" in the upper right corner of the screen, and then click "Yes" in the following screen.

=== Edit Names ===
The next step in Jewel setup is to enter the names of your donors (i.e. tithepayers) and vendors (i.e. utility companies). To add a new name, click the “Add New Name” button, or press F8 on your keyboard. Simply fill in the appropriate information for each name. When entering a vendor name, such as an electric company, that does not necessarily have a 'first' and 'last' name, enter the name of the company in the "Last Name" line. Remember you can also add names as you write checks and enter offerings, so don't worry if you don't have a complete list right now. When you have finished entering all the names you wish to add now, click OK, located in the upper right corner.

:'''''NOTE:''' Verify that ID# 999 has your correct Conference name. If not, please edit it so that your remittance checks will be written properly.''

It is recommended that you enter the donor/vendor names manually so that you don't clutter Jewel with old, unused names. But there is an option to import names from another file. If you already have a list of your church's donors/vendors in Excel, Word, or from your previous accounting program such as Donation Accounting or LUCIS, you can import these names by clicking the "Import Names and Addresses" button. (If you are importing from an Excel or Word file, you will need to save or export the file as a .csv file.) Choose the type of Source file you are importing from, then click "Read from Source". Adjust the options as needed so that the names and addresses import correctly, then click "Import Names and Addresses" to complete the import.

[[File:Edit_Names_screen.png|center|600px]]

=== Properties ===
Fill in your church's address and your name as treasurer. You will also enter your church's Entity ID by clicking on “Select Your Church,” choosing your church from the list, and clicking "OK". (If your church's name is not listed, first check your Internet connection. If that does not resolve the problem, contact your conference's clerk and request that your church be added to eAdventist's database.)

The remaining tabs on this screen contain the Jewel Properties that you can use to customize Jewel for your church's needs. It is recommended that you do not change any defaults at this point, but that you take a few minutes to familiarize yourself with the Properties content. You can change settings later by going to Maintenance / [[Properties Quick Start|Properties]], once you have become more familiar with Jewel. You will for sure want to set the [[Properties Quick Start#General|Backup Path]] before you close your first month.

[[File:Properties_Church_Info_screen.png|center|600px]]

=== Budget Allocations ===
If your church has voted on a budget, now is a great time to enter it. You may edit budget allocations at any time, but any additions or changes will only apply to unclosed months, not to previous months. So if you have a current budget, enter it before doing your month-end closing process. Please see [[Budget]] for detailed instructions.

==All Done?==
Once your new database is set up, your next step must be to [[Receiving and Handling Sabbath Offerings|enter a Sabbath offering]].

-----
[[Jewel Handbook|Return to main page of Jewel Handbook]]

Offering Deposit Corrections in Auditor

2026-04-30T20:12:39Z

Myla: /* Cancel an Unfinished Offering */

==Incorrect Offering Date==
If the correction is in the current month, use the front end.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then either:
# Contribution report, then clicking on a donation that's included in the deposit you're correcting, or
# Deposit report, clicking on the deposit you're correcting, then Make Corrections (bottom center of the window).

Now, you need to know whether you use Jewel's Deposit Slip feature. If you enter the number of coins and bills in each deposit, then you do use this feature. If you simply enter the total amount of the deposit, you do not use the Deposit Slip feature.

===If you use the Deposit Slip feature===
Click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

===If you do not use the Deposit Slip feature===
Check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, Date, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

Or do it the easy way. Go into the back end, click View Offerings, and delete the unfinished offering. There will not be anything to delete in View Journal because the offering isn't recorded there until Make Deposit has been clicked to finalize the offering.

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Offering Deposit Corrections in Auditor

2026-04-30T20:10:13Z

Myla:

==Incorrect Offering Date==
If the correction is in the current month, use the front end.

If the correction is in a previous month, or if the deposit needs to be moved from one month to another, click Auditor, then click "View Journal". Find the deposit you need to correct. Change the AccountingDate, the Date, the date in the Memo, and the Offerings Date (toward the bottom right of the window) to the correct values. That's '''four''' dates! Count them! Also use the Memo to record what you're changing and why. Click Close twice to get back to the front end.

:'''''Note:''' Each deposit has four dates: the Accounting Date, the Offering Date, the Deposit Date, and the date listed in the Memo. It is generally best to use the same date in all four places. If the Offering and Deposit dates are different, then your Contribution Report will not agree with your Deposit Report for the same dates, because they won't include the same offerings.

==Donations Recorded Under Wrong Name==
Go to Reports & Graphs / Contribution. Look up the name the donation is currently recorded under, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Donations Attributed to Incorrect Fund==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope, make your correction, then click Close to finish.

If the correction was in a previous year, remind the treasurer to reprint the donor's year-end receipt, and to file a note recording the correction with that year's paperwork.

==Incorrect Envelope Amounts==
Go to Reports & Graphs / Contribution. Look up the donor name, and click on the incorrect donation. This will take you to Contribution Entry, to the envelope that needs correcting. Click Edit Envelope and make your correction, then continue to the next section to correct the Deposit total.

==Incorrect Deposit Totals==
Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then either:
# Contribution report, then clicking on a donation that's included in the deposit you're correcting, or
# Deposit report, clicking on the deposit you're correcting, then Make Corrections (bottom center of the window).

Now, you need to know whether you use Jewel's Deposit Slip feature. If you enter the number of coins and bills in each deposit, then you do use this feature. If you simply enter the total amount of the deposit, you do not use the Deposit Slip feature.

===If you use the Deposit Slip feature===
Click Edit Deposit Slip. Adjust the deposit slip to reflect the correct deposit amount, by adding/deleting checks or by adjusting the amount of cash, as appropriate. Click OK and Close to finish.

===If you do not use the Deposit Slip feature===
Check the Edit box at the top left of the Contribution Entry screen. Correct the deposit total, and click Close to finish.

:'''''Note:''' You will generally have to correct or add envelopes along with correcting the deposit total, as the deposit total has to match the total of all the envelopes.

==Incorrect Deposit Account, Date, or Memo==
Go to Reports & Graphs / Deposit report. Click on the affected deposit. Check the "Edit This Deposit" box at the top left. Make your corrections, then click OK to finish.

==Duplicate or Unwanted Offering Deposits==
Offerings can be deleted. But remember that deleting does not leave a trail, so if the deposit is more than a month or two back, it should usually be reversed rather than deleted.

===Deleting a Deposit===
Click Auditor, then View Journal. Select the deposit you wish to delete, and press the delete key on your keyboard. Click Close, then View Offerings. Select the deposit to be deleted, and press delete on your keyboard. Click Close twice to return to the front end. Again, this leaves no trail, so should only be used for recently-entered deposits.

===Reversing a Deposit===
To reverse a deposit, use [[Reverse a Duplicate Offering In a Previous Month|these instructions]] as a guide. Make sure that your reversing deposit is dated in the same year as the deposit you are reversing, so that donor receipts are correct. ''Transactions cannot be entered outside of the current Jewel month, so you will need to use the back end to either a) change the current Jewel month before entering the reversing deposit or b) change the date of the reversing deposit after you enter it.'' Make good use of the memo to preserve an audit trail.

If a deposit is old enough, it may be appropriate to reverse it as a General Journal Entry in the current year, and not reverse each envelope. This will not correct donor receipts, but for old enough deposits that can be ok.

==Cancel an Unfinished Offering==
'''''Note:''' If “Make Deposit,” has been clicked, it is too late to cancel this offering. You must Delete the deposit following the instructions above.''

# Get into the Contribution Entry screen for the deposit you wish to cancel, using one of the following:
#*If the NextStep button says Contribution Entry, click on it.
#*If the NextStep button says Make Deposit, click on it, then click Make Corrections.
# The "# Envs Entered" box will tell you how many envelopes you have entered for this deposit.
# On the Contribution Entry page, click “Delete Envelope” on every envelope that has been entered, one at a time. You can use the “Next” and the “Previous” arrows to access each envelope.
#Once all the envelopes are deleted, the “Cancel This Offering” button will appear and you can click on it. Your NextStep button should again say “Start New Offering.”

==Entering a Forgotten Offering==
See [[Changing the NextStep Button]]

Beginning Balances and Other Setup Issues

2026-04-30T20:03:29Z

Myla:

Beginning Balances and Other Setup Issues

2026-04-30T20:03:15Z

Myla:

Beginning Balances and Other Setup Issues

2026-04-30T19:54:22Z

Myla: Created page with "==Correcting Beginning Balances== There are two ways to correct beginning balances. If the correction is simple, click Auditor, then go to View Journal, select the Beginning Balances (usually right at the top, always dated 12/1/1994), and make your corrections. But if you need to add additional lines to the Beginning Balance transaction, it is often easier to delete the beginning balances (select it in View Journal and type Delete on your keyboard), then add new beginni..."

Changing the NextStep Button

2026-04-30T19:52:39Z

Myla:

To change the NextStep button, click Auditor, and select the desired option from the NextStep dropdown menu. In general, try to avoid re-opening closed months, unless it was very recently closed. Exceptions can be made if there's a good reason, of course. Remind treasurers to reprint their month-end reports and/or write notes on the previous reports to clarify the changes for the auditor.

==Forgotten Offerings==
This is the usual reason for changing the NextStep button, and the solution depends on the current NextStep.

'''Remit to Conference:''': Direct the treasurer to go to Offerings (at the top of the Jewel Home Screen), then Start New Offering. Confirm that a new offering in the current month is desired.

'''Send Remittance Report:''' Void (or delete) the conference check, and change the NextStep button back to Start New Offering. The treasurer can then proceed as usual, writing a new conference check and closing the month as usual.

'''Reconcile Bank Statements''' or any other post-remittance step: This is tricky because backing treasurers up to Start New Offering allows them to submit a second remittance for the month, which is often confusing to the conference office. Jewel tech support generally asks the treasurer to call back once they've entered the deposit so that we can move them back to where they were. Then Jewel will automatically include any additional remittance in the next remittance check. If the additional remittance is unusually large, you can contact the conference to see if they prefer a second remittance.

'''Start New Offering''' for a future month: Ask the treasurer to go ahead and enter the offering in their current month. Once they've done that, they can send the database to Auditor, and tech support can [[Offering Deposit Corrections in Auditor|correct the date]]. Jewel will automatically include any additional remittance in the next remittance check.

==Beginning Balances==
On the rare occasion that you need one of the "setting up a new database" NextStep options, click Auditor, then Tables / GeneralInfo, and change the NextStep column to the desired number. See [[Beginning Balances and Other Setup Issues]].

Using Auditor to Make Corrections

2026-04-30T19:27:11Z

Myla:

Changing the NextStep Button

2026-04-30T19:18:46Z

Myla:

To change the NextStep button, click Auditor, and select the desired option from the NextStep dropdown menu. In general, try to avoid re-opening closed months, unless it was very recently closed. Exceptions can be made if there's a good reason, of course. Remind treasurers to reprint their month-end reports and/or write notes on the previous reports to clarify the changes for the auditor.

On the rare occasion that you need one of the "setting up a new database" NextStep options, click Auditor, then Tables / GeneralInfo, and change the NextStep column to the desired number. Beginning Balances is 3.

==Forgotten Offerings==
This is the usual reason for changing the NextStep button, and the solution depends on the current NextStep.

'''Remit to Conference:''': Direct the treasurer to go to Offerings (at the top of the Jewel Home Screen), then Start New Offering. Confirm that a new offering in the current month is desired.

'''Send Remittance Report:''' Void (or delete) the conference check, and change the NextStep button back to Start New Offering. The treasurer can then proceed as usual, writing a new conference check and closing the month as usual.

'''Reconcile Bank Statements''' or any other post-remittance step: This is tricky because backing treasurers up to Start New Offering allows them to submit a second remittance for the month, which is often confusing to the conference office. Jewel tech support generally asks the treasurer to call back once they've entered the deposit so that we can move them back to where they were. Then Jewel will automatically include any additional remittance in the next remittance check. If the additional remittance is unusually large, you can contact the conference to see if they prefer a second remittance.

'''Start New Offering''' for a future month: Ask the treasurer to go ahead and enter the offering in their current month. Once they've done that, they can send the database to Auditor, and tech support can [[Offering Deposit Corrections in Auditor|correct the date]]. Jewel will automatically include any additional remittance in the next remittance check.

Changing the NextStep Button

2026-04-30T19:07:32Z

Myla:

To change the NextStep button, click Auditor, and select the desired option from the NextStep dropdown menu. In general, try to avoid re-opening closed months, unless it was very recently closed. Exceptions can be made if there's a good reason, of course. Remind treasurers to reprint their month-end reports and/or write notes on the previous reports to clarify the changes for the auditor.

==Forgotten Offerings==
This is the usual reason for changing the NextStep button, and the solution depends on the current NextStep.

'''Remit to Conference:''': Direct the treasurer to go to Offerings (at the top of the Jewel Home Screen), then Start New Offering. Confirm that a new offering in the current month is desired.

'''Send Remittance Report:''' Void (or delete) the conference check, and change the NextStep button back to Start New Offering. The treasurer can then proceed as usual, writing a new conference check and closing the month as usual.

'''Reconcile Bank Statements''' or any other post-remittance step: This is tricky because backing treasurers up to Start New Offering allows them to submit a second remittance for the month, which is often confusing to the conference office. Jewel tech support generally asks the treasurer to call back once they've entered the deposit so that we can move them back to where they were. Then Jewel will automatically include any additional remittance in the next remittance check. If the additional remittance is unusually large, you can contact the conference to see if they prefer a second remittance.

'''Start New Offering''' for a future month: Ask the treasurer to go ahead and enter the offering in their current month. Once they've done that, they can send the database to Auditor, and tech support can [[Offering Deposit Corrections in Auditor|correct the date]]. Jewel will automatically include any additional remittance in the next remittance check.

Changing the NextStep Button

2026-04-30T18:58:51Z

Myla: Created page with "To change the NextStep button, click Auditor, and select the desired option from the NextStep dropdown menu. ==Forgotten Offerings== The solution depends on the current NextStep. '''Remit to Conference:''': Direct the treasurer to go to Offerings (at the top of the Jewel Home Screen), then Start New Offering. Confirm that a new offering in the current month is desired. '''Send Remittance Report:''' Void (or delete) the conference check, and change the NextStep button..."

To change the NextStep button, click Auditor, and select the desired option from the NextStep dropdown menu.

==Forgotten Offerings==
The solution depends on the current NextStep.

'''Remit to Conference:''': Direct the treasurer to go to Offerings (at the top of the Jewel Home Screen), then Start New Offering. Confirm that a new offering in the current month is desired.

'''Send Remittance Report:''' Void (or delete) the conference check, and change the NextStep button back to Start New Offering. The treasurer can then proceed as usual, writing a new conference check and closing the month as usual.

'''Reconcile Bank Statements''' or any other post-remittance step: This is tricky because backing treasurers up to Start New Offering allows them to submit a second remittance for the month, which is often confusing to the conference office. Jewel tech support generally asks the treasurer to call back once they've entered the deposit so that we can move them back to where they were. Then Jewel will automatically include any additional remittance in the next remittance check. If the additional remittance is unusually large, you can contact the conference to see if they prefer a second remittance.

'''Start New Offering''' for a future month: Ask the treasurer to go ahead and enter the offering in their current month. Once they've done that, they can send the database to Auditor, and tech support can [[Offering Deposit Corrections in Auditor|correct the date]]. Jewel will automatically include any additional remittance in the next remittance check.

Usually, forgotten offerings are found at the Bank Reconciliation step. If so,
'''''Note:''' Be aware that moving back before Remit to Conference will allow the treasurer to submit a second remittance report. In most cases, it's best to ask the treasurer to contact their tech support after entering the forgotten

Using Auditor to Make Corrections

2026-04-30T18:28:35Z

Myla:

Auditor is a powerful tool to correct Jewel databases. Therefore it must be used with extreme caution. Jewel locks down all but the current month, so that treasurers cannot make changes to closed months. There are important reasons for this, such as preserving an audit trail, and not changing reports that have been accepted by the church board. Auditor users must exercise care to not change closed months unnecessarily, and to leave an audit trail for necessary changes.

Additionally, Jewel includes safeguards that keep the database in balance. The "front end" of Auditor, the part that looks like Jewel, also includes these safeguards. But when you click Auditor and go into the "back end", those safeguards are gone. '''Do not make changes to a database in the back end of Auditor unless you are 100% sure you know what you are doing.''' If you are not completely confident, ensure that you have a backup accessible so you can use it to undo your changes, if necessary.

There is a lot of "use your best judgement" involved in deciding how to make corrections. When a month has been recently closed, it's usually fine to directly edit the incorrect transaction(s) and reprint the affected monthly reports. Please thoroughly familiarize yourself with [[Making Corrections]] in the Jewel Handbook for general guidelines on how to edit transactions. Note that the Current Month instructions often also work for Previous Months when you're using Auditor. Always use the front end of Auditor whenever possible, as it's much easier to use and harder to make mistakes. When it is necessary to make a change in a closed month, utilize the memo to leave an audit trail as well as a record of who made the change.

[[Changing the NextStep Button]]

[[Offering Deposit Corrections in Auditor]]

[[Check or Electronic Payment Corrections in Auditor]]

[[General Journal or Transfer Corrections in Auditor]]

[[Bank Reconciliation Corrections in Auditor]]

Bank Reconciliation Corrections in Auditor

2026-04-30T18:20:45Z

Myla: /* Transaction Cleared on Wrong Bank Rec */

Bank Reconciliation Corrections in Auditor

2026-04-23T04:20:21Z

Myla: /* Transfers and General Journal Entries */