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.
- It counts that one balance only — never the account’s total worth. See position types.
- It counts from the account’s first entry, so the figure on a row is that balance on that day. Narrowing the date range does not restart the count.
- It counts every entry that moves the balance, including entries the date range is hiding.
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 reversal is booked today, but value-dated at the original’s value date. The money is treated as never having moved.
- Where that value date is in the past, the account revalues from it, so interest already charged is corrected.
- The original keeps its row and loses its reverse action, so nobody reverses it twice.
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
- Date range. It opens on the last 180 days, ending at today’s trading date, and you cannot set a To date beyond that. It filters on trading date, so look for a backdated correction on the day it was booked.
- Search. The box matches any text on show, in any column — a narrative, an amount, a name, a date. The count beside the title reads “N of M” while a search is filtering.
- Order. The list is always newest first. The columns do not sort.
- Export. Excel, CSV and JSON exports carry exactly the rows and columns on screen.
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.