Just One Tab logoJust One TabAll walkthroughs
YOUR WORKBOOK, STEP BY STEP

13-week Cash Flow Planner

Alex, your spreadsheet guide

Follow the screens at your own pace. Replace fictional examples with your own information.

Visual and written guide available below. Recorded narration is being prepared.

13-week Cash Flow Planner example screen for Set your starting position
STEP 1 OF 5

Set your starting position

Hi, I'm Alex. Save your own copy and replace the fictional examples. On Cash dashboard, set the week-starting date, opening cash and the cash buffer you want to maintain.

Enlarge the screenshot
13-week Cash Flow Planner example screen for Enter receipts and payments
STEP 2 OF 5

Enter receipts and payments

Open Cash entries. Enter the expected cash date, description and category. Record each receipt in Cash in, or each payment in Cash out. Enter zero in the unused amount column.

Enlarge the screenshot
13-week Cash Flow Planner example screen for Check the entries
STEP 3 OF 5

Check the entries

Use actual spreadsheet dates and keep receipts and payments on separate rows. Check the Entry status column for missing information. The planner includes entries within the selected thirteen-week period.

Enlarge the screenshot
13-week Cash Flow Planner example screen for Review the cash outlook
STEP 4 OF 5

Review the cash outlook

Return to Cash dashboard. Review the closing-cash chart, lowest weekly cash and weeks below your buffer. Use the weekly table to see when receipts and payments create a shortfall.

Enlarge the screenshot
13-week Cash Flow Planner example screen for Update the plan
STEP 5 OF 5

Update the plan

Review expected dates each week and replace estimates with actual cash movements. Reconcile your opening cash when rolling the plan forward. This tracks cash timing, not accounting profit. Save a dated copy for your records.

Enlarge the screenshot

These instructions cover the workbook version shown. Check the product listing for included formats. Google Sheets import and feature compatibility have not been independently verified for these versions.

Download the quick-start steps