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). Also referred to in Link My Books as Non-Amazon Orders.
đĄ Only want the MCF fulfilment fee separated?
Fulfilment Type Grouping splits your whole Amazon breakdown â Sales, Refunds, Sales Tax and Seller Fees â by fulfilment type, which adds a good deal of detail across the board. If the only thing you need in its own account is the MCF per-unit fulfilment fee, there is a more targeted paid add-on that does just that and leaves everything else untouched. See Separate the Amazon MCF Per-Unit Fulfilment Fee into its Own Account.
If instead your MCF orders are recording Cost of Goods Sold twice â once via Amazon and once via the channel the sale was actually made on â see How to use the Cost of Goods Sold feature.
How to Turn On Fulfilment Type Grouping
â ď¸ You need the right user role for these steps. Settlement Settings and Account & Tax Mappings both require an Admin, Accountant or Owner role. If you are a Basic User (or a Team Member), Settlement Settings will not appear in your Settings menu at all â you will only see options such as Notifications and Security. Ask the account owner to make the change for you, or to update your role via Settings > Additional Users > Action > Change Role. See How to add additional users to your account.
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.