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:
Navigate to Settings: In Link My Books, go to Settings > Settlement Settings.
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.
Go to Account & Tax Mappings: Navigate to Accounts & Taxes > Account & Tax Mappings in Link My Books.
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
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.
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].