Amazon settlement reconciliation for Amazon.ae and Amazon.sa

Files you need

• Order / sales invoice register: Your record of what was sold and invoiced, from your ERP, accounting system or the marketplace order report.For example: Marketplace order report, ERP sales register, Zoho / Odoo / Tally sales export.
• Marketplace settlement / payout statement: The line-level payout statement the marketplace gives you for each settlement period.For example: Amazon settlement report (flat file), Noon statement of account, Namshi payout report.

The Microsoft Dynamics 365 Business Central connector can fill: Order / sales invoice register.

What Sawwi checks

• Invoiced but not settled: Order is in your sales register but has no settlement line yet.
• Short paid: Principal settled is lower than the invoice amount.
• Settled but not invoiced: Marketplace paid for an order missing from your register.
• Settled twice: The same order and SKU appear in more than one settlement.
• Ageing beyond payout cycle: Unsettled orders older than the marketplace's normal payout cycle.

Files you need

• Marketplace settlement / payout statement: The line-level payout statement the marketplace gives you for each settlement period.For example: Amazon settlement report (flat file), Noon statement of account, Namshi payout report.
• Fee rate card: Your agreed commission % and fee slabs by category, size or weight.For example: Marketplace fee schedule (Excel), Contracted rate card.
• SKU catalogue: Maps each SKU to its fee category and weight.For example: Marketplace listing report, Product master.

What Sawwi checks

• Commission overcharged: Charged % is higher than the rate card for that category.
• Unrecognised fee type: A fee type that's not in your rate card.

Listed for you to review (not calculated automatically yet): wrong weight / size slab; fees not reversed on return.

Files you need

• Order / sales invoice register: Your record of what was sold and invoiced, from your ERP, accounting system or the marketplace order report.For example: Marketplace order report, ERP sales register, Zoho / Odoo / Tally sales export.
• Marketplace returns report: Customer returns and failed deliveries (RTO), with refund amounts.For example: Amazon customer returns report, Noon returns report, Namshi return manifest.
• Warehouse returns received(optional): What actually arrived back in your warehouse. Optional, but needed to catch refunds for items that never came back.For example: WMS goods-received report, Returns inward register.

What Sawwi checks

• Refund exceeds invoice: More was deducted than was invoiced for that line.
• Return without an invoice: Return for an order or SKU that's not in your sales register.
• Refunded but not received back: Refund deducted but the item never reached your warehouse.
• Return quantity exceeds sold quantity: More units returned than were sold on that order.

Listed for you to review (not calculated automatically yet): no credit note issued.

Files you need

• Inbound shipments sent: What you shipped to the marketplace warehouse.For example: Inbound shipment plan, Your dispatch register.
• Marketplace inventory ledger: Receipts, sales, returns, adjustments, losses and damages by SKU.For example: Amazon inventory ledger, Noon FBN stock movement report.
• Reimbursements report: What the marketplace paid back for lost or damaged units.For example: Amazon reimbursements report, Noon claims statement.

What Sawwi checks

• Received short: Warehouse received fewer units than you shipped.

Listed for you to review (not calculated automatically yet): lost / damaged, not reimbursed; reimbursed below cost; closing stock mismatch.

Files you need

• Claims raised: Your log of claims raised with the marketplace.For example: Claims tracker (Excel), Marketplace case log export.
• Reimbursements / settlement credits: Credits the marketplace paid against claims.For example: Reimbursements report, Settlement lines of type 'reimbursement'.

What Sawwi checks

• Claim unpaid: No reimbursement found for the claim.
• Partially paid: Reimbursement is less than the claim amount.
• Close to claim window expiry: Unpaid claims near the marketplace's filing deadline.

Files you need

• Marketplace settlement / payout statement: The line-level payout statement the marketplace gives you for each settlement period.For example: Amazon settlement report (flat file), Noon statement of account, Namshi payout report.
• Advertising invoices: Invoices for sponsored ads and promotions.For example: Amazon Ads invoice, Noon Ads billing report.

What Sawwi checks

• Deducted without an invoice: Ad deduction on the payout with no matching invoice.
• Invoice not yet deducted: Invoice raised but not yet recovered from your payouts.

Listed for you to review (not calculated automatically yet): vat invoice missing.

Files you need

• Order / sales invoice register: Your record of what was sold and invoiced, from your ERP, accounting system or the marketplace order report.For example: Marketplace order report, ERP sales register, Zoho / Odoo / Tally sales export.
• Marketplace settlement / payout statement: The line-level payout statement the marketplace gives you for each settlement period.For example: Amazon settlement report (flat file), Noon statement of account, Namshi payout report.
• Marketplace fee tax invoices: Monthly tax invoices the marketplace issues for its fees.For example: Amazon VAT invoices for selling fees, Noon fee tax invoice.

What Sawwi checks

• Fee VAT without a tax invoice: VAT on fees was charged in settlements but there's no tax invoice to back the input claim.
• Wrong VAT rate: Rate applied doesn't match the destination country (e.g. 5% UAE, 15% KSA).

Listed for you to review (not calculated automatically yet): output vat mismatch.

Files you need

• B2B invoice register: Tax invoices raised to business buyers through the marketplace.For example: Amazon Business invoice report, ERP B2B invoices.
• Payment release / remittance report: What the marketplace released against B2B orders, including holds and reserves.For example: Marketplace B2B payment report, Remittance advice export.

The Microsoft Dynamics 365 Business Central connector can fill: B2B invoice register.

What Sawwi checks

• Overdue for release: Past payment terms and not fully released.
• Held or in reserve: Part of the amount is held. Shows how long and why.
• Released short: Released + held + deductions is less than the invoice.
• Unexplained deduction: Deduction with no matching credit note or fee.

Files you need

• Expected payouts: Payout batches from one or more providers (marketplace, gateway, BNPL, courier).For example: Marketplace disbursement summary, Gateway payouts list, Courier remittance summary.
• Bank statement: Bank statement for the account that receives payouts.For example: Emirates NBD / ADCB / Al Rajhi / SNB statement (CSV or Excel), MT940 converted to CSV.

What Sawwi checks

• Payout not credited: Provider says paid, but the bank shows no credit.
• Unidentified bank credit: Bank credit not linked to any payout.
• FX / bank charge difference: The amount differs because of currency conversion or bank charges.