A2X offers additional reporting tools to help you dig deeper and summarise your data for more precise reconciliation.
You can find export options under Reports > Exports in A2X. These reports offer helpful summaries to compare A2X data with your general ledger.
Export Sales by GL account with total amount
Use this export to compare total posted transactions per general ledger account—especially useful if you use different sales GL accounts or split sales by product type.
Example: Comparing Amazon P&L split totals with A2X-posted values.
Sales by GL account and broken down by description
This version breaks transactions down by line description, helping you spot incorrect or inconsistent mappings, missing entries, or duplicates.
Example: You might notice "Shipping Tax" recorded under "Amazon Shipping" instead of "Amazon Sales Tax Collected"—a quick fix in your mappings.
Another use case is reviewing your "Amazon FBA Fees" ledger. If the totals don’t match the export, check for missing lines, duplicates, or entries in your accounting ledger not present in A2X.
Exporting Individual Settlements for Deeper Review
If variances remain after reviewing the exports, you can bulk export each settlement from the Settlements page and compare them against your accounting ledger. Using pivot tables or Excel sort/filter tools, you can summarise and isolate the variances for more targeted troubleshooting.
Summary
Data variances can often be resolved by following a structured approach and using the right tools. A2X is designed to give you the clarity and accuracy you need to confidently complete your month-end close—smoothly and efficiently.