How to read invoice quantity and sales totals on the Transactions Report?

TB Reports · library · Last updated August 18, 2026 · Version 1

This process works in apps: TB Reports

This article will teach you how to read inventory quantity vs sales and purchase totals after the POS Transactions Report sign update.

The legacy Tire Base POS Transactions Report now sends inventory-oriented quantity and document-oriented amounts. Invoices show a positive dollar amount and a negative quantity (stock leaving). Credit memos, refunds, and purchase orders show the opposite. Vendor credits show a positive amount and a negative quantity. This is how POS records the document — not a bug. TB Reports keeps those signs on each grid row and still calculates Subtotal Sales, tax, gross profit, vendor spend, and Profit and Loss from the document type so sales stay sales and purchases stay purchases.

Steps

• Open TB Reports and run Transactions Report (or Sales Journal / Profit and Loss) for the store and date range you care about.
• Confirm Document Type on the row — Invoice, Credit Memo, Refund Receipt, Purchase Order, or Vendor Credit.
• Read Quantity as inventory movement: negative on an invoice means units sold (stock out); positive on a credit memo, refund, or PO means units returned or received.
• Read Amount / Subtotal as the document total: invoices stay positive; credit memos, refunds, and purchase orders are negative; vendor credits are positive.
• Use the Subtotal Sales, Tax Collected, Total Sales, and Gross Profit cards — or Profit and Loss — for sales and purchase performance. Those ignore inventory sign and net returns correctly.
• Open the dashboard Top Customers and Top Vendors lists to confirm net sales and net PO spend. Vendor ranking uses purchase spend, not the raw negative PO amount.
• If a Quantity footer looks negative on an invoice-heavy day, that is net inventory out. It does not mean the shop had negative sales.

Conclusion & best practices

Do not flip signs by hand in Excel to “fix” invoices. Filter to Invoices and Credit Memos when you want a sales view, and use the sales KPI cards or P&L for totals. Escalate only if Subtotal Sales or P&L income is wrong after you confirm the date range and store filter.