Tracing a ledger account
Trace answers one question: what moved this general ledger account over a period, and where did it end up? It shows the opening balance, every entry that touched the account, and the closing balance — with a running balance on each row.
You can trace several ledger accounts at once. Each becomes a column, so a posting that hit three accounts is legible on one line instead of three separate searches.
Opening the trace
Trace sits beside Balances and Entries in the Accounting group. It is available on an account, on an operating entity, and on a cost centre.
- On an account, Trace opens ready. It traces every ledger account the account’s entries touched in the period, and the grid is on screen without you choosing anything.
- On an operating entity or a cost centre, Trace asks first. Those scopes touch hundreds of ledger accounts, so you choose which to trace and select Run.
You can also reach Trace from a balance. On the Balances panel, select the search icon on any row and that ledger account’s trace opens with the account already chosen.
Reading the grid
Rows are entries, newest first, ordered by the date they were traded. Columns are the ledger accounts you are tracing.
| Column | What it shows |
|---|---|
| Trading date | The date the entry was traded. This is the order the balances build in. |
| Value date | The date the entry takes effect for interest. Information only here. |
| Transaction, Counterparty, Account | What the entry was and whose it is. |
| Cost centre | The cost centre the entry carries. |
| One column per traced account | That account’s balance after this entry. |
A cell is empty when the entry did not touch that ledger account. The closing row heads the grid. Older entries load a page at a time: select Load older to add them at the bottom. Once the oldest entry is in, the opening row closes the grid, so the period reads from the bottom up.
A worked example
A loan’s principal account opens a month at 600, takes an advance of 400, then another of 250.
| Row | Movement | Balance |
|---|---|---|
| Closing balance | 1,250 | |
| Advance | 250 | 1,250 |
| Advance | 400 | 1,000 |
| Opening balance | 600 |
Opening plus the movement equals closing, and every figure is in the operating entity’s accounting currency.
A summary row
If your books were imported with summarised history, a month of daily interest can be one row. That row says what it stands for, under the transaction name.
| Row says | What it means | Where it leads |
|---|---|---|
| covers 30 transactions, March 2019 | One entry for that month’s daily postings on this account | The account’s transactions for March 2019 |
| covers 21 daily revaluations, March 2019 | One entry for that month’s daily revaluations | Nowhere. Read the days in your legacy revaluation report. |
| Nothing extra | An ordinary entry | — |
To find one day inside a summarised month, select the covers text. The account’s transaction list opens on that month, and the day is there. The balance after a summary row is exact at month-end; there is no balance for the days inside it. The Entries panel shows the same text. See importing a book.
Why the columns cannot be sorted
Every other table in the app lets you sort by any column. This one does not, and that is deliberate.
A running balance only means something in the order it was accumulated. Sort the same rows by amount and every balance in the grid becomes a number that was never true. So the column headings offer no sort at all.
Dates and currency
Trace is stated in the operating entity’s accounting currency throughout. Each row still shows the entry’s own currency, its amount in that currency, and the rate used, so a foreign-currency entry is readable without leaving the screen.
Balances build on trading date, which is what the books are keyed on. An entry traded inside the period but value-dated before it starts is counted in the period’s movement, not in its opening. This is why a closing balance in Trace always equals the figure the Balances panel reports for the same ledger account.
Changing the period
While you have not chosen the accounts yourself, changing the period recomputes which are traced: widening brings in the accounts the wider period reaches, and narrowing drops the ones it no longer does. Browsing dates does not mean re-picking columns.
The moment you use the picker, your choice is fixed. Changing the period then leaves your columns alone.
Narrowing to one cost centre
On a cost centre, Trace shows only the entries that centre carries, and the opening and closing balances count only those entries.
Without narrowing, a ledger account’s balance is its total across every cost centre, and each row names the centre its own entry carries. Total on the face, split on demand.
Exporting
Select Export to download the whole period, not just the entries on screen. The file reads like the grid: the closing balances first, then one row per entry, newest first, then the opening balances. Each entry row carries a balance and a movement for each traced account. It is the screen, reconcilable in a spreadsheet.
Exporting needs its own permission, separate from viewing the trace. Without it, the Export button is not shown. Every export is recorded in your user history.
A very long period holds more entries than one page. The screen says how many of them it shows. The closing balance is always the whole period’s.
Trace or Entries?
Both list entries, and they answer different questions.
| Use | When |
|---|---|
| Trace | You want a balance. You are following one or more ledger accounts over a period and need the figures to tie. |
| Entries | You want to find something. You need search, sorting, and every entry for the scope regardless of which ledger account it touched. |
Trace is ordered and cannot be re-sorted, because its balances depend on the order. Entries sorts and searches freely, because it does not carry a running balance.
What your organisation configures
- Which account types offer Trace. It is part of the Accounting group, alongside Balances and Entries, and your organisation chooses which account types show that group.
- The ledger accounts themselves, and the cost centres entries are posted to.
- The accounting currency each operating entity reports in.
- Who may export a trace. It is a permission your administrator grants.
From the LedgerTM product guide, as shipped with the software and written with it. Copied from the platform repository on 2026-11-11.