[et_pb_section fb_built=”1″ admin_label=”section” module_class=”sheetgo-post” _builder_version=”4.22.2″ _module_preset=”default” da_disable_devices=”off|off|off” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on”][et_pb_row _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Understanding and managing your money is important in both business and personal life. One useful tool for this is budget vs actual analysis. In this guide we explain what budget vs actual means for a business, how to calculate budget variance, the types of variance you will run into, what to do when your plan and your results don’t match up, and the reports that pair well with a budget. We also hand you a free Budget vs actual template from Sheetgo: one Google Sheets file you copy to your own Drive, with no Sheetgo account needed. Plus, we’ll keep it simple and give you practical advice without using confusing words.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”What is” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Budget vs actual is a straightforward financial analysis method that helps you compare what you planned (the budget) with what actually happened (the actuals). The gap between the two is called the variance, and it’s what turns a budget from a wish list into a management tool.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/11\/budget-vs-actual-stock-scaled.webp” alt=”budget vs actual stock” title_text=”budget-vs-actual-stock” show_bottom_space=”off” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Get the free Budget vs actual template<\/a><\/p>\n [\/et_pb_text][et_pb_divider show_divider=”off” _builder_version=”4.22.2″ _module_preset=”default” custom_margin=”15px||15px||false|false” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_divider][et_pb_text module_id=”how to” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Step 1<\/strong>: Collect your data<\/p>\n Put your budgeted figures and your actual figures side by side in a spreadsheet, split into income and expenses. Use the same category names on both sides, otherwise you have nothing to compare.<\/p>\n Step 2<\/strong>: Use the variance formula<\/p>\n Variance = actual amount \u2212 budgeted amount. Work it out line by line, not just on the bottom line: a total that looks healthy often hides one category that is badly off. It also helps to express the gap as a percentage of the budgeted figure, so a $500 miss on a $1,000 line doesn’t get lost next to a $500 miss on a $50,000 one.<\/p>\n Step 3<\/strong>: Read the sign in context<\/p>\n The same arithmetic means opposite things on either side of the sheet. On income, an actual figure above budget is favorable. On expenses, an actual figure above budget is unfavorable. So label every line favorable or unfavorable before you draw any conclusion from it.<\/p>\n In the free template further down this page, the Budget Analysis<\/strong>, Income Analysis<\/strong> and Expenses Analysis<\/strong> tabs run this comparison for you: forecast next to actual, with the under\/over amount and the variation %.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what are” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Budget variances can be grouped into three types:<\/p>\n Favorable (good news) variance:<\/strong><\/p>\n Occurs when actual revenues are higher than budgeted, or actual expenses are lower than budgeted.<\/p>\n Unfavorable (not-so-good) variance:<\/strong><\/p>\n Happens when actual revenues fall short of budgeted amounts, or actual expenses exceed the budgeted figures.<\/p>\n Revenue variance:<\/strong><\/p>\n This focuses on the difference between what you expected to earn and what you actually earned. It’s worth keeping it separate from the cost side, because the two are usually driven by completely different things: the template gives each its own tab.<\/p>\n [\/et_pb_text][et_pb_text module_id=”what do” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Fixing differences between your budget and actuals involves:<\/p>\n Example:<\/em><\/strong> If marketing expenses exceed the budget, delve into specific campaigns, evaluating their success and any unforeseen costs contributing to the variance. Adjust future budgets to accommodate the successful campaign’s impact. Strengthen controls in the marketing department by setting spending limits, requiring pre-approval for large expenses, and enhancing transparency in financial processes. This proactive approach not only resolves immediate issues but also fortifies your financial framework against potential variances in the future.<\/p>\n For the full method, with the formula and a worked example in Google Sheets, read our guide to budget variance analysis<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”reports” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Boost the power of your budget vs actual analysis with these extra reports:<\/p>\n [\/et_pb_text][et_pb_text module_id=”free budget” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To make budgeting easier, Sheetgo publishes a free Budget vs actual template for Google Sheets. It’s a single spreadsheet file: you copy it to your own Drive and it’s yours to edit. Nothing to connect, nothing to set up, and no Sheetgo account needed.<\/p>\n Here’s what you get inside the file:<\/p>\n There’s also a Read me<\/strong> tab you can go back to whenever you need a reminder of how the file fits together.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click the button below, then click Make a copy<\/strong> to save your own free Budget vs actual template in Google Sheets by Sheetgo.<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/docs.google.com\/spreadsheets\/d\/1FVG_5SSl3Ik6jYJlRGDhv4Z6OKk76FL9JmDOAXAx0y4\/copy” url_new_window=”on” button_text=”Get the free template” button_alignment=”center” _builder_version=”4.27.7″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#FFFFFF” button_bg_color=”#2979FF” button_border_width=”0px” button_border_color=”#2979FF” button_border_radius=”6px” button_font=”|600|||||||” button_use_icon=”off” custom_padding=”15px|20px|15px|20px|true|false” hover_enabled=”0″ global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_text_color__hover_enabled=”on|desktop” button_border_color__hover_enabled=”on|hover” button_border_color__hover=”#2666E2″ button_text_color__hover=”#FFFFFF” button_bg_color__hover=”#2666E2″ button_bg_enable_color__hover=”on” theme_builder_area=”post_content” custom_margin=”30px||30px||true|false” sticky_enabled=”0″][\/et_pb_button][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Open the Inputs<\/strong> tab and set Year to analyze<\/strong> to the year you’re reporting on. The analysis tabs use that year to lay out their monthly columns, so it’s worth getting right before you type anything else.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/budget-vs-actual-inputs-2.png” alt=”Inputs tab of the budget vs actual template in Google Sheets, showing the year to analyze” title_text=”Budget vs actual template Inputs tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Go to Income Forecast<\/strong> and fill in the income you expect, month by month. The column headers are your income categories, so rename them to whatever you actually sell. Then do the same in Expenses Forecast<\/strong> for the money you plan to spend. Together, these two tabs are the budget half of the comparison.<\/p>\n The file arrives with sample figures in it so you can see how everything behaves. Delete the sample rows before you start entering your own.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/budget-vs-actual-income-forecast-2.png” alt=”Budget vs actual template Income Forecast tab with planned income per month and category” title_text=”Budget vs actual template Income Forecast tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Income Actual<\/strong> is a running log rather than a grid: one row per invoice, with the client, invoice number, amount, date and category. Expenses Actual<\/strong> works the same way for money going out. Use the same category names you used in the Forecast tabs, otherwise the analysis has nothing to line your actuals up against.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/budget-vs-actual-income-actual-2.png” alt=”Budget vs actual template Income Actual tab logging invoices by client and category” title_text=”Budget vs actual template Income Actual tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Budget Analysis<\/strong> tab updates as you enter data. It puts your actual operating profit against the expected figure, your actual income against the forecast, and your actual expenses against the budget, for every month of the year plus a year-to-date column. This is the view to open first: it tells you which side of the business the problem is on.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/budget-vs-actual-analysis-2.png” alt=”Budget vs actual template Budget Analysis tab comparing actual and expected figures month by month” title_text=”Budget vs actual template Budget Analysis tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once you know where the gap is, Income Analysis<\/strong> shows you why. Every income category gets a forecast column and an actual column for each month, with the under\/over amount, the variation % and a year-end total. Expenses Analysis<\/strong> does the same for your costs. This is where a variance stops being a number and turns into something you can act on: one client who paid late, one category you consistently underestimate.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/08\/budget-vs-actual-income-analysis-2.png” alt=”Budget vs actual template Income Analysis tab showing forecast versus actual and variation percentage” title_text=”Budget vs actual template Income Analysis tab” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n That’s the whole loop: your plan in the Forecast tabs, reality in the Actual tabs, and the variances calculated for you in the Analysis tabs.<\/p>\n [\/et_pb_text][et_pb_text module_id=”faqs” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Q: Why is budget vs actual analysis important?<\/strong> Q: How often should I do budget vs actual analysis?<\/strong> Q: Can I use budget vs actual analysis for my personal finances?<\/strong> In summary, understanding and analyzing the differences between your budget and actual results is crucial for managing your finances effectively. This blog post has given you practical insights, whether you’re new to spreadsheets or have some experience. Use this knowledge to make informed financial decisions and find success in your financial endeavors.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][difl_faq faq_item_gap=”25px” enable_schema=”on” close_icon_color=”#82afff” close_icon_size=”28px” open_icon_color=”#82afff” faq_anime_duration=”200″ faq_item_wrapper_bg_bgcolor=”#FFFFFF” que_text_margin=”10px|20px|10px|20px|true|true” ans_text_padding=”0px|20px|10px|20px|false|true” _builder_version=”4.27.6″ _module_preset=”default” question_text_font=”|600|||||||” question_text_font_size=”19px” design_answer_text_font=”|300|||||||” design_answer_text_font_size=”16px” design_answer_text_line_height=”1.6em” border_radii_faq_item_wrapper_border=”on|12px|12px|12px|12px” border_color_all_faq_item_wrapper_border=”#deeaf7″ global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”][difl_faqitem question=”Is the budget vs actual template free?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”]<\/p>\n Yes. It is a Google Sheets file you copy to your own Drive and keep. There is nothing to install and no account to create.<\/p>\n [\/difl_faqitem][difl_faqitem question=”Where do I see the variance?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”]<\/p>\n On the analysis tabs. Once you have filled in the forecast and actual tabs for the year you set in Inputs, those tabs show each line against plan.<\/p>\n [\/difl_faqitem][difl_faqitem question=”Can it flag variances for me automatically?” question_title_tag=”h3″ _builder_version=”4.27.6″ _module_preset=”default” global_colors_info=”{}” que_wrapper_bg_bgcolor__hover=”1px||||false|false” que_wrapper_bg_bgcolor__hover_enabled=”on|hover” theme_builder_area=”post_content”]<\/p>\n The spreadsheet shows you the numbers, but it does not send anything. Alerts and follow-ups are what Sheetgo’s finance virtual employee handles.<\/p>\n [\/difl_faqitem][\/difl_faq][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Understanding and managing your money is important in both business and personal life. One useful tool for this is budget vs actual analysis. In this guide we explain what budget vs actual means for a business, how to calculate budget variance, the types of variance you will run into, what to do when your plan […]<\/p>\n","protected":false},"author":44,"featured_media":41831,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[36],"tags":[],"class_list":["post-46549","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-finance-processes"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/46549","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/44"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=46549"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/46549\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/41831"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=46549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=46549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=46549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}How to calculate budget variance?<\/h2>\n
What are the types of budget variance?<\/h2>\n
What do you do when your budget and actuals don’t line up?<\/h2>\n
\n
Reports that complement budgets vs actuals<\/h2>\n
\n
This shows how much money is actually available to your business, month by month. That guide comes with its own free Google Sheets template.<\/li>\n
A detailed overview of how well your business is doing financially over a period. That guide comes with its own free Google Sheets template too.<\/li>\n<\/ul>\nFree budget vs actual template from Sheetgo<\/h2>\n
\n
How to get the Budget vs actual template<\/h3>\n
Get started<\/h3>\n
Step 1: Set the year you’re analyzing<\/h4>\n
Step 2: Enter your budget in the Forecast tabs<\/h4>\n
Step 3: Log what actually happened in the Actual tabs<\/h4>\n
Step 4: Read the headline variances in Budget Analysis<\/h4>\n
Step 5: Drill into the detail<\/h4>\n
FAQs (Frequently asked questions)<\/h2>\n
A: It helps you see how well you’re doing financially and makes it easier to decide what to do next.<\/p>\n
A: It’s a good idea to check every month or every few months, depending on how often you want to keep an eye on things.<\/p>\n
A: Absolutely! You can apply the same ideas to manage your personal finances and see where your money is going.<\/p>\nFrequently asked questions<\/h2>\n