Personal Budget Spreadsheet
Best Body · Best Life Personal Budget Spreadsheet for Excel and Google Sheets
Take control of your money with one clean, connected spreadsheet. Set your budget once, log your income and spending, and the dashboard, monthly budget and annual summary update automatically. It works for anyone: singles, couples, families, students and freelancers.
★ INSTANT DOWNLOAD: 1 Excel file (.xlsx) + 1 Access & Instructions PDF
★ WORKS IN: Microsoft Excel 2016 or newer, Microsoft 365, Excel for the web and Google Sheets (free)
★ NO MACROS: just working formulas, dropdowns and charts
━━━━━━━━━━━━━━━━━━
WHAT'S INSIDE: 9 CONNECTED TABS
━━━━━━━━━━━━━━━━━━
1. Start Here: a quick-start guide with links to every tab
2. Dashboard: pick a month to see income, spending, net savings and savings rate, plus year-to-date totals, a spending pie chart, a planned vs actual chart, an income vs spending by month chart and an over/under status for every category
3. Settings & Categories: choose your currency symbol, start month and year, and edit up to 10 income categories, 25 expense categories (each with a monthly budget) and your payment methods
4. Monthly Budget: 12 months of Planned, Actual and Difference for every category, with green (under budget) and red (over budget) highlighting, totals, net savings and savings rate
5. Expense Tracker: 1,000 rows for date, description, category (dropdown), amount, payment method (dropdown) and notes
6. Income Tracker: 1,000 rows for paychecks, side income, bonuses, interest and more
7. Savings Goals: up to 15 goals with target, amount saved, progress bars, months left and how much to save per month
8. Debt Payoff: up to 12 debts with interest this month, months to payoff, estimated payoff date, estimated total interest, plus avalanche and snowball order
9. Annual Summary: month-by-month and category-by-category totals, a yearly chart and a built-in data check
━━━━━━━━━━━━━━━━━━
FEATURES
━━━━━━━━━━━━━━━━━━
• Fully automatic: trackers feed the monthly actuals, which feed the dashboard and annual summary
• Start your budget year in any month
• Rename the categories to fit your life, and every tab and dropdown updates
• Frozen headers, filters on the trackers and print-ready layouts
• Light-yellow input cells on the setup and planning tabs, so it's clear where to type
• Light sample data, clearly labeled SAMPLE, so you can see how it works. Clear it in seconds before you start.
━━━━━━━━━━━━━━━━━━
HOW IT WORKS
━━━━━━━━━━━━━━━━━━
1. Purchase the listing.
2. Download both files from your Etsy Purchases page (You › Purchases and reviews) or from the link in your confirmation email. A computer is easiest.
3. Excel: open the .xlsx file and click Enable Editing if asked.
Google Sheets: upload the .xlsx file to Google Drive, right-click it and choose Open with › Google Sheets, then File › Save as Google Sheets.
4. Follow the Start Here tab or the instructions PDF. Setup takes about 10 minutes.
Google Sheets note: formulas, dropdowns and charts carry over. Colored data bars show as plain percentages, and charts may look slightly different. The text progress bars on Savings Goals still work.
━━━━━━━━━━━━━━━━━━
PLEASE NOTE
━━━━━━━━━━━━━━━━━━
• DIGITAL DOWNLOAD. No physical item will be shipped.
• NO REFUNDS. Because files are delivered instantly, all sales are final. If anything isn't working, please send me a message and I'll be happy to help.
• PERSONAL USE ONLY. One purchase is for your own use. Please don't share, resell or redistribute the file.
• NOT FINANCIAL ADVICE. This spreadsheet is an organization tool for general educational purposes only. It isn't financial, tax, investment or legal advice, and estimates such as debt payoff dates are approximate. Talk with a qualified professional about your situation.
• Amounts show your chosen currency symbol in the headers, and numbers use your computer's number format.
• Apple Numbers isn't officially supported. Please use Excel or Google Sheets.
• Listing images show sample data. Your file includes the same sample rows, ready to clear.
© Silver Division L.L.C. · Best Body · Best Life · bestbodybestlife.com. All rights reserved.