Help Center

How to create a budget for metrics using Google Sheets

To budget for metrics with Google Sheets, create actuals for them in a connected Google Sheet, then generate, complete and upload a budget template that ScaleXP matches to those actuals.


1. Create actuals in Google Sheets

Actuals must exist before a budget can be uploaded, even if the values are zero or blank.

1.1 Download the KPI Google Sheets template

  1. In ScaleXP, go to Load Data > KPIs, select Google Sheets and click Connect (if Google Sheets is already connected, click Google Sheets under KPIs).
  2. Under Step 1: Create Template & Return to This Tab, click Copy Template.
  3. Make a copy of the template in your own Google Drive.
  4. Rename the file so it is easy to recognize later.

1.2 Populate the sheet structure

  1. Keep columns A - E exactly as provided:
    1. Optional Group
    2. Name
    3. Data
    4. Increase Is
    5. Aggregation
  2. Add monthly columns using YYYY-MM format (for example: 2025-01).
  3. Enter actual values (they can be 0 or blank if no data yet).

Note: Even zero actuals are required. ScaleXP uses this structure to match budgets correctly.


2. Connect the Google Sheet to ScaleXP

Once your actuals sheet is ready:

  1. Return to the same page and, under Step 2: Select Template, click Select Template.
  2. Choose your Google account if prompted.
  3. Select the prepared Google Sheet.

The data will sync automatically and become available for reporting and budgeting.


3. Generate a budget template

With actuals loaded, you can now create a budget template.

  1. Go to Load Data > Budgets & Forecasts.
  2. Click Load New Budget, then Get Started.
  3. Select the metrics and categories you want to include (including Google Sheets KPIs), then click Continue.
  4. Choose the budget period.
  5. Turn off the Include actuals data in download file toggle if you want a blank budget template. Leave it on only if you want historical actuals pre-filled.
  6. Click Generate Excel, then Download Excel.

4. Complete the budget template

  1. Open the downloaded Excel template (in Excel or Google Sheets).
  2. Enter budget values for each metric and month.
  3. Save the file as an .xlsx file once complete.

Important: Do not change the row or column structure, use numeric values only (no formulas), and keep the months and metric names unchanged.


5. Upload the budget into ScaleXP

  1. Click Continue (the download button changes to Continue once the file is downloaded) to go to the Upload Template step.
  2. Click Select File and choose your saved file, enter a display name, then click Upload. Once the upload succeeds, click Continue.
  3. Review the preview to confirm values are correct.
  4. Click Done to complete the upload.

ScaleXP will automatically match the budget to actuals based on the metric structure.


What happens after upload

Once uploaded, you can report budget vs actuals across dashboards, reports, and board packs.

  • Budget vs actual comparisons are immediately available
  • Google Sheets metrics can be used across reports, dashboards, and presentations
  • You can change figures and add months later with View and Edit - see How to view and edit a budget in ScaleXP

How it works

Creating a budget for metrics using Google Sheets follows three essential stages:

  1. Create actuals in Google Sheets (even if all values are zero)
  2. Generate a budget template and select the metrics
  3. Upload the completed budget

ScaleXP uses the structure of your actuals to correctly align and reconcile budgets automatically.