Free Amazon bookkeeping spreadsheet
Use this Excel workbook to tie Amazon Seller Central sales, fees, refunds and reserve movements to the settlement that reached your bank.
Excel (.xlsx) · UK sellers · No email required
| Activity | Effect on payout |
|---|---|
| Sales | +£320.00 |
| Selling fees | −£48.00 |
| FBA fees | −£27.00 |
| Refund | −£40.00 |
| Reserve held | −£32.00 |
| Reserve released | +£20.00 |
| Bank deposit | £193.00 |
Why does my Amazon payout differ from my sales?
Amazon’s disbursement brings together the amounts in a settlement period. Selling fees, Fulfilment by Amazon (FBA) charges, refunds and amounts held in or released from reserve can all change the cash sent.
Inside the Excel workbook
- Amazon settlement for the amounts behind each payout.
- Payout check to compare those amounts with Amazon and your bank.
- Worked example with fictional figures. Both working tabs start blank.
Worked example of a £193.00 payout
The reserve lines affect cash available for this disbursement. Keep them distinct from fees when updating your main books.
Amazon sent £193.00 on . The bank received the same amount on .
| Date | Activity | Effect on payout |
|---|---|---|
| Sales in the settlement | +£320.00 | |
| Amazon selling fees | −£48.00 | |
| FBA fulfilment fees | −£27.00 | |
| Customer refund | −£40.00 | |
| Funds held in reserve | −£32.00 | |
| Prior reserve made available | +£20.00 | |
| Expected payout | £193.00 |
Where do I find my Amazon settlement report?
In Seller Central, open Payments and find the period under All Statements. Download the settlement detail and check the disbursement against your bank.
| Record | How to use it in your books |
|---|---|
| Statement View | Find the settlement period, the amount Amazon is transferring and the disbursement status. |
| Flat File V2 settlement report | Copy settlement-id to Settlement ID on both working tabs. On Amazon settlement, use posted-date for Activity date. Check transaction-type, amount-type and amount-description to choose Type. Enter each amount as a positive number. Type determines whether the workbook adds or deducts it. |
| Bank statement | Confirm how much arrived, when it arrived and the reference shown by your bank. |
How to match your Amazon payout to your bank
Use one settlement at a time
Pick a UK settlement in GBP and copy its settlement ID to the activity and payout rows. Keep other currencies and any conversions in separate records.
Enter the amounts behind the settlement
Separate sales, refunds, selling fees and FBA charges. Use the statement’s opening or carry-over balance and reserve movements where they affect the payout. Check whether the report amount already includes a fee or adjustment before you add it separately.
Tie the settlement to the bank
Enter the disbursement shown by Amazon and the deposit on the bank statement separately. Check any difference against the settlement detail and disbursement status.
Update your main books
Keep your original transactions, fees, stock costs and any VAT records. Reserve movements explain cash timing. Record the underlying sales and expenses once.
When Amazon bookkeeping software makes sense
Keep checking payouts and recording sales and costs in your spreadsheet. When you need to send Making Tax Digital for Income Tax quarterly updates, use aligned.tax with your main Excel records.
See how aligned.tax works for sole tradersFrom your payout to your quarterly update
- Use the Amazon workbook to check payouts. Keep your original digital sales and expense records in your main books, such as the sole trader bookkeeping spreadsheet.
- Prepare the quarterly update from your main records. If Transactions is available in your account, you can also review your entries and prepare the update there.
If you transfer digital records for Making Tax Digital, use a digital link such as linked spreadsheet cells or a file export and import. HMRC’s digital link guidance
Tax and Making Tax Digital for Amazon sellers
Do I have to pay tax on my Amazon sales?
Selling your own unwanted belongings is usually outside Income Tax. If you buy or make goods to sell at a profit, you may be trading. HMRC guidance on selling online
The trading allowance is up to £1,000 for the 2026/27 tax year. If your total gross trading income across all your trades is £1,000 or less before expenses, you usually do not need to tell HMRC about it. There are exceptions. Above £1,000, you may be able to claim the allowance in place of deducting your actual expenses. HMRC guidance on the trading allowance
The government has announced an increase to £3,000 from 6 April 2027. Government announcement on the trading allowance increase
If you sell a personal possession for £6,000 or more and make a gain, Capital Gains Tax may apply. Capital Gains Tax on personal possessions
Does Amazon report my sales to HMRC?
Digital marketplaces can be required to report seller details and income to HMRC. A calendar-year platform report has a different purpose from a settlement statement or your tax-year records. Read the reporting guidance
When do Amazon sellers need Making Tax Digital?
For a sole trader, HMRC uses total qualifying income from self-employment and property before expenses to decide when Making Tax Digital for Income Tax starts. Your marketplace payout is only the cash transferred to your bank. See the qualifying income thresholds and start dates or check your own start date.
Where can I check a missing Amazon payout?
Check whether Amazon shows the disbursement as sent, still processing or failed in Payments. If it failed, Amazon says it carries the money into the next settlement period. Amazon’s disbursement tracking guide
HMRC sources checked on
Published by aligned.tax. Codex checked the tax guidance against HMRC’sguidance for online sellersand its Making Tax Digital eligibility rules.
Get the Amazon bookkeeping spreadsheet
Start with the worked example, then enter your own activity and payouts.
Download Excel workbook