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, choose the month or choose what range of dates you would like the report for, and click Generate
If you need to get a transaction summary, in the case of an audit or as requested by support, make sure you select TRANSACTION instead of SUMMARY before clicking 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:
INCOME
- Sales
- Refunds
- Reimbursements
- Shipping Credits
- Shipping Credit Refunds
- Gift Wrap Credits
- Gift Wrap Credit Refunds
- Promotional Rebates
- Promotional Rebate Refunds
EXPENSES
- 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
OTHER
- Sales Tax
- Sales Tax Refunds
- Marketplace Facilitator Tax and 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.
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.)
0 comments
Article is closed for comments.