Quickbooky

Accounting News

Cash Flow & Reporting

Cash Flow Projector Receipt Methods Explained

How to choose a cash receipts projection method in the QuickBooks Cash Flow Projector, including manual entry and five historical-data options.

Cash Flow Projector Receipt Methods Explained

QuickBooks Desktop’s Cash Flow Projector gives users several ways to estimate incoming cash over the coming weeks, and the choice of method matters — switching methods wipes out any itemized receipts already entered and starts the projection fresh. Here is what each option does and when it makes sense to use it.

Why the Projection Method Matters

The Cash Flow Projector can generate receipt estimates automatically based on a company’s historical data, or it can leave the work to the user entirely. The default approach uses a weighted average of the prior six weeks of receipts, giving the most recent weeks the greatest influence on the forecast.

Changing the method at any time is supported — QuickBooks allows it so users can model different scenarios and compare outcomes. The trade-off is that selecting a new method clears the itemized cash receipts section, so anything entered manually under a previous method is removed before the new projection takes effect.

Manual Entry

Selecting the manual option puts full control in the user’s hands. For each expected inflow, the user fills in the Date, Description, and Amount fields in the Itemized Cash Receipts section. This approach suits businesses with a small number of predictable, large receipts — milestone billing, scheduled loan draws, or fixed contract payments — where historical averages would distort reality.

Historical-Data Methods

The remaining five options all pull from existing QuickBooks data, differing in how far back they look and how they process the numbers.

Last Six Weeks — Direct Duplicate

This method copies the actual cash receipts from the most recent six-week window and repeats them for the upcoming weeks. It is the simplest historical option and works best when receipts follow a stable, repeating pattern week over week.

Last Six Weeks — Simple Average

Instead of duplicating each week individually, this method averages the receipts across the prior six weeks and applies that single averaged amount to each upcoming week. The result is a smoothed forecast that flattens out one-time spikes or dips.

Last Six Weeks — Weighted Average

This is the default. It also draws on the prior six weeks, but it weights the more recent weeks more heavily, on the assumption that the latest trends are the strongest predictor of near-term receipts. The weighted average is then duplicated forward. For businesses where seasonal shifts or recent changes in customer payment behavior are in motion, this method typically produces the most realistic baseline.

Same Period Last Year — Direct Duplicate

This method looks back twelve months and copies the receipts from the comparable six-week window a year ago. It is designed for seasonal businesses — landscaping, retail, hospitality — where last month’s receipts tell you less than the same calendar period last year.

Same Period Last Year — Simple Average

As with the six-week average, this option takes the historical entries from the matching period a year earlier and averages them into a single figure, which is then applied to each upcoming week. It smooths out week-to-week variation within that seasonal window.

Practical Considerations

Switching between methods is cost-free in the sense that QuickBooks imposes no limit on how often a user changes the selection. The cost is in the data: every switch clears the itemized receipts section. Users who have invested time in manual entries should finalize or record those figures elsewhere before experimenting with a different method.

For businesses that want to compare scenarios side by side, the cleanest approach is to run the projector once per method, note the results, and then move on — rather than trying to toggle back and forth without losing entered data.

The Cash Flow Projector is one of the less-discussed tools in QuickBooks Desktop, but for owners trying to anticipate a tight month or plan a capital purchase, the receipt projection method is the single biggest lever in the forecast. Picking the one that matches the business’s actual revenue rhythm — steady, trending, or seasonal — is what separates a useful projection from a misleading one.

← Back to Community Issues