Match two lists

This is the job Dataweaver is best at. Two lists that should agree, and you need to know where they do not, and why.

Steps

• Open both files. They appear under Data sources.
• Tell Weaver which columns should match, and what to compare.
• Ask for a table of the rows that do not match, with a reason for each.

What comes back

One table. Each row is marked Matched, Missing or Different, with the reason in plain words: "amount differs by ₹500", "date is one day later", "not in the books". Every row is a link back to the source rows.

Common matches

• Bank statement against the cash book or Tally export.
• Purchase register against GSTR-2B.
• Marketplace settlement file against your orders.
• Vendor statement against your ledger for that vendor.
• Estimated charges against actual charges.

Tips

• Dates typed in different ways, spaces after names, and ₹ signs inside amounts are handled. You do not need to clean first.
• If one file uses "Invoice No." and the other "Inv#", tell Weaver they are the same thing.
• Check two or three mismatches yourself the first time. Select the row and look at both sources.