How to build a department budget template in SmartSuite

Executive overview

Spreadsheet budgets have two failure modes: version chaos and team avoidance. Files multiply into "final-final-approved-v3" variants, and non-finance team members never open them.

SmartSuite is a free, hybrid task-and-data tool that gives you a living, collaborative budget without the spreadsheet tax.

The tutorial walks through installing a free small-business budget template, stripping it back to essentials, entering real data, fixing formula errors, and adding conditional colour formatting — all in under 25 minutes.

Why spreadsheets fail as shared budgets

• Version proliferation makes it impossible to identify the authoritative file
• Non-finance staff avoid spreadsheets entirely, so actuals never get filled in
• Permissions in Excel/Google Sheets are coarse — users either see everything or nothing
• Manual colour formatting consumes hours that should go to actual budget thinking

Setting up SmartSuite and installing the template

• Sign up via the affiliate link for a free account (no cost required for this workflow)
• Click "Add a new solution" → "Start with template" → search "budget" → select "Small Business Budget"
• The template works for any small organisation, department, or nonprofit — not just whole businesses
• After installing, delete the "Budget Changes" app/tab — it tracks version history most teams don't need
• Delete the pre-set "2021 by quarter" view; it has an active filter that hides data

Cleaning up the template for reuse

• Rename the summary view from "2021 Summary" to "All Budgets" — keeps the template year-agnostic
• Rename the "Title" column to "Budget" so each row's meaning is clear
• Set the record label (under the app settings) to "Budget" so the UI reads "Add a new budget"
• In the Budget Items app, rename the "All Expenses 2021" view to "All Budget Items"
• Set the Budget Items record label to "Items"
• These renames take two minutes and prevent confusion when the template is reused in future years

Fixing formula errors caused by the deleted app

• The Budget and Actual formula fields break after deleting the Budget Changes tab
• Open each formula, locate the reference to the deleted app at the end of the expression, delete it, and recalculate
• Both formulas then resolve correctly — this is a one-time fix

Entering budget categories and data

• Delete the placeholder rows and add your own budget categories as new records
• Each row (budget item) links to a period: set Month, Quarter, and Year fields
• Quarter and Year can be bulk-applied across all rows in one click
• Income and expense rows sit in the same view; use the category field to distinguish them
• To copy items to the next month, duplicate existing records and update the month — faster than re-entering

Conditional formatting with spotlights

• Spotlights are SmartSuite's conditional formatting — rules apply automatically, no manual cell painting
• The default template ships with spotlights that colour rows by quarter (e.g. Jan–Mar = blue)
• Add a custom spotlight: when "Actual" is empty → highlight the field red as a fill-in reminder
• Spotlights can apply to a single field or an entire row
• Multiple spotlights can stack; conditions are fully configurable per field value or state
• This replaces two days of manual colour work in Excel with a five-minute setup

Customising the look

• Change the solution's theme colour and icon under the solution settings (top-left caret)
• Switch the view type from Grid to Card for a visual, tile-based layout — useful for image-heavy budgets
• Emojis can be added to any text field using the native OS emoji keyboard (Windows key + period on Windows)
• Grid view remains the practical default for most budget workflows

Expanding the template later

• Automations: trigger email notifications when an actual is entered or a budget changes
• Dashboards and chart views: build dynamic reports that replace pivot tables, filterable by any time period
• Connected workflows: link the budget to expense approvals, corporate card tracking, or team training cost logs