Handling Prepaid Revenue and Deposits Across CRM and Accounting
Your CRM shows Deposit Paid. Your books should show a liability, not earned income. When prepaid revenue, deferred revenue, and advance payments are mistimed, sales celebrates money finance has not yet earned, and VAT periods go wrong.
We build the integration that posts deposits correctly and releases them on delivery.
Sound Familiar?
These are the exact issues our clients faced before integrating prepaid deposits with the ledger:
- Sales marks "Deposit Paid" in the CRM while finance still books the cash as earned income
- Prepaid retainers and advance payments live in a spreadsheet that only gets updated at month-end
- Deferred revenue balances never tie to CRM deal stages, so leadership argues over two different numbers
- VAT on deposits is applied too early or too late, creating SARS exposure at every VAT period
- Month-end prepaid reconciliation takes a full day of ticking deposit slips against the liability account
SARS VAT Ruling VR 020 (April 2026) tightened how forfeited deposits are treated for VAT. If your CRM stages and ledger still disagree on when a deposit becomes consideration, every VAT period is a compliance risk, not just a bookkeeping headache.
What the Integration Actually Does
Deposit paid → deferred liability → delivery complete → revenue recognised. No manual journals between CRM and the books.
Deposit Paid in CRM
Sales moves the deal to Deposit Paid when the advance payment clears the bank
Deferred Revenue Booked
Cash posts to prepaid / deferred revenue liability with the correct VAT timing
Delivery Stage Hit
CRM moves to Delivery Complete or Won Complete when performance is satisfied
Revenue Released
Journal releases deferred revenue into income; CRM and P&L finally agree
Everything You Need for Reliable Prepaid Revenue
Deposit Receipt Posting
When a deal hits "Deposit Paid" in the CRM, accounting books cash to deferred revenue (liability), not income. The advance payment is recognised correctly from day one.
Delivery-Triggered Recognition
CRM stage moves to Delivery Complete or Won Complete → a journal releases prepaid revenue into recognised income for the period you actually earned it.
VAT Timing Controls
Deposit vs consideration rules are mapped once. Output VAT fires when the deposit is applied or forfeited under SA VAT Act rules, not when sales celebrates the stage change.
Prepaid Balance Sync
Every open deposit, retainer, and advance payment is visible against its CRM deal. Finance stops rebuilding waterfalls from bank statements.
Refund and Forfeiture Paths
Cancellations reverse the liability cleanly. Forfeited deposits follow your VAT treatment with an audit trail back to the CRM stage that triggered them.
IFRS 15 Stage Mapping
Pipeline stages map to performance obligations so recognition timing matches delivery, not cash receipt. Schedules stay locked to contract terms.
Platforms We've Connected for Prepaid and Deposits
From 12 Hours/Month to Under 2
How a 22-person Cape Town agency stopped booking R2.1M of project deposits as earned income before delivery.
The Manual Process
- Ops marked Deposit Paid in HubSpot; bookkeeper coded the receipt to income in Xero
- A separate Excel waterfall tracked what should still be deferred
- 12 hours every month reconciling prepaid balances to CRM stages
- Sales dashboards showed R2.1M of "won" cash that finance had not yet earned
- Two VAT periods needed corrections after deposits were treated as consideration too early
The Automated Process
- Deposit Paid → cash and deferred revenue liability post in Xero within seconds
- Delivery Complete releases prepaid revenue into income with one review click
- CRM stages and the liability account stay tied deal by deal
- Sales sees cash collected; finance sees unearned income until delivery
- VAT timing follows deposit vs advance-payment rules agreed with their accountant
Before vs After Integration
How It Works
From first conversation to live deferred revenue sync in 3 to 5 weeks.
Map Your Deposit Flow
Which CRM stages mean cash received, which mean delivery complete, and how you treat retainers, deposits, and advance payments today.
Free Scoping Call
30-minute call to design deferred revenue accounts, VAT timing, recognition triggers, and exception handling for refunds and forfeitures.
Build & Test
We build the integration, test with live deposit deals, and run parallel for a week so prepaid balances match CRM stages before go-live.
Go Live & Monitor
Switch off the spreadsheet schedule. Monitoring flags any deal where cash, liability, and stage fall out of sync.
Frequently Asked Questions
How is this different from ordinary CRM-to-accounting invoice sync?
Invoice sync books revenue when the invoice is raised. Prepaid and deposit work needs the opposite: cash hits a deferred revenue liability until delivery. We map CRM stages so deposits, advance payments, and retainers post correctly, then release into income only when the deal reaches delivery or won-complete.
Which CRMs and accounting systems do you support for deferred revenue?
We have built prepaid and deposit flows for HubSpot, Pipedrive, Salesforce, Zoho CRM, and Monday.com into Xero, QuickBooks, Sage (Pastel and Cloud), NetSuite, and FreshBooks. If both systems have an API, we can connect them with your chart of accounts and tax codes.
How do you handle South African VAT on deposits?
Under the VAT Act, a true deposit is not consideration until it is applied to the supply or forfeited. Advance payments that are part of the price can trigger VAT earlier. We configure the integration to match your contracts and tax advice so output VAT posts in the right period, and forfeitures follow your agreed treatment.
What happens if a client cancels after paying a deposit?
The CRM cancellation stage triggers a controlled path: refund reverse the liability and cash, or forfeiture releases deferred revenue into income (or a designated forfeiture account) with the correct VAT treatment. Nothing is left stranded on the balance sheet.
How long does setup take?
A standard prepaid and deferred revenue integration takes 3 to 5 weeks from scoping to go-live. Simpler one-way deposit posting can be live in about two weeks. Multi-entity or multi-currency recognition schedules take closer to 5 to 7 weeks. We always run parallel testing before switching off manual journals.
What does it cost and when do we see ROI?
Deposit-to-deferred posting starts from around R25,000. Full bidirectional setups with IFRS 15 stage mapping, VAT timing, refunds, and forfeiture paths typically range from R40,000 to R75,000. Most clients spending 10 or more hours a month on prepaid schedules see payback within 3 to 5 months from recovered finance time alone, before counting avoided VAT and recognition errors.
Stop Booking Deposits as Earned Income
If sales is celebrating Deposit Paid while finance is still rebuilding deferred revenue in Excel, you are carrying recognition and VAT risk every month.
Tell us which CRM and accounting system you use, how deposits and retainers work in your contracts, and where the CRM and ledger diverge. We will show you exactly how automated prepaid posting would work for your business.