If you are trying to reconcile numbers from the sales dashboard in Seller Central to InventoryLab, you're not going to get numbers that match up. They are not intended to.
This is because InventoryLab uses your payments data rather than sales. To clarify, InventoryLab only considers the order when a transaction posts rather than when the order is placed. As you know, orders can remain in "pending" status for days, but the money does not hit your account balance until shipped.
Since an order could get cancelled at any time or simply left in the cart for many days on end, we only account for the sale once it ships to the buyer. Otherwise, it would leave room for inconsistency in the numbers and inaccurate accounting.
To match up data from Amazon to InventoryLab you should always check your Date Range Summary report instead of sales reports or sales dashboard.
First, visit Seller Central and click on Reports. Select Payments from the dropdown box
Choose Date Range Reports from the tabs and click on Generate Report
Note: You will only want to run a report for dates in which all of your orders show as Reconciled inside of InventoryLab for accurate comparison
Select Summary, then choose what range of dates you would like the report for, and click Generate
Your report will now be In Progress. Give it a moment and click the Refresh link
You will now be able to click Download to download the Date Range Summary in .pdf format
Next, go to InventoryLab and click on the Reports tab. Choose Profit & Loss from the dropdown menu
Select the same exact date range that you did when you ran the Date Range Summary report and click View
You should then be able to compare the Income and Expenses areas of InventoryLab using the collapsable headers to the same sections on the Date Range Summary report
Areas you can compare:
- Shipping Credits
- Shipping Credit Refunds
- Gift Wrap Credits
- Gift Wrap Credit Refunds
- Promotional Rebates
- Promotional Rebate Refunds
- Selling Fees
- FBA Transaction Fees
- FBA Transaction Fee Refunds
- FBA Inventory and Inbound Services Fees
- Service (Subscription) Fees
- Refund Administration Fees
- Selling Fee Refunds
- Cost of Advertising *only if deducted from your disbursement
- Sales Tax
- Sales Tax Refunds
Note: Since InventoryLab allows you to include additional overhead fees to get your most accurate Net Profit, you will not include those items when comparing to Amazon. Below is an example of a Profit and Loss report from InventoryLab with additional expenses crossed out.
If the two figures between InventoryLab and Amazon Date Range Summary reports are off significantly, please check to make sure you have the following manually accounted for in InventoryLab (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.)