The first step in Reconciliation once you have your reports to compare is to find the Hand Reconcile document in the Customer Champion Basecamp channel.
When comparing IL to Amazon reports remember that Reimbursements within InventoryLab also include the Balance Adjustments.
Below are my notes from the meeting where we went over these steps, they are hard to follow so I will update these steps once I have an example case were I can include screenshots.
When trying to find Sales not included on Reports, compare the FBA Transaction Reports to the Exported Sales page within InventoryLab for the same time frame.
First, sort the Order Column to remove all rows except Orders (Service fees and Refunds need to be removed) then remove duplicates in Column D of FBA Transaction report.
Select My Listings has Duplicates
FBA Sales>Hide Columns D-AF then remove duplicates >Column C.
Paste remaining Sales into same report
Highlight Cell rules>Report Duplicates in Red
Sort Filter>Filter>Drop Down Arrows>Filter by Color>No Fill
All Orders listed will then be sales that are not included in the FBA Transaction Report. This is most likely caused by Sales reported in a different month, such as Sales with a Post Date in November that were not shipped until December.
Next Filter Other Column>No Fill. If no Orders appear than this means there are no Orders from the FBA Transaction report that are missing from InventoryLab.
Next use Scratchy to see Purchase Date> The item price should add up to the difference.
If there are Orders missing, have user reach out to Amazon support.