Skip to main content

Reports - POS Product Report

Written by Andy Hornbeak

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

  1. Go to Reports → Point of Sale → Product in the left sidebar.

  2. 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.

  3. Otherwise click + New and give it a Name, such as "POS Catalog Audit."

  4. Add the columns below from the Available panel.

  5. 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.

Did this answer your question?