Finance Summary Dashboard in Google Sheets

Month-end finance reporting often means stitching revenue, expenses and budget together by hand. The Finance Summary Dashboard in Google Sheets is a finance dashboard template that turns a year of monthly ledger totals into four dashboard pages: total revenue, total expenses, net income and profit margin, how each business unit and account performed, and how the actual numbers compare with the budget.

🌍 Join 10,000+ customers in 180+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

Watch the Finance Summary Dashboard in Google Sheets walkthrough

Good to know: this is a reporting dashboard, not an accounting system. You paste or enter ledger totals into the Data tab. All sample business units, accounts and figures are fictional.

🔑 Key Features of the Finance Summary Dashboard

📌 A finance dashboard in Google Sheets. This finance dashboard Google Sheets users can copy to their own Drive shows revenue, expenses, net income and net profit margin for the whole year on one screen.

📌 KPI cards on every page. Total Revenue, Total Expenses, Net Income, Net Profit Margin, Gross Profit, Gross Margin, Cost of Goods Sold, Operating Expenses, Expense Ratio and Budget Attainment.

📌 Native slicers. Business Unit, Quarter, Month, Account, Department and Type filter the charts and pivots on their pages with one click.

📌 A budget vs actual dashboard. The Budget page compares actual and budget by month for revenue and expenses and shows the variance by account and business unit.

📌 Revenue and expense breakdowns. Revenue by stream, business unit, quarter and month, and expenses by department, account and quarter, show where the money comes from and where it goes.

📌 Top 5 panels and sparklines. Top 5 expense accounts, top 5 months by revenue, top 5 departments by spend and top 5 favorable variances update with the slicers.

📌 Record-level Search page. Type any Entry ID such as GL-0001 and the full ledger entry appears.

📌 A profit and loss dashboard without add-ons. Built with formulas, pivot tables and native slicers. No add-on, no script, no macro.

📌 Room for 1,000 ledger rows. Paste your own ledger totals over the sample rows and the pages update on their own.

📦 What’s Inside the Finance Summary Dashboard

Four dashboard pages (Overview, Revenue, Expenses, Budget), a Search page, an Instructions page and a Data tab. Your download is a PDF guide with the link to open the dashboard and make your own editable copy.

Overview Page

Four KPI cards lead the page: Total Revenue, Total Expenses, Net Income and Net Profit Margin. Below them are Revenue, Expenses and Net Income by Month, Revenue by Business Unit and Expenses by Account. A side panel adds a financial snapshot with gross profit, gross margin and operating expenses, a 12-month revenue trend, the Top 5 expense accounts, key ratios and an At a Glance list. Business Unit, Quarter and Month slicers filter the page.

Revenue Page

Revenue by Stream, Revenue by Business Unit, Gross Profit by Quarter, Revenue by Month and a stacked monthly chart by business unit show where the sales come from and when. KPI cards show total revenue, gross profit, gross margin and revenue against budget. A side panel lists the Top 5 months by revenue and each unit’s revenue share. Business Unit, Account, Quarter and Month slicers filter the page.

Expenses Page

The spending control page: Expenses by Department, Expenses by Account, Expenses by Quarter, Operating Expenses by Month, Expenses by Business Unit and Cost of Goods Sold by Month. KPI cards show total expenses, cost of goods sold, operating expenses and the expense ratio. A side panel lists the Top 5 departments by spend. Department, Account, Business Unit and Month slicers filter the page.

Budget Page

Revenue and Expenses Actual vs Budget by Month, Budget Variance by Account and Budget Variance by Business Unit. KPI cards show revenue vs budget, spend vs budget, net budget variance and budget attainment. The side panel lists the Top 5 favorable variances, the expense budget used by unit and the variance for every quarter. Business Unit, Type, Account and Quarter slicers filter the page.

Search Page

Type any Entry ID, such as GL-0001, in the input box and the full general-ledger entry appears: period end, month, quarter, business unit, type, account, department, actual and budget amounts, revenue, expense, net income, gross profit and budget variance.

Instructions Page

Explains that each Data row is one business unit, account and month, how the pivot tables and slicers work, how net income, gross profit and budget variance are calculated, and how to replace the sample rows with your own trial balance or ledger export.

📊 Finance Summary Dashboard vs. a Finance Spreadsheet vs. BI Software: Where This Fits

If you already export monthly ledger totals from your accounting software and want a clear financial summary without another subscription, this dashboard fits. If you need bookkeeping, journal posting or tax filing, you need accounting software as well.

👥 Who This Template Is For, and Who It’s Not For

✅ This template is built for:

• Business owners who want revenue, expenses and profit on one screen
• Accountants and finance managers who report monthly results and budget variance
• Controllers who compare actual and budget by account and business unit
• Small and mid-size businesses with several business units or departments

❌ This template is NOT for:

• Teams that need bookkeeping, journal posting or invoicing, because it only reports on ledger totals you add
• Anyone looking for statutory financial statements or tax calculations, which it does not produce
• Teams that need a live feed from an accounting system, because the rows are pasted or typed into the Data tab

⚙️ How to Use the Finance Summary Dashboard

1. Open the PDF guide in your download and click the link to open the dashboard.
2. Choose File, then Make a copy and save it to your own Google Drive.
3. Go to the Data tab and paste your own ledger totals over the sample rows. Keep the header row unchanged.
4. Use the slicers on each page to filter the charts and pivots.
5. Move through Overview, Revenue, Expenses and Budget from the navigation bar at the top.

💼 Real-World Use Cases

The month-end review. A finance manager filters to one quarter on the Overview page and compares revenue, expenses and net income by business unit.

The budget check. A controller opens the Budget page, filters to one business unit and sees which accounts ran over plan and which came in under it.

The cost conversation. An owner looks at the Expenses page, sees which department takes the largest share of spend, and uses the figures in a budgeting meeting.

❓ Frequently Asked Questions

What does the Finance Summary Dashboard in Google Sheets show?

It turns a year of monthly general-ledger totals into total revenue, total expenses, net income, net profit margin, gross profit and budget against actual, split by business unit, account, department, quarter and month.

Is this an accounting system?

No. It is a reporting dashboard. You paste or type ledger totals into the Data tab and the pages report on them. It does not post journal entries or replace your accounting software.

How do I get my own copy?

Open the PDF guide in your download, click the link and choose File, then Make a copy. The copy lands in your Google Drive and is fully editable.

Do I need add-ons, scripts or macros?

No. It is built with formulas, pivot tables and native slicers. There is no add-on, no Apps Script and no macro to authorise.

How many ledger rows can it hold?

The pivots, slicers and formulas are set up for up to 1,000 ledger rows. You type 10 columns per row and the revenue, expense, net income, gross profit and variance columns calculate on their own.

Is the sample data real?

No. All business units, accounts and figures on the Data tab are fictional. Replace them with your own trial balance or ledger export.

Can I change the business units, accounts or departments?

Yes. Use your own values in the Data tab columns and the pivots and slicers pick them up.

How is budget variance calculated?

The Instructions tab explains it: favorable variance means revenue above plan or spend below plan, and the Budget page shows it by month, account, business unit and quarter.

👤 About the Author

Built by PK, Microsoft Certified Professional with 15+ years of Excel, Google Sheets and Power BI experience. Founder of NextGenTemplates. Every template is hand-built and tested before release.

🔗 Explore Related Templates

• Financial Auditing Dashboard in Google Sheets: audit findings and compliance tracking.
• Finance and Accounting Dashboard in Google Sheets: another view of finance and accounting performance.
• Zero-Based Budget Template in Excel and Google Sheets: plan the budget this dashboard reports against.
• Free Profit and Loss Statement Template in Excel and Google Sheets: a simple P&L to start with.

Browse all Google Sheets dashboards.

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

📅 Last updated: November 2026