Purchase and Expense Line Details
The Purchase and Expense Line Details report lists every line of your purchase invoices and expenses: the items you bought, the ledger (GL) lines entered on an invoice, and the expense heads of each expense, with the ledger each line is booked to, its tax type and its tax.
Reports > Purchases > Purchase and Expense Line Details
This report was called Purchase Invoice Item Detailed before. It now also shows ledger lines and expenses.
What each line is
| Line | Code | Description | Ledger |
|---|---|---|---|
| Item on a purchase invoice | The item code | The item description | Blank: an item is booked through its inventory or purchase accounts |
| Ledger line on a purchase invoice (a GL item) | The account code | The line's memo, or the account name when there is no memo | The account the line was entered against |
| Expense line | The expense head's code | The line's memo, or the expense head's name | The account set on that expense head |
Filters
| Filter | What it does |
|---|---|
| Date | The document dates to include. |
| Suppliers | One supplier, or all. |
| Items / Item Type | Show only the item lines of that item or item type. Ledger and expense lines are left out. |
| Branches / Departments | Lines of that branch or department. An expense line takes the expense's own branch, or the supplier's when the expense has none, the same one its ledger entry was posted with. |
| Ledger | Pick an account to see only the lines booked to it: ledger lines on invoices and expense lines whose expense head uses that account. Item lines are left out. |
| Document | Purchase Invoices (the default), Expenses, or Both. With Both, invoices and expenses print in two groups, each with its own total, and a grand total at the end. |
| Comments | Printed on the report, and also used as a search: only lines whose document reference or memo contains the text. |
| Destination | PDF or Excel. |
Columns
| Column | Description |
|---|---|
| Qty, Unit Price, Discount | Item lines only. |
| Net Amount | The line amount before tax. For a ledger or expense line on a tax-inclusive document, the tax is taken out of the amount. |
| Tax Type | The tax type chosen on the line. Blank when the line has no tax. |
| Tax | For an item, the tax charged on the invoice line. For a ledger or expense line, the line's tax type at the supplier's tax group rate, the same way the document charged it. A ledger line posted to a tax account carries no tax. |
| Total | Net Amount plus Tax. |
Voided documents and drafts are not included. Amounts are in the document's currency.
Related pages
Purchase and Supplier Reports · Purchase Invoice View · Purchase Expenses View · Purchase Expenses Settings · GL Accounts