Straight into the service manual page
WrenchQuarry
More

Cash budget timing: 3 figures for quarterly purchases

WrenchQuarry Editorial Team · Published · 16 min read · How these guides are written

A cash budget sets expected job cash beside planned purchases, period by period, so a short quarter shows before you order.

Key takeaways

  • Map every budget that feeds cash on one page before you plan a buy.
  • Forecast collections from your own payment history, not from booked work.
  • Record the order, bill, and payment date for each planned buy.
  • Compare each quarter's payments with expected collections before you place the order.

Every trade owner knows the feeling of a good month that still leaves the account thin. A busy stretch of installs, repairs, and rough-ins can fill the calendar and still leave you short when a supplier invoice arrives. Then the next buy, whether that is a replacement condenser, a pipe-threading machine, a bulk order of wire, or a van that needs to go on the road, lands in the wrong week.

The problem is rarely that the work is unprofitable. The problem is timing. Cash leaves on one schedule and comes in on another, and a planned purchase only works if those two schedules line up. Seeing that alignment on paper gives you room to change course.

The OpenStax textbook Principles of Accounting, Volume 2: Managerial Accounting makes the purpose plain: Preparing financial budgets involves examining the expectations for financing the operations of the business and planning for the cash needs of the organization. For a small firm, the cash needs of the organization are your payroll, your fuel, your parts, and every equipment buy you have in mind for the quarter. A budget that leaves out any of them is a guess.

This post walks through three figures from the same section of that textbook. Each one covers a piece of the timing problem: how the budgets connect, when job cash actually arrives, and when each quarter's purchases get paid. The textbook's sales-budget example comes from a sample company, Big Bad Bikes, not from a plumbing or electrical shop, so its numbers will not carry over to yours. The structure will, and that is what you need.

Trade firms feel this more sharply than many businesses because the work often arrives in bursts. A cold snap, a heat wave, a storm, or a surge of inspections can fill weeks at once, while the slow weeks still carry rent, insurance, and payroll. A plan that treats every month as the same will hide exactly the weeks that cause trouble.

If you are the owner, you probably carry the risk in your head. If you are the office lead, you probably carry the spreadsheet. The method below works best when both people can see the same page.

Figure 7.15: map the budgets before you plan a buy

Before you can time cash against a purchase, you need to know which budgets feed the cash budget. The textbook is direct about this: Figure 7.15 shows how the other budgets tie into the cash budget. A second line in the same section says that Figure 7.15 detailed the components of the master budget, and can be used to summarize the budget process.

Use the idea as a checklist. No budget stands alone. Job volume feeds collections, purchases feed payments, and payroll, vehicles, and overhead feed their own payments. Each of those lines has to appear in the cash picture, or the picture is incomplete.

The cash budget is the place where the other budgets meet. Each line you put on the map eventually lands there as money in or money out. That is why the cash budget is the most useful place to test a purchase. A purchase plan that never reaches the cash budget is a wish list, not a plan.

For a trade firm, the map usually includes these lines. Write them on one page and keep it where the owner and the office lead can both see it:

  • Expected job work for each month of the quarter, based on booked jobs and your usual rate of turning estimates into signed work.
  • Expected collections from that work, which often arrive after the work itself and get their own section below.
  • Planned purchases of materials, parts, and equipment, each tagged with the quarter it is planned for.
  • Payroll and payroll taxes, which leave on their own schedule.
  • Vehicle, fuel, insurance, rent, software, and other recurring overhead.
  • Loan or lease payments, if you carry any.

The point of the map is to find the missing lines. Budget trouble often starts with a missing line, not a wrong number. A van payment nobody wrote down, or a seasonal parts order that lives only in one technician's head, will break the plan. Ask each person in the firm what they pay for and when, and add anything they name.

Suppose a replacement condenser is planned for the second month of the quarter. That buy is more than one line in a purchases budget. It also changes the cash picture in the month it is paid, and that payment has to be checked against collections from work finished earlier. If the money coming in from those earlier jobs has not arrived, the buy is in the wrong place, even if the budget looks balanced on paper.

Once the map is complete, read it in one pass: money expected in, then recurring money out, then the purchases you are weighing, then the balance that remains. Do that every time a large buy comes up. For a related checklist, see 3 cash budget figures to set before buying equipment.

Every line on the map needs an owner. Someone in the office should own the collections forecast, because they see the invoices and the deposits. The owner should own the purchase plan, because they know which jobs need which equipment and which parts are critical. Payroll and overhead can sit with whoever runs the bills. When one person holds all of it, the plan goes stale the day they are busy with a job. Splitting ownership keeps each line current, and a short weekly check-in keeps the lines consistent with each other.

Figure 7.17: track when job cash arrives, not when work is booked

The textbook derives its collections line from the sales budget: Using information from Big Bad Bikes sales budget, the cash collections from the sales are shown in Figure 7.17. The key word is collections. A sales budget says what was earned. A collections line says what cash came in. Those are not the same number in the same month, and treating them as one is a common reason a planned buy looks affordable on paper and then stalls.

For a trade firm, this gap shows up everywhere. A job finished on the last day of the month may be invoiced the following week and paid after that. A large install may be billed in stages. A repair paid at the door arrives the same day. Each has its own timing, and a collections line that treats every job as paid on completion will overstate the cash you have.

To build a realistic collections line, start with your own history rather than your hopes. Pull a few past months, list billed work by month, then list deposits by month, and compare the two. You are looking for the typical delay between finishing work and getting paid, and for whether that delay changes by customer type or job type. Write the answer in plain terms, such as "small repairs are usually paid the same month, larger installs later." Use the pattern you observe in your own books, not a figure copied from anywhere else.

Apply that lag to your pipeline. Take open and scheduled jobs, assign each one to the month you expect its payment, and add them up by month. That is your collections line. Keep a separate line for money still owed from earlier work, because it is real cash that may still arrive, and it should not be counted twice.

Here is how the pieces combine, without any real numbers. Suppose a crew finishes a handful of repair jobs late in one month and a larger install wraps up near the end of the next. The repairs are billed quickly and the customers pay within the same month, so their cash lands where you expect. The install is billed in stages, and its final payment falls in a later month than its completion. A collections line that books the whole install as cash on completion would show money that is not yet there. The corrected line shows the stage payments as they are expected to arrive, and the final payment in its later month.

Stage billing deserves its own line. Each stage has a bill date and an expected payment date, and the stages should not all be lumped into the month the job closes. Writing them as separate entries makes it obvious when a large install is carrying cash that has not yet arrived.

Customer type matters more than it first appears. Work for a property manager, a homeowner, and a commercial account may follow different payment rhythms, and each rhythm should be modeled separately. Tag each job with its payer type when you invoice it, so the pattern shows up in the next review without extra digging.

Large jobs need extra care. If a big install's cash is expected in the quarter after a planned equipment buy, the buy is safe only if your balance covers the gap. Label those incoming payments as expected, not as money in the bank, until the deposit clears. A single slow customer can move a whole quarter, so note when one account makes up a large share of expected collections.

Once a month, put the collections line next to your actual bank deposits, and do it in the same format each time. Mismatches are normal at first. A deposit may cover work from two earlier months, or a single check may cover several jobs. Your job is not to force the numbers to match on the first pass. It is to find the pattern behind the differences, so the next forecast is closer to what arrives.

Figure 7.18: match each purchase payment to its quarter

The textbook's third figure covers the outgoing side: Figure 7.18 shows when each quarter's purchases will be paid. This separates two dates that are easy to blur: the date you buy and the date you pay. A purchase planned in one quarter may be paid in a later one, depending on the payment terms your suppliers give you and how your office processes invoices. Give payment timing its own schedule, not a footnote to the purchases budget.

The table below sets the textbook's related figures and tables side by side.

Figure or tableWhat the textbook statesHow to use it for your firm
Figure 7.15Shows how the other budgets tie into the cash budgetCheck that every budget feeding cash is on your map
Figure 7.17Cash collections from sales, taken from the sales budgetTime incoming job cash, not booked work
Figure 7.18Shows when each quarter's purchases will be paidMatch each planned buy to its payment quarter
Table 7.1Lists the most common balance sheet changes and where the information is derivedFind where an equipment buy will appear on the books
Figure 7.22Capital assets rose $8,500 from a copier purchase; common stock rose $5,000 from an additional issueSee how a large equipment buy changes the balance sheet

For each planned buy, record three dates: when you plan to order it, when you expect the bill, and when you expect to pay. Put the payment in the quarter where it falls. Then total those payments for each quarter and set them beside the collections line from the previous section. If payments run ahead of job cash in a given quarter, you have a timing gap to close before you place the order.

Parts and equipment do not behave the same way. A fitting pulled for one job is usually a small, near-term cost. An equipment unit may be one large payment or a series of smaller ones. Keep them on separate rows, because a single combined total hides the timing differences that matter most when cash is tight. If parts drive most of your recurring buys, a quarterly materials budget can give that line its own plan.

Seasonal work changes the purchase picture. Parts that a busy stretch will consume should be ordered ahead of that stretch, and the payment for them falls on the calendar as well. If a season's parts are bought in one quarter and that season's jobs are paid in the next, the cash has to bridge the gap. Put the work calendar beside the purchase calendar so you can see where the two drift apart, and ask whether each early buy is worth carrying the cost for.

Read the purchases line by quarter as well as by month. A month can look fine while the quarter as a whole is tight. Keep both views and check that they agree, since a month-level plan can hide a quarter-level squeeze.

When the purchases line runs ahead of the collections line, you have several options, and none of them requires guessing. You can move the order later, so the bill falls in a quarter with more cash on hand. You can split a large buy into parts that pay out across two quarters, if the supplier and the work allow it. You can ask your supplier about payment timing before you order, since the terms affect which quarter the payment lands in. You can also decide the buy is worth waiting for and build a cash reserve first. Whichever you choose, write the decision next to the buy so the next review starts from what was decided.

Illustrative example: a $5000 buy in month two

Suppose a $5000 equipment buy is planned for month two of the quarter. Expected collections for month two also total $5000, but $500 of that is a stage payment from a large install that may slip into month three. Treat the buy as at risk until that $500 clears, and either move the order or line up funding first. The buy fits only if the quarter's expected collections cover it along with the recurring payments on your map.

Mistakes that break the plan

A few errors show up again and again in shaky cash plans. Recognizing them is faster than fixing a bad quarter after the fact.

  • Counting booked work as cash. The sales line and the collections line are different. Keep them apart.
  • Leaving out a recurring cost. A monthly payment that nobody wrote down will surface at the worst time.
  • Mixing up buy date and pay date. An order placed in one quarter may be paid in the next, and the cash has to be counted where it actually leaves.
  • Trusting the supplier's bill date. A bill that arrives later than expected can push the payment date out, so keep the payment date tied to the terms you actually have.
  • Planning only for the best month. A plan that depends on the busiest stretch leaves no room when work slows down.
  • Forgetting to update. A schedule tends to drift from reality, and the drift often runs optimistic.

Each of these shows up in a monthly review if you look for it. Start with the one that matches your last tight quarter.

Putting the three figures to work each quarter

Here is the order to work in, once a quarter and again before any large buy:

  1. Build the map from Figure 7.15. List every budget that feeds cash, and check that nothing is missing.
  2. Build collections from Figure 7.17. Turn planned work into expected cash, using the payment lag from your own history.
  3. Build purchase payments from Figure 7.18. Record the order, bill, and payment dates for each planned buy.
  4. Compare month by month and quarter by quarter. Subtract outgoing payments from expected collections, and check that enough cash remains for payroll and overhead.
  5. Decide before you order. If a buy lands in a gap, move it, split it, or line up the funding first.

At the monthly review, keep to a short set of questions so the meeting stays useful:

  • Which collections arrived as expected, and which are late?
  • Which planned buys were paid, and which moved?
  • Did any recurring cost change, or appear without being on the map?
  • Does the next quarter still show room for planned buys after the updates?
  • Which decision from last month needs a follow-up?

Keep the schedule in one shared file that both people can open, with the three figures as its three tabs or sections. Date every entry, note who changed it, and keep last month's version so you can see how the forecast moved. A shared file is only useful if it is updated on the same day each month, so put the review on the calendar and treat it like a job.

Two cautions. First, the textbook's example figures come from a sample company, so the method is what transfers, not the numbers. Second, a schedule is only as good as its inputs. The owner and the office lead should review it together each month, because the people who sell the work and the people who chase the payments often see things the spreadsheet does not.

The textbook also shows the balance sheet side of a buy. The company's capital assets increased by $8,500 from the copier purchase, and their common stock increased by $5,000 from the additional issue as shown in Figure 7.22. The lesson for a trade firm is that a large equipment purchase changes what the business owns as well as how much cash it holds. Ask your bookkeeper or accountant how your own equipment and parts purchases are recorded, because that answer decides where the cost appears in your reports.

The three figures give you a method, not a forecast. They ask one question over and over: when does the money arrive, and when does it leave? If you can answer that for each planned buy before you order, you are far less likely to be surprised by a short week, and you have more time to plan the work that brings the cash in.

Try this on your next planned buy. Write the buy's order date, bill date, and payment date on one line. Find the collections you expect in the quarter of that payment, and subtract the other payments you know are due in the same window: payroll, vehicle costs, rent, and the loan or lease payments on your map. If what remains is comfortably positive, the buy fits. If it is close, or negative, the timing needs work before the order is placed, even if the buy itself is affordable over the full year. Full-year totals hide quarters that run short.

Frequently asked questions

Why does booked work differ from job cash?

Booked work is what the firm has earned, while collections are the cash that actually arrives, and the two often land in different months.

When should a planned buy be checked against cash?

Check it before you place the order, by comparing its payment date with the collections expected in that quarter.

Who should own the cash plan?

Split ownership: someone in the office should own the collections forecast, the owner should own the purchase plan, and a short weekly check-in keeps the lines consistent.

Sources

More field guides