07.00 Overview of the Excel Add-In

07.00 Overview of the Excel Add-In

The FastClose Excel Add-In provides a powerful, live connection between Microsoft Excel and your FastClose data sources. Unlike static exports, the add-in allows users to refresh reports, interact with live ERP data, and build advanced models directly within Excel.

Fully saveable to disk like any other .xlsx file, a FastClose Excel workbook will automatically reconnect to FastClose on opening, and a single Run All click updates every tab with fresh data and reflects any linked formula changes.

How the Add-In Fits into the Reporting Workflow

The FastClose Excel Add-In allows users to take reports built in the Designer and consume them in Excel.

Reports are designed first in the FastClose Designer, including layout, formatting, and calculations. The same report can then be opened in Excel, where users may adjust filters — such as period, entity, or customer — while the report's structure remains consistent with the design.

Filter changes made in Excel are stored with the workbook, allowing multiple worksheets to reference a single report design but show different filtered views. For example, the same report can be opened across three worksheets, with each reporting on a different entity.

The sections that follow will go through how to use the add-in effectively in your daily work, to efficiently deliver and update report packs and other content.

Powered By