Feature catalogue

Reading the transaction list

The Transactions panel is the account’s history. It holds every entry that has moved a balance, newest first.

This article explains what each column means, and why a figure is sometimes not the one you expected.

The two dates on every row

Every entry carries two dates. They answer different questions, and they often differ.

Column What it answers
Trading Date Which business day the entry was booked
Value Date Which day the entry counts from

You post a correction today for something that happened last week. The trading date is today. The value date is last week. Interest is then recomputed from last week, because the value date is the day the money is treated as having moved. See value dating.

Statement view calls the trading date the Booking Date. It is the same date under a name a bank statement uses.

What each column shows

Some columns appear only when there is something to put in them, so two accounts rarely show the same set.

Column What it shows When it appears
Type What happened, such as “Interest Accrued” Always
Trading Date The business day the entry was booked Always
Value Date The day the entry counts from Always
Narrative The description carried on the entry When at least one entry has one
External Account The bank account number the money came from or went to When at least one entry has one
Source What raised the entry, such as a debit order or a reversal When at least one entry was not posted by hand
Amount The entry’s effect on the balance you are reading When no entry on the account carries tax
Net, Tax, Gross The entry split into its taxed parts When at least one entry carries tax
One column per balance The running total of that balance after the entry One for each balance you have selected
Posted By Who posted it, or System Always

The Type column shows the wording your organisation chose for that transaction type. See transaction types.

Reading the amount

Negative amounts show in brackets and in red, as (1,234.56). That is the accounting convention, not an error state.

The sign is relative to the balance you are reading. An entry that increases the first selected balance it moves shows positive. An entry that reduces it shows negative.

So the same entry can flip sign when you select a different balance. That is expected: you have changed the question, not the entry.

Net, tax and gross

Where an entry carries tax, one Amount column is replaced by three.

Column What it is
Gross The whole amount that moved the balance
Tax The tax inside that amount
Net The gross less the tax

A fee of 100.00 taxed at 15% reaches the list as a gross of 115.00, a tax of 15.00 and a net of 100.00. The balance moves by 115.00 — the gross, not the net.

When you post a taxed entry by hand you may type either the net or the gross, and the field fills the other one in. The list always shows the gross in the balance columns.

The balance columns

Select which balances you want on the right of the table from the list above it. The account type your organisation configured decides which balances are selected when you open the panel.

Each balance column reads as a running total, and three rules govern it.

An entry that moves none of the balances you selected is hidden from the list entirely. If an entry you expect is missing, select more balances before you conclude it was never posted.

How a reversal shows

A reversal never erases anything. It adds a second row that cancels the first.

Row Trading Date Value Date Amount
The original deposit 28 April 20 April 250.00
The reversal 28 April 20 April (250.00)

Three things follow, and they are what makes a reversal readable months later.

The Source column marks the second row as a reversal. Both rows keep the same transaction type, so a search on the type finds the pair.

To reverse an entry, select the reverse arrow at the end of its row. The arrow appears only on transaction types your organisation marks as reversible, and a reversal can be held for a countersignature — see countersign.

An entry dated in the future

An entry value-dated later than today is not a transaction yet, so it is not in the list.

It shows instead as a Pending settlement banner at the top of the account, naming the amount and the day it will settle. For money leaving the account, the amount is held against the available balance from the day you post it.

On its value date the entry settles and joins the list, with the trading date and the value date both set to that day.

flowchart TD
    A["You post an entry"] --> B{"Its value date"}
    B -->|Later than today| C["Pending settlement banner<br/>Not in the list"]
    B -->|Today| D["In the list<br/>Both dates today"]
    B -->|Earlier than today| E["In the list<br/>Booked today, valued earlier"]
    C -->|On the value date| D
    E --> F["The account revalues<br/>from the value date"]

Entries that are only a preview

While you have changes staged but unsaved, the panel previews the entries those changes would book. A banner counts them, and each preview row is amber and marked with a layers icon.

These rows are not booked. They do count in the balance columns, so the balances read as they would after you save. Discard the staged changes and the rows go.

Finding an entry

Statement view

Turn on Statement view to read the account the way a bank statement reads.

What changes What you get
Grouping Entries grouped by booking day, with an opening and a closing balance
Balance The total of the balances the statement covers, not the ones you selected
BTC Code The ISO 20022 bank transaction code that classifies the entry
Contents Booked entries only — previews are left out

Which balances a statement covers is set on the account type by your organisation. Your own balance selection does not apply here, which is why the closing balance is the same figure for everyone reading the account.

Entries that move none of those balances are hidden. Select Show non-statement entries to see them greyed alongside, with no balance against them.