Jewel - Recent changes [en]

Offering Deposit Corrections in Auditor

Myla — Fri, 01 May 2026 03:37:59 GMT

Cancel an Unfinished Offering

← Older revision		Revision as of 23:37, 30 April 2026
(8 intermediate revisions by the same user not shown)
Line 1:		Line 1:
			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==		==Incorrect Offering Date==
	If the correction is in the current month, use the front end.		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.		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.
Line 20:		Line 22:

	==Incorrect Deposit Totals==		==Incorrect Deposit Totals==
	Get to the Contribution Entry screen of the deposit that needs correcting by going to Reports & Graphs, then either:		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		# Contribution report, then click 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).		# 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 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.
	===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.		:'''''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==		==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.		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.

Line 46:		Line 44:
	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.		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.		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==		==Cancel an Unfinished Offering==
			Treasurers can cancel an unfinished offering themselves, following the instructions [[Correcting Offering Deposits In the Current Month\|here]].
	'''''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.		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==		==Entering a Forgotten Offering==

Send/Receive Issues in Auditor

Myla — Fri, 01 May 2026 02:26:04 GMT

Database Uploads from Auditor to Wrong Server

← Older revision		Revision as of 22:26, 30 April 2026
(5 intermediate revisions by the same user not shown)
Line 1:		Line 1:
	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~~ to ~~wrong~~ ~~server~~		==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".
	Treasurer sent, but it isn't on the server

			==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.

Beginning Balances and Other Setup Issues

Myla — Thu, 30 Apr 2026 21:34:45 GMT

← Older revision		Revision as of 17:34, 30 April 2026
Line 14:		Line 14:
	# 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 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.		# 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

Myla — Thu, 30 Apr 2026 21:24:15 GMT

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

New page

Can't access the server

Database uploads to wrong server

Treasurer sent, but it isn't on the server

Jewel Auditor

Myla — Thu, 30 Apr 2026 21:23:23 GMT

← Older revision		Revision as of 17:23, 30 April 2026
Line 17:		Line 17:

	[[Using Auditor to Make Corrections]]		[[Using Auditor to Make Corrections]]

			[[Send/Receive Issues in Auditor]]

Beginning Balances and Other Setup Issues

Myla — Thu, 30 Apr 2026 21:22:20 GMT

Entering the EntityID

← Older revision		Revision as of 17:22, 30 April 2026
(One intermediate revision by the same user not shown)
Line 7:		Line 7:

	'''''Note:''' If you change the beginning balance of a '''bank account,''' you must also go to Tables / BankRecs and correct the beginning balance there.''		'''''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.

Maintaining and Customizing Jewel

Myla — Thu, 30 Apr 2026 21:15:08 GMT

Pro Tips

← Older revision		Revision as of 17:15, 30 April 2026
(One intermediate revision by the same user not shown)
Line 42:		Line 42:
	:[[Simplified Entry for Complicated Payments / Reimbursements]]		:[[Simplified Entry for Complicated Payments / Reimbursements]]
	:[[Creating Excellent Reports for the Church Board]]		:[[Creating Excellent Reports for the Church Board]]


	-----		-----

Bank Reconciliation Corrections in Auditor

Myla — Thu, 30 Apr 2026 20:54:53 GMT

Bank Rec Beginning Balance

← Older revision		Revision as of 16:54, 30 April 2026
Line 8:		Line 8:

	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.		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.

			Remember that you can sort by clicking on column headings. This can be very helpful in finding mistyped dates that are in the distant past or in the future.

	==Cleaning Up the Bank Rec in Auditor==		==Cleaning Up the Bank Rec in Auditor==

Fixing Remittance Issues in Auditor

Myla — Thu, 30 Apr 2026 20:49:45 GMT

Duplicate Remittance Checks

← Older revision		Revision as of 16:49, 30 April 2026
(One intermediate revision by the same user not shown)
Line 16:		Line 16:
	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.		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.		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====		====Non-duplicate Remittance Checks====

Bank Reconciliation Corrections in Auditor

Myla — Thu, 30 Apr 2026 20:47:59 GMT

Transaction Cleared on Wrong Bank Rec

← Older revision		Revision as of 16:47, 30 April 2026
Line 32:		Line 32:
	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.]]		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~~==		==Marking Transactions Cleared/Uncleared==
	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.		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.

Fixing Remittance Issues in Auditor

Myla — Thu, 30 Apr 2026 20:46:52 GMT

Non-duplicate Remittance Checks

← Older revision		Revision as of 16:46, 30 April 2026
(One intermediate revision by the same user not shown)
Line 21:		Line 21:
	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 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 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.		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.
Line 28:		Line 28:
	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.		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!		:'''''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

Myla — Thu, 30 Apr 2026 20:44:55 GMT

Forgotten Offerings

← Older revision		Revision as of 16:44, 30 April 2026
Line 9:		Line 9:

	'''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.		'''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.		'''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.

Fixing Remittance Issues in Auditor

Myla — Thu, 30 Apr 2026 20:44:00 GMT

Stale Date Remittance Checks

← Older revision		Revision as of 16:44, 30 April 2026
Line 21:		Line 21:
	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 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.		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.

⚫	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.		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

Myla — Thu, 30 Apr 2026 20:39:10 GMT

← Older revision		Revision as of 16:39, 30 April 2026
(One intermediate revision by the same user not shown)
Line 17:		Line 17:
	If the treasurer is frequently entering duplicate checks or electronic payments, they may need help finding a better system.		If the treasurer is frequently entering duplicate checks or electronic payments, they may need help finding a better system.

	===Stale Date Remittance ~~Check~~===		===Stale Date Remittance Checks===
			See [[Fixing Remittance Issues in Auditor]]
	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.

		⚫	===Offering Deposit===
	====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.		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.

Line 41:		Line 27:
	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.		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==		===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.		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.

Fixing Remittance Issues in Auditor

Myla — Thu, 30 Apr 2026 20:38:09 GMT

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..."

New page

==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

Myla — Thu, 30 Apr 2026 20:34:35 GMT

Remittance Checks

← Older revision		Revision as of 16:34, 30 April 2026
Line 19:		Line 19:

	==Remittance Checks==		==Remittance Checks==
			See [[Fixing Remittance Issues in Auditor]]
	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.

Using Auditor to Make Corrections

Myla — Thu, 30 Apr 2026 20:33:45 GMT

← Older revision		Revision as of 16:33, 30 April 2026
Line 14:		Line 14:

	[[General Journal or Transfer 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]]

Bank Reconciliation Corrections in Auditor

Myla — Thu, 30 Apr 2026 20:32:55 GMT

Bank Rec Ending Date

← Older revision		Revision as of 16:32, 30 April 2026
Line 3:		Line 3:

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


	==Bank Rec Beginning Balance==		==Bank Rec Beginning Balance==

Program Installation and Database Setup Instructions

Myla — Thu, 30 Apr 2026 20:31:53 GMT

Installation

← Older revision		Revision as of 16:31, 30 April 2026
Line 7:		Line 7:
	Double-click on the Jewel Install file you have received. Once the Jewel Setup screen has appeared, follow the prompts to complete 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.		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 ==		== Setting Up Your Database ==

Offering Deposit Corrections in Auditor

Myla — Thu, 30 Apr 2026 20:12:39 GMT

Cancel an Unfinished Offering

← Older revision		Revision as of 16:12, 30 April 2026
(One intermediate revision by the same user not shown)
Line 1:		Line 1:
	__NOTOC__
	==Incorrect Offering Date==		==Incorrect Offering Date==
	If the correction is in the current month, use the front end.		If the correction is in the current month, use the front end.
Line 58:		Line 57:
	# 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.		# 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.”		#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]]

Beginning Balances and Other Setup Issues

Myla — Thu, 30 Apr 2026 20:03:29 GMT

← Older revision		Revision as of 16:03, 30 April 2026
(One intermediate revision by the same user not shown)
Line 2:		Line 2:
	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.		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 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.		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.
⚫	If you change the beginning balance of a bank account, you must also go to Tables / BankRecs and correct the beginning balance there.

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

Beginning Balances and Other Setup Issues

Myla — Thu, 30 Apr 2026 19:54:22 GMT

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..."

New page

==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 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.

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

Changing the NextStep Button

Myla — Thu, 30 Apr 2026 19:52:39 GMT

← Older revision		Revision as of 15:52, 30 April 2026
Line 1:		Line 1:
	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.		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==		==Forgotten Offerings==
Line 14:		Line 11:

	'''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.		'''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

Myla — Thu, 30 Apr 2026 19:27:11 GMT

← Older revision		Revision as of 15:27, 30 April 2026
Line 4:		Line 4:

	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.		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]]		[[Changing the NextStep Button]]

Changing the NextStep Button

Myla — Thu, 30 Apr 2026 19:18:46 GMT

← Older revision		Revision as of 15:18, 30 April 2026
(One intermediate revision by the same user not shown)
Line 1:		Line 1:
	To change the NextStep button, click Auditor, and select the desired option from the NextStep dropdown menu.		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==		==Forgotten Offerings==
	~~The~~ solution depends on the current NextStep.		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.		'''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.
Line 12:		Line 14:

	'''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.		'''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

Changing the NextStep Button

Myla — Thu, 30 Apr 2026 18:58:51 GMT

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..."

New page

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

Myla — Thu, 30 Apr 2026 18:28:35 GMT

← Older revision		Revision as of 14:28, 30 April 2026
Line 4:		Line 4:

	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.		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]]		[[Offering Deposit Corrections in Auditor]]

Bank Reconciliation Corrections in Auditor

Myla — Thu, 30 Apr 2026 18:20:45 GMT

Transaction Cleared on Wrong Bank Rec

← Older revision		Revision as of 14:20, 30 April 2026
Line 48:		Line 48:

	==Transaction Cleared on Wrong Bank Rec==		==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.