Purchase and Expense Line Details

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

LineCodeDescriptionLedger
Item on a purchase invoiceThe item codeThe item descriptionBlank: an item is booked through its inventory or purchase accounts
Ledger line on a purchase invoice (a GL item)The account codeThe line's memo, or the account name when there is no memoThe account the line was entered against
Expense lineThe expense head's codeThe line's memo, or the expense head's nameThe account set on that expense head

Filters

FilterWhat it does
DateThe document dates to include.
SuppliersOne supplier, or all.
Items / Item TypeShow only the item lines of that item or item type. Ledger and expense lines are left out.
Branches / DepartmentsLines 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.
LedgerPick 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.
DocumentPurchase 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.
CommentsPrinted on the report, and also used as a search: only lines whose document reference or memo contains the text.
DestinationPDF or Excel.

Columns

ColumnDescription
Qty, Unit Price, DiscountItem lines only.
Net AmountThe line amount before tax. For a ledger or expense line on a tax-inclusive document, the tax is taken out of the amount.
Tax TypeThe tax type chosen on the line. Blank when the line has no tax.
TaxFor 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.
TotalNet 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

Global Coverage

Multi-Country ERP — One Platform

Supports GST (India), VAT (UAE, South Africa, Egypt, Iraq, Botswana), and local compliance across all regions.

🇮🇳 India (GST)
🇦🇪 UAE (VAT)
🇸🇦 Saudi Arabia
🇶🇦 Qatar
🇧🇭 Bahrain
🇴🇲 Oman
🇰🇼 Kuwait
🇪🇬 Egypt
🇮🇶 Iraq
🇿🇦 South Africa
🇧🇼 Botswana
🇲🇾 Malaysia
🇸🇬 Singapore
🇦🇺 Australia
🇬🇧 United Kingdom
🇺🇸 USA
🌏 & More Regions
Chat with us
Book a demo Free trial