Aantar

Aantar Books

The Sales, Purchases, Inventory, Damaged and Tax report screens

Five quick report screens that sit beside the Report Centre: daily sales, bills, live stock value, damaged-goods write-offs and tax collected by rate.

Where: Reports ▸ Sales ▸ Sales Reports · Reports ▸ Purchases ▸ Purchase Reports · Reports ▸ Inventory ▸ Inventory Reports · Reports ▸ Inventory ▸ Damaged Goods · Reports ▸ Sales Tax ▸ Sales Tax Summary

Besides the Report Centre, Aantar Books has five quick report screens, each answering one everyday question at a glance with summary tiles over a simple table:

Screen Opens from Answers
Sales report Reports ▸ Sales ▸ Sales Reports How much did we invoice each day, and how much of it has been paid?
Purchases report Reports ▸ Purchases ▸ Purchase Reports Which bills came in, and what do we still owe on them?
Inventory valuation Reports ▸ Inventory ▸ Inventory Reports What stock do we hold right now, at cost and at selling price?
Damaged goods Reports ▸ Inventory ▸ Damaged Goods What was written off as damaged, from which invoice, and why?
Tax report Reports ▸ Sales Tax ▸ Sales Tax Summary How much sales tax did we charge, rate by rate?

They work from your documents (invoices, credit memos and bills) rather than from the ledger. For the books' own figures, and for the reports you file from, use the Report Centre (see The Report Centre).

What the screens share

Choosing the period

The four dated screens (all but Inventory valuation, which is always live stock) open on the last 30 days and show the dates beside the title (2026-08-27 → 2026-09-25). To change them:

  • 7d, 30d, 90d — the last 7, 30 or 90 days, ending today.
  • Quarter, month, year ▾ — a menu headed PERIODS YOU CAN FILE FROM: this month, last month, the last completed quarter, the quarter before it, this fiscal year and last fiscal year. Quarters and years follow your company's fiscal year. The chosen period's name replaces the button text.
  • Pick two dates… (at the foot of that menu) — any two dates, up to the end of next year.

Buttons and table

  • Refresh reloads the figures.
  • Email and Export work as on every report: Export saves CSV, Excel or PDF; Email sends it as an attachment. Both carry the period by name, the table and the summary tiles. See Print, export and email a report.
  • The tiles above the table summarise the period.
  • Double-click a row, or select it and press Enter, to open what it adds up.
  • The footer shows the number of rows and what the figures include.

If a period has more documents than the screen can fetch at once, an amber banner warns: This period has more documents than one pull returns — the figures below are a MINIMUM, not the full period. Narrow the range (or use the back office) before filing anything from them. Use a shorter period, or the matching Report Centre report.

Sales report

One row per day, newest first, for invoices dated in the period.

Column What it shows
Date The invoice date.
Invoices How many invoices are dated that day.
Sales Their total, including tax.
Collected Payments recorded against those invoices (refunds subtract).
Outstanding Sales less Collected: what is still unpaid on that day's invoices.

Tiles: Invoices, Total sales, Collected, Outstanding and Average sale (total sales divided by the number of invoices).

Only saved (final) invoices count; estimates and held or pending sales are left out. Credit memos are not listed on this screen. Double-click a day to open Sales by Customer Detail for that day.

Tip: For sales before tax, net of credit memos, by customer, item or month, use the Sales reports in the Report Centre.

Purchases report

One row per bill dated in the period.

Column What it shows
Ref The bill's reference number.
Date The bill date.
Supplier The vendor.
Total The bill total.
Paid Payments made against it (refunds from the vendor subtract).
Owing Total less Paid.

Tiles: Bills, Total purchases, Paid, Owing. The screen fetches up to 1,000 bills for a period; beyond that the amber banner appears. Double-click a bill to open it in Enter Bills.

Inventory valuation

Every item with stock on hand right now, valued at its cost and at its selling price. There is no period: quantities are live.

Column What it shows
Item The item (and its variation, when it has one).
Code Its SKU.
On hand The quantity in stock across all locations.
Unit cost The item's purchase cost as set on the item. — when none is set.
Stock value On hand × unit cost.
Retail value On hand × the item's selling price.

Tiles: Items in stock, Units, Value at cost, Value at retail, and Potential margin (retail less cost). When some items in stock have no cost, the tile reads Value at cost (INCOMPLETE), a tile Items with no cost on this device says how many were valued at zero, and Potential margin is not shown. A tile INCOMPLETE — first 100,000 catalogue items only appears only for a catalogue larger than that.

Double-click an item to open its Item ledger: every movement in and out, across all locations. The footer reads Valued at catalog cost · live quantities.

Important: This screen values stock at each item's catalogue cost. The value your books carry, which follows the actual cost of what you bought, is on the Inventory Valuation Summary report and the Balance Sheet. See Inventory reports.

Damaged goods

Every item written off as damaged in the period.

Column What it shows
Date When it was written off.
Item The item (and variation).
Code Its SKU.
Qty How many were written off.
Loss value What the write-off cost.
Warehouse The location the stock left.
Invoice The invoice it came from, when it came back from a sale.
Customer That invoice's customer.
Reason The reason recorded.

Tiles: Write-offs, Units lost, Loss value, Invoices affected. Double-click a row to open its invoice.

Tax report (Sales Tax Summary)

The tab is called Tax (GST/PST) in a Canadian company and Tax in a US one. It shows the sales tax you charged in the period, one row per tax, and its figures are the same as the returns': it reads them from the Tax Collected by Rate report, which is worked out exactly as the GST/HST Return and the PST / QST Return are. For the same dates, the GST/HST here is line 103 of the GST/HST Return to the cent, and each PST row is its line on the PST / QST Return.

It opens on this quarter (your fiscal quarter), or on this month or this fiscal year when your GST/HST registration (Sales Tax ▸ Registrations) files monthly or yearly. The period menu still has Last 7 days, Last 30 days and Last 90 days, the months, the quarters and the years.

Column What it shows
Tax The tax, such as GST 5% or BC PST 7%.
Rate Its percentage.
Taxable amount The sales it was charged on.
Tax collected The tax charged.

How it is worked out:

  • Combined rates are split. A 12% "GST + PST" code on an invoice appears under GST 5% and under PST 7%, because they go on different returns. The invoice's sale is counted once in the Taxable sales tile, not once for each tax.
  • Credit memos subtract, in the period they were issued, including credit notes with no lines of their own (read through the invoice they returned).
  • A discount on the whole invoice lowers its tax, as it does in your books.
  • Tax charged on the invoice rather than its lines, and tax on freight, count as tax collected.
  • Rounding appears as its own row when your books round each invoice's tax to the cent and the rows, added up unrounded, come to a few cents different. With it, the GST/HST rows add up to line 103.
  • GST/HST on documents with no tax rate (as your books posted it) appears when a document charged tax with no tax code; it is on line 103 as your books posted it. Open Unassigned Sales Tax Amounts to fix those documents.
  • Zero-rated and exempt (E, 0%) and No tax code (not specified) show the sales that charged no tax. Double-click either for the sales behind it.
  • NOT CLASSIFIED rows are tax rates that are neither GST/HST nor provincial in your setup. Set their tax accounts in Accounting ▸ Setup before filing.

Tiles: Taxable sales (each taxed sale once), GST/HST (line 103), PST, Tax collected (the two together), Zero-rated & exempt, Credit notes netted (how many), and Agrees with your books ✓ document by document, or DOES NOT AGREE WITH YOUR BOOKS when a document's tax in your books differs from the document (open the GST/HST Return to see which).

When you choose a rolling window (7, 30 or 90 days) an amber banner says: This is a rolling window ending today, not a filing period. Pick a quarter, month or year before filing anything from these figures.

Double-click a tax row to open the Tax Detail for that rate and period, listing every document behind it.

Important: This screen shows tax collected only. The return you file also deducts input tax credits from your bills and expenses. File from the GST/HST Return and PST / QST Return reports (see Sales Tax reports) and Manage Sales Tax.

Common problems

Problem Fix
Amber MINIMUM banner The period holds more documents than the screen fetches. Choose a shorter period, or use the matching Report Centre report, which has no such limit for normal periods.
DOES NOT AGREE WITH YOUR BOOKS on the Tax report A document's GST/HST in your books differs from the document itself. Open the GST/HST Return for the same dates: its alert names each document. Open it and save it again, then refresh.
Inventory Value at cost (INCOMPLETE) Some items in stock have no purchase cost. Set a cost on those items (see Add or edit an item).
Sales figures differ from the Sales by Item Summary This screen totals invoices including tax and does not subtract credit memos; the Report Centre sales reports are before tax and net of credit memos.
Could not build this report The figures could not be fetched. Check your connection and click Try again.

Related articles

Something unclear or out of date? Write to support@aantar.com and name this page.