Core Reports for Streamlined Reconciliation
Amazon Order Report:
This report acts as the foundation, providing a comprehensive record of all your Amazon orders. It details order details such as product information, quantities, and customer information.
Amazon Merchant Fulfilment by Amazon (MTR) Report:
Focused on fulfillment activities, the MTR report offers insights into the fees associated with Amazon’s fulfillment services like storage, picking, packing, and shipping.
Amazon Disbursement Report:
This report showcases all the financial transactions between Amazon and your seller account. It details the net amount deposited into your account after factoring in order proceeds, deductions for various fees, and any applicable refunds.
Amazon FBA Return Report:
Managing returns is an integral part of e-commerce. This report provides a clear picture of all returned items processed through Amazon’s FBA program, including the reason for the return and the corresponding deduction from your account.
Amazon Reimbursement Report:
In instances where product damage or loss occurs during fulfillment, Amazon may offer reimbursements to sellers. This report details all such reimbursements received from Amazon.
SKU Master:
This report acts as a reference point, containing essential information about each product you sell on Amazon. It specifies the Stock Keeping Unit (SKU) assigned by Amazon, product name, and potentially other relevant product details.
Bank Statement:
Integrating your bank statement into the reconciliation process ensures a holistic view of your finances. It allows for matching the net deposits received from Amazon with the actual amounts reflected in your bank account.
Order Management System (OMS) Reports:
Many sellers utilize third-party OMS platforms to manage their inventory, orders, and fulfillment processes. Cointab’s software seamlessly integrates with popular OMS solutions like Incred, Unicommerce, and EasyEcom, allowing for effortless data retrieval.
Matching Orders and Identifying Discrepancies
Cointab’s software meticulously compares every detail within your OMS with corresponding entries in the Amazon MTR report. This comprehensive analysis yields the following classifications:
Reconciled Orders:
Representing a perfect match, these orders showcase identical details (order information and amounts) in both the OMS and Amazon MTR reports. This signifies a seamless transaction process.