HELP · USER MANUAL
7. The reference tables
These tables hold the vocabulary the rest of the app uses. A new engagement arrives with sensible contents, so most firms change them only when something is missing. All five are under Setup › Account Tables. Hover over a button for a tooltip.
| Screen | What it controls | Change it when |
|---|---|---|
| Leadsheet Groups | Which leadsheet an account appears on (A - Cash, BB - Accounts Payable, and so on). | You need a leadsheet the standard set lacks. |
| Leadsheet Subgroups | The subtotal rows inside a Group (BB.1, BB.2). | You want to split a leadsheet into labelled sections. |
| Statement Classes | The financial statement section an account belongs to (Assets - Current, Equity, Revenue, and so on). | A section is missing or needs a different order. |
| Map Numbers | The mapping catalogue: statement type, normal sign, GIFI code, and flip rule for each Map Number. | You need a Map Number the standard set lacks. |
| GIFI Table | The GIFI codes you can map to. | The code you need is not listed. |
On every table screen, edit a row and click Save Changes, and reorder with the Up and Down buttons where they appear. The + Add button opens a small form: fill it in and click OK to save the new record straight away, or Cancel to add nothing. Fields marked * are required. If something is missing or already exists, the form says so and stays open with what you typed.
Double-click a field to open its list
Double-click a field that picks from one of these lists, and that list's own screen opens in a separate window, on the entry the field shows. Add, review or fix what you need, close the window, and the field's choices are refreshed. For example, double-click the Account in a journal entry to open the Chart of Accounts.
| Double-click | Opens |
|---|---|
| Account on a journal entry line | Chart of Accounts |
| Map No., Group, Subgroup or Class on the Chart of Accounts | Map Numbers, Leadsheet Groups, Leadsheet Subgroups, Statement Classes |
| Map Group or GIFI Code on Map Numbers (the list or the details form) | Map Groups, GIFI Table |
| Group on Leadsheet Subgroups | Leadsheet Groups |
A single click still opens the drop-down list, after a short pause so the app can tell a single click from a double-click.
Statement Classes and Map Groups are different things
They look alike but do different jobs.
- A Statement Class is a property of an account. It decides which section of the financial statements the account prints in. It affects your numbers.
- A Map Group is only a folder that organizes Map Numbers in the picker. It never affects a number. Open it from the Map Numbers screen with Manage Map Groups....
Flip accounts
Some accounts print on one side of the balance sheet or the other depending on their balance. Due to/from shareholder is the usual example: a debit balance is an asset, a credit balance is a liability. This is set on the Map Number, not on the account.
- In Setup › Map Numbers, make sure there are two Balance Sheet Map Numbers, for example Due from Shareholder (Normal Sign: Debit) and Due to Shareholder (Normal Sign: Credit).
- Select Due from Shareholder. Set Flip Rule to Display if Credit and Flip Target to Due to Shareholder. Click Save Changes.
- Map your shareholder account to Due from Shareholder, the one with the flip rule.
A debit balance now prints as an asset, and a credit balance prints as a liability. Use Display if Debit for the opposite case, where an account mapped to a liability moves to the asset side.
Remember three things:
- The flip applies to the financial statements only. Leadsheets and trial balance screens keep showing the account where you mapped it.
- Each account flips on its own balance. Two shareholder accounts are not netted against each other.
- The rule belongs to the Map Number, so every account mapped to it flips.