The 13-Week Cash Flow Forecast Recommended by Your Favorite Orange County Bookkeeper

toa-cash flow

Patty Hansen

One of the best tools to forecast cash requirements is the 13-week cash flow forecast. It can help a business owner predict what their cash balance will be 13 weeks in the future. It helps to answer whether there will be enough cash to cover payroll and bills for a particular week. If you are experiencing significant ups and downs in your cash balance, it’s the perfect tool to help gain clarity around your cash needs.

Thirteen weeks may sound like an odd length to select, but it’s the length of a calendar quarter. It is the length of a financial projection that professionals typically use when a business is in financial distress; however, it’s also useful when a company is going through some ups and downs or want to get a better handle on its cash requirements.

The forecast computations start with entering cash receipts and cash disbursements into a spreadsheet. Start with actual spending and receipts for the first week, then use estimates for the remaining weeks. Include planned expenditures such as overhead, payroll, and loan payments. Add in inventory purchases. Project your receipts based on history or recent changes in your business.

Once you’ve completed your forecast, you can make changes and do what-if scenario planning.

For example, if the forecast shows that you will run out of cash in week seven, you have some time to decide what you need to do to remedy the shortfall. Options might be:

  • Accelerate the collection of 30 percent of your receivables.
  • Dip into your line of credit to cover a portion of any shortfall.
  • Furlough 10 percent of your workers.

Plug your selected scenario into the forecast to see how much that relieves your shortfall.

The benefits of creating a 13-week cash flow forecast are many. You can see what actions you need to take and when to take them well ahead of time. You can also see what action you need to take. For example, instead of furloughing 50 percent of your staff, you may only need to furlough 25 percent. Or instead of borrowing $50,000, you might only need $20,000.

The cash flow forecast can also save time when developing your annual budget. Budgets are especially useful when business conditions are volatile or when business owners need all the clarity they can get. This is a great Excel tutorial on how to set it up.

Try your hand creating a 13-week cash flow forecast for your business, or reach out to your favorite Orange County bookkeeper for help at any time.

Related Posts

Back-to-Business Checklist – Resetting Your Books and Your Routine

By Charlotte Van Dyck | Sep 23, 2025

By: Charlotte Van Dyck September brings a certain “back-to-school” energy that we can all benefit from: new routines, sharper focus, and a fresh start after Summer. It’s the perfect time for small business owners do the same with their finances. Think of this as a “back-to- business” checklist for your books. Step 1: Reconcile Your…

Read More

What Bookkeeping and Gardening Have in Common

By Charlotte Van Dyck | Sep 10, 2025

By: Charlotte Van Dyck At first glance, bookkeeping and gardening might seem worlds apart. One involves spreadsheets and financial reports, while the other is about soil, sunlight, and watering cans. But here’s the truth: managing your books is a lot like tending a garden. Both take regular attention, a little patience, and the right care…

Read More

How Accountants Keep Cool Under Pressure (And How You Can, Too)

By Charlotte Van Dyck | Aug 18, 2025

By: Charlotte Van Dyck Accountants and bookkeepers have a reputation for thriving under pressure. Deadlines, tax season, year-end reconciliations-we’re used to working in high-stress environments and coming out on the other side composed (and hopefully with balanced books!). But here’s the secret: it isn’t magic. It’s a combination of staying organized, building strong systems, and…

Read More