Announcing the New A2X Monthly Exports Feature – In Beta This October
With tools like the A2X Amazon Summary Report and Shopify Reconciliation Report, you can check to see if your data matches across your sales channels, A2X, and your accounting software – giving you 100% confidence in the accuracy of your books. But what happens when data doesn’t match between A2X and QuickBooks, Xero, Sage, or NetSuite?
Common issues like duplicate entries, unposted payouts/settlements, or incorrect mappings can throw off your reconciliation process. That’s why we’re introducing the Monthly Export feature, available in Beta from 1 October.
This new feature helps you identify and resolve discrepancies between A2X and your GL. With the ability to export monthly CSVs showing SKU quantities and transactions by mapped account, this tool offers another layer of certainty that everything ties back correctly to your GL.
What exports are being released?
We’re launching three exports, all of which can be exported as CSVs for easy data manipulation. These exports will be accessible via the Reports navigation, and more exports are in the pipeline.
1. SKU Export
The SKU Export allows you to generate an export showing SKUs and quantities sold per month. This is especially useful for checking against your records, entering data into your accounting system, or making inventory adjustments. Although this might seem like simple data, it isn’t always easy to retrieve from your sales channels.
How is this export useful?
Imagine you’re trying to reconcile inventory for the month and your accounting system shows you sold 1,200 units of a specific SKU, but Shopify reports 1,300. With the SKU Export, you can quickly generate an export to verify exactly how many units were sold per month, ensuring your records match up with actual sales data.
2. Sales Summary Export
When discrepancies arise, the Sales Summary Export is a great first place to look – it aggregates all the transactions in A2X based on how they’re mapped on the mapping page. It helps you identify potential mapping issues quickly, providing a clear comparison between your sales channels and accounting records.
How is this export useful?
Say Shopify reports $8,500 in sales, but your accounting system shows $12,500. You can use the Sales Summary Report to quickly identify whether transactions were mapped incorrectly – perhaps finding that $4,000 was allocated to the wrong account. This export gives you an overview of where discrepancies might be happening.
3. Detailed Sales Export
The Detailed Sales Export dives even deeper, showing a breakdown of your chart of accounts and separating descriptions from your sales channels. If your Sales Summary Export highlights an issue, this Detailed Export will help you pinpoint exactly where the discrepancy is occurring.
How is this export useful?
If you’ve identified an issue using the Summary Export, the Detailed Sales Export allows you to drill down further. For example, you might discover that a large refund from Amazon was misclassified as a sale. By breaking down the chart of accounts and separating descriptions from the sales channel, this export gives you the granular detail needed to correct errors.
How to access the Exports
The Export feature is available in Beta from 1 October. You can find it under ‘Reports’ > ‘Export Data’ in your A2X dashboard. From here, you’ll be able to select and export the new reports directly to CSV for easy data manipulation.
What’s coming next?
This is just the beginning – more exciting updates are on the way, so stay tuned for additional features that will streamline your accounting and reconciliation process.
Save hours on your ecommerce accounting
A2X connects your sales channels and accounting software for fast and accurate monthly bookkeeping.
Try A2X today