Frequently Asked Questions

General FAQs

network computer network Can Jewel be used on a network?
Yes. However, if two or more computers are doing the same function, such as entering contributions, then the computer that started the operation must be the one to close/finish the operation.

independent ministry Can Jewel be used for the bookkeeping of an Independent Ministry? There is no tithe or remittance check used.
Yes. You will need to void the Conference remittance check when it comes each month to avoid skipping a check number.

multiple databases database Can I have more than one database on one program of Jewel?
Yes. You'll just need to make sure the file names are different, and be careful to put the correct data into the correct database. To open different databases, go to File → Open Database. Select the database you would like to open, then click Open. This is only to be done for groups or companies associated with your church. A separate church will need to purchase their own copy of Jewel.

restore full backup backup restore backup How do I restore a backup?
Go to File → Utilities → Restore Full Backup. Change directory to where the backup is stored (usually the Jewel directory, but it depends on what you have named it) and select the backup (.jlb) file, then click open. The full backup of your database is restored to Jewel as soon as you click open.

investment funds gains/losses investment How do I record gains and/or losses for investment funds?
This is done during your monthly reconciliation of your investment fund account. In the reconciliation screen, select the appropriate account for your investment fund. Then, in New Entry at bottom right corner, enter the interest (positive for gain, negative for loss), add a Memo, and click Add Entry. Make sure to click OK when the reconciliation is complete, and the gain/loss entry will be recorded.

You can also record investment gains/losses by making a General Journal Entry. You can use this method if you want to record them at a different time from when you are performing your monthly bank reconciliation.

Jewel not opening Help!! My Jewel software won't open!!
You will need your original Jewel CD. First, back up your database. You should be able to find it in your Jewel directory on your computer - simply save your database on external memory (memory stick, CD, etc). Then uninstall Jewel (go to My Computer → Control Panel → Add/Remove Programs). Once Jewel is uninstalled, reinstall Jewel from the your original CD and restore your backup database (File → Utilities → Restore Full Backup).

MacIntosh computer macintosh apple windows emulator Can I run Jewel on a Mac Computer?
Yes. But you will need to run it in a Windows Emulator. Contact the business you purchased your Mac from, and ask about a Windows Emulator for running software designed for Windows.

opening database database won't open database error message database When I try to open my database, an error message comes up saying the file has been moved, deleted, or renamed. How can I open my database?
On your Windows toolbar, go to Start → Search, then type your church's name.mdb and search in all files and folders. When the database is found, move it to the directory under My Documents named "Jewel." You should now be able to open your database as usual in Jewel.

screen resolution resolution netbook What is the recommended screen resolution for running Jewel?
The minimum screen resolution for Jewel is 1024 by 768 pixels. It is recommended to set the DPI to 96, and font size to normal. Jewel should work just fine on any normal screen resolution. If you are using a netbook however, we recommend you use an external monitor.

How much history can my Jewel database hold?
As much as you need it to! It's only limit is the size of your computer's hard drive, which should be quite adequate. Data files take up a very small amount of memory.

security system antivirus virus I am installing Jewel on a new/different computer. However, when trying to install, my security system flagged Jewel as a virus. What do I do?
This is likely due to the file: WINVNC.exe It is a file within Jewel that is used for desktop sharing. Look at your security system and find out this is the file being flagged. If so, it's fine to go ahead and install. Jewel does not have a virus! Your security system may find the WINVNC.exe file a security threat because it is part of a system which would allow another user to have access to your desktop.

database database from auditor opening database I can't open my database received from the auditor. And/or there is a Windows error message when trying to open database directly from my memory stick. Why can't I open the database?
You are probably trying to open the database with something other than Jewel. Remember: Your database can ONLY be opened IN JEWEL!! You will get error messages when trying to open it any other way.

backup database database backup back up It is not month-end, but I want to make a back up of my database. How can I perform this process?
From Jewel's Menu Bar, go to File → Copy to Disk. This will back up your database to the drive specified under Maintenance → Properties → Copy to Disk Path. This is the same location you back up to at month end, so if you are using a different drive from your month end backups, you will need to change the Disk Path name.

Making Corrections

correct donor name change donor name How do I correct a Donor name in a closed month?

1. Go to Start New Offering and change the date to the first day after the last offering you entered (if you have entered March 6 offering, then change the date to March 7.
2. Leave the offering amount blank.
3. Bring up the incorrect name in Contribution Entry. Put a minus sign (-) in front of the cash or check amount. Put a minus sign (-) in front of all the amounts that were entered on that envelope.
4. Click "No" when Jewel asks if you want to do a Trial Deposit.
5. Now, still in Contribution entry, bring up the correct name. Enter the envelope as usual.
6. Go on to Make Deposit and complete the Deposit. (You should have zero for all offerings because you added on one envelope and subtracted on the other.)

How do I void a check in a closed month?

1. To void a check that has already been entered into the computer, click on Accounting → Void a Check.
2. Click on the check you would like to void.
3. If needed, modify the memo field so that it documents what you are doing.
4. Click OK.

check correction change check edit check How do I correct a check written in the current month?
Go to Reports & Graphs → Check Report and Select (double click) the check you need to correct. Then click on Edit Check, make the necessary corrections and click OK.

correct remittance check How do I correct a Conference Remittance check?
First, you will need to void the incorrect remittance check, by selecting the appropriate check from the Check Report, then edit check, and enter Void in pay to the order of, then click make electronic payment. Once the check is voided, go to Accounting → Make Manual Remittance and enter the correct amount for the remittance check. Click OK to complete the record and print the corrected check.

incorrect contribution order contribution order I've entered a week's contribution in the wrong order - how do I fix it?
Okay. For the sake of explaining, let's call the weeks, week 1 and week 2. You have accidentally entered week 2 BEFORE entering week 1. We are assuming Week 2 was entered under the correct date. What you'll need to do is go ahead and enter week 1, but under a date AFTER week 2's offering (ie Week 2 was March 6, so enter week 1 under March 7). After you have completed week 1's offering, go to the Deposit Report, select Week 1's deposit, and change the offering to the correct date.

If you have entered more than one offering in the wrong order, you will need to either send it to your auditor to fix the dates, or just leave them in the wrong order and make a note of it on your month-end reports.

transfer funds I accidentally put money in a conference account that should have been a local account. How do I transfer the funds to the appropriate account?
First, you will need to enable transfers from conference accounts. Go to Maintenance → Properties → General tab. Under the section "Options", find the option that says "Allow Transfers Between Conference and Local Accounts" and place a check by it. Now you can go to Transfer Funds and make the appropriate transfer from conference to local funds. Make sure to go back to Properties and Uncheck the allow transfer from Conference option, to avoid accidentally making an incorrect transfer in the future.

correct an offering How do I correct an offering in a current month?

1. Go to Reports and Graphs → Deposit Report.
2. Double click on the Deposit that needs correction.
3. Click on the Make Corrections button, then click on Trial Deposit.
4. Double click the envelope that needs to be corrected.
5. Click on Edit Envelope and make the necessary correction.
6. Click Close.
7. Click on the NextStep button that says Make Contributions. Click on Edit box in upper left hand corner and change the date and amount to the next offering you need to enter.

You can reprint your weekly report, or just pencil in the change on the report that you printed earlier.

send to auditor send database receive from auditor receive database How do I send my database to my auditor/tech support for corrections?
There are times when you will need the auditor/tech support to make corrections for you. This is done by sending your database to your auditor/tech support. They will make the necessary corrections, and then send the corrected database back to you. Follow these instructions when sending/receiving from your auditor or our tech support:

How to Send/Receive From Auditor
1. First you will need to contact your auditor/tech support either by phone or e-mail and let them know what corrections need to be made.
2. Go to File → File Transfer → Send to Auditor. Jewel will check for an Internet connection, and will immediately send your database to your auditor.
3. Wait for your auditor to complete the database correction. Wait for them to contact you - via phone or email - to let you know the database is ready to be received.
4. Now go to File → File Transfer → Receive From Auditor. Again, you will need an Internet connection for this step as well. Clicking on "Receive from auditor" will replace your current database with the corrected database from your auditor.