Cash flow Google Sheet template for business reporting

A cash flow Google Sheet template compares dated receipts and payments with a cash plan, then proves that opening cash plus net movement equals closing cash. Keep actual transactions separate from planned amounts so a favorable variance can be traced to the receipts or payments that caused it.

This layout is for a finance team's monthly cash review. For the assumptions behind future collections and payment dates, use the existing monthly cash flow forecasting method. Here the job is to compare exported actuals with a plan you already have.

Build the transaction and plan tabs

Create tabs named Transactions, Plan and Summary. Start with one USD bank account at an illustrative US distributor, Cedar Supply. Use posted cash dates throughout, and enter receipts and payments as positive numbers. Each row must represent a distinct movement; the reference column helps identify duplicate imports.

Put these headers in Transactions row 1 and the example entries in rows 2 through 9. Dates must be date values, not text labels.

The Plan tab holds the approved amounts. Start this table in A1; use the month's first day in column A. Keep the approved version unchanged while reviewing actual performance.

Do not mix unpaid invoices with bank transactions. An invoice date belongs in a collections forecast, while the actual receipt belongs on its cash date. If the task is a reported indirect statement starting from profit, use the cash flow statement example for that separate format.

Add the monthly summary formulas

In Summary B1, enter =DATE(2026,9,1) and display it as September 2026. Use column A for labels, B for actual, C for plan and D for actual minus plan. Start the financial lines at row 3:

Opening actual cash in B3 comes from the prior month's reconciled closing balance. C3 is the opening cash in the approved plan. Enter the following in B4:

=SUMIFS(Transactions!E2:E,Transactions!C2:C,"Receipt",Transactions!A2:A,">="&$B$1,Transactions!A2:A,"<"&(EOMONTH($B$1,0)+1))

For B5, use the same formula with "Payment" instead of "Receipt". Google's SUMIFS documentation confirms that it sums amounts whose rows satisfy multiple criteria. Here both the flow label and the date window must match.

The upper date boundary is the first day of the next month, excluded. Google's EOMONTH documentation explains the month-end function and the need to supply a valid date. Using a boundary before next month also handles exported timestamps on the last day.

In C4, sum the planned receipts:

=SUMIFS(Plan!C2:C,Plan!A2:A,$B$1,Plan!B2:B,"Receipt")

Change "Receipt" to "Payment" for C5. Finish the calculated cells with these formulas:

For another month, repeat the summary block with its own period cell and adjust the date references. The actual opening balance rolls from the previous actual closing balance; the plan continues from the original planned balance. A weekly cash schedule is more useful when intra-month payment timing drives the decision.

Prove the result from the rows

Receipts are $180,000 + $140,000 = $320,000. Payments are $70,000 + $55,000 + $12,000 + $43,000 + $18,000 + $2,000 = $200,000. Net movement is therefore $120,000, and $90,000 + $120,000 = $210,000 closing cash. All amounts are exact whole dollars; no rounding is needed.

The plan produces $300,000 - $210,000 = $90,000 net movement and $180,000 closing cash. The actual closing balance is $30,000 higher: $20,000 more receipts minus a payment variance of negative $10,000. A negative payment variance means less cash paid than planned; investigate whether the saving is permanent or simply a delayed supplier payment.

Enter independently reconciled September 30 cash in B8. Its $210,000 must come from the bank reconciliation, not a link back to B7. The check returns $210,000 - $210,000 = $0. A zero difference proves the movement total agrees with the stated cash balance; it does not prove every category is correct.

For example, omitting receipt R-102 would reduce calculated closing cash to $70,000 and produce a negative $140,000 reconciliation difference. The reference and amount identify the missing row. Separately confirm that imported row counts and totals match the original export, because offsetting omissions could leave the balance check at zero.

Share the working sheet for review

Keep transaction imports with the preparer and route questions through review comments. Google's sharing guidance distinguishes Viewer, Commenter and Editor access. A reviewer who only needs to challenge classifications can use Commenter access; the person maintaining the cash schedule needs editing access.

Protect the summary's formula ranges and the approved plan inputs against unintended edits. Google's protected range instructions describe restricting range editing and explain that protection is not a security measure. Use sharing permissions to control access to the file itself.

Covirage is not affiliated with Google.

Where it goes wrong

• Different cash scopes. Opening cash includes several accounts but transactions cover only one. Define the same account list for opening cash, movements and closing cash, and exclude transfers within that list.
• Mixed signs. Negative bank payments entered into this positive-payment layout make subtraction reverse their effect. Normalize signs before comparing totals.
• Month-to-date versus full-month plan. Label partial actuals clearly. A receipt still expected later in the month is not yet a missed collection.
• Overwritten plan. Updating the approved plan to match actuals erases the variance. Keep a separate revised forecast when expectations change.
• Dates or amounts stored as text. An apparently populated row can be excluded from a date test or a sum. Check import types before reading the result.

For a position statement alongside the cash review, see the Google Sheets balance sheet layout. It answers a different question: what the company owns and owes at the reporting date.

Compare your own sheet in Covirage

Bring your Google Sheet or exported receipts-and-payments file with the supplied plan and cash balances. Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See Covirage for finance teams for the supporting business context.