Get FP&A best practices, research reports, and more delivered to your inbox.
To stop exporting trial balances from Sage Intacct every month, connect Intacct to your spreadsheet through a tool with a native Intacct connector. GL actuals then refresh by entity, department and location straight into the Excel or Google Sheets model you already use.
Sage Intacct itself doesn't offer a live Excel link. Its exports are static files, and its bulk Data Delivery Service sends CSV batches. So the live connection comes from one of three places: an Excel add-in that pulls GL balances with formulas, a data connector that imports Intacct tables, or an FP&A platform that syncs Intacct and feeds your models.
Bottom line: If you only need live GL formulas in a report, an Excel add-in will do. If your model also needs budgets, headcount and CRM data alongside Intacct actuals, and you want budget vs actual to refresh itself, use an FP&A platform with a native Intacct connector. Aleph is our pick for teams that want to keep their existing Excel or Google Sheets models.
Why exporting trial balances stops working
The monthly routine is familiar: run a trial balance in Intacct for each entity, or by department and location, export it to Excel, paste it into the model, fix the account mapping, and check that it ties. It works until the model has to serve more than one audience. A board pack wants one layout, investors want another, and every department owner wants their own slice.
Each export is a static snapshot. If a late journal posts, the whole thing gets rerun. It also adds up: the FP&A Trends 2025 survey found FP&A teams spend 46% of their time collecting and validating data, the highest share in five years.
What can Sage Intacct do on its own?
More than people expect for reporting inside Intacct, and less for Excel:
- Report exports. Financial reports export to Excel, CSV, PDF or HTML, per Sage Intacct's help on exporting reports. Each export is a static download.
- Interactive custom reports. The Interactive Custom Report Writer lets you filter, pivot and drill into live transaction data inside Intacct. Exports from it are static too, and capped at 65,000 rows for Excel.
- Dashboards. Performance cards, graphs and actual vs budget views inside Intacct. Good for a quick look; not a model.
- Data Delivery Service. Intacct's Data Delivery Service sends bulk CSV files of all records, or only what changed, to cloud storage on a daily, weekly or monthly schedule. It's built for feeding a warehouse, not a spreadsheet.
- APIs. Intacct's XML and REST APIs can return account balances by any dimension, including user-defined ones. Using them requires the Web Services subscription and an authorized sender ID or OAuth app, per Intacct's developer FAQ.
Sage doesn't ship its own live Excel add-in. Sage Intacct Planning, Sage's budgeting product, is web-based and positioned as a replacement for spreadsheets rather than a link to them. So if your model lives in Excel, the live connection comes from a third party.
Three ways to get live Intacct data into Excel
They differ in what lands in the sheet: formulas, tables, or a full model with data from other systems.
- Excel add-ins with GL formulas. Tools like Velixo and insightsoftware's Spreadsheet Server add functions that return GL balances by account, period and dimension, and refresh on demand. Velixo also documents drill-down to transactions and write-back of journals and budgets. Best when the goal is reporting from Intacct alone.
- Data connectors that import tables. CData's Excel add-in and Coefficient pull Intacct objects or custom reports into sheets on a schedule (hourly to monthly). Power Query can do it too, but only through a third-party driver. These give you raw tables to build on, not finance-ready balances.
- FP&A platforms with a native Intacct connector. Aleph, Cube, Datarails, Vena, Abacum and others sync Intacct actuals, with dimensions, into their own data layer and feed your models. They also bring in HRIS, CRM and billing data, which a pure Intacct add-in can't. Our guide to the best FP&A tools for Sage Intacct compares them.
Here's how the options compare as of October 2026:
Pricing models are general, not quotes. Check Intacct subscription requirements (Web Services, Data Delivery Service) with your Sage partner.
How to set up live Sage Intacct data in Excel
Whichever tool you pick, the setup follows the same six steps:
- Authorize the connection. Your Intacct admin enables Web Services and authorizes the tool's sender ID, or approves its OAuth app. Create a dedicated, read-only user with access to only the entities and modules the tool needs.
- Pick the dimensions. Decide which of entity, department, location, class, project and any user-defined dimensions the model needs. Check that the tool supports all of them; some connectors only bring in departments and locations, or only the top-level entity.
- Map accounts to reporting lines. Map Intacct accounts to the lines your P&L, board pack and investor templates use, once. Changes to the chart of accounts should show up as unmapped, not disappear.
- Point the model at the live data. Replace pasted trial balances with formulas or ranges that read the synced data, keeping the layouts investors already expect.
- Set the refresh. Schedule it (daily is enough for most monthly reporting) and make sure analysts can refresh on demand during close.
- Tie it out. Compare the live numbers against an Intacct trial balance for a closed period, by entity and department, before you retire the old process.
Our walkthrough of real-time NetSuite to Excel integration covers the same steps for NetSuite, and real-time spreadsheet sync for finance explains the sync patterns in more depth.
What budget vs actual looks like once actuals refresh themselves
The biggest change is the budget vs actual. With actuals refreshing from Intacct, the BvA isn't rebuilt each month; it rolls forward. You open the model after close, refresh, and every department and location shows actuals against budget, already mapped.
Three things get easier:
- Department views. The same model filters to each department owner's slice, so you're not maintaining a workbook per owner.
- Drill-down. When a variance looks wrong, you go from the line to the transactions behind it without leaving the sheet.
- Commentary. With AI on top of live data, the first draft of variance commentary writes itself, and the analyst edits rather than starts from scratch.
See how to build a live, drillable BvA in Excel with AI for a worked example, and budgeting software for mid-market companies if the budget itself needs a new home.
Excel add-in or FP&A platform: which do you need?
Both get live Intacct numbers into a spreadsheet. The difference is what else the spreadsheet has to do.
An Intacct-specific Excel add-in is the right call when the job is reporting from Intacct alone. The controller wants live financial statements by entity and department, drill-down to transactions, and maybe journal entries or budgets pushed back from Excel. Everything the report needs already lives in the general ledger.
An FP&A platform is the right call when the model needs data Intacct doesn't hold. Headcount comes from the HRIS, pipeline from the CRM, bookings or usage from the billing system. Budget versions, scenarios and forecasts need to be stored and compared over time, and department owners each need their own view. An add-in can pull GL balances into that model, but someone still has to bring in everything else and keep it in sync.
A quick test: list the tabs in your monthly model. If every input tab comes from Intacct, start with an add-in. If half of them are pasted from other systems, you need a platform.
Common mistakes when connecting Intacct to Excel
Most failed rollouts come down to a handful of setup choices:
- Pulling at the wrong grain. Bringing in account balances by entity only, then discovering the board pack needs department and location. Decide the dimensions up front, including any user-defined ones.
- Mapping by account name. Names change; account numbers and mapping tables don't. Map on the account number and flag anything unmapped.
- Ignoring the entity structure. In a multi-entity Intacct company, pulling at the top level and at the entity level gives different answers once intercompany activity is involved. Be explicit about which level each report reads.
- Refreshing an open period without knowing it. A refresh mid-close pulls in entries that may still change. Label every report with the period status and the time of the last refresh.
- Opening everything to everyone. A connected model can expose payroll and other sensitive accounts to every department owner. Set permissions by department and account before you share it; our guide to role-based access controls in FP&A covers the patterns.
Where Aleph fits
Aleph connects natively to Sage Intacct and syncs entities, dimensions and transactions into its data layer. From there, Excel and Google Sheets add-ins pull the data into the models your team already uses, in the layouts investors and the board already expect, refreshed on a schedule or with one click. Budgets and scenarios push back into Aleph, where they're versioned, and AI explains budget vs actual variances and drafts the commentary. Because Aleph also connects HRIS, CRM and billing data, headcount and pipeline sit in the same model as Intacct actuals.
- Strengths: no model rebuild; Excel and Google Sheets both supported; actuals, headcount and pipeline in one place; AI variance commentary.
- Considerations: if the only job is formula-based reporting straight from Intacct, an Intacct-specific Excel add-in is the lighter purchase.
Get live Sage Intacct data into your model with Aleph
Connect Intacct once, keep your Excel or Google Sheets models, and let actuals refresh themselves. Book a demo to see it on your Intacct data.
Get FP&A best practices, research reports, and more delivered to your inbox.
