Transactions
The Transactions page lists every transaction across your Family Office, split into All, Investment and Banking tabs, with filters, search, CSV download and bulk updates.
Transactions are the individual events behind your balances: buys and sells, income, fees, deposits, withdrawals and transfers. The Transactions page gathers them from every account in one table, so you can find, review and correct them in one place.
How it works
Where to find your transactions
- Sidebar → Transactions shows every transaction across your Family Office.
- An account's Transactions tab shows only that account's transactions, with a running balance.
- An asset's Transactions tab shows only the transactions for that holding.
The All, Investment and Banking tabs
The Transactions page splits your history into three tabs:
| Tab | What it shows |
|---|---|
| All | Every transaction. |
| Investment | Transactions in your investment accounts. |
| Banking | Transactions in your bank, loan and credit card accounts. |
A tab is greyed out when you have no accounts of that kind.
The columns
| Column | What it shows |
|---|---|
| Date | The date of the transaction. |
| Type | The transaction type, with the security it involves (or Cash). |
| Account Name | The account it belongs to. Transfers show an arrow and the other account. |
| Security / Payee | The category and the Payee. A transaction with neither shows Uncategorized and Unknown. |
| Quantity | The number of shares or units. |
| Price | The price per share or unit. |
| Amount | The value of the transaction. |
On an account's Transactions tab there's also a Running Balance column, showing the account's balance after each transaction.
Transactions you haven't seen yet appear in bold the first time you open the page.
The coloured dot at the start of each row shows whether a transaction has been cleared, reconciled, or needs your review. See Transaction status.
Using it
Searching and filtering
- Search looks through transaction descriptions.
- The filter button opens Custom Filter, where you can narrow the list by Status, Date Range, Security, Account, Payor/Payee and Category. Each filter you add appears as a chip above the table. Click a chip to change or remove it, or Clear all to start over.
- Clicking Uncategorized or Unknown in the table shows every transaction that is missing a category or payee.
Sorting and paging
The table is sorted newest first. Click Date or Account Name to sort by that column. Choose 50, 100, 250 or 500 rows per page at the bottom of the table.
Downloading transactions
The download icon above the table saves the transactions on the current page as a CSV file. To download more at once, set the rows per page to 500 first, or narrow the list with filters.
Updating many transactions at once
- Tick the box beside each transaction you want to change. The box in the header selects every transaction on the current page.
- Click Bulk Update.
- Choose what to do:
- Change type to:
- Add a category:
- Add a payee:
- Add a note:
- Delete transaction(s)
- Clear transaction(s)
- Unreconcile transaction(s)
- Apply the update and confirm.
You can combine type, category, payee and note changes in one update. Deleting, clearing and unreconciling each run on their own.
If only some of the selected transactions can take a category or payee, Annise tells you how many it will apply to before you confirm.
Opening balance rows (the starting positions of an account) can't be selected for a bulk update.
Troubleshooting
Adding, editing and bulk updates need edit access to the Family Office. If you can view transactions but not change them, ask a Family Office owner to update your permissions.
The download saves the current page only. Raise the rows per page to 500, or filter the list down, and download again.
Connected accounts bring in new transactions from your bank about once a day, usually overnight after the market closes. The refresh icon above the table checks your accounts for anything new.