To download your Link My Books settlement and Cost of Goods Sold (COGS) entries in bulk to a CSV file for a specified date range, follow these steps:
How to Download Your Data
Access the Download Option:
From your Settlement Dashboard, click the Download icon (usually a downward arrow or cloud icon) located at the top right of the page just above the top settlement.
Choose Your Download Type:
A list of download options will appear. Select the type of data you wish to download:
Option 1: Download Settlement List
This option will download all settlements currently displayed on your dashboard to a CSV file.
The data in this file will include:
Settlement ID
Marketplace
Currency
Amount
Converted Currency (if applicable)
Converted Currency Amount (if applicable)
Start Date
End Date
Status of Settlement
Option 2: Download Settlement Data
This option allows you to download detailed settlement data for a specific date range.
Select your desired Start and End Dates for the data you want to download.
Generation Time: Please note that the file may take some time to generate depending on the size of your account and the selected date range.
Option 3: Download COGS Data
This option allows you to download your Cost of Goods Sold (COGS) data for a specific date range.
Select your desired Start and End Dates for the COGS data you want to download.
Option 4: Download Audit Data
This option allows you to download your Audit data for a specific date range.Audit data typically includes detailed Order IDs, transaction amounts, and relevant settlement details, making this option invaluable for in-depth financial analysis and record-keeping.
Select your desired Start and End Dates for the audit data you want to download.
Generation Time: Please note that the file may take some time to generate depending on the size of your account and the selected date range. For Xero users, audit files will automatically attach to each invoice within 48 hours after syncing settlements, including detailed order information and invoice matches.Additionally, users requiring sales data by province or state can extract this through manual reorganization of downloaded audit data.
What the Audit CSV Includes and Excludes
The audit data CSV provides a transaction-level breakdown of each settlement, but it does not include every data point from the original marketplace. Here is what to expect:
Included:
Order IDs, SKUs, and transaction amounts
Sales, refunds, fees, and tax breakdowns per order
Settlement totals and date ranges
Not included:
Destination country: The audit CSV does not include a country column. For a regional breakdown of sales (e.g. UK vs international), use Financial Analytics > VAT Audit tab instead, which groups sales by dispatch and destination.
Per-order shipping line items: Shipping is grouped into its own category total rather than broken down per order within the audit file.
⚠️ VAT Audit tab and non-VAT-registered sellers: If you are not yet VAT registered, the VAT Audit tab in Financial Analytics will return minimal or empty data. This is expected, as your sales are mapped to "No VAT" in the Accounts & Taxes wizard, so there is no VAT data for the report to display. For a breakdown of where your orders shipped, use your marketplace's own reporting tools (e.g. eBay Seller Hub > Reports > Orders, filtered by country).
If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].