Formula Library
Budgeting Formulas
Formulas for tracking expenses, calculating budget allocations, and analyzing spending patterns.
50/30/20 Budget Allocation
beginnerCalculate how much to allocate to needs, wants, and savings based on the popular 50/30/20 budgeting rule.
=income * 0.50 (needs), =income * 0.30 (wants), =income * 0.20 (savings) Budget Variance
beginnerCalculate the difference between planned budget and actual spending to see if you're over or under budget.
=planned_amount - actual_amount Sum Expenses by Category
beginnerAdd up all transactions that match a specific category, like "Groceries" or "Entertainment".
=SUMIF(category_range, "Category Name", amount_range)