Invoice tracking that finally matches the bank

• Invoices said clients paid.
• The bank said otherwise.
• The spreadsheet said both — depending on which tab you trusted that morning.

Chris contracted commercial jobs and tracked invoices in a sheet that never quite matched deposits. Corpeva did not replace his invoicing tool. It made the bank the referee for what actually landed.

1. Connected the business account that receives client payments.
2. Categorized deposits as revenue when they cleared — not when the invoice was sent.
3. Flagged partial payments instead of forcing a full-invoice fantasy.
4. Reviewed the P&L against open invoices every Friday for fifteen minutes.
5. Sent his licensed bookkeeper a Membership export only after the review queue was clear.

An invoice is a promise. A deposit is a fact. Books should prefer facts.

Within a month, Chris stopped arguing with himself about “paid.” He could see which jobs had cash and which still lived in hope. Retainers, progress bills, and final balances stopped blurring into one optimistic total.

The habit that stuck

Friday: clear Needs review. Match large deposits to jobs with a short note. Glance at revenue on the P&L. If the sheet and the bank disagree, the bank wins until proven otherwise.

• Promises live in the invoicing tool.
• Facts live in the bank feed.
• The P&L tells you whether the month was real or hopeful.

That is how invoice tracking finally matched the bank — not with a bigger spreadsheet, but with a ledger that refuses to confuse promises for cash.