How to Calculate CAC Payback from a Bank Statement

Pull every debit from the business bank account and merchant processor for the period, then mark each line as acquisition or not.

The inclusion list follows the standard fully loaded definition: salaries, tools, ads, agencies and overhead, not just ad spend, because companies that count only ad spend underestimate true CAC by two to three times the LTV-CAC Book. A separate guide breaks the same list into include and do-not-include columns and puts customer success on the exclude side BaseDash.

Two bank-statement details people miss. First, processing fees: if you pay an agency by card, the surcharge is part of the acquisition cash that left the account. Second, foreign exchange: book the USD amount that debited, not the platform's converted figure. Lock a single conversion date if you must convert, because mixing rates across a month skews the total ad invoice reconciliation.

Write the rule down. Every month you apply the same rule, and every month the numbers are comparable.

Assume a B2B SaaS company with the following three months of bank activity. All figures are illustrative.

New paying customers whose first successful payment landed in each month: 118, 126, 131. Total: 375.

Cash CAC = 366,730 ÷ 375 = 977.95 per new customer.

Now the margin side. Average revenue per customer is 320 per month, gross margin is 78 percent (hosting, support and payment costs are the only deductions). Monthly gross profit per customer = 320 × 0.78 = 249.60.

Cash payback = 977.95 ÷ 249.60 = 3.9 months.

Three things to notice. The blended CAC hides a trend (month one at 987, month three at 978), so the quarter number alone is not enough. The payroll line is 52 percent of the pool, which is why an ad-only CAC of roughly 361 would have understated the truth by nearly two thirds. And the payback is short enough that this business can reinvest quickly, which is the whole point of the metric.

The cash you spent in March may have bought a customer who first paid in April. If you pair March cash with March signups, you are pairing two different things.

The cleaner method is cohort based: assign each new paying customer to the month of their first successful payment, then divide the acquisition cash from the spend months that produced that cohort. In practice, most B2B teams use a one-month lag assumption (March cash produces April's cohort) and state it explicitly. Eric Andrews makes the cohort point directly, noting that the metric is properly calculated by following a group of customers who first purchased in the same month across their lifetime, and that payback figures are commonly 20 to 100 percent longer than founders expect when that is done properly how to calculate CAC payback.

A decision rule that works: if your sales cycle is under 30 days, pair same-month cash with same-month first payments. If it runs 30 to 90 days, use a one-month lag. If it runs longer, use a two-month lag and note it. Changing the lag between periods makes the trend meaningless.

Exclude from the customer count anyone who has not yet made a real payment: trials without a card charge, invoices issued but unpaid, and customers on a credit hold.

These three items break most spreadsheet attempts at cash CAC.

Prepaid ad credits. Platforms issue promotional credits and refunds for invalid traffic, and those adjustments often land on invoices days or weeks after the original charge ad invoice reconciliation. Record the net cash that left the bank. If you paid 50,000 and received a 6,000 credit applied to next month's bill, month one carries 50,000 and month two carries the reduced amount. Do not smooth credits across both months.

Annual contracts paid upfront. A customer who pays 3,840 for a year and costs 978 to acquire looks like a 0.25-month payback on gross cash, which is misleading. The correct treatment is to keep the cash in the payback logic but measure recovery against monthly gross margin, since revenue is recognized over the term. Note the cash-timing benefit separately: annual prepayment improves effective payback because you receive twelve months of revenue on day one BaseDash.

Refunded or churned customers. If a customer pays and reverses within the measurement window, remove them from the customer count. Leaving them in deflates CAC and flatters payback.

The core calculation, whichever billing model you use, is CAC divided by the gross margin dollars the customer generates per month The SaaS CFO. Stripe's worked example follows the same structure: acquisition cost divided by new customers, then divided by monthly profit per customer Stripe.

Shared costs are where cash CAC silently drifts. Two rules keep it honest.

First, allocate sales and marketing salaries by role, not by department. A person who spends 60 percent of their time on new business and 40 percent on expansion contributes 60 percent of their fully loaded cost to acquisition. The SaaS CFO's warning is explicit: do not overburden your CAC, and allocate S&M expenses between new and existing customers The SaaS CFO.

Second, allocate tools by seat and purpose. A CRM used by five reps, four of whom do acquisition, takes 80 percent of the seat cost. A design tool used for both onboarding and campaigns needs a stated split.

The last row matters: allocating acquisition spend by revenue share makes big customers look expensive to acquire and small ones cheap, which is backwards.

Once the pool is set, compare your cash figure against the dashboard figure and explain the gap in a footnote. Common causes are credits, timing of threshold charges, payroll excluded from the dashboard, and agency fees paid outside the ad account.

Payback only helps if you act on it. The thresholds below are drawn from published guidance, not from your specific market, so treat them as starting points.

The under-12 and over-24 bands come from the LTV-CAC Book, which also notes that a 5:1 LTV:CAC ratio with a 30-month payback still needs enormous working capital to grow the LTV-CAC Book. BaseDash maps the same thresholds onto the same month bands BaseDash.

Two refinements the simple formula ignores. It does not account for churn: if a customer leaves before payback, their remaining CAC has to be absorbed by later cohorts The SaaS CFO. And it ignores the time value of money, which matters more as the payback lengthens The SaaS CFO. For most operating decisions under 18 months, the simple version is fine. For a board pack on a 30-month payback, run the cohort version.

One more caution on the margin denominator. Gross margin and contribution margin are different, and mixing them shifts payback. Gross margin deducts cost of goods sold, while contribution margin also deducts variable costs such as commissions and performance marketing Golden Egg Check. Since you already put commissions in the CAC numerator, using gross margin in the denominator avoids double counting.

If you want the reconciliation and the model built for you rather than assembled from exports, Quanta can take the statement, the billing records and the customer list and produce the working payback model as a maintained document or internal tool: https://quantaintelligence.ai/.