Skip to main content

Reports

CloseCore reports use accounting data from your connected ERP or trial balance uploads. The report builder lets you group and filter data around the way your team works.

Viewing reports​

Open Reporting from the navigation menu and choose the report you want to review. Use the Subsidiary and Period selectors to change the entity and period the report covers.

Report data is pulled from your ERP, so it reflects your most recent sync.

A report appears under every entity whose data it includes, so a report that covers several subsidiaries can be opened from any of them. Flux analysis for a report is available only under the entity the report was created in.

Creating reports​

  1. Open Reporting & Flux and open the report creation menu.
  2. Select Custom Report or an available report template.
  3. Choose the reporting period, subsidiaries, dimensions, and any filters or budget options.
  4. Select Create Report.

The Reporting feature controls access to the reporting area and the custom report builder.

Drilling into transactions​

Click a value in a report to see the transaction-level detail behind it. You can view the individual journal lines that make up the balance, making it easy to investigate a number without leaving CloseCore.

Account sign (natural balances)​

Depending on how a report is configured, accounts may display with their raw ledger sign (for example, revenue shown as a negative). If you'd like reports to present natural account balances instead, talk to your account manager about the right configuration for your team.

Custom reports​

Custom reports let you group and filter data by the dimensions that matter to your team.

Reports based on trial balance uploads group by Account and use period-end balances.

Grouping by dimension​

Build a report that groups by a dimension such as department, account, vendor, or other dimensions your ERP tracks. Combine grouping with filters to focus on exactly the slice you want to review.

NetSuite budgets​

For a NetSuite report, you can select a NetSuite budget category as the Budget Source. CloseCore converts the budget values to the currency used by the report. If the report has a Consolidation Target, its base currency is used. Otherwise, the report's primary subsidiary determines the currency. The report's Account Types, Include Accounts, and Exclude Accounts filters apply to budget values as well as actual values.

NetSuite Local budget categories store each subsidiary's budget in that subsidiary's base currency. Global budget categories store budgets in the root-parent subsidiary's base currency. CloseCore uses NetSuite Budget Exchange Rates for each accounting period before adding values across periods. Actual values continue to use NetSuite Consolidated Exchange Rates.

Flux defaults (required explanations)​

A custom report can include a flux default rule: require an explanation whenever a period-over-period variance exceeds a specific amount (or percentage). This enforces your materiality policy automatically. Reviewers are prompted for the movements that matter and can ignore the noise.

AI report commentary​

A custom report can carry an AI-generated variance commentary that summarizes what moved the numbers for the period. From the Report Commentary panel, Generate produces an executive-style write-up: the grand-total variance, then the biggest drivers broken out by each dimension the report groups by, plus any standout individual rows. You can Rewrite it with an instruction ("focus on material drivers," "make it more concise") or Edit the text by hand.

You can also generate in bulk — filling in the report commentary and every required flux explanation across the report in a single pass. Existing, reviewed explanations are left untouched.

Commentary is a reviewable draft, saved separately for each comparison (month over month, quarter over quarter, year over year, and budget vs. actual). See AI variance analysis for how it works and who can use it.

Saving reports as templates​

Administrators can save report configurations as report templates so the whole team uses consistent reports each period. See Close calendar & other tools.

Exporting to Excel​

You can export reports into Excel for further analysis. With the Add-in for Excel, you can pull report and transaction data straight into a workbook.

Combined reports​

A combined report adds together compatible custom reports. The source reports can use the same or different ERP connections. Each source report continues to load and cache its own ERP data. CloseCore matches accounts by account number. It matches departments, vendors, customers, and other dimensions by the name shown in the report, ignoring capitalization and extra spaces. Matching values are then added together in the combined view. A combined account shows the account name from the first source report that recognizes its account number.

To create one:

  1. Open Reporting & Flux and open the report creation menu.
  2. Select Combined Report.
  3. Enter a report name and select at least two source reports.
  4. Select Create Report.

All source reports must use the same reporting period, dimensions in the same order, amount basis, and natural account sign setting.

Each source report contributes its full amount. Selecting reports with overlapping data can count the same amounts more than once.

CloseCore does not convert currencies in a combined report. If source reports contain different currencies, their amounts are added together as entered.

caution

Account numbers and names control how rows are matched. If two different accounts share an account number, or two different departments, vendors, or other items have the same displayed name, their values are added together, even across ERP connections. If CloseCore cannot resolve a department, vendor, or other item to a display name, that row stays separate for its ERP connection.

Budgets in combined reports​

Combined reports support actual, budget, and variance columns. Actual values and budget values are combined separately before the variance is calculated. Every source report must include a budget, or none of the source reports can include a budget. A missing budget is not treated as zero.

Each source can use its existing CloseCore budget or supported ERP budget configuration.

Combined report limitations​

Combined reports are read-only views. Configure dimensions, filters, natural account signs, and budgets on each source report. The combined view does not support Flux, report commentary, row groups, sign-offs, transaction drill-down, or Excel export. Those features remain available on the individual source reports where supported.

Deleting a source report, removing access to it, or changing it to an incompatible configuration prevents the combined report from showing a partial result. Update the source reports or recreate the combined report with compatible sources.