If your business sells via Amazon, we require a few specific reports from your Seller Central account to accurately calculate your profitability, stock levels, and tax liabilities for your statutory accounts.

Before you begin, please check the email we sent you to confirm your Year-End Date (e.g., 31 March, 30 September, etc.) and your Start Date. You will need these dates for the steps below.

Please follow these instructions carefully and email all the requested files back to us once completed.

Part 1: Download Your Income and Expenses Summary

We need the Amazon report showing your income and expenses summary for your exact accounting year.

How to download this:

  1. Log in to Amazon Seller Central on your computer browser.
  2. Click on the three lines (menu) on the top left, select Payments, and then select Payments again from the drop-down.
  3. Select the Reports Repository tab on the far right.
  4. Under Report Type, select Summary.
  5. Select Custom Date Range.
  6. Enter your specific date range: From [Your Start Date] to [Your Year-End Date] (Note: If you type the dates manually, please pay attention to whether your specific Amazon account requires the UK format (DD/MM/YYYY) or the US format (MM/DD/YYYY) to avoid downloading the wrong data).
  7. Click Request Report.
  8. Scroll down to view your report as it generates. Wait a minute or two, then click Refresh under the Action tab.
  9. Click Download PDF. (Please save this file to send to us).

Part 2: Calculate Your Stock Valuation

We need to know the value of the stock held by your business on your exact Year-End Date. Important: This must be the COST value (what you paid for it), not the sales value.

This is a provisional estimate based on stock held in the Amazon warehouse, stock at your home/office, and stock currently in transit.

Step A: Download the Amazon Warehouse Stock File

  1. In Seller Central, click the three lines on the top left and select Reports.
  2. Click on Fulfilment by Amazon.
  3. Under the Inventory tab on the left, click on Inventory Ledger.
  4. Select the Download tab at the top (next to “View Online”).
  5. Leave these three sections blank: ASIN, Fulfilment network SKU, and Merchant SKU.
  6. Select Summary View for Type of Report.
  7. Select Country for the Aggregate report by location.
  8. Select Monthly for the Aggregate report by period.
  9. Next, select the Date range Specific months from the drop-down menu.
  10. Enter the exact month of your Year-End Date in both the “From” and “To” boxes.
  11. Click Request .csv Download.
  12. Wait until the “Report Status” says “Download,” then click Download.

Step B: Adjust the Excel File

  1. Open the downloaded file. Look at Column G (Starting Warehouse Balance). This shows the number of units held by the business.
  2. Look at the “Date” column. We are ONLY interested in the stock held exactly on your Year-End Date. Highlight, right-click, and Delete the rows for any other dates.
  3. You can also delete Column H through Column U to clean up the spreadsheet.
  4. Add a new heading at the top of the new Column H and call it “Cost Per Unit”.

Step C: Calculate the Final Stock on Hand

  1. Amazon Stock: For every product listed in your spreadsheet, enter the cost price per unit in Column H. (If any product has 0 units in Column G, simply delete that row).
  2. Home Stock: At the bottom of this same spreadsheet, create a list of any unsold stock you held at home/the office on your Year-End Date. Add the quantity and the cost per unit.
  3. Stock in Transit: Add any stock that was paid for right before your Year-End Date but was still on its way from the supplier. (Check your emails or bank statements for recent supplier payments if you are unsure).
  4. VAT Registration (If applicable): If your company is VAT registered, please make a note of the VAT rate next to the product name (e.g., 20%, 5%, or 0%).

(Please save this adjusted Excel file to send to us).

Part 3: Determine How Much Amazon Owed You

We need to know the exact amount Amazon owed you on your Year-End Date.

Step A: Recent Payouts

  1. Go to the menu (three lines), select Payments, and then Payments again.
  2. Select All Statements on the top tab.
  3. Review the Statement Period column and scroll down to the period covering your Year-End Date.
  4. Note down the payout amounts for that final month.

Step B: Account Level Reserve

  1. Staying on the All Statements page, find the last statement dated right before your Year-End Date.
  2. Click the View Summary link next to it. This will display a graph.
  3. Click on Amazon Fees on the graph so it provides a summary of the fees and displays your Account Level Reserve figure.
  4. At the bottom right corner of the graph, click Print this page. Please save/print this as a PDF.
  5. (If you have issues printing as a PDF, simply write down the “Account Level Reserve” figure in your email to us. If there is no figure, please write £0).

Final Step: Send Us Your Information!

Once you have completed the steps above, you should have:

  • 1x Income & Expenses Summary (PDF)
  • 1x Adjusted Stock Valuation Spreadsheet (Excel/CSV)
  • 1x Account Level Reserve graph (PDF) or noted figure
  • A list of recent payout amounts

Please attach these to an email, along with your bank statements and any other requested documents, and reply directly to us.