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:
Key Features of the Excel Import

How the Excel Import Works
The import takes minutes. Here’s how it works:
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.