Mastering Sage Intacct Financial Reports: Format

If you’ve followed our series, you’ll be relieved to know the grunt work is now done. You have successfully built your account groupings, pulled them into a new financial report and updated your report’s configuration to pull in the necessary data to analyze. But we are still missing one important aspect of financial report customization — formatting.

Intacct has many formatting options available to choose when finalizing your financial report. You may have board members who are sticklers for format and require specific amounts be highlighted or certain totals underlined. All of that — and so much more — can be done using the available formatting options in the Sage Intacct Financial Report Writer.

Conditional highlighting

Conditional highlighting is an available formatting option within the report columns to flag any value within a report, based on predefined criteria. For example, if there was a request to highlight any actual expenses exceeding budgeted expenses, you could create a rule to highlight any amounts in your “actual minus budget” column less than zero, as seen below:

The remaining formatting options are within the “format” tab of the Financial Report Writer. From this tab, you can dictate general formatting options, highlight specific columns or rows, or update the report layout.

General formatting

The general tab of the format section allows you to dictate how numbers and dimensions will display on your report. This section allows you to round any of the amounts on your report based on preferences, and provides formatting options for how negative numbers display (i.e in parentheses or with a minus sign). Within general formatting, you can also indicate whether dimensions will display with both their ID and name, or just one of these options, if applicable.

Bonus tip — Once you update the formatting on one report to fit your organizations preferences, you can copy that report’s format to any of your other financial reports using the “copy formatting from an existing report” option seen in the above screenshot.

Page setup and columns

There are many options within the page setup and columns tab. Within this section, you can:

• Set the report title and headers, and add any footer text if needed
• Include the company logo within the report output
• Determine how the report will fit onto a PDF or printed page
• Update the font, size, and color of any of your report headers or columns

One item to note is if you are going to leverage dimension filters when running reports, you can have the selected filters display in the footer section of the financial report so the report’s reader knows which dimensions data is displaying for, if not otherwise specified.

Report rows and totals

The rows and totals formatting section allows report builders to highlight/underline totals, hide account group headings, and insert blank rows to separate certain sections of the financial report. In the structure section, we discussed rolling your account groupings into an Account Hierarchy, but if you do not want to display the Account Group headers at the top of your report, they can be hidden in this formatting section. See below:

What’s next?

Give yourself a pat on the back — not just for making it through this series but for becoming the first Sage Intacct Triple Crown winner in your organization’s history. You mastered report structure, learned configuration, and conquered tedious report formatting to build an outstanding financial report. Well done! If you need any assistance with financial report building or other consulting or support, please contact your CLA Sage Intacct team.

For more information

Subscribe to our Sage Intacct blog to receive future posts directly to your inbox.

Missed the first two installments in the blog series or the webinar? You can find those here:

Webinar: Unlocking the Full Potential of Financial Reporting in Sage Intacct

Blog 1: Mastering Sage Intacct Financial Reports: Structure   

Blog 2: Mastering Sage Intacct Financial Reports: Configuration