OOrgFilesWEB
Help
OrgFiles Web demonstration A fictional firm with three sample engagements (one with French statements), shared with other visitors and rebuilt every night. Try anything inside an engagement. How it worksTalk to B2B

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.

ScreenWhat it controlsChange it when
Leadsheet GroupsWhich leadsheet an account appears on (A - Cash, BB - Accounts Payable, and so on).You need a leadsheet the standard set lacks.
Leadsheet SubgroupsThe subtotal rows inside a Group (BB.1, BB.2).You want to split a leadsheet into labelled sections.
Statement ClassesThe financial statement section an account belongs to (Assets - Current, Equity, Revenue, and so on).A section is missing or needs a different order.
Map NumbersThe 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 TableThe 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-clickOpens
Account on a journal entry lineChart of Accounts
Map No., Group, Subgroup or Class on the Chart of AccountsMap 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 SubgroupsLeadsheet 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.

  1. 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).
  2. Select Due from Shareholder. Set Flip Rule to Display if Credit and Flip Target to Due to Shareholder. Click Save Changes.
  3. 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.