Skip to main content

Sales Tax Report

Provides a detailed breakdown of taxable and non-taxable sales by tax rate to support reconciliation and sales tax filing accuracy.

Navigate to: Reports > Financial > Sales Tax Report


What This Report Is For

  • Reviewing taxable vs. non-taxable sales for a period.
    See all sales grouped by tax rate for your selected time window.

  • Reconciling collected tax totals by tax rate.
    Verify tax amounts by rate — including 0.00% rows — against your collected totals.

  • Preparing monthly sales tax filings.
    Use this report to support local and state sales tax returns. Share a downloaded copy with your accountant or tax preparer.

  • Exporting a tax-supporting file for your bookkeeper or CPA.
    Download a PDF or CSV to share with your accounting team.

What This Report Is NOT For:

  • Finding item-level detail.
    The Sales Tax Report shows totals grouped by tax rate, not individual products or services. To see which specific items make up your taxable or non-taxable totals, use the Invoice Line Items Report.

  • Separating non-taxable sales by product category.
    If you need to break non-taxable sales into categories — such as services vs. prescriptions vs. nutritional items — this report cannot do that. Both categories will appear as a combined 0.00% row. Use the Invoice Line Items Report and filter by product category.

  • Determining what should be taxable in your state or locality.
    Shepherd can configure and report on sales tax, but cannot advise on taxability rules. Consult your accountant or tax advisor for state- and locality-specific compliance questions.

  • Full revenue or P&L reporting.
    This report covers sales-tax-related totals only. For broader financial reporting, use the Summary Report, QuickBooks Journal Entry Report, or Invoice Line Items Report.

What You Need To Know

Total Sales does not include sales tax collected.

Total Sales is Net Taxable Sales + Net Non-Taxable Sales — it represents pre-tax revenue only. Sales tax collected is tracked separately and is not reflected in this figure.

Taxable Sales and Net Taxable Sales are not the same column.

Taxable Sales is your taxable revenue before returns. Net Taxable Sales subtracts Taxable Return Sales from that total. If your tax preparer asks for Gross Taxable Sales, use the Taxable Sales column — they are the same figure.

Prior-period reports may show different totals if you run them again.

If invoices, returns, payments, or line items are edited after a report was originally generated, those changes will be reflected the next time you run the report. Download and save reports at filing time to preserve your filing snapshot.

Tax Collected may not exactly equal Taxable Sales × the tax rate.

Shepherd calculates and rounds tax at the individual line-item level before aggregating. A small variance when you multiply aggregate Taxable Sales by the rate is expected — it's a rounding artifact, not an error. Example: 4 items × $10.25 at 10% each round from $1.025 to $1.02, giving $4.08 Tax Collected — but $41.00 × 10% = $4.10.


Filters

The Sales Tax Report, found at Reports > Financial > Sales Tax Report, has two filters.

Filter

Description

Time Period

Choose from predefined date ranges (e.g., This Month, Last Month) to define your reporting window.

Filter By

Choose whether to filter report data by Item Administration Date or Item Creation Date. Defaults to Item Administration Date.

After selecting your filters, click View Report. Use Clear to reset all selections.


Report Tabs

The Sales Tax Report contains four tabs organized by accounting method. Select the tab that matches your clinic's accounting process.

Accrual Basis — Reports tax based on when invoices were created, regardless of when payment was received.

  • Accrual Basis Sales Summary

  • Accrual Basis Sales Tax Amounts

Cash Basis — Reports tax based on when payments were received, regardless of when the invoice was created.

  • Cash Basis Sales Summary

  • Cash Basis Sales Tax Amounts

Example: An invoice created in April but paid in May will appear in April on accrual basis tabs, and in May on cash basis tabs.

When comparing the Sales Tax Report to the Summary Report, use the same date range and the same accounting basis — accrual or cash — to ensure the figures align.


Report Columns

Each row in the Sales Tax Report corresponds to a tax rate. Column sets differ by tab type.

Sales Summary Tabs

The following columns appear on the Accrual Basis Sales Summary and Cash Basis Sales Summary tabs. Use column sorting to organize data by tax rate or total sales.

Column

Description

Zip Code

The zip code associated with the tax rate.

Tax Rate

The sales tax percentage applied (e.g., 6.00%, 8.30%).

Taxable Sales

Taxable revenue before returns. If your tax preparer asks for Gross Taxable Sales, use this column — they are the same figure.

Taxable Return Sales

The value of returns on taxable items.

Net Taxable Sales

Taxable Sales minus Taxable Return Sales.

Non-Taxable Sales

Non-taxable revenue before returns.

Non-Taxable Return Sales

The value of returns on non-taxable items.

Net Non-Taxable Sales

Non-Taxable Sales minus Non-Taxable Return Sales.

Total Sales

Net Taxable Sales plus Net Non-Taxable Sales. This is pre-tax revenue — it does not include sales tax collected.

Negative values in any column indicate returns or refunds.

Note on Tax Collected and rounding: Shepherd calculates sales tax at the individual line-item level and rounds each amount to the nearest cent before aggregating. If you multiply the Taxable Sales total by the tax rate, the result may differ slightly from the actual Tax Collected. This is expected behavior — see What You Need to Know above for a full explanation and example.

Sales Tax Amounts Tabs

The following columns appear on the Accrual Basis Sales Tax Amounts and Cash Basis Sales Tax Amounts tabs.

Column

Description

Tax Rate

The sales tax percentage applied (e.g., 6.00%, 8.30%).

Sales Tax

The total sales tax calculated on taxable sales for the period. Labeled Sales Tax Collected on the Cash Basis Sales Tax Amounts tab.

Sales Tax on Returned Products

The sales tax amount associated with returned items.

Net Sales Tax

Sales Tax minus Sales Tax on Returned Products.

Which Column Should I Use for Filing?

Your accountant or tax preparer may need different figures depending on the form or jurisdiction. Here's what the key columns represent:

  • Taxable Sales — Taxable revenue before returns. Use this if your preparer asks for Gross Taxable Sales.

  • Net Taxable Sales — Taxable revenue after returns.

  • Total Sales — Combined pre-tax revenue (Net Taxable + Net Non-Taxable). Does not include sales tax collected.

Confirm with your accountant or tax preparer which column maps to each line on your state or local tax filing.


Export Options

  • Download — Exports the full report as a file.

  • Tab-specific CSV — You can download any tab's data via the CSV link at the top right of that tab (e.g., Accrual Basis Sales Summary CSV, Cash Basis Sales Tax Amounts CSV).

Download and save reports at filing time. Totals may change if invoice or payment records are edited after the original export.


Frequently Asked Questions

Why is tax not calculating for a product even though I marked it as taxable?

Check the following: your clinic's tax settings are fully configured in Admin settings; if your clinic uses product-based rates, the product must also have a rate assigned — marking it Taxable alone isn't enough; and the item wasn't added inside a static bundle, which don't calculate sales tax. If the issue persists, contact Shepherd Support.

Why doesn't my Tax Collected match when I multiply Taxable Sales by the tax rate?

This is expected, not an error. Shepherd rounds tax at the individual line-item level before aggregating, so multiplying aggregate Taxable Sales by the rate will produce a slightly different result than actual Tax Collected.

Example — 4 items × $10.25 at 10%:

  • Each item: $1.025 rounded to $1.02 → $4.08 Tax Collected

  • Aggregate: $41.00 × 10% = $4.10

  • The $0.02 difference is a rounding variance, not a discrepancy

Why does my Sales Tax Report not match my Summary Report?

Confirm both reports use the same date range and accounting basis (accrual or cash), and that you're comparing the Sales Tax section of the Summary Report — not total revenue or total payments. If totals still differ, invoice or payment edits made after the reporting period may be affecting one or both reports.

How do I find which specific items make up my non-taxable sales?

The Sales Tax Report shows totals by tax rate, not individual products. Use the Invoice Line Items Report to see line items sold in a period (filterable by taxable status or category), or the Product Report to see which products are currently marked Taxable = No.

Can Shepherd tell me what should be taxable in my state?

Shepherd can configure and report on sales tax, but cannot advise on taxability rules. Tax rules vary by jurisdiction and may apply differently to services, medications, prescription diets, and other product types. Contact your accountant or tax advisor for guidance.

Did this answer your question?