In general, our system pulls data directly from your connected stores or manual uploads to generate filings. Data is captured based on the parameters of each filing period, and taxable sales are determined by product categorizations, exemption settings, and—for Shopify clients—sales channel configurations. It also detects marketplace connections (or Shopify channels like TikTok, Facebook, Amazon, and Shop Pay) that collect and remit tax on your behalf, helping prevent double payment on already-taxed orders.
✅ Export Your Transaction Report: To verify that your sales data and tax settings are transmitting correctly—or to reconcile your data with tax returns processed by our team—you can export your transactions:
Navigate to Filings
Select the filing you want to reconcile or review
Choose Export Transactions in the Transactions section of the filing’s detailed view
The guidance below explains how to interpret these reports, troubleshoot unexpected behavior, and identify potential issues.
The Summary Tab
Once you’ve downloaded your transaction report for a particular filing, you’ll see a CSV file with two tabs: Summary and Detail. Each tab provides a different level of insight into your sales and tax data. The Summary tab gives you a quick, high-level snapshot of your sales activity for the selected filing period. It includes:
Total Gross Sales — All sales shipped to the state associated with your return during that tax period.
Taxable Sales — Sales where the Taxable column = TRUE.
Nontaxable Sales — Sales where the Taxable column = FALSE.
Taxes Collected — The total amount of sales tax your business has collected from customers, based on data from your store connections, custom APIs, or manual uploads.
The Detail Tab
The Detail tab gives you a more granular view of your transactions. You can use this tab to reconcile data, review sales details, and troubleshoot discrepancies.
Columns A–D | Order Information
These columns help you—or our team—locate specific transactions on your platform for troubleshooting:
Order Number
Platform
Sales Channel (for Shopify clients)
Date of Sale
Columns E–L | Product Information
These columns help you understand how products are categorized and classified for tax purposes:
Product Name
Product Type (or Category) — Indicates how an item is defined for taxability (e.g., clothing, diapers, gift items).
Wholesale — TRUE indicates the order was flagged as wholesale.
Marketplace — TRUE indicates the order was flagged as marketplace.
Taxable — TRUE indicates the order was treated as taxable.
Quantity
Price
Sales
💡 If a product appears under an unknown or incorrect product type, it may not be mapped properly to its tax category (e.g., “General Merchandise” instead of “Baby Supplies”). Our team can review or adjust product categories upon request.
💡 If an order doesn’t appear under the correct Sales Classification (Wholesale, Marketplace, or Taxable/Nontaxable), it may indicate a configuration issue within your connected sales channels. This is usually a quick fix, and we can help confirm your setup.
Columns M–N | Taxes Collected
These columns show how much tax was applied to each sale:
Collection Rate — The amount of tax divided by the taxable base of the sale
Total Collected — Pulled from the sales data transmitted through your store connections or uploaded manually by your team
💡 Different platforms and tax engines may calculate rates differently depending on your setup. Contact our team for guidance specific to your configuration.
Columns O–T | Shipping Information
Geography is the primary driver of taxability. These fields display the address details Numeral uses to determine where and how each transaction is reported on your returns. In most cases, we use the shipping address, but if one isn’t available, the billing address may be used instead.
Shipping Address City
Shipping Address State
Shipping Address County
Shipping Address Zip Code
Shipping Address Country
Shipping Address Currency
⚠️ Incomplete or inaccurate shipping information can lead to incorrect tax collection, since most tax engines calculate rates at the state, county, or even rooftop level.
Troubleshooting Your Transaction Reports
If you notice discrepancies or believe certain orders are being reported or taxed incorrectly:
Provide specific order numbers to our team for faster troubleshooting
Check Product Categories — Ensure each product has the correct tax category mapping
Verify Sales Classification — Make sure orders are correctly flagged as Wholesale, Marketplace, or Taxable/Nontaxable
Most issues are configuration-based and can be resolved quickly with guidance from our team.
Transaction Report FAQs
Why is there a discrepancy between tax collected and tax due?
Why is there a discrepancy between tax collected and tax due?
Even with advanced tax engines, small differences between the tax collected and the tax owed can occur—this is often referred to as a tax delta.
When our team files on your behalf, we report your taxable sales at both the state and county levels. The state then calculates the tax due based on that data. If there’s a significant delta (typically greater than 5%), our team can investigate your sales data and store connections to identify the root cause.
Additionally, if you elected to file from the date you established nexus and had our team prepare backfilings, your tax collection configurations may not have been enabled during that period. This can result in $0 collected or amounts significantly lower than what was actually owed. In such cases, you would be expected to remit the outstanding tax out of pocket to remain compliant.
Why is there a discrepancy between tax collected in my internal report and the Numeral transaction report?
Why is there a discrepancy between tax collected in my internal report and the Numeral transaction report?
These discrepancies are typically related to marketplace sales. Marketplace facilitators—such as Amazon, TikTok, Meta (Facebook and Instagram), Walmart, and others—are required to remit collected taxes directly. This means the tax is paid by the marketplace, not by you.
While Numeral reports these marketplace sales to the state as required, we exclude the tax collected from your transaction report so you don’t double-remit taxes already paid by the marketplace facilitator.
To ensure your transaction report reflects only the tax you are responsible for remitting, our team has removed “tax collected” for marketplace transactions. This way, your report shows only the tax amounts for orders that fall under your responsibility for filing.
💡 If you notice a difference between the tax collected in your platform and our report, be sure to exclude marketplace transactions from your internal reporting to avoid skewed data.
How do I generate a Shopify report to reconcile our team's data with the Numeral transaction report?
How do I generate a Shopify report to reconcile our team's data with the Numeral transaction report?
At a high level, Numeral maps your sales data based on your sales channel configurations in Shopify. This determines whether sales processed through a particular channel should be treated as:
Taxable (Direct to Consumer)
Nontaxable or Wholesale
Marketplace
Our team includes marketplace sales in reporting when required but excludes them from tax remittance for platforms like TikTok, Facebook/Instagram, Amazon, and Shop Pay, since these platforms already collect and remit tax on your behalf.
Reconciling in Shopify | To align your Shopify reports with Numeral:
Start with the “Total Sales Over Time” report: Navigate to Analytics > Total Sales Over Time in Shopify.
Set the date range to match the filing period you are reviewing.
Exclude marketplace channels: Add filters for each sales channel your team uses to process marketplace sales (e.g., Shop Pay, Facebook/Instagram).
Filter by shipping region: Set the dimension to shipping region to group and view sales data by state.
Following these steps will help your team generate a Shopify report that aligns with Numeral for accurate reconciliation.
💡 Tip: If some transactions aren’t registering correctly as marketplace or wholesale orders, flag them with our team. We can review your backend configurations and help ensure proper classification.
Want to see how your Shopify channels are currently configured? View more detailed guidance here.
How do I get a broader report of my total sales tax liability for multiple states or periods?
How do I get a broader report of my total sales tax liability for multiple states or periods?
See the Accessing Sales Tax Liability Data and Returns section in our article, Filing at Numeral: Everything You Need to Know, for details
💡 Additional resources with more detailed guidance:
Shopify <> Numeral Collection > All Shopify articles in our Help Center
Shopify Apps <> Numeral > Learn how to set up and troubleshoot tax collection when using common Shopify apps, such as Recharge and Loop Returns.
Time Zones and Your Sales Data > Learn how Numeral applies time zones to your sales data and why this may affect reporting across platforms.
💬 Questions? Reach out to our team anytime via the messaging widget in your Numeral dashboard.