Invoice collections: 4 timing figures for cash planning

• Measure collection shares from payments for the same jobs as the sales.
• Apply each share to the correct quarter’s sales.
• Count expected payments once, and assign no cash to invoices you expect will never be paid.
• Compare expected collections with bills due in each quarter.

For a shop, a contractor, or a service firm, the gap between finishing a job and receiving payment decides whether wages, rent, and suppliers are paid on time. Profit and cash arrive on different schedules, and a cash plan has to follow the second one.

This post works through four timing figures for turning job revenue into a cash forecast. It is written for owners and managers who need to know when job revenue turns into cash. The figures come from a worked budget example in the OpenStax managerial accounting textbook, which estimates when sales made in one quarter will be collected over the quarters that follow. Treat them as a method for thinking about timing, not as a forecast for your business.

The four figures are 65% of a quarter’s sales collected in that quarter, 30% collected in the quarter after the sale, a combined example for quarter 1 of year 2, and $0 in collections from a prior quarter that had no sales. Each one answers a different timing question, and together they show how one quarter of work becomes cash across two quarters.

Collection timing decides when job revenue becomes cash you can spend, so it belongs in the cash plan next to your sales figures.

A job can be finished and billed in one month while the payment arrives in a later one. During that gap, bills for materials, wages, and fuel can still come due. A plan that shows only sales can look healthy while the bank balance runs short.

The OpenStax example handles this by forecasting cash quarter by quarter, based on when each sale happened. The sections below take its figures one at a time and then show how to apply them to your own jobs.

This matters most when you have to decide whether to take on new work, hire, or buy materials before a payment arrives. The question is not only whether a job is profitable, but when the money for it will be available.

The example is built around quarters, which suits a budget. If your jobs are short and you want a finer view, you can lay out the same two-step logic by month, as long as you use the same definitions for the sales and payment dates throughout. For recurring jobs, review your maintenance billing calendar alongside the forecast.

The textbook states it this way: "In the quarter of sales, 65% of that quarter’s sales will be collected."

This 65% is a figure set for the example, not a rule for every business. Your own in-quarter share may depend on your payment terms and on when in the quarter each job is finished. A job completed near the end of a quarter has less time to be paid inside that quarter than one completed near the start, so a percentage measured on one set of jobs may not fit another.

The textbook’s wording is: "In the quarter after the sale, 30% will be collected."

If your customers pay more slowly than that, estimate later payments separately by expected payment date, excluding amounts already counted.

The example states it this way: "For example, in quarter 1 of year 2, 65% of the quarter 1 sales will be collected in cash, as well as 30% of the sales from quarter 4 of the prior year."

The same pattern works for any quarter in your forecast. Use this sequence for each one:

1. Total the sales for the quarter you are forecasting.
2. Total the sales for the quarter before it.
3. Apply your in-quarter share to the first total, and your next-quarter share to the second.
4. Add the two results. The sum is the collection line for that quarter.

That makes it easy to check a row by hand when a number looks wrong.

The calculation does not require you to know exactly which invoice a payment settles, only the totals for each quarter. That makes it a workable starting point even when your records are imperfect, although the result will be only as good as the records behind it.

Assume illustrative sales of $50 in the preceding quarter and $0 in the current quarter. Using the example’s next-quarter share, $50 × 30% gives $15 expected in the current quarter. Current-quarter sales contribute $0, so expected collections total $15. The cash arrives in a quarter with no new sales because it comes from earlier work.

A full year of rows is a chain: each quarter’s collection line reuses the sales of the quarter before it, so an error in one row can carry into the next.

Because each row draws on the prior quarter’s sales, a wrong sales total affects two collection lines. The first is the quarter it belongs to, and the second is the quarter after, which uses it for the next-quarter share. Checking the sales totals before you calculate is therefore cheaper than correcting the cash line afterward. Once the table is filled in, read down it and confirm that each row points to the right prior-quarter total.

The textbook puts it this way: "There were no sales in quarter 4 of the prior year so 30% of zero sales shows the collections are $0."

The arithmetic is simple, but it matters in practice. A quiet quarter does not leave a blank in the forecast. It appears as a zero for the collections from that quarter, and the zero stays visible in the totals. That keeps the gap in work from being hidden inside another number.

Replace the example percentages with collection shares from your own invoices, measured quarter by quarter.

The textbook figures are a starting shape, not a benchmark. To make them yours, pull a recent year of invoices and group them by quarter. Use the date the work was done or the invoice was issued, whichever your books use, and be consistent about it. For each quarter’s sales, total the payments for those same invoices received during the sale quarter and during the next quarter separately, then divide each total by that quarter’s sales. The results are your in-quarter and next-quarter shares.

Two cautions apply. First, make sure the sales base and the payments base cover the same jobs, so a payment is not counted against the wrong quarter’s sales. Second, use recent history. Older invoices may reflect terms, customers, or work you no longer have, so they can point the forecast in the wrong direction.

Once you have the shares, write them down with the date you measured them. That tells you when they were last checked, and when they need to be measured again.

Before you rely on the shares, test them on a quarter you already know. A close match gives some confidence. A large miss points to the shares, or to the dates you used to assign sales and payments to quarters.

The example figures are assumptions in a textbook exercise, so they do not describe your customers, your trade, or your location.

Your forecast also needs to account for later payments, partial payments, and invoices that are never paid. Those are real parts of job revenue. Counting an invoice expected never to be paid as future cash overstates the money available for bills.

When measuring your own shares, note the payment terms, deposits, and overdue-invoice follow-up in place during the period. Each of those may change the shares you measure in your own records.

Add a separate line only for expected payments not already included in your measured collection shares, using their expected payment dates.

An overdue invoice paid during the sale quarter or the following quarter may already be included in those shares. Assign no cash collections to invoices you expect will never be paid.

When the amount is uncertain, use the cautious end of your range, so that a slow payment does not leave a gap you did not plan for.

Review that row each month. When an invoice is paid, replace its expected payment with the actual payment without counting it again, and update the late row with what is still expected. Doing this keeps one stalled invoice from quietly distorting the whole forecast.

You can move collections earlier by changing when invoices go out, how payment is requested, and what you ask for before work starts.

The example treats the timing as a given, but in your business the timing is partly a decision. Sending invoices as soon as a job is complete shortens the gap before payment can be due. Making the payment request clear, with the amount, the due date, and the way to pay, removes friction that can delay a check. Asking for a deposit or a progress payment on larger jobs brings some cash in before the work is finished. Review partial billing and estimate approval when planning those payments.

Each change affects the shares you measure, so make one at a time and remeasure after enough time has passed to see the results. Changing several things at once makes it hard to tell which one worked.

Compare the collection line with the payments that actually arrived each month, and adjust the shares when they drift.

A forecast is only useful if you check it. At the end of each month, total the payments received and compare them with what the forecast expected for that period. Note the difference and its cause. A payment that came late is different from a job that was never paid, and the forecast needs to treat them differently.

If the gap keeps pointing the same way, the shares are probably off. Recalculate them from your most recent invoices and record the change. If the gap is a one-time event, leave the shares alone and explain it in the notes. That habit makes the next forecast easier to trust.

Today, choose a past quarter and trace its sales to payments received in that quarter and the next. Calculate the shares and check them against your forecast.

Update the forecast at least once a month, and remeasure the shares whenever recent invoices change the pattern.

Monthly updates keep the collection line close to what is actually in the bank. Between updates, record new jobs and payments as they happen, so the next check starts from current figures. Remeasuring is a separate task. Do it when recent history looks different enough to change the shares, rather than treating it as a routine chore.

The easiest timing mistake is to date a payment by the sale instead of by when the cash arrives.

Sales and cash are recorded on different dates, and the figures in this post only work if each is put in the right quarter. A job sold in one quarter but paid in the next has to appear in the collection line of the later quarter. Entering it in the quarter of the sale makes that quarter look better than it will be in the bank.

A second mistake is to apply one quarter’s shares to every quarter. Work that is busy in one period and quiet in another does not necessarily carry the same timing, so use shares that match each quarter’s history where you have them. A third is to forget the zero case. A quarter with no prior sales still needs a row, even if the row shows zero.

Each quarter should show expected collections beside the bills that fall due in that quarter.

Put the collection line in the same table as your outgoing bills, such as wages, materials, rent, loan payments, and tax payments. Then compare the two totals for each quarter. A quarter where bills exceed collections is the one to plan for. The response could be timing a purchase later, asking for deposits on new work, or setting aside cash from an earlier quarter.

The forecast does not choose the response for you. It shows the quarter where a decision is needed, and the choice depends on your own finances and commitments.

Anyone who approves spending should see the collection line, not only the totals.

A collection line shows the timing that a total hides. A manager deciding whether to order materials for next quarter needs to know what cash is likely to arrive before the order is due, and the quarter view answers that. Share the table with the people who approve payments, and explain the two shares so that everyone reads the numbers the same way.

A good forecast is one whose collection line you can check against the bank each month without rebuilding the model.

A forecast is easy to use when each row traces back to sales and shares, and when the monthly comparison takes a short time rather than an afternoon. If you cannot tell where a number came from, it is hard to correct. Keep the inputs, meaning sales by quarter, the two shares, and the late row, on one sheet, and the outputs on another, so that a reviewer can see what drives the result.

1. Total your sales for each quarter from your job records.
2. Measure your in-quarter and next-quarter shares from recent invoices.
3. Build the collection line for each quarter, entering zero for any prior quarter with no sales.
4. Add a separate row only for expected payments excluded from those shares.
5. Compare each quarter’s total collections with the bills due in that quarter.

Related guides: Form 8300 cash reporting: 5 rules for a shop to check · Invoice total calculation: 4 tools and rounding limits · Mixed-rate invoice totals: 3 checks before quoting repairs .