We've updated how ConnectBooks exports settlements to QuickBooks and Xero. You can now export your sales and product costs separately, so missing product costs no longer hold up your settlement export.
1. How the new export works
Before, ConnectBooks exported your settlement and cost of goods sold (COGS) together. If a product was missing a cost, the whole export was held up.
Now, each settlement has 2 separate exports:
Export | What's included |
Settlement | Sales, refunds, fees, and all transactions included in the settlement report. |
COGS | The cost of products sold, moving the amount from Inventory Asset to Cost of Goods Sold. |
Each export has its own status and can be completed on its own.
Issues in the COGS part no longer hold up the settlement. Issues in the Settlement part still block it, like products that are not mapped in Product Settings.
Example: Your settlement is ready, but 3 products are missing costs.
Before: The whole export was held up until those costs were added.
Now: Export the settlement right away. Fix the missing costs and export COGS separately.
This means your sales and fees can reach QuickBooks or Xero without waiting for inventory costs.
2. Understanding the new export page
You'll now see separate Settlement and COGS columns on the Accounting Export page. Each column shows its own status, issues, and export options.
For example:
Settlement | COGS | What it means |
Exported | Pending | Sales are exported. Product costs are still waiting. |
Exported | Exported | Both exports are complete. |
Export | Missing cost | You can export the settlement now and fix COGS later. |
Don't see a COGS column?
On a single store's page, the separate COGS column only shows when:
Your store does not track inventory in QuickBooks.
"Import Cogs to QuickBooks" (or Xero) is turned on. You find this toggle under the "More" button on the store's page.
Otherwise, you'll continue to see one Settlement column on that page, with any COGS issues included there.
In the all stores view, the COGS column always shows. To turn COGS on for a store there, click "COGS off", then click "Turn on COGS".
3. What each status means
Status | Meaning | What to do |
Pending | Waiting for data or processing to finish. | Wait, or fix any issues shown. |
Export | Ready to export. | Click Export. |
Syncing | Currently sending to QuickBooks or Xero. | Wait for it to finish. |
Exported | Successfully exported. | No action needed. |
No docs | There was nothing to export for this part. | No action needed. |
Error Syncing | The export failed. | Hover over the status to see the error, or contact support. |
Error | ConnectBooks couldn't process the settlement data. | Contact support. |
Missing Settlement | Amazon hasn't provided the settlement report. | Click Fix for instructions. |
Deleting / Deleted | Documents are being removed or have been removed from QuickBooks or Xero. | No action needed unless the delete fails. |
Error Deleting | Documents couldn't be deleted. | Contact support. |
Important: Each column works on its own. An error or delay in COGS does not affect a settlement that's already exported.
4. How to fix export issues
If something needs your attention, an orange notification shows next to the affected export. Click it to see what's missing, then select Fix to open the right page.
Settlement issues
Issue | How to fix it |
Uncategorized products | Update product categories in Product Settings. |
Unmapped products | Map the products in Product Settings. |
Unmapped fees | Update fee mapping in Store Settings. |
Missing settlement | Follow the instructions to request the report from Amazon. |
QuickBooks or Xero not connected or setup incomplete | Complete the accounting connection or onboarding. |
Missing accounting account | Update the required account in Store Settings. |
Missing shipping cost | Add shipping costs if needed. This is a warning and does not block the export. |
COGS issues
Issue | How to fix it |
Missing product cost | Add the missing cost in Product Settings. |
Missing cost from an integration | Review the cost for that settlement. |
Unmapped products | Map the products to the correct ConnectStock or QuickBooks items. |
Missing COGS or Inventory Asset account | Set up the accounts in Inventory File Settings. |
Negative inventory | Review and fix the negative inventory. |
Once you fix the blocking issues, the affected export becomes available when any needed processing is complete.
You don't need to fix a COGS issue to export a settlement that's already ready.
5. Exporting, resending, and deleting
You can now manage the Settlement and COGS separately. Click the 3 dots menu (⋯) next to any settlement to see these options:
Action | What you can do |
QuickBooks docs (or Xero docs) | Preview or review Settlement and COGS documents separately. |
Download documents | Download available invoices, credit memos, or Excel documents for either part. Shows after that part is exported, and only when Enable Invoice and Credit File Download is on in Store Settings. |
Resend to QuickBooks (or Xero) | Resend Settlement, COGS, or Both. |
Delete from QuickBooks (or Xero) | Delete Settlement, COGS, or Both. |
Resending or deleting from the 3 dots menu asks you to confirm.
To work on many settlements at once, go to a single store's page, tick the settlements and click "Action". Then choose "Re-Export Settlement", "Re-Export COGS", "Delete Settlement Docs" or "Delete COGS Docs". These run right away, without asking you to confirm. The checkboxes show on a single store's page when Allow Multi-Select Delete & Re-Export to QuickBooks (or Xero) is on in Store Settings.
Auto Sync: If it's on, ConnectBooks exports each part as soon as it's ready. You don't need to wait for both parts.
The main takeaway
Your settlement no longer needs to wait for missing product costs.
ConnectBooks can now export sales, refunds, and fees first, then export COGS when it's ready. Each part has its own status and can be managed separately, giving you more control over when your financial data reaches QuickBooks or Xero.
Frequently asked questions
Why does my settlement say Exported while COGS says Pending?
Your sales have already been exported, but your product costs aren't ready yet. Click the COGS issue notification to see whether anything needs fixing. If no issues show, ConnectBooks may still be waiting for cost data, ship dates, or an integration to finish syncing.
Can I export a settlement with missing product costs?
Yes. That's the main benefit of this update. You can export the settlement now and export COGS once the missing costs are added, as long as no other issue, like unmapped products, blocks the settlement.
Why don't I see the COGS column?
On a single store's page, the separate column only shows when the store doesn't track inventory in QuickBooks and "Import Cogs to QuickBooks" (or Xero) is turned on under the "More" button. In the all stores view, the COGS column always shows. To turn COGS on there, click "COGS off", then click "Turn on COGS".
How do I export something again?
Open the 3 dots menu next to the settlement and select Resend to QuickBooks (or Xero). Choose Settlement, COGS, or Both. The regular Export button won't resend documents that have already been exported.
What happens if I resend or delete both parts and only one works?
If the settlement part works but COGS fails, you see Partial success and only need to retry COGS. The settlement part runs first. If it fails, COGS isn't tried.
What if COGS shows Error Syncing?
Hover over the status to see the error. If your QuickBooks or Xero connection expired, reconnect your account. For other errors, contact support. Your Settlement export is not affected.