Back End Overview

Jewel Auditor's back end is where the magic happens. But remember that not all magic is good! The back end is extremely powerful, which means it's also a place where mistakes can easily be made and audit trails can be lost forever. The back end is the raw data behind the Jewel database. Transactions in any time period can be deleted or changed or added. Reconciliations can be hopelessly tangled. Beginning balances can be altered. Deposits and entire databases can be left out of balance. And none of this leaves an audit trail unless you intentionally leave bread crumbs.

If you are not 100% sure of what you are doing in the back end, be sure you have a backup of your database, try your fix, then triple- and quadruple-check that you did what you intended to do. Or better yet, consult this wiki or your tech support team for help before things get hopelessly muddled. We often tell treasurers that there's very little they do that we can't fix. This is not true of Auditor users. If you mess it up, we may or may not be able to fix it.

Below is an overview of the back end features. Some get used more than others, and so their description is more detailed.

Open Database

The obvious!

Tables

All tables are sortable by clicking on column headings.

Names

This is the same list you see in Maintenance / Edit Names in the front end, but in spreadsheet format. Rarely used.

Accounts

This is the same list you see in Maintenance / Edit Accounts. Note that the AccountID column is an internal Auditor designation, and is not visible in Jewel. You will sometimes need to know the AccountID of a given account when editing transactions in the back end.