Store the date basis before joining merchant reports
Two exports both say October. One is a merchant's monthly processing statement. The other is an activity report filtered by settlement date. Your importer gives them the same 2026-10 key, joins the totals, and raises a discrepancy. The files may be correct. The comparison contract may be missing. I work on BrowserAct. A guide we prepared about Worldpay iQ statements separates monthly processing…
We haven't written up this one. Dev.to has the full story — the link below goes straight to it.