Cash Flow Forecast Template: A Simple Weekly Format

A cash flow forecast template is not a promise about the future. It is a practical place to organize what you know today: the cash available now, the customer payments you reasonably expect, and the bills that must be paid. When those dates sit together in one view, an owner can see a tight week early enough to make a calmer decision.

The template below is intentionally simple. It is designed for a small business owner who needs a usable weekly rhythm, not a complicated financial model. You can make it in a spreadsheet, accounting report, or paper worksheet. The value comes from reviewing it regularly and adjusting it when reality changes.

1. Start with a real opening cash balance

Use the available bank balance at the start of the first week, after accounting for transactions that have already cleared or are certain to clear immediately. A forecast becomes misleading quickly when it begins with a number that does not match the records. If the bank balance and the books differ, take time to understand the difference before relying on the forecast for a decision.

Your records do not need to look the same as another business’s records. The IRS explains that a business can use a recordkeeping system suited to its needs as long as it clearly shows income and expenses. Its recordkeeping guidance lists invoices, deposit information, account statements, receipts, and paid bills among the documents that support those entries. Those same documents are the best starting point for a trustworthy forecast.

2. Set up the weekly template

Create one column for each upcoming week. Four to 13 weeks is usually enough for a close view of payroll, rent, vendor payments, and customer collections. A longer monthly view can be useful for seasonal planning, but a weekly layout is better at showing a cash dip that a monthly average can hide.

Use the rows below as a starting format. Keep only the categories that help you make a decision. If a line will never change your next action, it does not need its own row yet.

Do not fill every cell just to make the grid look complete. Put known cash movement into the right week, and leave a note where the timing is uncertain. That makes the uncertainty visible instead of burying it in a general estimate.

3. Add expected receipts by likely payment date

Cash in is not the same as sales. Add expected customer payments in the week they are likely to reach the bank, not the week the invoice was sent. Review open invoices, the customer’s usual payment pattern, payment-processor timing, signed deposits, recurring receipts, and any funding that is genuinely committed.

It helps to mark the confidence behind a material receipt. A payment that is due next week and has a history of arriving on time is different from a proposal that has not been accepted yet. Keep possible sales or financing separate from the base forecast so the core view does not depend on hope. If you invoice customers, an accounts receivable aging report can help you see which open balances are current, late, or worth a direct follow-up.

A good question for each expected receipt is: “What would make this arrive later?” It might be a missing purchase order, a customer approval step, a dispute, a payment plan, or no clear reason at all. When timing is uncertain, move the receipt to a later week or place it in a separate cautious scenario. The goal is not pessimism. It is a forecast you can use.

4. List the cash commitments that cannot be ignored

Start with items that have a clear date and would create a real problem if missed. For many businesses, that includes payroll and payroll taxes, rent, debt payments, insurance, supplier bills, sales-tax or estimated-tax payments, subscriptions, owner draws, inventory, and planned equipment purchases. Add the payment in the week cash is expected to leave the account, not merely the month in which it is recorded in the books.

Supporting documents help prevent common omissions. The IRS notes that business records may include account statements, invoices, credit-card statements, receipts, and canceled checks. Review the calendar and recent bank activity as well as recurring bills. Annual insurance, quarterly taxes, and a large vendor renewal can be easy to miss if you only look at a typical week.

Separate ordinary operating costs from one-time decisions. For example, payroll and rent may belong in the base forecast, while a new vehicle, expansion project, or owner distribution may deserve its own scenario. That separation lets you see whether the business can support the decision without hiding its effect inside normal operating costs.

5. Read the low point, not only the ending balance

After you calculate the expected closing cash for each week, scan for the lowest point in the period. A forecast that finishes the month with a positive balance can still reveal a difficult week in the middle, when several payments leave before a customer deposit arrives. That low point is often the number that matters most.

When the forecast shows a tight week, do not treat it as a failure. Treat it as a planning signal. You may be able to follow up on a specific invoice, request a customer deposit for new work, change the timing of a discretionary purchase, ask a supplier about payment timing, or begin a financing conversation earlier. The correct answer depends on the facts, but the forecast gives you time to consider options before the account is under pressure.

Template results should support a decision, not replace judgment. A business with seasonal income, grant funding, inventory commitments, multiple bank accounts, or restricted funds may need categories and timing that a basic four-week format cannot capture. That is a reason to expand the model carefully, not to abandon the weekly habit.

6. Compare the forecast with what actually happened

A forecast becomes more useful after the first review. Each week, replace estimates with actual receipts and payments, note why a material item landed earlier or later, and add a new week at the end. The earlier forecast does not need to be perfect. It needs to help you understand which assumptions deserve a closer look next time.

For example, if a customer payment repeatedly arrives two weeks after its due date, the next forecast should reflect that pattern until there is a reason to expect a change. If payroll costs rose because of a new hire, update the recurring cash-out line. This simple feedback loop makes the forecast less of a spreadsheet exercise and more of an operating tool.

Pair the weekly review with a dependable bookkeeping routine. The small business bookkeeping checklist can help keep invoices, deposits, bills, and reconciliations current, which gives the forecast better input. If the books are behind, begin with a catch-up bookkeeping plan before relying on a precise-looking forecast built from incomplete records.

7. Keep a short review checklist beside the template

A short checklist helps the forecast become a habit. Set aside a recurring time, preferably before the busiest part of the week, and work through the same questions. Start by entering the actual bank balance. Mark payments and receipts that have cleared. Review the invoices and bills due before the next review. Then compare the new expected closing balances with the prior version.

• Confirm the opening balance. Check the bank activity and make sure the starting cash reflects what is actually available.
• Update material customer receipts. Move receipts when a customer gives a new payment date or an invoice becomes a collection concern.
• Check the next payroll, tax, and supplier dates. These items are easy to overlook when they happen only monthly, quarterly, or annually.
• Read the lowest projected balance. Ask what would change if one large receipt arrives late or one major payment is higher than expected.
• Record the next action. A forecast only helps when it leads to an appropriate follow-up, decision, or conversation.

Keep notes simple. A short explanation beside a significant line can be more useful than a complex tab full of formulas. For instance, a note might say that a customer promised payment after an approval meeting, or that an insurance renewal is included in the third week. These notes help the next review move quickly and make it easier to explain the forecast to a business partner, bookkeeper, or lender when needed.

Use the same categories from week to week whenever possible. Consistent labels make it easier to notice a real change, such as slower customer collections or a higher supplier cost, rather than mistaking a renamed line for a business trend. When a category needs to change, write down why so the next review starts with context.

What a cash flow forecast template cannot tell you

A template can reveal timing pressure, but it cannot decide what the business should do about it. It does not determine whether an expense is deductible, whether a customer balance should be written off, whether a loan is appropriate, or whether an owner distribution is wise. Those decisions depend on the business’s records, commitments, tax position, and goals.

It also does not replace the core financial reports. An income statement helps you understand performance over a period. A balance sheet shows assets, liabilities, and equity at a point in time. The forecast is different: it turns expected movement into a forward-looking cash view. Used together, those reports provide a clearer picture than any one number can offer.

For a new business, a seasonal business, or a company preparing for rapid growth, the template may need more detail over time. The Small Business Administration’s planning guidance identifies cash flow statements alongside income statements and balance sheets as core financial information for an established business plan. Start with the simple version, then add detail only when it helps answer a real question.

When professional support makes the template more useful

A simple cash flow forecast can be a strong owner tool. Professional bookkeeping support becomes particularly valuable when the business has several accounts, complex payroll, inventory, loans, sales taxes, recurring late payments, restricted funds, or a backlog of unreconciled activity. In those situations, a clean starting balance and current records are not small details. They are the foundation of the forecast.

Integra’s full-charge bookkeeping service helps businesses keep transactions, reconciliations, and financial reporting current. Its financial accounting support can also help owners use reports, budgets, and forecasting to guide decisions. If you need a clearer starting point for the cash ahead, schedule a conversation with Integra.

Frequently asked questions