Tax Collected by Transaction Report

This report details tax collected on any debit (payment etc..) or tax refunded for every credit (Refund).

Guide to using the Report

Available filters:

  • Company
  • Company Groups; when Company Groups exist
  • Channel
  • Date Range
  • Purchaser
  • State
  • County
  • OrderID
By default, the report shows only Taxable Sales. To include the Non-Taxable Sales, check off the option "Show Orders Without Tax"

By default, the report runs on Accrual Basis. To run the report on Cash Basis, check off the option "Show Paid Orders Only"

Export the report to excel to get more specific information for tax reporting.

How to read the Tax Collected by Transaction Report in SellerCloud

On-Screen Field Name Description
Transaction Type The type of transaction: either debit or credit
Transaction Date The date of when the transaction occurred
Order ID SellerCloud's unique Order Identification
Order Source The Channel name
State The ShipTo State on the order
County The ShipTo County on the order
City The ShipTo City on the order
Tax The Tax amount collected on the order
Gross Sales GrossSales = GrandTotal - Tax
Grand Total The total sale amount of the order. GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount)

How to read the Tax Collected by Transaction Report In the Exported File

Excel Export Field Name Description
TransactionID SellerCloud's unique Transaction Identification
TransactionType The type of transaction; either debit or credit
State The ShipTo State on the order
Zip The ShipTo Zip on the order
County The ShipTo County on the order
City The ShipTo City on the order
OrderID SellerCloud's unique Order Identification
TransactionDate The date of when the transaction occurred
TimeOfOrder The date of when the order got created
OrderSource SellerCloud's unique Channel Identification
OrderSourceName The Channel name
SubTotal The total sale amount of the items, before any discounts, shipping, tax etc.
Grandtotal The total sale amount of the order. GrandTotal = (SubTotal + ShippingTotal + HandlingFee + Insurance + GiftWrapCharge + Tax) - (ShippingDiscount + Discount)
GrossSales GrossSales = GrandTotal - Tax
Tax The Tax amount collected on the order


How did we do?