Financial Reports list

The Financial Reports list provides access to all the financial reports that have been defined for your company.

  • Define reports using the Financial Report Writer. Select Add to create a new report, or select Edit next to an existing report.

  • Generate an existing report.

    • Using the Process & store feature, you can generate (run) a report in any format and store it in the My reports list or in a cloud storage location such as Dropbox, Box, Google Drive, or Amazon S3.
    • You can also download a report immediately in HTML, CSV, PDF, or Excel format.
  • Schedule a report to be run at a future date, or on a recurring schedule.

If your company was created using a QuickStart setup template, you can access stock financial reports by selecting Financials library, which provides access to a set of reports you can run as-is or modify.

View a financial report

Subscription

General Ledger

Regional availability

All regions

User type
  • Business
  • Employee
Permissions List, View, Add, Edit
Tip Users without further permissions to view application data might not be able to drill down.

For each report in the Financial Reports list, you see the name of the report that you entered in the Report name field on the Report Info tab of the Financial Report Writer. You also see the name of the owner of the report or Public if everyone has access to the report. To narrow the list further, filter by Report type or Report audience.

Reports can be either public or private. Everyone who uses the application can view public reports. Only those who have been assigned permission by the administrator or the person who created the report can view private reports. (To grant permission to a private report for a user or group, select Edit for the report and then select the Permissions tab.)

Multi-entity companies: Making a report private means that the report will never be visible to other entities.

Administrators can choose whether new reports are created as public or private by default. Public is the out-of-the box setting. To change that setting, at the top level go to Company > Setup > Subscriptions. Next, select General Ledger, then Configure.

  1. On the Financial Reports page, select one of the following to view the report:
    • Process & store: enables you to generate the report (in any format) and store it in a location of your choice. Reports can be stored in the My Stored Reports list or delivered it to a cloud-storage location, such as Dropbox, Box, Google Drive, or Amazon S3. Learn more about setting up cloud storage.
    • HTML: displays the report online, in your browser window. Because you are viewing the live report, you can expand/collapse the amount of detail and drill down to more detailed records.
    • CSV: download the report in CSV (comma separated value) format.
    • PDF: opens the report in PDF format in Adobe Acrobat, reflecting exactly how you have expanded or collapsed the summary titles.
    • Excel: opens the report in Microsoft Excel.
  2. To schedule the report to run automatically in the future, select Schedule.
    • The Schedule Financial Report page appears for you to enter the details. Go to Schedule report delivery for more information.

    • The Schedule Status column displays either "Scheduled" or "Not Scheduled," depending on whether you scheduled the report to run automatically at a future date.

  3. To edit the definition of an existing report or create a new report, select Edit or Add.

If you don’t have Edit permissions, you might not see the Edit option, and for existing reports you’ll see View instead.

To display the list of Financial library reports list, select Financial reports library. This is visible only for companies that were created using a QuickStart. It looks similar to the Financial Reports list, except that you use it to create reports from the financial templates that were installed when your company was configured. Go to Templates for financial reports for details.

By default, financial reports are set to Public.
To make entity-level financial reports private by default, change the setting at the top level configuration.

To set all financial reports to Private:

  1. At the top level go to General Ledger > Setup > Configuration.
  2. In the Reports & Budgets section, locate Financial Reports.
  3. Clear the checkbox from Set default permissions to public.
  4. Save your changes.

If your report is showing a different number than you were expecting, the most likely culprit is that a filter (or combination of filters) is affecting the value.

To quickly find out what filters are being used:

  1. Run the report.
  2. Drill down into the questioned value to open the underlying GL report. (All financial reports are based on the GL.)
  3. Select Customize.
  4. Scroll to the Filters section to see the filters including in the report.
  5. Make sure that Include subdimensions is selected for all included dimensions.

From this section, you can often determine that the report uses an unexpected filter that's not apparent in the Financial Report Writer report.

If the issue isn't found here, check to see if there is a filter applied to the account group. See Account groups for more.