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.
Cashflow organization / Income variance
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
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 review workflow
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.
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.
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.
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.
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.
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'.
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
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.
Example setup
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.
The year-level folder holding one record per closed period for fiscal year 2026, kept separate from your forward planning sheets.
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.
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.
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.
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
How it helps
Create a dedicated record for each closed period so the expected and actual figures for that period sit together in one place.
Attach deposit slips, remittance advice, or payment confirmations directly to the period record so the received figure is backed by evidence.
Group your period records under a fiscal-year folder, keeping each year's variance reviews organized and separate from forward planning sheets.
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 your period records when you want to review them offline or share the variance history as accountant-ready records.
Related
Compare income levels month over month across the year, where this variance page compares one period's expectation to its actual, the month summary tracks the actual levels themselves side by side.
The forward list of money you expect to arrive soon, this is where the expected figure you later review against often comes from.
Lay expected inflows beside expected outflows for the coming weeks, a forward-planning view that feeds the expected side of these variance records.
A year-end folder pairing total income against total expenses for review, the annual companion to your per-period variance records.
A ready-made starting structure for organizing your cash records, useful when you are setting up the folders that hold these period reviews.
Track invoice statuses and expenses in one place, the underlying records that tell you what income actually came in for the actual column.
FAQ
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.
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.