Find a transaction

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. Add filters until the list is what you want. Each one 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.

What you can filter by

• Text 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.
• Type, for example only bills, or only bank transactions.
• Supplier, customer or job.
• Amount, as a lower bound, an upper bound, or a range.
• Money in or out, if you only want one side.

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.

Export it

CSV downloads exactly the rows on screen, with a header block listing the period and every filter you applied, so the file explains itself later. 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.