Help CenterHelp Center / Reports and insights · Reference
Product lines with each order's delivery charge, tax, total and tenders on its first line, for accounting entry.
The Tally Report is built for bookkeeping. It lists each product line of the orders placed in a date range, and puts the order-level money on the order's first line.
Open Reports › Tally report. For the shared controls, see Detailed reports.
Date Range, Order Statuses and, for shops with several locations, Fulfilment location. The report opens on today with Order Placed and Preparing Order selected. For accounting, select Delivered.
| Column | Meaning |
|---|---|
| # | Row number |
| Invoice Id | The order's invoice number with its prefix |
| Order Date, Delivery Date | When the order was placed and its scheduled delivery date |
| Customer Name | The customer |
| Address, Phone Number | Shop owner and Shop Manager only |
| Product, Quantity | The item and units ordered |
| Rate | The item's unit price |
| Single Unit Value, Unit | Pack size and unit |
| Total | The line's rate × quantity |
| Status | The order's status |
| Type | Goods, or Gift card for a gift-card sale |
| Column | Meaning |
|---|---|
| Delivery Charge | The order's delivery charge |
| Shop Charge | Any shop charge on the order |
| Net Price | The order's total: tax, delivery and charges included, discounts deducted |
| Tax Amount | Tax on the order |
| Wallet Used | Amount paid from the customer's wallet |
| Paid By Gift Card | Amount paid with a gift card |
These cells are empty on the order's other lines. That way, adding up a column gives the right sum for the period.
Commas in addresses are replaced by spaces so the address stays in one cell.
The file is named "Tally Report - " followed by the date range.