Reconciling Reports: Amazon vs InventoryLab

If you'd like to compare your numbers between Seller Central and InventoryLab, you'll need to follow the below steps.

First, log in to Seller Central and visit Reports>Payments>Date Range Reports.

You will want to generate a Summary report for any given month or timeframe where the reports are completely reconciled in Stratify. Be sure to select All for the account type to include as you will need the report to include both Invoiced and Standard orders.

Once you generate the report, you need to download the PDF file and open it. You only need to be concerned with finding your gross profit, so there are only 3 totals to be concerned with in terms of reconciling your InventoryLab numbers from this report.  

You will want to take the Income Total  – Expenses to determine your gross profit for any given month.

Once you know your gross profit totals from the Amazon payments reports, you’ll want to compare that number with InventoryLab Gross Profit. To find that, you will subtract your Amazon Related Expenses from your Amazon Related Income. This information can be found under Reports>Profit and Loss in Stratify:

MINUS

Note: You will not factor in other expenses, such as Cost of Goods Sold, Office Supplies, Rent, etc. to this equation.

If the two gross profit figures between InventoryLab and Amazon Payments reports are off significantly, please check to make sure you have the following manually accounted for in Stratify (service fees and removal orders became available through the API and were automatically imported by IL beginning in Jan 2015):

• Optional FBA Service Fees that you may have opted into (Inventory Placement Service, FBA Label Service, FBA Prep Service) (must be manually entered prior to 2015)
• Removal Order Fees (must be manually entered prior to 2015)
• Optional Loan Payments/Fees
• Advertising campaign costs —- These will be automatically accounted for from any settlement reports occurring after May 24, 2016, if you have selected to have the costs deducted directly from your Amazon disbursement
• Other transaction fees line on your Amazon Date Range Report
• Nothing outside of Amazon FBA only is included (Multichannel sales, other marketplaces, etc.)

A good rule of thumb is to not concern yourself with total profit reports for any given current month until all of your sales for that month show as reconciled. There is a timestamp on the Profit & Loss report to help see the last date your information was reconciled.

Once a month is fully reconciled, your net profit should be final for that month and should not change beyond that point.

You will also need to make sure all of your data is synced. As a paid subscriber, you are able to request your sales and expense data be synced to your InventoryLab account at no extra cost. For instructions on how to do this, please see- Importing Historical Sale and Expense Data.