Beginning Balances and Other Setup Issues

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:

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