Product
Mail Books Ecommerce Assistant
Pricing Partners Demo Security Q&A Log in Request access

Help › Bookkeeping

Find a transaction

Open this in Talisk HQ

Transaction detail answers the question the other reports cannot: "show me everything that matches this, across every account, in date order". The General Ledger walks one account at a time; this walks the whole period and lets you narrow it.

  1. Go to Ledger › Reports, pick Custom on the group row, then open the Transaction detail tab beneath it.
  2. Set the period at the top right. Everything below is inside that window.
  3. Use the Filters row underneath to narrow the list. Each filter you add narrows the last.

Every row is one line of a posted journal entry: its Date, the Type of thing that posted it, the Name it was with, the Account it landed on, the Memo and Description, and its Debit or Credit.

Two things you can click on a row

There is one rule, and it holds on every row:

  • The Type chip narrows the report. Click it and only that kind of transaction is listed. It adds to whatever you were already filtering by, so you can go from one supplier to that supplier's payments in a click.
  • The Name opens the document. Click it and you land on the bill, the invoice, the bank line or the payout that row came from.

A Name that is not a link means there is no document to open. That is a real answer, not a fault: the opening balance entry, for instance, IS the document.

Clicking a Type only ever adds it. To take it off, use its chip on the Filters row, the same way you remove any other filter, so there is only ever one place to look.

Making the columns fit

Drag the edge of any column heading to make that column wider or narrower. This browser remembers the widths for that set of books, so the shape you set up stays put next time you open the report here. Another device or browser starts from the standard widths. The Date column is a fixed size that always fits a full date on one line.

What you can filter by

The search box sits in the header beside the period. Everything else is a button on the Filters row: click one, pick from the list that drops down, and the report narrows.

  • Text, in the search box, matches memos, line descriptions, account names and numbers, the type, an amount, or an entry id typed as #1482. Every word you type has to match somewhere.
  • Account, so you can pull one account out of the whole period. Pick more than one and you get all of them. The list searches by name or by number, so typing 5 narrows it to the 5000s.
  • Type, for example only bills, or only bank transactions. This one also takes more than one at a time.
  • Supplier, customer or job, one of each.
  • Amount, as a lower bound, an upper bound, or a range.
  • Direction, if you only want the debits or only the credits.

Taking a filter off again

Every filter you set appears as a small chip under the buttons, naming what it is. Click the chip to remove that filter, or Clear filters to remove them all at once. A filter that names something no longer on your books, a supplier you merged away for instance, still shows as a chip so you can see it and take it off; TALISK_HQ never quietly drops one, because dropping it would widen the report without telling you.

The address in your browser holds the whole thing, so you can send someone a link to exactly what you are looking at. Saving it as a view keeps the filters and the period together under a name; see Saved report views.

What the totals mean

The figures at the bottom are the totals of the transactions listed. That is the point of the report: filter to one supplier and the total is what you spent with them. It is not an account balance, and the screen says so whenever a filter is on.

This is deliberately different from the General Ledger, the Trial Balance and the Balance Sheet, where searching narrows the rows and every balance keeps its true, unfiltered value. Those are statements; this is a list you define.

Things worth knowing

  • A text search matches whole entries. Search for a word in one line and you get every line of that entry, including the other side of it. That is usually what you want when you are tracing something, but it means the totals cover both legs.
  • A supplier, customer or job filter works the same way. A job is recorded on the document, not on the individual ledger line, so a bill split across two jobs appears in full under each of them.
  • Some words will not find anything. The search matches a whole word or the start of one, so deprec finds depreciation but reciation does not.
  • A link TALISK_HQ cannot read shows nothing, on purpose. If a link has been mangled in transit, or edited by hand into something that is not a real filter, TALISK_HQ names the part it could not read and shows no rows. It does not quietly ignore that part and show you everything instead, because the totals underneath would then be the whole period while the link still says otherwise. Remove that filter's chip, or fix the address, and the report comes back.

Export it

CSV downloads every row the report matches, not just the page on screen, with a header block listing the period and every filter you applied, so the file explains itself later. It is offered only while the report is actually showing you something: if a filter cannot be read, or a saved view will not open, there is no download button, because a file outlives the screen it came from and nobody would be there to see the warning. A very large export stops at 20,000 rows and says so in the file, and leaves the totals off, because a total printed beside part of a list would not describe it.

Good to know: Transaction detail lists posted journal-entry lines only, so anything not yet posted (a bill awaiting approval, a draft entry) is absent. It is always on an accrual basis: there is no cash toggle, because the cash view changes when income and costs are recognised on a statement, not which lines exist in your ledger. The totals shown are the totals of the transactions listed, never an account balance. A text search matches whole journal entries, so both sides of a matching entry are listed. A supplier, customer or job filter also works at the entry level, so a bill split across two jobs is listed in full under each. A line with no amount on either side is left out of an amount search. It is a read-only report, so corrections are made where the entry came from.