PlanGuru and Excel Import

PlanGuru + Excel Import

Not every accounting system connects directly to PlanGuru, and it doesn’t need to. If you can export it to Excel, you can bring it into PlanGuru.

Import your chart of accounts, your historical financials, and the business drivers behind them, such as assumptions, KPIs, headcount, units sold, customers, and locations. Map your accounts once, and every monthly update after that takes minutes.

The result: Your financials and the metrics that drive them, together in a real planning tool, no matter which system you use to keep your books.

This page covers how the PlanGuru Excel import works: what your file needs, what gets imported, how account mapping works, and how to keep your actuals and business drivers current month after month.

What You Can Import from Excel

When you import an Excel file into PlanGuru, you bring in the full foundation you need to start planning.

Data Type What Gets Imported
Chart of Accounts Account numbers (optional) and account descriptions for your Income Statement and Balance Sheet
Historical Actuals Monthly trial balance values, with multiple years in a single import
Business Drivers Assumptions, KPIs, and operating metrics such as headcount, units sold, pricing, customers, locations, and any other driver behind your numbers
Account Structure Your accounts, mapped to the correct sections of PlanGuru’s financial statements
Monthly Updates New actuals each month, or month-to-date numbers whenever you need them
Prior Budgets (optional) An existing budget or forecast, to use as a starting point when you switch to PlanGuru

Built for ongoing use, not just setup. You can run the Excel import as many times as you need on any scenario. Most teams do their first import right after creating a scenario, then use it every month to bring in updated actuals and driver data.

What Your Excel File Needs

You don’t need a special template. A standard trial balance export works, as long as it follows a few simple rules:

  • One tab. Put everything you’re importing on the first tab of the workbook.
  • Simple column layout. Account numbers (if you use them) go in column one, account descriptions in column two, and monthly values in the remaining columns.
  • Both statements in one sheet. Stack your Income Statement on top of your Balance Sheet.
  • As much history as you want. For example, 24 monthly columns brings in two full years at once.
  • Headers and totals are optional. PlanGuru’s financial statements already include section headers and totals, but you can leave yours in to make mapping easier.

Key Features of the Excel Import

Connect PlanGuru and Excel

How the Excel Import Works

The import takes minutes. Here’s how it works:

1. Choose & Upload

Select Financial Statements or Assumptions/KPIs from the Import menu, then drag and drop your Excel file.

2. Tag

Label your columns as account number, description, and month. Then select the months you want to import.

3. Map

Drag each account into the right section of your financial statements and choose its account type. You only do this the first time.

4. Forecast

Review your account order, click Import, and start building your budgets and forecasts.

One import tool for everything. Financial statements, assumptions, and KPIs all use the same import process. You choose what you’re importing, and PlanGuru handles the rest.

Watch the Excel Import Walkthrough

See the full process in action, from uploading your file to reviewing your imported actuals:

Excel for Your Data. PlanGuru for Your Plan.

Excel is great for moving data around, but it isn’t built for budgeting and forecasting. Spreadsheet models break as formulas multiply, versions pile up, and every scenario becomes a new file.

The PlanGuru Excel import lets you keep Excel for what it does well, getting data out of your accounting system, and move your planning into a tool designed for it.

Capability Spreadsheet Budgeting PlanGuru
Forecast horizon Limited by your model Up to 10 years
3-way forecasting (P&L + Balance Sheet + Cash Flow) Manual formulas Fully integrated
Balance Sheet stays in balance Up to you Automatic
Scenario modeling Copy the file Multiple named scenarios
Monthly actuals updates Copy and paste Import in minutes
Budget-vs-actual reporting Build it yourself Built in

A note on importing budgets: PlanGuru can import an existing budget or forecast from Excel. We recommend this only when you’re switching from a spreadsheet process and want your current budget as a starting point. From there, PlanGuru’s projection methods are the best way to build your future plans.

Who the Excel Import Is Built For

The Excel import gives every business and advisor a path into PlanGuru, whatever accounting system they use.

Businesses on Any Accounting Platform

If your accounting software doesn’t connect directly to PlanGuru, you’re not left out. A trial balance export gives you full access to PlanGuru’s small business budgeting, forecasting, and reporting.

Teams Moving Off Spreadsheet Budgets

Bring over your history, your current budget, and the assumptions and KPIs you already track in Excel. You get a structured, integrated plan without starting from a blank page.

Nonprofits

Import your financials and program data from whatever system your organization uses, then build program-level budgets and the variance reports your board and funders expect.

Fractional CFOs, Accountants, and Advisors

Your clients use all kinds of accounting systems. The Excel import gives advisors one consistent way to onboard any of them into PlanGuru, and a fast monthly routine to keep their actuals current.

Frequently Asked Questions

Excel Import FAQs

Any system that can export a trial balance to Excel. The Excel import is designed for businesses whose accounting software doesn’t integrate directly with PlanGuru.

Yes. In addition to your chart of accounts and financial history, you can import assumptions, KPIs, and any other metric that drives your business, such as headcount, units sold, pricing, customers, or locations. Just select Assumptions/KPIs instead of Financial Statements from the Import menu. The process works the same way.

Put all of your data on the first tab of the workbook. Use the first column for account numbers (optional), the second for account descriptions, and the remaining columns for monthly trial balance values. Stack your Income Statement on top of your Balance Sheet so all accounts are on one sheet.

Yes. You can include as many monthly columns as you’d like. For example, a file with 24 monthly columns imports two full years at once.

As often as you need. The Excel import can be run an unlimited number of times on any scenario, so you can bring in actuals every month or import month-to-date numbers mid-period.

No. You only map your accounts on the first import. PlanGuru remembers your mapping, so future imports go much faster. If you add a new account, it appears in the unmapped section for you to place.

No. PlanGuru’s financial statements already include section headers and totals. You can leave yours in your file to help with mapping, then simply skip them during the mapping step.

Yes. PlanGuru can import budgeted or forecasted data. We recommend this only when you’re moving from a spreadsheet budget and want to use it as a starting point. Going forward, PlanGuru’s projection tools are the best way to build your budgets and forecasts.

Click the X next to the account to unmap it, then drag it to the correct section. You can also change account types after the import is complete.

Turn Your Spreadsheet Into a Plan

Your trial balance already has everything PlanGuru needs. Import it in minutes and start budgeting, forecasting, and reporting in a tool built for planning, not just calculating.

Go to Top