How to model a one-time receipt, like a data license, in a 13-week cash flow forecast

The rule: the base case only holds contractual cash

A 13-week cash flow forecast earns trust because every receipt in its base case has a contract, an invoice or a payment history behind it. A possible one-time receipt, such as a data license payment, stays out of that base case until the license is signed, the buyer has selected the data and the invoice has gone out. Until then it sits in a clearly labeled scenario, dated to when cash should land rather than to when terms were agreed.

The discipline matters most when a lender, a board or a turnaround adviser reads the model. One unlabeled inflow can make a tight liquidity position look comfortable, and once a reader spots it, every other line gets questioned.

The evidence ladder for one-time receipts

Move a one-time receipt toward the base case only as the evidence improves. The ladder works for asset sale proceeds, insurance recoveries, tax refunds and legal settlements; the third column maps it to a data licensing deal run through SourceX.

Two timing facts drive the placement. Once a company is deal-ready, buyers typically respond within about two weeks, but a response is not a payment. And once the buyer selects the data, the one-time payment typically arrives within about 60 days of invoicing, a gap that on its own can push the receipt past week 13.

What you need before modeling it

• A working direct-method forecast: opening cash tied to the bank, receipts by customer group, disbursements by category (payroll, rent, vendors, debt service, taxes) and a weekly actual-versus-forecast variance.
• The agreement or term summary, so you know the amount due, what triggers the invoice and any conditions before payment.
• The credit agreement, to see whether one-time proceeds must be reported to the lender, applied to prepay debt or excluded from a borrowing base. Read whether lender consent is needed to license company data before the license is signed, not after.
• Clarity on who signs for the company. The CFO models the deal; the owner or an authorized officer approves it, as covered in whether a fractional CFO can sign a data license for a client.

How to add a one-time receipt to the forecast

1. Create a separate block. Below operating receipts, add a non-operating and one-time receipts section with its own subtotal, so operating cash flow stays clean and comparable week to week.
2. Add a scenario switch. Build three views: base case, base plus signed one-time items, and upside. The base case never reads from scenario rows.
3. Date the receipt to cash, not to signing. Enter an earliest and a latest plausible week. For a data license, start the clock at the buyer's data selection and the invoice, then apply the roughly 60-day collection window.
4. Model a single gross receipt. A SourceX license is priced as one all-in amount with SourceX's fee built in and no separate charges, so there is no platform-fee payment to model. A referral reward paid to an adviser also comes out of SourceX's fee, so it does not reduce the receipt.
5. Model the costs around the deal. Add rows for outside counsel review, staff or contractor time to run exports and apply the agreed redaction rules, and any tax payments the company's tax adviser expects on the income.
6. Apply lender terms in the same week. If the credit agreement requires a prepayment, a cash sweep or a notice for this kind of proceeds, show the outflow or the task alongside the receipt.
7. Write one line of commentary per scenario item. State its stage on the ladder, its expected week range and the evidence that would move it into the base case.
8. Roll it every week. Move the item down the ladder only on new evidence, and record the variance once the cash lands.

Cash timing is not revenue timing

The forecast tracks cash; the income statement may tell a different story. Under ASC 606, a license of intellectual property is either a right to use the IP as it exists when granted, recognized at a point in time, or a right to access it throughout the license period, recognized over time, as Deloitte's roadmap on identifying the nature of a license explains. How a particular data license is classified is a question for the company's auditors, not for the cash model. Lenders and acquirers will also ask how the item is treated in adjusted EBITDA; see how a one-time data license affects adjusted EBITDA and QoE.

If your firm also performs attest work for the client, check whether helping a client license data affects CPA independence before taking on modeling or advisory work around the deal.

This is general information, not legal, tax or financial advice. Confirm with your own counsel, tax adviser or professional body before acting.

Common mistakes

Illustrative example: placing a license receipt week by week

Illustrative and fictional: a 220-person IT services firm. Week numbers count from the start of the engagement, and each weekly roll shows the next 13 weeks. The amount is whatever the signed agreement states; the example shows placement only.

The CFO's week 5 commentary reads: "One-time license receipt moved into the base case. Invoice issued in week 5; payment typically arrives within about 60 days of invoicing, so it is modeled in week 14. Operating assumptions unchanged."

Where a fractional CFO fits in the deal

The CFO owns the model and the questions, not the decision. The owner decides whether to license, on what scope and at what price; SourceX runs qualification, the data inventory, pricing, buyer review, contracting and delivery. The companies that reach this stage are US businesses with 50+ full-time employees at peak (contractors excluded), several years of documented operations, rights to the records and an authorized sponsor, and the company fit checker gives a preliminary read without any contact details.

If you introduced the client, say so in writing and disclose any reward. Partners earn 25% of the eligible platform fees SourceX actually collects from the referred company's licensing deals, capped at $100,000 per referred company. That reward becomes payable only once the buyer has paid and SourceX has its fee, and no reward is guaranteed. More guidance for the role sits on the fractional CFO hub.

Next step

Add a one-time receipts block and a scenario switch to your 13-week template before the next deal appears, so a possible license never lands in the base case by accident. If a client has the records and the appetite, register as a partner and make the introduction, or have the owner apply at sourcex.si/apply with your referral link.