Managing financial data in ecommerce can be overwhelming, especially when dealing with multiple sales channels like Amazon and Shopify. To make this process easier for you, we’ve been working hard to roll out new tools that simplify reconciliation and ensure your data in A2X, and what is posted to the accounting system, is accurate.
Exports is just one of the tools we’ve added to help you stay on top of your financials. Recent releases like the Amazon Summary Report and Shopify Reconciliation Tool are already providing a simple process to compare the A2X data with the Sales Channel reports to give you confidence that the two systems are matching.
The new Exports feature takes this a step further by helping you reconcile A2X data with your accounting system reports.
Exports: Aggregated Data
We’ve built three main types of Exports to meet different needs:
GL Account and Type Report
Provides a high-level summary of transactions, categorized by General Ledger (GL) account and transaction type.
Perfect for quickly checking totals, or spotting discrepancies related to accounts mappings.
GL Account, Type, and Descriptions Report
Offers a detailed breakdown by transaction descriptions for a deeper dive.
Ideal for troubleshooting, and ensuring every detail matches up.
SKU and Quantity Report
Tracks the number of units sold for each SKU, helping you manage inventory and monitor sales trends.
A simple way to generate your best selling products list.
Why Use the Exports Feature?
The Exports feature is designed to save you time and effort by:
Simplifying Reconciliation: You can quickly compare sales channel data with your accounting system, based on the chart of account name.
Improving Accuracy: Aggregated reports help you spot discrepancies right away.
Providing Insights: From high-level overviews to detailed transaction data, you’ll get the information you need to make better decisions.
Use CSV Exports for Flexible Reporting
Export the report in CSV format for more flexible reporting. Once in Excel or Google Sheets, you can customize how data is presented, apply filters, or calculate metrics like total sales, expenses, or taxes across different dimensions.
Note:
The Exports feature uses the current account mappings from the mappings page. If you’ve recently changed these mappings, the totals per GL account in the Exports reports might not match the amounts in your accounting system.
Troubleshooting Tip: Handling "Not Mapped" Transactions
If a transaction line is not mapped, or if a transaction exists in the database but does not appear on the accounts and taxes mapping page, these transactions will show up as "Not mapped" in the export.
To resolve this:
Refresh the payouts, focusing specifically on the payouts with the missing mappings.
Once refreshed, the transaction lines will generate in the Accounts and Taxes page to map.
What’s Next?
Right now, the Exports feature works at the sales channel level, allowing you to review data for each channel individually. In future updates, we plan to roll out combined reports, where you can aggregate the data across multiple sales channels at once.