Skip to main content

Frac CFO

By Jonas Tyrone Lobaton, MSc Quantitative Finance, FMVA®
Founder, Frac CFO · Updated November 9, 2026

A cash disbursement schedule is a month-by-month (or week-by-week) plan of the cash your business will pay out: suppliers, payroll, rent, taxes, loan payments and anything else. It is built on when money leaves your bank account, not when a bill is dated. Put it next to your expected cash receipts and you can see your ending cash balance before it surprises you. This guide shows how to build one in Excel or Google Sheets, with a worked example you can copy.

Fraccfo
Bring More Clarity to Cash Flow
Frac CFO helps businesses use their existing spreadsheets for financial modeling, forecasting, and clearer cash flow insights.

TL;DR

  • A cash disbursement schedule is the outflow half of a cash budget. It lists every expected payment in the period it will actually be paid.
  • For purchases paid over two periods, multiply each period’s purchases by the share paid immediately, then add the share of last period’s purchases paid now.
  • Build it on a cash basis. Payroll, rent, taxes, interest, dividends and debt repayments belong in it alongside supplier bills.
  • The schedule is a forecast of payments. The cash disbursement journal is the record of payments already made.
  • Update it with actuals every week or month, and add checks so the cash balance reconciles.

Table of Contents

What a cash disbursement schedule is

In managerial accounting, a cash payments schedule is part of the proforma cash budget. It plans the outflow of payments for accounts payable, such as direct material purchases. Management also has to estimate other payments for the year, including overhead, sales and administrative items, and capital assets.

The same source explains how the pieces fit together. The cash budget combines the cash collection schedule, the cash payment schedule and other budgets that plan inflows and outflows. It then shows whether you need financing to maintain your balance or have excess cash for additional liabilities or assets.

For a small business owner, that means one practical thing. The schedule answers “how much cash do I need to have on hand in each period to pay what I owe?”

What a cash disbursement schedule is

Schedule vs. journal: forecast vs. record

The two terms are easy to mix up.

Cash disbursement schedule Cash disbursement journal
Looks Forward Backward
Purpose Plan when cash will go out Record cash that already went out
Contents Expected payments by period Each payment with date, payee, account and amount
Feeds Cash budget and forecast General ledger

A cash disbursement journal is a specialized accounting tool that tracks all cash payments a business makes, and its entries are later posted to the general ledger, usually monthly. It lists each payment once, in date order, with the payee, the account charged and the amount.

Your journal becomes the best input for your schedule. Past payment patterns tell you how fast you really pay.

What to include in the schedule

A useful schedule goes beyond supplier invoices. According to the Association for Financial Professionals, a disbursement schedule projects payments for purchases, payroll, taxes, interest, dividends, rent and projected debt repayments. The same article notes that accounts payable data may need adjusting, because payments often do not clear on the day they are issued.

A practical category list for a small business:

  • Inventory and materials: supplier invoices, split by payment terms
  • Payroll: wages, payroll taxes, benefits
  • Operating expenses: rent, utilities, software, insurance, marketing
  • Debt service: loan principal and interest
  • Taxes: estimated payments, sales tax remittance
  • Capital purchases: equipment, vehicles, build-outs
  • Owner draws or dividends

Use cash, not accrual

In the receipts and disbursements method, you build separate projected receipts and disbursements schedules on a cash basis, not accrual. The forecast then reflects actual cash flow rather than projected earnings.

That matters for three common items:

  • Depreciation is an expense but not a payment, so it stays out.
  • An annual insurance premium is paid once, so it lands in the month you pay it, not spread over twelve.
  • A supplier invoice dated in May but due in July goes into July. BDO’s guidance makes the same point, as summarized in the Lumen Learning cash budget chapter.

How to calculate expected cash disbursements

The core formula handles purchases paid partly now and partly later.

Cash paid this period = (this period’s purchases × % paid now) + (last period’s purchases × % paid next period)

Period one also includes any opening accounts payable you owe from before the schedule starts.

A published example

Lumen Learning’s managerial accounting course walks through a company that pays 80% of purchases in the quarter of purchase and 20% the next quarter. Q1 disbursements equal the opening accounts payable of $300,000 plus 80% of Q1 costs ($832,848), or $1,132,848. Q2 equals 80% of Q2 costs ($1,015,776) plus 20% of Q1 costs ($208,212), or $1,223,988.

Q1 and Q2 cash disbursement components

Notice the opening payable. It is easy to forget, and it makes the first period heavier than the purchases alone suggest.

A small-business example you can copy

This is an illustration with made-up numbers, not data from any company. Say you pay 60% of supplier invoices in the month of purchase and 40% the next month.

Jan Feb Mar
Purchases $20,000 $25,000 $30,000
Paid in month (60%) $12,000 $15,000 $18,000
Paid from prior month (40%) $6,000 $8,000 $10,000
Supplier payments $18,000 $23,000 $28,000
Payroll $14,000 $14,000 $14,000
Rent $3,500 $3,500 $3,500
Loan payment $1,200 $1,200 $1,200
Total disbursements $36,700 $41,700 $46,700

The January “paid from prior month” figure of $6,000 assumes December purchases were $15,000 and 40% of them remained unpaid. Purchases grew by $10,000 over the quarter, but total payments grew by $10,000 too, and the supplier part lags behind purchases by a month. If you plan only on purchases, you understate the early-month squeeze and misjudge the later one.

Cash and credit mix

Some businesses pay part of their purchases in cash and part on credit. A worked example from a coursework site (an educational illustration) has 10% paid in cash and 90% of the credit purchases paid in the following month. April disbursements are $57,600: cash purchases of $6,300 plus $51,300 of March purchases. The structure is the same as above: one row for what is paid now, one for what is paid from last month.

Estimating when payments really leave your bank

Terms on the invoice are a starting point. Your actual behavior is the better guide.

  1. Use your AP aging report. One expert guide suggests using an accounts payable aging schedule (30 to 60 days) to estimate near-term outflows, then sorting them into debt payments, cost of goods sold, operating expenses and major purchases.
  2. Record each payment in the month it is most likely to occur. A practitioner’s spreadsheet guide advises putting receipts and payments in the month they are most likely to happen, even if that differs from the credit terms.
  3. Remember checks and transfers take time. A check mailed on the 28th may clear next month. Use your bank’s cleared date, not the issue date.
  4. Mirror your customers’ timing. Your own payment schedule only works if the receipts side is realistic too. Practical tips on getting invoices paid faster help you place customer payments in the right forecast period.

A good rule: when you are unsure, put the payment in the earlier month. A forecast that is cautious on outflows is safer than one that is optimistic.

How to set up a cash flow spreadsheet

The disbursement schedule is one block in a bigger cash flow sheet. Here is a layout that works in Excel and Google Sheets.

Step 1: Create the time axis

Put periods across the columns. Use months for a planning view, or weeks if cash is tight. Start with 12 months, or 13 weeks for a short-term view.

Step 2: Opening balance

The government of Australia’s small business guidance explains that in the first month the opening balance is your opening bank balance, and in later months it is the prior month’s closing balance. Link each opening cell to the previous closing cell so you never retype it.

Step 3: Receipts block

List customer collections, then other inflows such as interest, and non-recurring items like loan proceeds or asset sales. Those categories match the receipts schedule described by financial professionals.

Step 4: Disbursements block

Build a small assumptions area at the top: percent paid in the month, percent paid next month, payroll dates, rent amount. Then write formulas that reference those cells. Do not hard-code numbers inside formulas. When terms change, you change one cell.

A typical supplier formula, with purchases in row 5 and the percent-now assumption in cell B2:

=C5*$B$2 + B5*(1-$B$2)

The first term is this month’s share; the second is last month’s remainder.

Step 5: Ending balance

The simplest version of the formula is shown in a month-by-month forecasting table: ending balance equals beginning balance plus total receipts minus total disbursements. Receipts go in on the actual date of receipt, and disbursements on the actual payment date.

Step 6: Add a minimum cash line

Set a minimum balance you want to keep, for example one payroll cycle. Add a row that flags any month where ending cash falls below it. That row is your early warning to delay a purchase, collect faster or arrange financing.

Checks that keep the sheet honest

A spreadsheet that quietly breaks is worse than none. Liam Bastick, writing in FM Magazine, recommends three types of checks: error checks, sensitivity checks and alert checks. He also stresses that checks should be created while you build the model, not added later.

For a cash sheet, that translates to:

  • Error check: the closing balance equals the opening balance plus receipts minus disbursements, and the closing cash ties to your bank statement after reconciling items.
  • Alert check: flag negative cash, a missing payroll entry, or a month where disbursements are zero.
  • Sensitivity check: change collections to be 15 days slower and see which month breaks.

Watch the timing inside the month

A monthly total can hide a problem. FinModelCheck notes that a month-end total does not prove every payment can be made when due, and that a positive month-end balance can conceal a shortfall earlier in the month. If payroll hits on the 1st and your big customer pays on the 28th, a monthly view will look fine while your account runs dry.

The fix is a weekly view for the tight months. A 13-week approach maps open approved invoices into specific weeks. Each week you record actuals against the prior week’s forecast, explain variances, and roll the model forward so week 14 becomes week 13. Our own guide on building a 13-week cash flow forecast in Excel walks through that layout.

The cash disbursement process behind the numbers

The schedule forecasts. The process makes sure the payments are controlled and recorded. The New York State Comptroller’s Office lists the steps for local governments: paying claims, documenting the transaction, safeguarding check stock, authorizing electronic transfers and wires, recording in the accounting records, reconciling accounting and bank records, reporting, and monitoring and audits. A small business can borrow the same logic.

In a textbook description of the expenditure cycle, the AP department identifies items that are due and sends a voucher packet to cash disbursements. The clerk prepares a check and records it in the check register. The entry debits accounts payable and credits cash, and it posts to the general ledger.

For a five-person company, a lean version looks like this:

  1. Approve: someone other than the payer approves each bill against a purchase order or contract.
  2. Schedule: add the bill to the disbursement schedule in the week it will be paid.
  3. Pay: release the payment by check, ACH or card on the planned date.
  4. Record: log it in your journal or accounting records with date, payee, account and amount.
  5. Reconcile: match the records to the bank statement each month.
  6. Review: compare actual payments with the schedule and update next period’s assumptions.

Step 6 is what turns the schedule from a one-time exercise into a management tool.

Common mistakes

  • Forgetting opening payables. Bills from before the first period still need to be paid.
  • Mixing accrual and cash. Depreciation and accrued expenses are not payments.
  • Ignoring irregular items. Quarterly taxes, annual insurance and equipment purchases need their own months.
  • Using averages. Equal monthly payments hide seasonal swings.
  • Never updating. A practitioner’s guide notes the spreadsheet is a working document that can be updated frequently, even daily, as receipts and payments actually occur.

Perspective

Most small businesses we talk with do not need new software to see their cash clearly. They need a well-structured spreadsheet and a routine.

We build everything in Excel and Google Sheets because that is where our clients already work. When the disbursement schedule, the receipts and the balance sit in one sheet you understand, you stay in control of your own financial data.

Our approach is to start with the payment calendar: payroll, rent, suppliers, taxes, debt. We connect it to expected collections, add alerts for low-cash weeks and turn the result into a dashboard where the numbers finally tell a story. Then we review it with you every week or month, so the forecast gets sharper over time.

That is the same logic behind our 13-week cash flow work and our fractional CFO support: clear inputs, simple formulas, checks built in from day one.

frac

Get a ready-made structure

If you would rather not build the layout from scratch, our 13-Week Cash Flow Forecast template gives you a weekly cash view in Excel. You can also browse our budgeting and cash flow templates.

Cash  Financing Optimizer

Want it built around your own suppliers, payroll and payment terms? Our one-time finance projects include a 13-week cash flow forecast and a budget build. The Launch Kit is $650 one-off, and our ongoing fractional CFO plans start at $600 per month on the Starter plan. Each includes hands-on onboarding and email support.

FAQ

Is a cash receipt a cash disbursement?

No. A receipt is money coming in, such as a customer payment. A disbursement is money going out, such as a supplier payment or payroll. The two schedules sit side by side in a cash budget, and the difference between them, added to your opening balance, gives your ending cash.

How often should I update my cash disbursement schedule?

Update it at least monthly, and weekly if cash is tight. Replace forecast numbers with actual payments as they clear, then adjust upcoming periods. A rolling 13-week view is a common way to keep it current.

What is the difference between a disbursement schedule and a disbursement journal?

The schedule is a forecast of payments you expect to make. The journal is the record of payments already made, listed by date with payee, account and amount. Use the journal’s history to improve the schedule’s assumptions.

Do I need accounting software to create one?

No. A spreadsheet with an assumptions area, a receipts block, a disbursements block and an ending balance formula is enough for many small businesses. The key is consistent formulas, a cash basis and regular updates.

About the author

Jonas Tyrone Lobaton is the founder of Frac CFO. He holds a Master’s degree in Quantitative Finance and the FMVA® certification, with work spanning financial modeling, forecasting, optimization, dashboards, business finance, and spreadsheet automation.

Sources

Leave a Reply