CointabCointab
Product
Solutions
Popular reconciliations
PricingResources
Schedule guided setupLogin
Start free

Popular reconciliation template

AWB Reconciliation

Reconcile AWB records across orders, shipments, delivery partners, COD reports, returns, settlements, and logistics systems to ensure every shipment is accurately tracked and accounted for.

Upload the required shipment and logistics reports, select the period, run reconciliation, and review fully matched, partially matched, unmatched, and skipped records.

Start this reconciliationSchedule guided setup
View demo report

Ready-made workflow · Reusable every period · Manual upload or automated data flow

Order Report
Shipment Report
Carrier AWB Report
Delivery Status Report

Cointab AWB Reconciliation

MatchedPartially MatchedUnmatchedSkipped

Reconcile shipment activity using AWB records

AWB numbers are often the common identifier connecting orders, shipments, delivery partner reports, COD collections, returns, and settlements. Cointab helps reconcile these records in one structured workflow.

The AWB Reconciliation template helps operations, logistics, and finance teams compare shipment records against delivery partner data using AWB numbers as the primary matching reference.

This helps teams answer questions such as:

  • Which orders have valid AWB numbers?
  • Which AWBs were shipped but never delivered?
  • Which AWBs appear in carrier reports but not in internal records?
  • Which AWBs have mismatched shipment statuses?
  • Which deliveries are missing from settlement or COD reports?
  • Which returns and RTO shipments are correctly reflected?
  • Which AWBs are duplicated across reports?
  • Which records require follow-up with logistics partners?

This template is useful for eCommerce brands, D2C businesses, marketplaces, logistics teams, and finance teams handling shipment, delivery, COD, and return reconciliation.

Required files for this template

Cointab's ready-made workflow is designed around standard shipment and logistics reports used for AWB reconciliation.

Data sourceExample records
Shipment ReportUsed as the primary source containing order IDs, shipment IDs, AWB numbers, shipment dates, and fulfillment information.
Carrier or Delivery Partner ReportUsed to compare internal shipment records against carrier-side shipment activity.
Delivery Status ReportUsed to reconcile delivered, in-transit, returned, cancelled, or RTO shipments.
COD or Settlement ReportOptional, but useful when AWBs need to be linked to collections, remittances, or settlements.
Supporting DataOptional supporting files can be used for carrier mappings, warehouse mappings, customer information, service levels, or other enrichment.

What Cointab matches in AWB reconciliation

Cointab compares shipment records, carrier reports, delivery statuses, COD activity, and settlement records using AWB-based matching.

Shipment records

Match internal shipment records against carrier-side AWB activity.

Delivery status

Verify whether shipment statuses align across systems.

COD collections

Compare delivered AWBs against COD collection and remittance records.

Returns and RTOs

Review whether returned and RTO shipments are correctly reflected.

Settlement activity

Track AWBs through delivery, collection, and settlement workflows.

Internal logistics records

If ERP, OMS, WMS, or logistics system data is included, Cointab can compare operational records against partner reports.

Common AWB reconciliation exceptions

Cointab helps teams focus on shipment differences instead of manually reviewing every AWB.

AWB missing in carrier report

An AWB exists in internal shipment records but is not found in carrier data.

AWB missing in internal records

A carrier report contains an AWB that does not exist internally.

Shipment status mismatch

The same AWB shows different statuses across systems.

Delivered but not settled

An AWB is marked delivered but is not reflected in settlement or COD reports.

Return or RTO mismatch

Returned shipments are not reflected consistently across reports.

Duplicate AWB

The same AWB appears multiple times across one or more reports.

Missing or unclear reference

AWB number, shipment ID, order ID, or carrier reference is incomplete or missing.

Timing difference

Shipment activity appears in different reporting periods across systems.

Skipped record

A row cannot be reconciled because required data is missing, invalid, duplicate, or unusable.

How this ready-made reconciliation works

Cointab pre-configures the workflow so your team does not need to rebuild the AWB reconciliation setup every period.

01

Select the template

Choose AWB Reconciliation from popular reconciliations.

02

Select the period

Choose the month, quarter, year, lifetime period, or custom period you want to reconcile.

03

Upload shipment reports

Upload shipment reports, carrier reports, delivery status reports, and any required COD or supporting files.

04

Validate file format

Cointab checks whether uploaded files match the expected structure and highlights missing or incorrect columns.

05

Run reconciliation

Cointab applies predefined data preparation and matching logic for AWB-based reconciliation.

06

Review output

View fully matched, partially matched, unmatched, and skipped records.

07

Download or automate

Download the Excel report, or automate future data input and output through email, SFTP, or APIs.

Structured matching first, AI assistance for difficult cases

Cointab applies structured reconciliation logic first, then uses AI to help with difficult open transactions where fixed rules are not enough.

Structured matching

Structured matching can use:

AWB NumberShipment IDOrder IDTracking NumberCarrier ReferenceCOD ReferenceSettlement ReferenceDate fieldsStatus fieldsDerived or cleaned identifiers

Matching scenarios

  • One-to-one

    One shipment record matches one carrier AWB record.

  • One-to-many

    One shipment maps to multiple logistics events or status updates.

  • Many-to-one

    Multiple internal records are grouped into one logistics record.

  • Many-to-many

    Multiple shipment and carrier records are grouped and compared.

  • Partial matching

    Identifiers match, but shipment details differ.

  • Net and contra matching

    Returns, reversals, RTO activity, and adjustments are netted where required.

AI-assisted transaction matching

After structured rules run, AI helps match difficult open transactions where:

  • AWB references are incomplete
  • Tracking information differs across systems
  • Carrier descriptions are inconsistent
  • Multiple possible matches exist
  • Status information is fragmented
  • Shipment references appear in remarks or notes

AI exception analysis

For transactions that remain open, AI can help identify possible reasons such as:

Missing shipment reportCarrier-side delayRTO processingSettlement timing differenceDuplicate shipmentData quality issuePartner reporting issueManual correction requiredStatus synchronization issue

AI assists matching and exception review, but Cointab keeps reconciliation transparent, reviewable, and audit-friendly.

Audit-ready AWB reconciliation reports

Cointab gives your team a clear report showing which AWB records matched, partially matched, remained unmatched, or were skipped.

Report categories

  • Fully matched

    AWB records where identifiers and shipment information match.

  • Partially matched

    Records where AWB references match but shipment details differ.

  • Unmatched in Shipment Records

    AWBs present internally but not found in carrier reports.

  • Unmatched in Carrier Reports

    Carrier AWBs that do not clearly match internal shipment records.

  • Skipped

    Records excluded due to missing, invalid, duplicate, incomplete, or unusable data.

Report capabilities

  • Summary cards
  • Transaction-level details
  • Filters for review
  • Difference analysis
  • Matched record drill-down
  • Manual match
  • Undo manual match
  • Excel export
  • Audit-friendly output

Automate recurring AWB reconciliation

Once this workflow is stable, Cointab can automate file input, reconciliation runs, and output delivery.

1

Bring data into Cointab

Data can be received or pulled through:

EmailSFTPAPI integrations
2

Run automatically

Schedule reconciliation:

DailyWeeklyMonthlyAfter file receiptAfter all required files are availableAt a custom frequency
3

Push output back

Send reconciliation output to:

ERPOMSWMSLogistics systemBI dashboardFinance systemAnalytics databaseInternal exception tracker
  • Matched AWBs
  • Status mismatches
  • Missing shipments
  • RTO differences
  • Settlement-linked exceptions
  • Open items
  • Suggested actions
  • Excel reconciliation report
  • Structured API output

View an AWB reconciliation demo report

See how Cointab presents AWB reconciliation output with matched, partially matched, unmatched, and skipped records.

AWB Reconciliation Demo

Explore a sample report showing shipment records, carrier AWBs, delivery statuses, COD activity, and open items.

View demo report
Your browser does not support the video tag.

Explore related logistics reconciliations

Cointab supports other shipment, delivery, COD, and logistics reconciliation workflows.

Sales vs COD Partner

Match order records with COD remittance reports from delivery partners.

View template

Shipment Report vs Carrier Invoice

Reconcile shipment activity against carrier billing and freight invoices.

View template

Sales vs Delhivery COD

Reconcile sales records with Delhivery COD collections and remittances.

View template

Logistics Reconciliation

Match shipment, delivery, return, settlement, and logistics partner data.

View template

Built for teams managing high-volume shipments

This template is useful for teams that regularly reconcile shipment activity using AWB numbers.

eCommerce brands

For businesses shipping large volumes of online orders.

D2C businesses

For teams managing carrier operations and delivery performance.

Logistics teams

For teams responsible for shipment visibility and carrier reconciliation.

Operations teams

For teams tracking deliveries, returns, and RTO performance.

Finance teams

For teams reconciling shipment activity with settlements and collections.

Trusted by teams handling recurring logistics reconciliations

Cointab is used by finance and operations teams that reconcile high-volume shipment, logistics, marketplace, payment, and accounting data.

  • Ixigo logo
  • Abhibus logo
  • Confirmtkt logo
  • Keventers logo
  • Lotus Herbals logo
  • The Belgian Waffle Co logo
  • PharmEasy logo
  • FormulaRX logo
  • Borosil logo
  • Croma logo
  • Checkers logo
  • Charleys logo
  • Ascott logo
  • FoxTale logo
  • Newtap logo
  • Vibgyor School logo
  • Gameskraft logo
  • Recode Studios logo
  • Bonkers Corner logo

“We have worked on many softwares but we love the ease of using cointab. The staff and support is very instant. They are approachable, proficient and patient. Team is very cooperative with the customisations. The experience of using cointab was nice.”

— Urbanic

AWB Reconciliation FAQs

AWB reconciliation is the process of comparing shipment records against carrier, delivery, COD, return, and settlement reports using AWB numbers as the primary matching reference.

Typically shipment reports and carrier reports. Delivery status reports, COD reports, settlement reports, and supporting files may also be included.

Yes. Businesses can reconcile AWBs from multiple logistics partners using separate or custom workflows.

Yes. The reconciliation highlights AWBs present in one system but missing from another.

Yes. Return and RTO records can be included to help explain shipment and settlement differences.

Yes. Once this template is selected and used, the same setup can be reused for future periods.

Yes. Cointab can receive or pull required reports through email, SFTP, or APIs, run reconciliation automatically, and push output back to downstream systems.

Yes. AI can help match difficult shipment records, analyze logistics differences, review exceptions, and suggest possible reasons and next actions.

Yes. Users can manually match records that the system and AI could not confidently match and undo manual matches if needed.

Yes. Users can download Excel reports with fully matched, partially matched, unmatched, skipped, and transaction-level details.

Start AWB reconciliation

Use Cointab's ready-made AWB reconciliation workflow to match shipment records, identify logistics differences, review exceptions, and export audit-ready reports.

Start this reconciliationSchedule guided setup
View demo report→

Ready-made workflow · Reusable every period · Manual upload and automation supported

CointabCointab

Reconciliation automation for finance teams. Match sales, payments, marketplaces, banks, and partner reports with reusable workflows and audit-ready reports.

Product

  • Reconciliation automation
  • Popular reconciliations
  • Data automation
  • Reconciliation reports
Explore product
Solutions
  • Payment gateway
  • Marketplace
  • Bank reconciliation
  • COD reconciliation
All solutions
Popular
  • Sales vs payment gateway
  • Amazon MTR vs disbursement
  • Flipkart sales vs settlement
  • Bank statement vs books
All templates

Resources

  • Blog
  • Guides
  • FAQs
Resources hub

Company

  • About
  • Pricing
  • Contact
  • Schedule guided setup

© 2026 Cointab. All rights reserved.

Privacy policy·Terms of service