IOSOR Learn
Finance and product share one export
Product dashboards and finance close must read the same DLR export. A second spreadsheet with friendlier statuses is a reconciliation failure waiting to happen.
Finance and product both need messaging truth at month-end. The failure mode is two files: a product dashboard that counts “success” and a finance sheet that counts delivered receipts. When those diverge, the wallet looks wrong even when prepaid debits were correct.
IOSOR expects one export schema shared by both seats. Same DLR states, same period bounds, same corridor keys. Product may chart the file; finance may pivot it — neither invents a private status dictionary.
One export, two seats, same DLR columns
Publish a single report export that both product and finance pull. Columns name delivered, failed, unknown, rejected, and spend in shared status language. Product may chart; finance may add invoice notes — neither renames unknown to delivered for a softer slide.
Lock the period clock. If product closes the week on Friday 23:59 UTC and finance closes on calendar month, document the cut and keep both views derived from the same underlying export rows. Do not let each team pull a different API snapshot for convenience.
Shared status language is the contract
Shared status language for product and finance is the contract that makes one export usable. Delivered means a receipt. Submitted means accept-for-send, not inbox proof. Unknown means still waiting. If product writes “OK” and finance writes “DLR delivered,” you already have two truths inside one CSV header set.
Train both teams on the same glossary before the first joint close. When dashboard and invoice week disagree, open the export first — not a side sheet. Deliverability ops stays adjacent, but the numbers both seats argue about must come from the shared file.
Volume review still reads the same file
Wallet volume review and spend governance sit on the same export. Soft review near higher monthly spend still uses delivered and debit truth from the shared pack — not a marketing funnel count. If governance asks for “successful sends,” translate that to delivered receipts in the export, never to submit totals.
When spend spikes, product and finance open the same rows: which corridors drove delivered, where unknown grew, which refunds landed. Separate funnels create silent governance drift.
Refuse the second spreadsheet
A shadow sheet that “cleans” statuses for the board is the anti-pattern — delete it or mark it unofficial. If leadership needs a simpler view, chart the canonical export; do not hand-edit statuses. White-label partners get the same rule: one export contract, no private success aliases.
Related ops paths
- Shared status language for product and finance
- SMS deliverability operating guide
- Wallet volume review and spend governance
Start with IOSOR
Open the IOSOR console reporting tab and schedule a canonical export containing standardized DLR statuses and debit columns for your team. Direct both product analytics pipelines and finance ledger ingestion to this single scheduled file or webhook feed. Delete existing spreadsheet macros that reclassify unknown or submitted statuses before board presentations.
IOSOR takeaway
Product feature health and finance spend governance require identical delivery truth. Reconciling separate exports for product dashboards and account ledgers creates artificial discrepancies and hides deliverability issues under custom status definitions.
Do ingest one automated export with strict DLR receipt terms across both product and finance tools. Don't generate secondary spreadsheets or manually re-map status columns to present softer delivery curves.
Was this guide helpful?
Related guides
- Report views vs raw wallet ledger rows
Finance and product report views roll up DLR and spend. Raw wallet ledger line items stay under Wallet export — do not treat the report CSV as the ledger.
- Reports must match DLR, not submit counts
Submitted is not delivered. Finance and product report exports must follow DLR receipts — never invoice a week on accept-for-send totals alone.