Cashflow organization / Income variance

Expected vs actual income records

When a month closes, you often have two numbers in your head: what you expected to come in, and what actually landed. An expected vs actual income record puts those two numbers side by side for the same period so the difference is right there on the page instead of in your memory. This is a review-and-organize workflow, not a forecast. You record what you had expected for January, record what you actually received in January, and note the variance and a short reason for it. Cash Workspace gives you folders and records to keep each period's comparison together with the payment proofs that back up the "actual" column. It is free, and it does not predict, project, or advise on your income, it simply organizes the expected figure next to the received figure so you can review the gap yourself.

The problem

Why the gap between expected and actual income gets lost

Most people set an expectation for the period somewhere, a forward list, a planning sheet, a mental note, and then never go back to check it against what really happened. The expected figure lives in one place and the actual deposits live in another, so the two never meet on the same page. By the time you wonder why the month felt tight, the original expectation is gone and you are left guessing. An expected vs actual record fixes that by capturing both numbers for the same period in one record, with the proof attached, so the comparison survives and you can review it deliberately.

  • The expected figure for a period is jotted somewhere forward-looking and never revisited once the period ends.
  • Actual deposits are scattered across separate income records, so no single number sits next to the expectation.
  • Without both numbers together, you can't see whether a shortfall came from a delayed client or an income source that simply didn't materialize.
  • You repeat the same surprise every period because last period's expected-vs-actual gap was never written down or reviewed.
  • There is no per-period home that pairs the expectation with the received amount and the proof behind it.

The review workflow

How to record expected vs actual income for a period

This is a backward-looking review you run once a period closes. The goal is one record per period that holds the expected total, the actual received total, the variance, and a short note explaining it. Keep the grain to a single period per record so each comparison stays clean.

  1. 1

    Create a period record

    Inside your Expected vs Actual Income folder, create one record per period, for example '2026-01 Expected vs Actual'. One record covers one closed period, no rolling multi-period totals here.

  2. 2

    Enter what you expected

    Write the expected income figure you had set for this period and, if you want, list the sources it was built from (e.g. Retainer - Acme $2,000, Project balance - Bremner $1,500). This is the figure you are reviewing against, copied in from wherever you planned it.

  3. 3

    Enter what actually arrived

    Record the income you actually received in the period as your actual total. Pull the figure from your real deposits and payments for those dates, not from invoices that are still unpaid.

  4. 4

    Attach the proof for the actual column

    Attach the payment confirmations, remittance notes, or deposit slips that back up the actual figure to the record, so the received number is supported and not just typed in.

  5. 5

    Calculate and note the variance

    Subtract actual from expected to get the variance (e.g. expected $3,500, actual $3,000, variance -$500). Write a one-line reason: 'Bremner balance slipped to February' or 'Acme paid in full, on time'.

  6. 6

    File and review the closed record

    Lock the record into the period's folder and read it. The point is the review: you now have a written, proof-backed account of where the gap came from, ready to look at next to the following period.

Record structure

Fields to record per period

These are the metadata fields for a single expected-vs-actual period record. Keep them consistent across every period so the comparison reads the same way each time. Variance is something you calculate and type in yourself, Cash Workspace does not compute or forecast it for you.

Period
The single period this record covers, e.g. '2026-01' or 'Q1 2026'. One period per record.
Expected income
The income total you had set for the period, copied from wherever you planned it.
Expected sources (optional)
The line items the expected figure was built from, e.g. 'Retainer - Acme $2,000; Project balance - Bremner $1,500'.
Actual income received
The income you actually received during the period, taken from real deposits and payments.
Variance amount
Expected minus actual, entered by you, e.g. '-$500' (short) or '+$300' (over).
Variance reason
A one-line explanation, e.g. 'Bremner final balance slipped to next period' or 'extra ad-hoc job paid this period'.
Status
A simple label such as 'reviewed' or 'open question', so you know which periods you've already looked at.
Attached proof
The deposit slips, remittance notes, or payment confirmations supporting the actual figure.

Example setup

An example folder layout

Here is one way to lay out an Expected vs Actual Income folder for a freelancer reviewing income month by month. Each month is its own record, and the proofs for the actual column live attached inside.

Expected vs Actual Income / 2026

The year-level folder holding one record per closed period for fiscal year 2026, kept separate from your forward planning sheets.

2026-01 Expected vs Actual

Expected $3,500 (Acme retainer $2,000 + Bremner balance $1,500); Actual $2,000; Variance -$1,500; Reason: 'Bremner balance unpaid, slipped to Feb'; Status: reviewed. Attached: Acme remittance advice.

2026-02 Expected vs Actual

Expected $2,000 (Acme retainer); Actual $3,500; Variance +$1,500; Reason: 'Bremner Jan balance arrived this period'; Status: reviewed. Attached: Acme + Bremner deposit slips.

2026-03 Expected vs Actual

Expected $4,000 (Acme retainer $2,000 + Delaney project $2,000); Actual $4,000; Variance $0; Reason: 'all sources paid as expected'; Status: reviewed. Attached: two payment confirmations.

_template - period record

An empty copy of the period record with the field labels (period, expected, actual, variance, reason, status, proof) ready to clone for the next month.

Common mistakes

Common mistakes to avoid

  • Counting invoiced-but-unpaid amounts in the actual column. Actual means money received in the period, not money billed.
  • Letting one record span several periods. Keep one period per record so each comparison stays clean and reviewable.
  • Skipping the variance reason. The number alone tells you there was a gap; the one-line reason is what makes the record useful later.
  • Treating this as a forecast. It is a backward review of a closed period, not a prediction of the next one.
  • Filling in the expected figure after the period ends, from memory. Copy it from where you actually planned it so the comparison is honest.
  • Leaving the actual figure unsupported. Attach the deposit or remittance proof so the received number can be verified.

How it helps

How Cash Workspace helps

One record per period

Create a dedicated record for each closed period so the expected and actual figures for that period sit together in one place.

Attach the proof to the actual column

Attach deposit slips, remittance advice, or payment confirmations directly to the period record so the received figure is backed by evidence.

Fiscal-year folders

Group your period records under a fiscal-year folder, keeping each year's variance reviews organized and separate from forward planning sheets.

Reusable period template

Save an empty period record as a template with the variance fields already labeled, then clone it each period so every comparison is structured the same way.

Export for review or handoff

Export your period records when you want to review them offline or share the variance history as accountant-ready records.

FAQ

Frequently asked questions

Does Cash Workspace calculate the variance for me?
No. You enter the expected figure, the actual received figure, and the variance you calculated yourself. Cash Workspace organizes the record and stores the attached proof; it does not compute, forecast, or project any numbers.
How is this different from an income-by-month summary?
An income-by-month summary compares your actual income levels across several months. This page compares two numbers within one period, what you expected versus what you received, and notes the gap. One is month-over-month levels; this is per-period variance.
Where does the expected number come from?
From wherever you planned it, such as a forward expected-income list or a planning organizer. You copy that figure into the period record as the 'expected' value, then fill in the 'actual' once the period closes.
Should I count invoices I sent but haven't been paid for yet?
Not in the actual column. Actual income means money you actually received during the period. An unpaid invoice belongs in your expected figure or a forward list, not the received total.
Is this a way to predict next period's income?
No. This is a backward-looking review of a closed period. It organizes what you expected against what arrived so you can review the gap. It does not predict or guarantee future income.

What this page does and does not do

This is organizational guidance, not financial, tax, or accounting advice. Cash Workspace helps you record an expected income figure next to an actual received figure for the same period and attach the proof behind it. It does not sync with your bank, does not read or extract figures from your documents, and does not calculate, forecast, or project variance, you enter every number yourself. The expected figure is whatever you chose to plan; the actual figure should reflect money you genuinely received. Use these records to review your own income, not as a prediction of future results.

Start your free workspace

Open a free Cash Workspace and create your first Expected vs Actual Income folder. Add one record per period, type in the expected and actual figures, attach the deposit proofs, and note the variance, so the gap is reviewed on the page instead of guessed at later. It's free to start.