Budget vs Actual Dashboard Template

Monthly budget and actual spending by department and expense category, with the variance that shows who is over or under budget.

See who is over or under budget at a glance. The template builds six KPI numbers, four charts, a monthly spending table and two filters from 200 rows of budget data.

  • 6 KPI numbers
  • 4 charts
  • 2 filters
  • 200 sample rows

Budget vs Actual Dashboard

Expense Category: AllDepartment: AllBudget vs Actual DashboardTotal Budget$5.57MTotal of BudgetActual Spending$5.7MTotal of ActualBudget Variance-$132.7KTotal of VarianceBudget This Mo…$567K0% vs last monthSpending This…$581.8K▼ 2.6% vs last monthVariance This…-$14.8K▲ 51.6% vs last monthMonthly Actual SpendingJanFebMarAprMayJunJulAugSepOctSpending by Expense CategoryPayroll76%Software10%Facilities9%Travel5%Budget Variance by DepartmentSalesMarketingEngineeringOperationsFinance & AdminActual Spending by DepartmentPayrollSoftwareTravelFacilitiesEngineeringSalesOperationsMarketingFinance & AdminMonthly SpendingMonthDepartmentExpense CategoryBudgetActualVariance2026-01-01EngineeringPayroll$168,000$174,074.61-$6,074.612026-01-01EngineeringSoftware$21,000$23,869.15-$2,869.152026-01-01EngineeringTravel$4,000$3,845.60$154.402026-01-01EngineeringFacilities$12,000$12,293.37-$293.372026-01-01SalesPayroll$96,000$98,987.95-$2,987.952026-01-01SalesSoftware$9,000$10,007.69-$1,007.692026-01-01SalesTravel$14,000$13,704.62$295.382026-01-01SalesFacilities$7,000$6,961.38$38.62About this dashboardMonthly budget and actual spending for fivedepartments and four expense categories from Januaryto October 2026. Actual spending came to $5,703,749against a budget of $5,571,060, which is $132,689over budget. Variance is budget minus actual, so anegative number means the department spent more thanplanned. Sales has the largest overspend.•Use the Department and Expense Category filters atthe top to narrow every widget.•Switch to Sheets to edit the sample months orpaste in your own budget report.

About this template

What the budget vs actual dashboard shows

The sample tracks five departments and four expense categories from January to October 2026. Actual spending came to $5,703,749 against a budget of $5,571,060, which leaves the company $132,689 over budget.

Variance is budget minus actual, so a negative number means a department spent more than planned. Sales has the largest overspend at $77,641, followed by Marketing and Engineering, while Finance and Admin came in $27,006 under budget. Payroll makes up about three quarters of all spending.

The first row of KPIs covers the whole year to date and the second row covers the latest month, so October spending of $581,818 sits right next to its $567,015 budget. The Department and Expense Category filters narrow every widget.

What's included

Every widget on the budget vs actual dashboard

The numbers below are what each widget shows for the sample data. Replace the rows with your own and they update to match.

KPI numbers

Total Budget

$5.57M

Total of Budget

Actual Spending

$5.7M

Total of Actual

Budget Variance

-$132.7K

Total of Variance

Budget This Month

$567K

0% vs last month

Total of Budget, compared with last month

Spending This Month

$581.8K

Down 2.6% vs last month

Total of Actual, compared with last month

Variance This Month

-$14.8K

Up 51.6% vs last month

Total of Variance, compared with last month

Charts

Area Chart

Monthly Actual Spending

Total spending across every department, by month

Pie Chart

Spending by Expense Category

Share of actual spending

Horizontal Bar Chart

Budget Variance by Department

Budget minus actual, below zero is over budget

Stacked Bar Chart

Actual Spending by Department

Split by expense category

Filters

The Department and Expense Category filters sit in the dashboard header. Picking a value narrows every KPI, chart and table on the page.

Data table and notes

The Monthly Spending table lists every row of the sample sheet, and a text widget explains what the dashboard shows and how to use the filters.

Sample data

Sample data for the budget vs actual dashboard

The template loads 200 rows into a sheet named Department Spending. Keep the same columns, replace the rows with your own data, and the whole dashboard updates.

Month

Date

Used in Budget This Month, Spending This Month, Variance This Month, Monthly Actual Spending

Department

Text

Used in Budget Variance by Department, Actual Spending by Department, Filter: Department

Expense Category

Text

Used in Spending by Expense Category, Actual Spending by Department, Filter: Expense Category

Budget

Currency

Used in Total Budget, Budget This Month

Actual

Currency

Used in Actual Spending, Spending This Month, Monthly Actual Spending, Spending by Expense Category, Actual Spending by Department

Variance

Currency

Used in Budget Variance, Variance This Month, Budget Variance by Department

The first 10 rows of sample data for the Budget vs Actual Dashboard template
MonthDepartmentExpense CategoryBudgetActualVariance
2026-01-01EngineeringPayroll$168,000$174,074.61-$6,074.61
2026-01-01EngineeringSoftware$21,000$23,869.15-$2,869.15
2026-01-01EngineeringTravel$4,000$3,845.60$154.40
2026-01-01EngineeringFacilities$12,000$12,293.37-$293.37
2026-01-01SalesPayroll$96,000$98,987.95-$2,987.95
2026-01-01SalesSoftware$9,000$10,007.69-$1,007.69
2026-01-01SalesTravel$14,000$13,704.62$295.38
2026-01-01SalesFacilities$7,000$6,961.38$38.62
2026-01-01MarketingPayroll$52,000$54,039.24-$2,039.24
2026-01-01MarketingSoftware$11,000$11,618.54-$618.54

Showing the first 10 of 200 rows.

How to use it

How to build the budget vs actual dashboard

  1. 1

    Click Use this Template

    Log in, or create a free InstaCharts account with your email or Google account.

  2. 2

    Get the finished dashboard

    InstaCharts adds the sample sheet to your workspace and builds every KPI, chart, table and filter in the Financial Light theme.

  3. 3

    Swap in your data

    Switch to Sheets to paste in your own rows or update the sheet from a CSV or Excel file with the same columns.

  4. 4

    Make it yours

    Pick another theme in Dashboard Settings, move or resize widgets, and add more charts, KPIs or text.

Tips for adapting the budget vs actual dashboard

  • Export budget and actual amounts from your accounting system or planning spreadsheet with one row per month, department and expense category.
  • Work out Variance as budget minus actual in your spreadsheet before you import it, so a negative value always means overspending.
  • Keep the amounts as currency values so the KPIs abbreviate large totals, such as $5.57M.
  • Add new months as new rows, and the This Month KPIs move to the latest month in your data.

FAQ

Budget vs Actual Dashboard template FAQ

What is a budget vs actual dashboard?

A budget vs actual dashboard compares planned spending with real spending, usually by month and by department. The variance between the two shows where spending ran over or under the plan.

Can I use this template for revenue as well as expenses?

Yes. Replace the expense rows with revenue lines and their targets. The KPIs, variance chart and filters work the same way for a revenue plan.

Is this dashboard template free?

Yes. Click Use this Template and sign up for a free InstaCharts account, or log in. The budget vs actual dashboard is built in your workspace with its sample sheet, widgets and filters. Inside the app, the template is also under New, New Dashboard, Start from a Template.

How do I replace the sample data with my own?

Switch to Sheets in the dashboard toolbar to open the sample sheet. Paste in your own rows or update the sheet from a CSV or Excel file with the same columns, and every chart, KPI and data table on the dashboard updates to match.

Can I change the theme and layout?

Yes. Open Dashboard Settings to pick another theme or customize the header, page and chart colors. Widgets can be moved, resized, duplicated or deleted, and you can add more charts, KPIs, tables and text.

Learn how dashboards work on the dashboard maker page, or read the guide on how to create a dashboard.

More templates

More dashboard templates

Product Category: AllRegion: AllSales Performance DashboardTotal Revenue$909.6KTotal of RevenueRevenue This Month$103.3K▼ 3.9% vs last monthOrders266Unique count of Order IDAverage Order Value$3,419.46Average of RevenueMonthly RevenueJanFebMarAprMayJunJulAugSepOctRevenue by RegionEast34%North27%West21%South18%Units Sold by Product CategoryTrainingSoftwareHardwareServicesRevenue by Sales RepMia JohnsonEthan BrooksAva ThompsonSofia GarciaLiam PatelOlivia ChenLucas RiveraNoah KimMonthly Profit by Product CategorySoftwareTrainingHardwareServicesJanFebMarAprMayJunJulAugSepOctProfit by RegionEastNorthWestSouthOrdersOrder DateOrder IDRegionSales RepProduct Cate…UnitsRevenueProfit2026-01-03SO-10001SouthSofia GarciaSoftware5$2,352.20$1,520.752026-01-05SO-10002SouthNoah KimTraining17$2,677.68$1,134.782026-01-06SO-10003EastEthan BrooksHardware5$1,309.96$314.672026-01-07SO-10004EastMia JohnsonSoftware4$1,779.54$992.542026-01-08SO-10005NorthLiam PatelSoftware9$4,249.41$2,715.242026-01-09SO-10006NorthAva ThompsonHardware2$486.93$132.092026-01-09SO-10007WestLucas RiveraTraining20$3,521.51$1,571.472026-01-12SO-10008WestOlivia ChenSoftware8$4,103.75$2,525.59About this dashboard266 sample orders from January to October 2026, with$909,576 in revenue across four regions, eight salesreps and four product categories. East is thelargest region and Software brings in the mostrevenue. Each row is one order with its units,revenue and profit.•Use the Region and Product Category filters at thetop to narrow every widget.•Switch to Sheets to edit the sample orders orpaste in your own sales data.

Sales Performance Dashboard

Revenue, orders and profit by month, region, sales rep and product category, with region and category filters.

  • 4 KPIs
  • 6 charts
  • 2 filters
View template
Campaign: AllChannel: AllMarketing Campaign DashboardTotal Spend$119.5KTotal of SpendTotal Clicks79,134Total of ClicksTotal Leads6,239Total of LeadsConversions Last 30 Days280▲ 18.1% vs previous 30 daysWeekly Leads by ChannelSearch AdsSocial AdsEmailDisplayApr 6Apr 27May 18Jun 8Jun 29Jul 20Aug 10Aug 31Sep 21Spend by ChannelSearch Ads48%Social Ads34%Display14%Email4%Clicks by ChannelSearch AdsEmailSocial AdsDisplayConversions by CampaignBrand SearchMonthly NewsletterOnboarding SeriesRetargetingCompetitor KeywordsSpring Product LaunchSummer AwarenessMonthly ImpressionsAprMayJunJulAugSepMonthly Spend by ChannelSearch AdsSocial AdsEmailDisplayAprMayJunJulAugSepWeekly Campaign ResultsWeekChannelCampaignImpressionsClicksSpendLeadsConversions2026-04-06Search AdsBrand Search9754649$951.5071182026-04-06Social AdsSpring Produ…60838657$1,607.123232026-04-06EmailMonthly News…14785461$87.963372026-04-13Search AdsBrand Search9128806$1,145.7884202026-04-13Social AdsSpring Produ…67447768$2,016.994162026-04-13EmailMonthly News…15588517$87.3436102026-04-20Search AdsBrand Search9534654$1,040.8784192026-04-20Social AdsSpring Produ…63522876$1,741.46568About this dashboardWeekly results for seven campaigns across search,social, email and display ads from April toSeptember 2026. The campaigns spent $119,497 andbrought in 6,239 leads and 1,453 conversions, withSearch Ads producing the most leads.•Use the Channel and Campaign filters at the top tonarrow every widget.•Switch to Sheets to edit the sample weeks or pastein an export from your ad platforms.

Marketing Campaign Dashboard

Weekly spend, clicks, leads and conversions for search, social, email and display campaigns, with channel and campaign filters.

  • 4 KPIs
  • 6 charts
  • 2 filters
View template
Location: AllDepartment: AllHR Workforce DashboardHeadcount152Count of Employee IDHires This Year36▲ 33.3% vs last yearAverage Salary$81,845.39Average of Annual SalaryAverage Performance Rating3.55 / 5Average of Performance RatingHeadcount by DepartmentRemoteNew YorkAustinLondonEngineeringCustomer SupportMarketingHires by Year201820192020202120222023202420252026Employment TypeFull-time80%Part-time13%Contract7%Average Salary by Job LevelSeniorMid-LevelAssociateManagerDirectorAverage Performance Rating by DepartmentMarketingCustomer SupportSalesOperationsEngineeringFinanceEmployee RosterEmployee IDDepartmentLocationJob LevelEmployment T…Hire DateAnnual SalaryPerformance…E-1001Customer Sup…RemoteSeniorFull-time2018-02-07$79,0004E-1002EngineeringNew YorkMid-LevelFull-time2018-05-30$97,5002E-1003Customer Sup…RemoteSeniorFull-time2018-06-16$72,0003E-1004FinanceNew YorkSeniorFull-time2018-08-20$104,0001E-1005SalesAustinAssociateFull-time2018-09-01$60,0004E-1006Customer Sup…AustinManagerPart-time2018-09-14$41,5003E-1007EngineeringAustinAssociateContract2018-10-09$72,5004E-1008MarketingLondonSeniorFull-time2018-11-28$102,5004About this dashboardA roster of 152 sample employees across sixdepartments and four locations, with each person'sjob level, employment type, hire date, salary andlatest performance rating. 36 people joined in 2026and the average salary is $81,845.•Use the Department and Location filters at the topto narrow every widget.•Switch to Sheets to edit the sample roster orpaste in an export from your HR system.

HR Workforce Dashboard

Headcount, hiring, salaries and performance ratings by department, location and job level, built from an employee roster.

  • 4 KPIs
  • 5 charts
  • 2 filters
View template
Channel: AllCampaign: AllNonprofit Fundraising DashboardTotal Raised$213.9KTotal of AmountRaised This Mo…$27,895▲ 1.4% vs last monthUnique Donors145Unique count of Donor…Average Gift$795.13Average of AmountNumber of Gifts269Count of Donor IDMonthly Donations by Donor TypeNewReturningJanFebMarAprMayJunJulAugSepOctAverage Gift by MonthJanFebMarAprMayJunJulAugSepOctProgress to Annual Goal$213.9KGoal $250KFunds Raised by CampaignMonthly GivingSummer Matching Chal…Spring AppealAnnual GalaBack to School DriveNumber of Gifts by ChannelOnlineMailEventMajor GiftDonations by ChannelMajor Gift73%Event14%Online8%Mail5%DonationsDonation DateDonor IDCampaignChannelDonor TypeAmount2026-01-01D-2127Monthly GivingOnlineNew$1002026-01-03D-2116Monthly GivingOnlineNew$1002026-01-04D-2109Monthly GivingMailNew$752026-01-05D-2025Monthly GivingOnlineNew$1002026-01-06D-2034Monthly GivingOnlineNew$1002026-01-07D-2034Monthly GivingMailReturning$1002026-01-08D-2006Monthly GivingMailNew$1002026-01-12D-2023Monthly GivingMajor GiftNew$14,250About this dashboard269 sample gifts from 145 donors between January andOctober 2026, raising $213,890 across fivecampaigns. Monthly Giving raised the most, and thegauge tracks progress toward a $250,000 annual goal.•Use the Campaign and Channel filters at the top tonarrow every widget.•Switch to Sheets to edit the sample gifts or pastein an export from your donor database.

Nonprofit Fundraising Dashboard

Donations by month, campaign, channel and donor type, with unique donors, average gift and progress toward an annual goal.

  • 5 KPIs
  • 6 charts
  • 2 filters
View template
Plan: AllRegion: AllCustomer Satisfaction DashboardResponses315Count of Response IDSatisfaction This Month3.79 / 5▼ 3.7% vs last monthLikelihood to Recommend6.78 / 10Average of Likelihood to RecommendMedian Resolution Hours3.6Median of Resolution HoursAverage Satisfaction by MonthJanFebMarAprMayJunJulAugSepOctResponses by Support ChannelLive Chat43%Email37%Phone20%Likelihood to Recommend by RegionNorth AmericaEuropeAsia PacificLatin AmericaAverage Satisfaction by Plan and ChannelPhoneEmailLive ChatProfessionalStarterEnterpriseAverage Resolution Hours by ChannelEmailPhoneLive ChatMonthly Responses by Support ChannelPhoneEmailLive ChatJanFebMarAprMayJunJulAugSepOctSurvey ResponsesResponse DateResponse IDRegionPlanSupport Chan…Satisfaction…Likelihood t…Resolution H…2026-01-04R-50001EuropeProfessionalPhone485.42026-01-04R-50002North AmericaStarterPhone471.52026-01-06R-50003North AmericaEnterprisePhone461.82026-01-09R-50004North AmericaEnterpriseEmail2436.62026-01-10R-50005EuropeProfessionalLive Chat370.72026-01-11R-50006North AmericaEnterprisePhone363.22026-01-14R-50007Latin AmericaProfessionalEmail3418.92026-01-14R-50008Latin AmericaStarterLive Chat361.2About this dashboard315 sample customer support survey responses fromJanuary to October 2026, across four regions, threeplans and three support channels. Each response hasa satisfaction score from 1 to 5, a likelihood torecommend from 0 to 10, and how many hours the issuetook to resolve. The average satisfaction score is3.68.•Use the Region and Plan filters at the top tonarrow every widget.•Switch to Sheets to edit the sample responses orpaste in an export from your survey tool.

Customer Satisfaction Dashboard

Support survey responses with satisfaction scores, likelihood to recommend and resolution times by month, region, plan and channel.

  • 4 KPIs
  • 6 charts
  • 2 filters
View template

Browse all dashboard templates.

Build your budget vs actual dashboard today

InstaCharts makes data visualization easy, so you can build clear reports without design experience.