Budget Variance Calculator · Calculation guide

Compare actual income and spending with your budget.

Calculation guide

For people checking a money question using their own amounts and assumptions.

Use a consistent monthly basis except where a different period is explicitly entered. Allocation percentages must total 100%; rounded shares reconcile to the total. Ratios and reserve targets are editable assumptions rather than recommendations. A sinking fund must cover the earliest due date, not just an annual average. Runway reports no depletion under the assumptions when cash does not decline.

V_income=A−P; V_expense=P−A

Inputs

Planned

Budgeted amount for this row and period.

Actual

Actual amount received or spent for the same row and period.

Cash type

Choose income or expense; this determines the sign used in totals and budget variance.

Worked example

Budget items

PlannedActualCash type
10,0009,000Expense
50,00052,000Income

Formula:

V_income=A−P; V_expense=P−A

Favorable variance = 3000.00000000000

ResultValue
Favorable variance3,000
Item 11,000
Item 22,000

Interpreting the result

Income above budget plus expenses below budget; a negative total is unfavorable.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Planned (row 1)10,00011,000Favorable variance3,0004,000
Actual (row 1)9,0009,900Favorable variance3,0002,100
Cash type (row 1)ExpenseIncomeFavorable variance3,0001,000
Budget Variance Calculator →