Frequently Asked Questions

General FAQs

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.

Can Jewel be used for the bookkeeping of an Independent Ministry? There is no tithe or remittance check used.

Yes. If you have no Conference Funds in your Account List, then Jewel will skip the remittance check step of the month-end closing.

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.

How do I restore a backup?
Go to File → Utilities → Restore Full Backup. Find the location where the backup is stored and select the backup (.jlb) file, then click open.

Can I run Jewel on a Mac Computer?
Yes. However, Jewel is a Windows-based program. So you must install Windows on your Mac, which generally requires a Windows Emulator application.

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.

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.

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.

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.

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

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.

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.

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.

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.

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.

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.