Sales Tax Report

Created by Migration Bot, Modified on Fri, 23 Oct at 11:25 AM by Migration Bot

Originally written by John Hardwick, last updated Jun 14, 2023, on the Swan Retail knowledge base (FRS).

Part of: Financial Reports


Primarily for the US market, this report lists taxes due in respect of confirmed / Finalized deliveries (and collections)

Crystal report name Sales Tax Report 4

This report produces a detailed section plus the Total only section shown below

The State is the fifth line of the delivery address.

This report produces a detailed section plus the Total only section shown below

This report assumes all SKU items are either a delivery or a return unless …

The SKU is the subject of an open service, where the item is marked as ‘service’

The SKU has an attribute named ‘DeliveryTax’ assigned to it, whereby it is marked as ‘Delivery’

The SKU has an attribute named ‘InstallationTax’ assigned, in which case the item will be marked as ‘Installation’.

Selection Criteria

Run time choices, user selectable.

  • Date Range

  • Restricted Location(s)

  • Format

    • Show Invoice Details / Show Invoice Totals Only / Show Report Total Only

  • Tax Rates

  • Include Allowance Lines

    • Yes / No

Print Sequence

As indicated by blue numbered squares in the report example.

1 Location

2 Invoice Number

Report Totals

As indicated by yellow numbered squares in the report example.

1 Location

2 Report

Printed Fields

Fields printed on the report.

Detailed Report

  • Trading Location

  • Invoice ID

  • Invoice Date

  • Sales Order Number

  • Written on Date

  • Full Customer’s Name

  • Selling Price Ex Tax

  • Cost Price

  • City (Fifth line of Address)

  • Tax Rate

  • Tax Description

  • State

  • Type (Delivery / Sale)

  • Tax Value

  • Total Inc Tax

Invoice Total

  • Trading Location

  • Invoice ID

  • Invoice Date

  • Sales Order Number

  • Full Customer’s Name

  • Selling Price Ex Tax

  • Cost

  • City

  • State

  • Tax Value

  • Line Total Inc Tax

Totals - repeated for Sales Inc Tax / Sales Ex Tax / Tax / Tax by Rate

  • Trading Location

  • State

  • City

  • Delivery items

    • Delivery Value

    • Returns Value

  • Installation Items

    • Delivery Value

    • Returns Value

  • Goods

    • Delivery Value

    • Returns Value

  • Total Delivery / Returns

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article