Headaches Importing / Syncing Amazon Sales into Xero – Recommendations and Advice Sought

Hi folks, we recently switched our business from vendor central to seller central and are enjoying the improved margins. However it has come with some bookkeeping headaches. We use Xero and Shopify so of the solutions out there A2X and Parex Bridge seemed to be the most popular. However there appears to be limitations with these integrations – which I presume is based on how Amazon gives access to the data / payouts.Individual Order Sync – Syncs order level invoices so inventory transactions are accurate however our bookkeeper claims the invoices are very time consuming to reconcile due to the quantity of transactions and payouts are not made on order level so multiple orders have to be reconciled against payouts.

Pro: Inventory is accurately tracked (not operational inventory on Amazon, but in Xero for bookkeeping/cogs/margin) Con: Significant time costSummary Sync – Syncs the summary transactions against the amazon payouts. Much easier to reconcile, however does not contain SKU level sales data so that data has to be added in to track inventory and margin. And annoyingly, the only way to get that information against the payouts is some guesswork such as dividing the payouts by SKU prices to back calculate the units sold. Fortunately payouts are grouped by SKU so line items payouts are per sku and not mixed with SKUs, that would be a total nightmare.

Pros: Reconciliation is far simpler quicker – Con: still requires manual calculation of sales by SKU that have to be manually tabulated and added into Xero – can lead to accuracy issues.

Are these really the only options? Neither are ideal – and I’ve poked around looking at a lot of other software platforms / integrations and haven’t found something better. Is Amazon just not offering these apps the right data for the transactions to be easily reconciled?