The POS Product report lists the point of sale items in your catalog — everything you sell over the counter — along with each one's price, SKU, tax treatment, and the general ledger accounts it posts to. It is a setup and audit report rather than a sales report.
This article assumes you already know the basics of the Sharper reporting module — the Name, Token, Subtotal, column picker, and filter fields. For a full walkthrough of the reporting form itself, see the Sharper Reporting Reference Guide. This article only covers what's specific to the Product report.
Why This Report Matters
Point of sale catalogs grow quickly and get tidied rarely. Items are added for a season and never retired, prices drift out of date, and a product set up in a hurry ends up with no income account and no tax code. This report is how you review the whole list at once, which makes it useful for:
Checking every item posts to the correct income account before a period close
Reviewing prices across the range ahead of a price update
Confirming tax codes are applied consistently across similar items
Finding duplicate or obsolete items cluttering the register screen
Setup, Not Sales
This report describes how products are configured, not how they have sold. There are no quantity, revenue, or date-of-sale columns.
If you want to know what is selling, this is the wrong report — it shows the list price and nothing about actual sales. Use POS Order Details, which has quantities and revenue by product. This report only lists point of sale items; marina, campground, and booking products each have their own Product report.
Building a Product Report
Go to Reports → Point of Sale → Product in the left sidebar.
If a shipped report is close to what you need, use the ⋯ menu → Copy first — shipped reports can only be edited by the Sharper team.
Otherwise click + New and give it a Name, such as "POS Catalog Audit."
Add the columns below from the Available panel.
Click Save, then Get Report to run it.
Available Columns
Field | What It Shows |
Product Name | The item as it appears on the register |
SKU | The stock code — useful for matching against a supplier list or a stock count |
Price | The current selling price |
Active | Whether the item is still available to sell. Retiring old items keeps the register screen usable. |
Taxable | Whether tax is applied at all |
Tax Code | Which tax code governs the rate charged — worth reviewing where food, drink, and goods are taxed differently |
Income account | Where revenue from this item posts. The most important column for accounting accuracy. |
Account | The product's general account, used where a more specific one is not set |
Assets account | The asset account associated with the item, where one applies |
COGS account | The cost of goods sold account — relevant for resale stock where you track margin |
Created Date, Created Week, Created Time | When the item was added — useful for reviewing recent catalog changes |
Product ID | The item's identifier, for matching against other reports |
Note: A blank Income account does not necessarily mean revenue goes nowhere — Sharper falls back to the product's general Account when no income account is set. It does mean the posting is relying on a fallback rather than a deliberate choice, which is worth reviewing.
Useful Filters
Items with no income account: Field Income account, set to is empty. Run this before every period close.
Active catalog only: Field Active, set to Yes.
Non-taxable items: Field Taxable, set to No — check each one is deliberately exempt.
Items with no SKU: Field SKU, set to is empty, which makes stock counts harder than they need to be.
Zero-priced items: Field Price, operator =, value 0.
Everything on one income account: Field Income account, set to the account.
Pairing this with the POS Order Details report is the most useful review you can run — this one shows what is in the catalog, that one shows what has actually sold, and anything active in the first but absent from the second is a candidate for retirement.
