{"id":12901,"date":"2026-09-19T08:26:34","date_gmt":"2026-09-19T08:26:34","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=12901"},"modified":"2026-11-18T06:48:43","modified_gmt":"2026-11-18T06:48:43","slug":"budget-and-money-planner-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/zh\/product\/budget-and-money-planner-spreadsheet\/","title":{"rendered":"Budget &#038; Money Planner Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 Every dollar, one year at a glance<\/span><\/p>\n<h2 id=\"a-yearly-budget-spreadsheet-with-paychecks-bills-debt-payoff-and-net-worth-in-one-file\">A yearly budget spreadsheet with paychecks, bills, debt payoff and net worth in one file<\/h2>\n<p>The Budget &amp; Money Planner is for households that budget by the paycheck and want the year to add up, not just the month. On Settings, name your income sources and your spending categories, each in a group (needs, wants, savings or debt) with a monthly plan. That plan starts every month; type over it on one month&#8217;s tab when that month is different.<\/p>\n<h3>Twelve months, one list each<\/h3>\n<p>Each month has its own tab. Log money on the right as it comes and goes, the date, what it was, a category and the amount, income and spending in the same list. The left side shows each category&#8217;s plan against what you spent, what each paycheck brought in and paid for, and the four groups, needs, wants, savings and debt, each as a share of the income that came in that month: the numbers to hold against the 50\/30\/20 rule or a split of your own. The Year tab adds all twelve up, earned, spent and kept, and nothing on it is typed.<\/p>\n<h3>Set up once, then they run<\/h3>\n<ul>\n<li><strong>Paychecks<\/strong>: every payday of the year from one date, with the bills that fall before the next check and what is left to spend.<\/li>\n<li><strong>Bills<\/strong>: a paid grid for all twelve months and a calendar that turns green as they are paid.<\/li>\n<li><strong>Debt Payoff<\/strong>: snowball and avalanche side by side, with the debt-free date, the interest each costs and the order to pay.<\/li>\n<li><strong>Sinking Funds and Savings Goals<\/strong>: what to put aside each month for the once-a-year bills and each target. A new goal shows up in every month&#8217;s plan.<\/li>\n<li><strong>Net Worth<\/strong>: what you own and owe, month by month, with a chart.<\/li>\n<\/ul>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A whole year of money in one spreadsheet: monthly budgets by paycheck, bills that turn green as they are paid, snowball and avalanche debt payoff side by side, sinking funds, savings goals and net worth.<\/p>\n","protected":false},"featured_media":17030,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Budget Spreadsheet for Google Sheets and Excel | Templacity","rank_math_description":"A yearly budget spreadsheet for Google Sheets and Excel: paycheck budgets, bill tracker, debt payoff, sinking funds, savings goals and net worth.","rank_math_seo_score":"10","_templacity_copy_live":"1","_templacity_faq":[{"q":"Snowball or avalanche?","a":"Both, worked out side by side on Debt Payoff: the debt-free date, the interest each method costs and the order to pay. Pick the one you follow."},{"q":"Can I budget by paycheck?","a":"Yes. Paychecks lists every payday of the year from your first one, with the bills due before the next check and what is left. Each month shows what each paycheck brought in and what it paid for."},{"q":"Can I use it for a 50\/30\/20 budget?","a":"Yes. Every spending category belongs to a group, needs, wants, savings or debt, and each month shows what each group took as a share of your income, so you can hold the month against 50\/30\/20 or a split of your own. The planner shows the shares; it does not set a target for each group."},{"q":"Which year is it for?","a":"It follows today's date. The Year cell on Settings is the only place a year lives: type next year to plan early, or last year to look back."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-12901","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product\/12901","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/comments?post=12901"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media\/17030"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/media?parent=12901"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/niche?post=12901"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/template_type?post=12901"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/templacity_topic?post=12901"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_brand?post=12901"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_cat?post=12901"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/zh\/wp-json\/wp\/v2\/product_tag?post=12901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}