Variable Income Budget Spreadsheet
Spreadsheet Template · Portfolio Video
About this work
This video showcases a digital budget spreadsheet designed for managing variable income. It demonstrates two primary methods: the 50/50 Pay method, which splits income between bills and savings, and the Variable Income Split method, allowing users to allocate income based on percentages. The spreadsheet automatically calculates totals and tracks savings goals, offering a visual representation of progress.
Read the transcript
Variable Income Budget Spreadsheet Split & Save Plan 50/50 Pay Method Variable Income Split Best for two main pay periods. Enter your monthly expenses. The planner divides them by two, reserves that amount for bills and shows what is left for savings. Bills covered first remainder split into savings. Best for variable income. Enter any payment. The planner uses your personal percentages to divide it between bills, savings and flexible. Every payment automatically divided by percentage. Then follow three simple steps. Enter only numbers. Formulas calculate everything automatically. Make the transfers. Use the results as your payday checklist. Customize your categories. Track savings goals. Use again each payday. See the 50/50 method in action. Enter your payments. See the exactly what can move to savings. Monthly expenses. Phone/internet. Insurance. Utilities. Transportation. Gifts. Child / Dance costs. Subscriptions. Extra expenses. Savings. Bills / Checking. Personal. Total expenses monthly. $2,107.00. This pay. Repay checking. Savings. Long-term savings. Unassigned check. $0.00. $4,200 monthly expenses $2,100 kept 100% $2,000. $2,100 split $690.00. For variable income. Enter any payment and divide it using percentages that match your real budget. Payment received. $2,400.00. Allocation goal. 100%. Your personal split. Category. Percentage. Move. Account. Bills/checking. 50%. $1,320.00. Expenses. Emergency fund. 10%. $240.00. Dance savings. Activities. 10%. $240.00. Savings. Travel. 10%. $240.00. Rename this goal. Long-term savings. 10%. $240.00. Home/Car. 10%. $240.00. Total. 100%. $2,400.00. Your percentages adjust them total. If they're your income. That account. Watch every amount. Goal grow. Balances, amounts needed and progress bars update automatically. Sample numbers. Automatic totals. Savings goals tracker. Savings goal. Target. Still needed. % complete. Emergency. $2,500.00. $2,350.00. 94%. Annuals activities. $1,800.00. $1,425.00. 79%. Travel. $1,000.00. $4,000.00. $2,550.00. 38%. Long-term savings. $3,825.00. $6,000.00. $2,175.00. 36%. Home/Car. $350.00. $1,000.00. $650.00. 35%. See the balance, target, amount remaining and percentage complete at a glance.
Created by