Intercompany Transactions Reconciliation Template Excel Review

| Transaction Date | Entity (From) | Entity (To) | Invoice # | Nature | Amount (USD) | Status | |---|---|---|---|---|---|---| | 01/15/2026 | Singapore | New York | INV-IC-101 | Loan Interest | $20,000 | Mismatch | | 02/01/2026 | Mexico | Germany | PO-8842 | Parts | $1,000 | Mismatch | | 02/10/2026 | London Hub | Singapore | SRV-202 | IT Services | $12,500 | Matched ✅ | | 02/10/2026 | London Hub | New York | SRV-203 | IT Services | $12,500 | Missing in NY |

Three minutes later, Clara (New York): “Maya, our payables to Singapore are only $5.10M.” intercompany transactions reconciliation template excel

She clicked a button in the template:

The problem?

The Billion-Dollar Typo

“No, the email says 4.5%,” Clara fired back. | Transaction Date | Entity (From) | Entity