Schema Mapping

Open it from the Schema Mapping item in the side menu. The back arrow returns to the Overview.

Reading the structure

• The Balance Sheet tab shows the reporting structure as a tree. The number on each line is how many ledgers are mapped to it or to the lines beneath it.
• The line above the tree shows how many ledgers are mapped and how many still need review.
• Search by name or code to find a line. Collapse all folds the tree; Expand all opens it again.
• Keyboard: ↑ ↓ move between lines, → ← expand or collapse, Enter selects.

Upload a schema file

• Click Upload schema file above the tree to bring in your own mapping as an Excel (.xlsx, .xls) or CSV file, up to 20 MB.
• Choose the column with ledger names, optionally the group or tagging column, and the column with the reporting group or code each ledger belongs to. We suggest columns from the headers.
• Apply schema matches the ledgers in your latest trial balance by name or group and files them under those reporting lines. You see how many ledgers matched and how many rows had no match.
• A trial balance must already be imported for the match to work.

Line details

• Select a line to open its details on the right: its code, the first mapped ledgers, its reporting path and whether it is a system line or a custom one.
• View all ledgers opens Mapping Studio.
• The close button clears the selection.

Profit & Loss, Cash Flow, Notes to Accounts and MIS Dashboard structures, adding custom lines and the more-actions menu are coming next.