Designer · For report power users

The report builder for the person who knows the numbers.

Pull the data you want, lay it out how you want it, and add the hierarchies, calculations, buckets and drills that turn a data grid into a report people trust. Make it look pretty, then publish it — secured by any ERP dimension — to the people who need it.

Book a live demo What you can build ↓

No SQL · No BAQ · No IT ticket

FastClose Designer showing a P&L This Month vs YTD vs Last Year report with filters and drill-through
Who Designer is for

A small number of report builders. Everybody else reads.

Designer is the Power User's environment — typically a financial controller or analyst. They own the report definitions, and the rest of the business consumes them in Excel, FastCharts or the browser.

One report builder at a Designer workstation publishing to many readers on laptops, tablets and phones
You know the accounts, not the schema

Reports are built by choosing dimensions and hierarchies. There is no SQL to write and no BAQ to request.

You start from a template, not a blank grid

Pre-built templates and sample solutions for your ERP give you a working P&L or ageing report to adapt rather than invent.

One definition, every tool

Publish once and the same report reaches Excel, FastCharts and the browser — no separate build for each.

A change is minutes, not a change request

New cost centre? Restructured hierarchy? Extra comparison column? You make it yourself, in the meeting if need be.

What you build with it.

Six capabilities do most of the work in practice.

Six Designer capabilities: layout, hierarchies, calculations, drills, presentation, publish and secure
LAYOUT

Data in the grid, filters above

Add and remove dimensions to shape rows, columns and filters. Decide which filters end users need or are allowed to change when they run it.

HIERARCHIES

P&L and balance sheet structures

Import a hierarchy or build one, including reporting structures your ERP doesn't hold — and group structures spanning companies.

CALCULATIONS

New insight from retrieved data

Subtotals, ratios, margin percentages, variance and rolling comparisons — derived in the report rather than pasted into a spreadsheet afterwards.

DRILLS

Custom drills that follow the money

Define where a figure leads: to the journal, to the invoice or sales order, or across to a related report that answers the next question.

PRESENTATION

Formatting and dynamic titles

Format precisely enough for a board pack, and let titles and headings be data-driven so one report serves every company and period.

PUBLISH & SECURE

Control who sees which slice

Publish to users who can open reports in Excel and the browser. Separately, lock data down on any ERP dimension — company, cost centre, account code, warehouse by user or group.

Designer report grid with the filter bar highlighted — connections, measures, dates, company and customer filters above the rows
Add and remove data in the grid and filters
Designer hierarchy editor with a P&L account range (6300–6399) being added to Labour Costs
Import or create hierarchies for P&Ls and balance sheets
Right-click Drill Through menu on a P&L line, leading to GL Balances, GL Transaction Analysis and GL Journal Detail
Create custom drills to help the user follow the money

What Designer usually replaces.

Customers most often arrive from a reporting tool that requires a specialist, or from a spreadsheet that requires its creator. Designer is a practical alternative to Epicor Financial Report Designer, Epicor FP&A and SAP Crystal Reports.

... and on Epicor, work already done in XL Connect or BAQs can come with you. FastMigrate →

Exported spreadsheets, a queue of BAQ requests and a locked report replaced by one report a finance user adjusts themselves
A report design that only one consultant understands
Exports stitched together in a monthly workbook
A queue of BAQ requests sitting with IT
Reports nobody dares change because the author left years ago

Designer builds it. These three consume it.

One report definition, three audiences — and one set of numbers between them.

One Designer report definition feeding the Excel Add-in, Read & Navigate and FastCharts
REPORTING IN EXCEL
Excel Add-in
Run your published reports live inside Excel, change filters, and build models on top of accurate numbers.
Excel Add-in →
FOR MANAGERS & EXECS
Read & Navigate
Managers read live reports on the web, drill to the detail, following the money — with no training.
Read & Navigate →
DASHBOARDS & KPIS
FastCharts
Turns a report straight into KPI tiles and charts — the report IS the data model, so there's nothing extra to build.
FastCharts →

?Common questions about FastClose Designer

Do I need SQL or BAQ skills to build reports?

No. Designer presents your ERP as dimensions and hierarchies, so a report is built by choosing structure rather than writing queries. Finance power users build their own reports without IT.

How many people need Designer?

Usually one or two. Designer is for the people who build and publish; everyone else consumes those reports in Excel or the browser and never opens Designer at all.

Do I have to start from scratch?

No. Pre-existing templates and sample solutions for your ERP give you working reports to adapt, and standard content is available immediately after install.

How is data security handled?

Data is locked down on any ERP dimension — company, cost centre, account code, warehouse — so a single published report shows each viewer only their permitted slice.

Can a report drill into another report?

Yes. As well as drilling to transaction detail, you define custom drills to related reports, so a viewer can follow a figure to whichever view answers their next question.

Can Designer report on custom fields and tables?

Yes. Customisations and user-defined fields can be brought into reporting, and on Epicor an existing BAQ can be imported as a data source with FastBAQ.

Build your own report on the call.

Bring the one you rebuild every month — we'll build it live in Designer.

Book a live demo How the engine works