Skip to main content

Split Sales, Refunds, Sales Tax, and Seller Fees by Fulfilment Type

How to categorise your Amazon financial data by FBA, MFN, and Other fulfilment types.

Daniel Little avatar
Written by Daniel Little
Updated over 3 weeks ago

For Amazon accounts, Link My Books allows you to categorise your financial data (including Sales, Refunds, Sales Tax, and Seller Fees) based on the order's fulfilment type. This provides a more detailed breakdown in your accounting software, allowing for granular reporting on different business models.

The fulfilment types recognised are:

  • FBA (Fulfilled by Amazon): Orders placed on Amazon and fulfilled directly by Amazon's warehouses.

  • MFN (Fulfilled by Merchant) / FBM: Orders placed on Amazon but fulfilled by you (the merchant) directly.

  • Other (Multi-Channel Fulfilment - MCF): Orders fulfilled by Amazon's warehouses, but originating from sales made on other channels (e.g., manual fulfilment orders you send to Amazon FBA for shipping to non-Amazon customers).

How to Turn On Fulfilment Type Grouping

Follow these steps to enable the feature:

  1. Navigate to Settings: In Link My Books, go to Settings > Settlement Settings.

  2. Enable Fulfilment Type Grouping: On the 'Transaction Grouping' tab, tick the 'Turn on Fulfilment Type Grouping' checkbox.

How to Set Separate Accounts for Each Fulfilment Type

Once 'Fulfilment Type Grouping' is enabled, you can then assign separate accounts in your accounting software for each fulfilment type within your mappings.

Important: Before you begin, ensure you have already set up the necessary separate accounts in your chart of accounts within your bookkeeping software (Xero or QuickBooks) to select them in Link My Books.

  1. Go to Account & Tax Mappings: Navigate to Accounts & Taxes > Account & Tax Mappings in Link My Books.

  2. Expand Relevant Categories: Expand one of the top-level categories where you wish to apply the fulfilment type split. These categories include:

    • Amazon Sales

    • Amazon Refunds

    • Amazon Sales Tax (for North American Amazon accounts only)

    • Amazon Seller Fees

  3. Set Separate Accounts: For each expanded category, you will now see options to set a separate account for each fulfilment type (FBA, MFN, Other). Select your chosen accounts for each, based on your preference.

    Screenshot of the "Account Taxes" page with the "Amazon Sales" transaction category expanded.  Three fulfilment types are shown: "Other," "FBA," and "MFN."  Each fulfilment type is mapped to a specific account name (e.g., "LMB1: Amazon Sales," "LMB1-FBA: Amazon Sales - FBA") with a tax rate of "20% (VAT on Income)."  A red box highlights the fulfilment types and their respective account mappings, and a red arrow points to the expanded "Amazon Sales" section.

How Fulfilment Type Grouping Affects Settlements

Once the 'Fulfilment Type Grouping' setting is enabled and you have selected your chosen accounts, all your settlements that have not yet been sent to your bookkeeping platform will be automatically refreshed. Once refreshed, these settlements will show the new breakdown detailing transactions by fulfilment type.

Please note that settlements already sent to your accounting software will not be affected by this change unless they are subsequently rolled back and re-sent.

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].

Did this answer your question?