Financial Reports - Standard Reports

Overview

Financial Reports provide a way to communicate financial information using official records that document the financial activities of your business, person, or other entity. Financial Reporting includes a company’s communication of financial information that will be shared with people outside of the company such as shareholders. These reports generate financial statistical data that relates to the company’s status of operations. Accounting Seed provides pre-configured Standard Financial Reports, which can be filtered using criteria such as Ledger, Accounting Periods, GL Variables, Suppress Zero Amount Rows, and Report Rounding. The Standard Financial Reports can be generated for Transactional, Consolidations-Transactional, and Eliminations Ledgers.

Financial Reports can be selected by Ledger. Therefore, when running reports, if you have an Accrual Ledger and/or Cash Ledger, you can simply select the Accrual Ledger to view an Accrual Basis report or the Cash Ledger to view a Cash Basis report.

Important: If Multi-currency is enabled in your org (organization), all currencies must be configured in the Global Picklist. For more information, refer to Update Global Picklist Value - Currency. 

To learn more about the Standard Reports, click a Link below:

• Standard Reports - General Overview
• View a Standard Report in the Report Viewer
• Foreign Currency Translation
• Run a Profit & Loss Report
• Run a Profit & Loss versus Budget Report
• Run a Balance Sheet Report
• Run a Trial Balance Report
• Run a Cash Flow Report
• Run a Ledger Inquiry Report
• Rerun a Standard Report from the Report Viewer
• Export a Standard Report
• Delete one or more Standard Reports

Standard Reports - General Overview

Financial Reporter Icons

When you initially access the Financial Reports - Standard Reports tab, the following icons are available on the upper-right portion of the screen.  

• Management Reports - provides access to the same reports that are available from the Accounting Home | Reporting | Management Reports link. This is a quick and easy way to access the Management Reports without having to return to the Accounting Home page. 
•  Knowledge Base - provides access to this Financial Reports - Standard Reports knowledge article. If you have the Custom Reports tab selected, the Financial Reports - Custom Reports knowledge article displays when this icon is clicked. If you have the Report Settings tab selected, the Financial Reports - Reports Settings knowledge article displays when this icon is clicked. 
•  Dashboard - provides access to the same Accounting Dashboard that is accessible from Accounting Home |  Reporting | Dashboards. 

Standard Reports

On the Standard Reports tab, the following reports are available from the Select Standard Report drop-down list.

Generate and Run Standard Reports

The section only applies to the following Standard Reports: Profit & Loss, Profit & Loss versus Budget, Balance Sheet, Trial Balance, and Cash Flow Report. The Run button is available to generate and run a Standard Report. Whenever valid criteria is entered and Run is clicked, a message displays to indicate that the report generation is in progress. The report displays at the bottom of the screen in the Reports data grid with an initial status of “Running.” The status changes to “Complete” and the Report Number becomes a hyperlink once the report has been generated and is available to open in the Report Viewer.


Note: Click here to view the above image in full screen. 

Up to 25 reports per page can display in the Reports data grid. If more than 25 reports are available, you can click the next page number or click Next to view an additional page(s) of reports.

The Reports data grid includes hyperlinks to other records such as to the Ledger, the Accounting Period, and the User record in Salesforce for the person who created the report.

All of the column headings on the Reports data grid are sortable. Click a column heading to sort it in ascending or descending order.

Return to top

View a Standard Report in the Report Viewer

After you run a Standard Report and the report completes in the Reports data grid, you can click a Report Number hyperlink to display the actual report in the Report Viewer. The Report Viewer will display in a separate browser tab. The Profit & Loss, Profit & Loss versus Budget, Balance Sheet, Trial Balance, and Cash Flow Report can be displayed in the Report Viewer. 

When you view a report, you can click the More Information drop-down menu to display additional information such as Ledger, Starting and Ending Accounting Period, as well as who created the report. Available information in this section displays based upon the selected report. Additionally, if you have Multi-Currency enabled, the Currency is also included in the More Information section. The More Information in the sample report below is from a Profit & Loss Report.

The More Information section includes hyperlinks to view detailed record information. 

The Report Viewer sample screen below provides an example of a Profit & Loss Report.

Note: Click here to view the above image in full screen. 

When viewing a report, keep the following points in mind:

• If a Report Subtitle was added, it will display in the Report Viewer directly under the report name. In the sample report above, “ABC Northern Division '' was entered in the Report Subtitle textbox and it displays directly under the report name of Profit & Loss. You can click the Pencil icon to modify the subtitle, if necessary.
• The Expand All and Collapse All hyperlinks are available for the report. Collapse All is the default for Standard Reports. Click Expand All to review all available rows on a report. Otherwise, you can click the left arrow to expand or collapse individual rows.
  
  
  Note: Click here to view the above image in full screen. 
  
  Note: Expand All/Collapse All is not applicable for the Trial Balance Report.
  
  
• Standard Reports can be exported to an Excel spreadsheet and/or a PDF version can be created.
• In the Report Viewer, the left panel on the report is frozen. This is very helpful when you need to scroll to the right on a report. The frozen left panel allows you to continue to view the content in the left panel for matching the values with the correct information. 
• If transactions were posted during an Accounting Period(s), values on the report columns will display as a hyperlink(s). These links can be clicked to access the details on the Ledger Inquiry. Then, from the Report Results data grid on the Ledger Inquiry, you can drill-down into specific transactions.
  
  Note: If you click a hyperlink value from the Cash Flow Report, the Financial Report Transactions screen will display (rather than the Ledger Inquiry).

Return to top

Foreign Currency Translation

At Accounting Seed, running Foreign Currency Translation is an automatic background process that is completed as part of Run Consolidations using exchange rates created in the Exchange Rates tab. After running Consolidations, you will be able to run Standard Financial Reports and/or Custom Financial Reports in the base currency of the Ledger, as well as in the Reporting currency (parent currency).

Multi-currency must be enabled to use Foreign Currency Translation. With Multi-currency enabled, the reports listed below will include a Currency drop-down list, which can be used to select a different or the same currency as the Ledger currency. For example, you might want to run a report to view data in both Ledger and Reporting currency. In which case, you would run the report and select the Ledger currency and then run the report again and select the Reporting currency. 

• Profit & Loss
• Profit & Loss vs Budget
• Balance Sheet
• Trial Balance
• Cash Flow

The sample screen below includes the Currency drop-down list on the Profit & Loss Report.

When you initially access a Standard Report, the Currency field defaults to the currency of the selected Ledger. If you change the Ledger, the Currency field will automatically change based upon the selected Ledger. For example, you might select a GBP Ledger, the Currency field would automatically populate with GBP.

Note: If you select a Ledger with a currency that is not included in the Currency drop-down list, an error message will display. Additional currencies can be added to the Currency picklist. For more information, refer to the Update Global Picklist Value Set - Currency section of the Foreign Currency Translation Configuration Setup article.


Note: Click here to view the above image in full screen. 

When you run a report, the Currency column is included in the Reports data grid. Additionally, when you select the report from the data grid to view it, the currency that was selected in the Currency drop-down list will be included in the Currency column in the More Information section. The selected currency will also be available on both the Excel spreadsheet and PDF versions of the exported report.

As part of Foreign Currency Translation, the CTA (Cumulative Translation Adjustment) GL Account (plug) that was added to the Default GL Accounts screen will be available on reports. The sample Trial Balance below displays the CTA GL Account.


Return to top

Run a Profit & Loss Report

1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Standard menu, click Profit & Loss. 
2. Update the required fields, as necessary. Required fields display with a red asterisk (*).
   
   1. Ledger - this can be a Transactional, Consolidations-Transactional, or Eliminations Ledger. This populates with the system system Default Ledger or the Ledger for the current user (if a Ledger was selected in the Ledger Manager). If more than one Ledger is available, click the X to clear the default Ledger and then search for and select another one.
   2. Currency - only displays if Multi-Currency is enabled. When you initially access the Profit & Loss Report, the Currency field defaults to the currency of the selected Ledger. If you change the Ledger, the Currency field will automatically change based upon the selected Ledger. For example, you might select a GBP Ledger, the Currency field would automatically populate with GBP. Additionally, you can click the Currency drop-down list to select the currency to include on the report. This provides a way to include the Ledger currency on the report, as well as data for the parent currency, which can be selected from this Currency drop-down list. Otherwise, you can select the same currency as the Ledger currency to only view data for the base currency.
      
   3. Starting Accounting Period - click the X to clear the default period. Then, search for and select a different period. The Profit & Loss Report can be run on open or closed periods. The Starting Accounting Period defaults to the Ending Accounting Period minus up to twelve months (depending upon available system data).
   4. Ending Accounting Period - click the X to clear the default period. Then, search for and select a different period. The Profit & Loss Report can be run on open or closed periods. The Ending Accounting Period defaults to the current Accounting Period. This period cannot be more than 12 periods past the Starting Accounting Period. Additionally, the Ending Accounting Period cannot be before the Starting Accounting Period.
3. Complete any or all of the following optional fields:
   
   1. Include Sub Type 1 - select this checkbox to include Sub Type 1.
   2. Include Sub Type 2 - select this checkbox to include Sub Type 2.
      The sample screen below provides an example of how Sub Type 1 and 2 will display on a report.
      
      
      Note: Click here to view the above image in full screen. 
      
      
   3. Suppress Zero Amount Rows - this checkbox defaults to selected. De-select this checkbox to include rows with zero amounts on the report.
   4. Report Subtitle - enter a subtitle in the textbox. This will display in the Report Viewer directly under the report name. The Report Subtitle can also be added/modified from the Report Viewer.
      Note: Once you open the Report Viewer to display the report, the Pencil icon can be used if the subtitle needs to be changed.
      
      
      
      
   5. Report Rounding - the default that displays is based upon the Default Rounding selection on the Report Settings tab.
      1. No Rounding - this selection will not round up or down the amounts that display on the report.
         
         
         Note: Click here to view the above image in full screen. 
         
         
      2. Whole Numbers - rounds up to the nearest whole number.
         
         
         Note: Click here to view the above image in full screen. 
         
         
      3. Rounds to 1000s - rounds the amounts on the report to the nearest 1,000. In the sample screen below, the currency is USD and the amounts are rounded to the nearest 1,000 dollars. For example, the total for the 4000-Product Revenue was rounded to $155,000.00 dollars.
         
         
         Note: Click here to view the above image in full screen. 
         
         
   6. GL Account Variables 1-4 - enter one or more of the four variables. These are traditional Sub-General Ledger account segments used to filter the report results on divisions, departments, geographies, cost centers, profit centers or business units. If you include GL Account Variables, they will display in the Report Viewer on the generated report.
      
      
      Note: Click here to view the above image in full screen. 
      
      
4. Click Run. Based upon valid criteria entered/selected, a message displays to indicate the report is being generated. Another message will display when the report generation completes. The new report displays as the first report in the Reports data grid at the bottom of the screen.
   
   When running a Profit & Loss Report, keep the following points in mind:
   
   
   • If no data is available for the entered criteria, a message displays to indicate that there are no posted transactions for the selected criteria.
   • The maximum number of cells that a Standard Report can have is 5,000. If a report contains more than 5,000 cells, the system will hide all zero rows to make the result count of cells less than 5,000 (if the Suppress Zero Amount Rows checkbox was not selected). If the remaining results are less than 5,000 the report will be generated. If the Suppress Zero Amount Rows checkbox was selected, and more than 5,000 cells are included in the result count, the following message displays: “The report has too many rows for the start and end periods selected. Please select a new start and/or end period that limits the period range.”
     
     
5. Click the Report Number to display the Report Viewer and view the report in a separate browser tab.
   
   Amounts that display as hyperlinks identify totals for transactions that were posted during an Accounting Period and for a specific GL Account number. Click a hyperlink to access the Ledger Inquiry Report, and from there continue to drill-down directly into the related transactions.
   
   Note: Hyperlinked amounts for access to the Ledger Inquiry Report are not applicable when a Consolidations-Transactional Ledger is selected.
   
   
   Note: Click here to view the above image in full screen. 

Return to top

Run a Profit & Loss versus Budget Report

1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Standard menu, click Profit & Loss vs Budget.
2. Update the required fields, as necessary. Required fields display with a red asterisk (*).
   
   1. Transactional Ledger - this populates with the system Default Ledger or the Ledger for the current user (if a Ledger was selected in the Ledger Manager). If more than one Ledger is available, click the X to clear the default Ledger and then search for another one. This can be a Transactional, Consolidations-Transactional,, or Eliminations-Transactional Ledger.
   2. Currency - only displays if Multi-currency is enabled. When you initially access the Profit & Loss Report, the Currency field defaults to the currency of the selected Ledger. If you change the Ledger, the Currency field will automatically change based upon the selected Ledger. For example, you might select a GBP Ledger, the Currency field would automatically populate with GBP. Additionally, you can click the Currency drop-down list to select the currency to include on the report. This provides a way to include the Ledger currency on the report, as well as data for the parent currency, which can be selected from this Currency drop-down list. Otherwise, you can select the same currency as the Ledger currency to only view data for the base currency.
   3. Budget Ledger - this populates the system default Budget Ledger. If more than one Budget Ledger is available, click the X to clear the default and then search for and select another one. This can be a Budget Ledger, Eliminations-Budget, or a Consolidations-Budget Ledger.
   4. Starting Accounting Period -  the Profit & Loss versus Budget Report can be run on open or closed periods. The Starting Accounting Period defaults to the Ending Accounting Period minus up to twelve months (depending upon available system data). Click the X to clear the default period. Then, search for and select a different period.
   5. Ending Accounting Period - the Profit & Loss versus Budget Report can be run on open or closed periods. The Ending Accounting Period defaults to the current Accounting Period. This period cannot be more than 12 periods past the Starting Accounting Period. Additionally, the Ending Accounting Period cannot be before the Starting Accounting Period. Click the X to clear the default period. Then, search for and select a different period.
3. Complete any or all of the following optional fields:
   
   1. Include Sub Type 1 - select this checkbox to include Sub Type 1.
   2. Include Sub Type 2 - select this checkbox to include Sub Type 2.
      
      The sample screen below shows how each sub type will display on a report.
      
      
      Note: Click here to view the above image in full screen. 
      
      
   3. Suppress Zero Amount Rows - this checkbox defaults to selected. De-select this checkbox to include rows with zero amounts on the report.
   4. Show All Periods - select this checkbox if you want to display all of the individual Accounting Periods (Starting to Ending) on the report in the Report Viewer. Otherwise, only the totals and differences between Actual vs Budget will be included on the report.
      
   5. Report Subtitle - enter a subtitle in the textbox. This will display in the Report Viewer directly under the report name. The Report Subtitle can also be added/modified from the Report Viewer.
   6. Report Rounding - the default that displays is based upon the Default Rounding selection on the Report Settings tab.
      Note: Report Rounding is not applicable to the “% of Budget” column on the Profit & Loss versus Budget Report.
      
      1. No Rounding - this selection will not round up or down the amounts that display on the report.
         
      2. Whole Numbers - rounds up to the nearest whole number.
         
      3. Rounds to 1000s - rounds the amounts on the report to the nearest 1,000. 
         
   7. GL Account Variables 1-4 - enter one or more of the four variables. These are traditional Sub-General Ledger account segments used to filter the report results on divisions, departments, geographies, cost centers, profit centers or business units. If you include GL Account Variables, they will display in the Report Viewer on the generated report.
      
      
4. Click Run. Based upon valid criteria entered/selected, a message displays to indicate the report is being generated. Another message will display when the report generation completes. The newly created report displays as the first report in the Reports data grid at the bottom of the screen.
   
   When running a Profit & Loss versus Budget Report, keep the following points in mind:
   
   
   • If no data is available for the entered criteria, a message displays to indicate that there are no posted transactions for the selected criteria.
   • The maximum number of cells that a Standard Report can have is 5,000. If a report contains more than 5,000 cells, the system will hide all zero rows to make the result count of cells less than 5,000 (if the Suppress Zero Amount Rows checkbox was not selected). If the remaining results are less than 5,000 the report will be generated. If the Suppress Zero Amount Rows checkbox was selected, and more than 5,000 cells are included in the result count, the following message displays: “The report has too many rows for the start and end periods selected. Please select a new start and/or end period that limits the period range.”
     
     
5. Click the Report Number to display the Report Viewer and view the report in a separate browser tab.
   
   The report includes the Actual Total, Budget Total, Difference between the two, and the percentage (%) of the Budget. Additionally, amounts that display as hyperlinks identify totals for transactions that were posted during an Accounting Period and for a specific GL Account number. Click a hyperlink to access the Ledger Inquiry Report, and from there continue to drill-down directly into the related transactions.
   
   Note: Hyperlinked amounts for access to the Ledger Inquiry Report are not applicable when a Consolidations-Transactional Ledger is selected.
   
   
   Note: Click here to view the above image in full screen. 

Return to top

Run a Balance Sheet Report

The Balance Sheet is a cumulative report. For example, the amounts on the report in the current period will be equal to the sum of the amounts in the previous period plus the amounts in the current period.

1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Standard menu, click Balance Sheet.
2. Update the required fields, as necessary. Required fields display with a red asterisk (*).
   
   1. Ledger -  this can be a Transactional, Consolidations-Transactional, or Eliminations Ledger. This populates with the system Default Ledger or the Ledger for the current user (if a Ledger was selected in the Ledger Manager). If more than one Ledger is available, click the X to clear the default Ledger and then search for and select another one.
   2. Currency - only displays if Multi-currency is enabled. When you initially access the Profit & Loss Report, the Currency field defaults to the currency of the selected Ledger. If you change the Ledger, the Currency field will automatically change based upon the selected Ledger. For example, you might select a GBP Ledger, the Currency field would automatically populate with GBP. Additionally, you can click the Currency drop-down list to select the currency to include on the report. This provides a way to include the Ledger currency on the report, as well as data for the parent currency, which can be selected from this Currency drop-down list. Otherwise, you can select the same currency as the Ledger currency to only view data for the base currency.
   3. Starting Accounting Period - click the X to clear the default period. Then, search for and select a different period. This equals the Ending Accounting Period minus up to twelve months (depending upon available system data). The Starting Accounting Period must be either the first open period, a closed period, or one that has been archived. The Starting Accounting Period cannot be after the Ending Accounting Period.
   4. Ending Accounting Period - click the X to clear the default period. Then, search for and select a different period. This defaults to the first open Accounting Period. The Ending Accounting Period must be either the first open period, a closed period, or one that has been archived. The Ending Accounting Period cannot be more than twelve periods past the Starting Accounting Period.
3. Complete any or all of the following optional fields:
   
   1. Include Sub Type 2 - select this checkbox to include Sub Type 2.
      
      The sample screen below shows how the sub type will display on a report.
      
      
      Note: Click here to view the above image in full screen. 
      
      
   2. Suppress Zero Amount Rows - this checkbox defaults to selected. De-select this checkbox to include rows with zero amounts on the report.
   3. Report Subtitle - enter a subtitle in the textbox. This will display in the Report Viewer directly under the report name. The Report Subtitle can also be added/modified from the Report Viewer.
   4. Report Rounding - the default that displays is based upon the Default Rounding selection on the Report Settings tab.
      1. No Rounding - this selection will not round up or down the amounts that display on the report.
         
      2. Whole Numbers - rounds up to the nearest whole number.
         
      3. Rounds to 1000s - rounds the amounts on the report to the nearest 1,000. 
         
   5. GL Account Variables 1-4 - enter one or more of the four variables. These are traditional Sub-General Ledger account segments used to filter the report results on divisions, departments, geographies, cost centers, profit centers or business units. If you include GL Account Variables, they will display in the Report Viewer on the generated report.
      
      Important: If Header Level Post is enabled in the Post Settings screen, the GL Account Variables 1-4 will not be available as selections on the Balance Sheet. GL Account Variables will only be available to select if Line Level Post is enabled in the Post Settings.
      
      
4. Click Run. Based upon valid criteria entered/selected, a message displays to indicate the report is being generated. Another message will display when the report generation completes. The new report displays as the first report in the Reports data grid at the bottom of the screen. 
   
   When running a Balance Sheet Report keep the following points in mind:
   
   
   • If no data is available for the entered criteria, a message displays to indicate that there are no posted transactions for the selected criteria.
   • The maximum number of cells that a Standard Report can have is 5,000. If a report contains more than 5,000 cells, the system will hide all zero rows to make the result count of cells less than 5,000 (if the Suppress Zero Amount Rows checkbox was not selected). If the remaining results are less than 5,000 the report will be generated. If the Suppress Zero Amount Rows checkbox was selected, and more than 5,000 cells are included in the result count, the following message displays: “The report has too many rows for the start and end periods selected. Please select a new start and/or end period that limits the period range.”
     
     
5. Click the Report Number to display the Report Viewer and view the report in a separate browser tab.
   
   Amounts that display as hyperlinks identify totals for transactions that were posted during an Accounting Period and for a specific GL Account number. Click a hyperlink to access the Ledger Inquiry Report, and from there continue to drill-down directly into the related transactions.
   
   Note: Hyperlinked amounts for access to the Ledger Inquiry Report are not applicable when a Consolidations-Transactional Ledger is selected.
   
   
   Note: Click here to view the above image in full screen. 

Return to top

Run a Trial Balance Report

The Trial Balance Report is a worksheet that compiles all debit and credit accounts for a Ledger. This data can be presented on a report for a specific Accounting Period.

Important: If you want to run this report for a Consolidations Ledger, in order for the Opening Balance to be populated, run the Consolidations routine on the prior Accounting Period. Then, rerun the Trial Balance report for the Consolidations Ledger and the Accounting Period currently selected. 

1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Standard menu, click Trial Balance.
2. Update the required fields, as necessary. Required fields display with a red asterisk (*).
   
   1. Ledger -  this can be a Transactional, Consolidations-Transactional, or Eliminations Ledger. This populates with the system Default Ledger or the Ledger for the current user (if a Ledger was selected in the Ledger Manager). If more than one Ledger is available, click the X to clear the default Ledger and then search for and select another one.
   2. Currency - only displays if Multi-currency is enabled. When you initially access the Profit & Loss Report, the Currency field defaults to the currency of the selected Ledger. If you change the Ledger, the Currency field will automatically change based upon the selected Ledger. For example, you might select a GBP Ledger, the Currency field would automatically populate with GBP. Additionally, you can click the Currency drop-down list to select the currency to include on the report. This provides a way to include the Ledger currency on the report, as well as data for the parent currency, which can be selected from this Currency drop-down list. Otherwise, you can select the same currency as the Ledger currency to only view data for the base currency.
   3. Accounting Period - click the X to clear the default period. The Accounting Period defaults to the first open period.
3. Complete any or all of the following optional fields:
   
   1. Suppress Zero Amount Rows - this checkbox defaults to selected. De-select this checkbox to include rows with zero amounts.
      
   2. Suppress Opening Balance and Period Columns - this checkbox provides the ability to only display amounts in the Year-to-Date column on the report when it is viewed. The Opening Balance column and the selected period(s) column will not display on the report when this checkbox is selected (enabled).
      Note: If you have Multi-currency enabled, this checkbox defaults to selected.
   3. Report Subtitle - enter a subtitle in the textbox. This will display in the Report Viewer directly under the report name. The Report Subtitle can also be added/modified from the Report Viewer.
   4. GL Account Variables 1-4 - enter one or more of the four variables. These are traditional Sub-General Ledger account segments used to filter the report results on divisions, departments, geographies, cost centers, profit centers or business units. If you include GL Account Variables, they will display in the Report Viewer on the generated report.
      
      Important If Header Level Post is enabled in the Post Settings screen, the GL Account Variables 1-4 will not be available as selections on the Trial Balance. GL Account Variables will only be available to select if Line Level Post is enabled in the Post Settings.
      
      
4. Click Run. Based upon valid criteria entered/selected, a message displays to indicate the report is being generated. Another message will display when the report generation completes. The new report displays as the first report in the Reports data grid at the bottom of the screen.
   
5. Click the Report Number to display the Report Viewer and view the report in a separate browser tab.
   
   The report includes the Opening Balance, selected Accounting Period, and Year to Date amounts for each GL Account.
   
   Amounts that display as hyperlinks identify totals for transactions that were posted during an Accounting Period and for a specific GL Account number. Click a hyperlink to access the Ledger Inquiry Report, and from there continue to drill-down directly into the related transactions.
   
   Note: Hyperlinked amounts for access to the Ledger Inquiry Report are not applicable when a Consolidations-Transactional Ledger is selected.
   
   Note: The Expand All and Collapse All links are not applicable when using the Report Viewer to view a Trial Balance Report.
   
   
   Note: Click here to view the above image in full screen. 
   

Note: The Opening Balance will generally equal the Closing Balance from the previous period. However, if balances were translated in the prior period, the current period Opening Balance may be translated using a different rate and therefore may not equal the prior period Opening Balance.

Return to top

Run a Cash Flow Report

The Cash Flow Report summarizes the amount of cash from ongoing operations and external investment sources, as well as cash equivalents that enter and leave a company. 

Note: Cash Receipts, Cash Disbursements, and Journal Entry Lines must have a Cash Flow Category specified for the period selected. If this information is missing, a message will display when you attempt to run the report. The records would need to be unposted, have the Cash Flow Category added, and then reposted in order to run the report successfully.

The Net increase (decrease) in cash row on the Cash Flow Report is calculated based upon the difference between the Ending Cash Balance row and the Beginning Cash Balance row. The Beginning Cash Balance is calculated as the aggregated balance for all Bank GL Accounts for the prior period. The Ending Cash Balance is calculated as the aggregated balance for all Bank GL Accounts for the current period. The rows between Beginning Cash Balance and Ending Cash Balance are reporting rows for Cash Flow categories. The Year-to-Date column contains historical data, which is best understood when the Show All Periods checkbox is selected for running the report.

1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Standard menu, click Cash Flow.
2. Update the required fields, as necessary. Required fields display with a red asterisk (*).
   
   1. Ledger -  this can be a Transactional, Consolidations-Transactional, or Eliminations Ledger. This defaults to the system Default Ledger or the Ledger for the current user (if a Ledger was selected in the Ledger Manager). If more than one Ledger is available, click the X to clear the default Ledger and then search for and select another one.
   2. Currency - only displays if Multi-Currency is enabled. When you initially access the Profit & Loss Report, the Currency field defaults to the currency of the selected Ledger. If you change the Ledger, the Currency field will automatically change based upon the selected Ledger. For example, you might select a GBP Ledger, the Currency field would automatically populate with GBP. Additionally, you can click the Currency drop-down list to select the currency to include on the report. This provides a way to include the Ledger currency on the report, as well as data for the parent currency, which can be selected from this Currency drop-down list. Otherwise, you can select the same currency as the Ledger currency to only view data for the base currency.
   3. Accounting Period - click the X to clear the default period. The Accounting Period defaults to the first open period.
3. Complete any or all of the following optional fields:
   
   1. Show All Periods - select this checkbox if you want to include all Accounting Periods for the current year. Otherwise, if this is not selected only the selected Accounting Period and the Year to Date amounts will display on the report in the Report Viewer.
      
   2. Suppress Zero Amount Rows - this checkbox defaults to selected. De-select this checkbox to include rows with zero amounts on the report.
   3. Report Subtitle - enter a subtitle in the textbox, which displays on the report under the title. The Report Subtitle can also be updated/modified from the Report Viewer.
   4. Report Rounding - the default that displays is based upon the Default Rounding selection on the Report Settings tab.
      1. No Rounding - this selection will not round up or down the amounts that display on the report.
         
      2. Whole Numbers - rounds up to the nearest whole number.
         
      3. Rounds to 1000s - rounds the amounts on the report to the nearest 1,000. 
         
   5. GL Account Variables 1-4 - enter one or more of the four variables. These are traditional Sub-General Ledger account segments used to filter the report results on divisions, departments, geographies, cost centers, profit centers or business units. If you include GL Account Variables, they will display in the Report Viewer on the generated report.
      
      Important If Header Level Post is enabled in the Post Settings screen, the GL Account Variables 1-4 will not be available as selections on the Cash Flow Statement. GL Account Variables will only be available to select if Line Level Post is enabled in the Post Settings
      
      
4. Click Run. Based upon valid criteria entered/selected, a message displays to indicate the report is being generated. Another message will display when the report generation completes. The new report displays as the first report in the Reports data grid at the bottom of the screen.
   
5. Click the Report Number to display the Report Viewer to view the report in a separate browser tab.
   
   The report includes all the Accounting Periods for the current year (if Show All Periods was checked), the selected Accounting Period, and Year to Date amounts.
   
   
   Note: Click here to view the above image in full screen. 
   
   Amounts that display as hyperlinks identify totals for transactions that were posted during an Accounting Period. Click a hyperlink to access the Financial Report Transactions screen, and from there continue to drill-down directly into the related transactions.
   
   Note: Hyperlinked amounts are not applicable when a Consolidations-Transactional Ledger is selected.
   
   
   Note: Click here to view the above image in full screen. 
   

Return to top

Run a Ledger Inquiry Report

The Ledger Inquiry screen will automatically display with selected details and related transaction numbers when you drill-down from a hyperlink on the following reports:

• Profit & Loss
• Profit & Loss versus Budget
• Balance Sheet
• Trial Balance

From the Report Results data grid, you can click a transaction hyperlink to drill-down to review the actual transaction details. 

When the Ledger Inquiry Report is accessed from one of the reports listed above, the Report Statistics section includes information such as the Opening Balance, Inquiry Amount, and Year to Date Balance. The Ledger Inquiry Report can also be accessed directly from the Select Standard Report drop-down list. And, when a GL Account is entered, the Report Statistics section will also populate. Values display in the Report Statistics section based upon the following:

• Opening Balance - for all GL Accounts, the Opening Balance aggregates from the Total Balance of any transactions that are before the selected Starting Accounting Period. For example, the Starting Accounting Period might be set to 2021-07. The Closed Accounting Period was 2021-06. Using this example, the Opening Balance in the Report Statistics section for a selected GL Account would display the Total Balance from the 2021-06 Accounting Period as the Opening Balance. 
• Inquiry Amount - displays the total amount of the transactions from the Report Results data grid. If you clicked a hyperlink from a Standard Report to access the Ledger Inquiry, the Inquiry Amount is also the amount of the link that you clicked. 
• Year to Date Balance - for Balance Sheet GL Accounts, the Year to Date Balance aggregates the total from the beginning of the GL Account to the current date. For Revenue and Expense GL Accounts, this balance only aggregates the total from the beginning of the year to the Ending Accounting Period. 

Up to 50 transactions per page will display in the Report Results data grid. If more than 50 transactions are available, you can click the next page number or click Next to view additional results. 

1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Standard menu, click Ledger Inquiry.
                                                           -OR-
   From the Report Viewer, when viewing a Profit & Loss, Profit & Loss versus Budget, Balance Sheet, or Trial Balance Report, click a hyperlink amount to display the Ledger Inquiry.
   
   Tip: If you accessed the Ledger Inquiry screen from one of the reports listed above and you want to make changes to what displays, continue with the steps below. Refreshing the screen will not remove the existing values.
   
   
2. Update the required fields, as necessary. Required fields display with a red asterisk (*).
   
   1. Ledger - this can only be a Transactional Ledger or an Eliminations Ledger. This populates with the system Default Ledger or the Ledger for the current user (if a Ledger was selected in the Ledger Manager). If more than one Ledger is available, click the X to clear the default Ledger and then search for and select another one.
   2. Starting Accounting Period - click the X to clear the default period. Then, search for and select a different period. The Starting Accounting Period defaults to the current Accounting Period minus 12 periods. If 12 periods do not exist, the system will display the earliest period that is less than 12 periods.
   3. Ending Accounting Period - click the X to clear the default period. Then, search for and select a different period. The Ending Accounting Period defaults to the current period.
3. Complete any or all of the following optional fields:
   
   1. GL Account - search for and select a GL Account.
      Note: The Project, Project Task, Product, and Account fields are enabled when a GL Account (Balance Sheet, Revenue, or Expense) is selected or if the GL Account field is blank.
      
      When a GL Account is entered, the Running Balance totals for the GL Account displays in the report data grid, as in the sample screen below. Additionally, the Running Balance totals for the GL Account will be included on the Excel spreadsheet.
      
      Note: If no GL Account is entered, the Running Balance column will be blank in the report data grid. And on the Excel spreadsheet the Running Balance column will display with zeros (0.00).
      
      Running Balance Calculation
      
      Opening Balance + Total Amount on the first row = Running Balance for the first row
      
      Sample screen below, Open Balance (300.00) + Total Amount on the first row 1,150.13 = Running Balance for the first row of 850.13
      
      Running Balance amount on the first row + Total Amount on the second row = Running Balance for the second row (and so forth with additional rows)
      
      Sample screen below, Running Balance amount on the first row 850.13 + Total Amount on the second row 1150.13 = Running Balance for the second row of 2,000.26
      
      Note: As mentioned earlier in this article, the column headings are sortable. Therefore, if you sort a column, the Running Balance will be recalculated based upon the updated sort.
      
      
      Note: Click here to view the above image in full screen. 
      
      
   2. Source - this drop-down list defaults to All. To filter, click the drop-down list to view the available sources, which are listed in the sample screen below. To select more than one of the available sources, press Shift and make your selections. A checkmark displays to the left of each selected source.
      
      
      
      
   3. Aggregate By - this report can also be set to run aggregated based upon the fields on the report. The default is None, which will include all available values in the related column headings on the report. In the sample screen below “None” was selected in the Aggregate By drop-down list. Based upon the criteria selected, using this example, all available values that match the criteria displayed on the report, including GL Accounts, Customer/Vendor Accounts, and Accounting Periods.
      
      
      Note: Click here to view the above image in full screen. 
      
      In the sample screen below “GL Account” was selected in the Aggregate By drop-down list. The sample report includes the GL Accounts and the Total Amounts for each GL Account.
      
      
      Note: Click here to view the above image in full screen. 
      
      
   4. GL Account Variables 1-4 - enter one or more of the four variables. These are traditional Sub-General Ledger account segments used to filter the report results on divisions, departments, geographies, cost centers, profit centers or business units.
      
   5. The following four fields will only be enabled when a Balance Sheet, Revenue or Expense GL Account is selected in the GL Account field or if the GL Account field is blank. Search for and select one or all of these fields.
      
      1. Project - encompasses everything that needs to be completed in order to reach a specific outcome on an engagement or event.
      2. Project Task - a single element or component of work that needs to be accomplished within a project.
      3. Product - an article or substance that is manufactured or refined for sale. Something that is produced by labor.
      4. Account - the name of the customer or vendor.
4. Click Run. Report Results display based upon the selected criteria.
   
   
   Note: Click here to view the above image in full screen. 
   
   
5. Click Export to Excel to export the report to an Excel spreadsheet. You can view the downloaded spreadsheet and save it, as needed. 
   

Rerun a Standard Report from the Report Viewer

After a report has been generated, you can rerun it to update the data with the very latest information. For example, you may have run a Profit & Loss Report last week. However, since that time, transactions have been updated and posted. Using this example, you can rerun the report to include the updated/additional data. By simply clicking the Rerun button from the Report Viewer, the report will be generated with the same filters, but will include the updated information. Using the Rerun button will be a timesaver to quickly and easily rerun a report. The Rerun button is included on the Report Viewer for the following Standard Reports:

• Profit & Loss
• Profit & Loss versus Budget Report
• Balance Sheet  
• Trial Balance 
• Cash Flow  

For existing Accounting Seed users, if the Rerun button is clicked for a report that was generated prior to the the Winter ‘23 release upgrade, any optional settings (Include Subtype 1, Include Subtype 2, Suppress Opening Balance and Period Columns, Suppress Zero Amount Rows, Show all Periods, and/or Report Subtitle) that were included on the initial report will not be stored on the Financial Report Result. Therefore, these optional settings will be ignored when such a report is rerun.

Best Practice: Click Run from the Standard Reports screen to generate the report. Then, after this initial run, the Rerun button can be used to re-generate the report with the selected optional settings.

Rerun a Standard Report

1. From the Reports data grid, click the hyperlink for the report that you want to rerun.
   
   
   Note: Click here to view the above image in full screen. 
   
   The report displays in the Report Viewer.
   
   
2. Click Rerun.
   
   
   Note: Click here to view the above image in full screen. 
   
   The “Report generation is in progress” message displays.
   
   
3. When the report has been generated, the “Report generation is complete” message displays. Click the here hyperlink to view the updated version of the report.
   
   
   
   Note: The “Report generation is complete. View it here” message only displays for a few seconds. If you missed the message or did not have time to click the “View it here” hyperlink, the “rerun” version of the report will also be available at the top of the Reports data grid, and can be clicked from the data grid to view the report.
   

Return to top

Export a Standard Report

A Standard Report that is displayed in the Report Viewer can be exported into Excel or a PDF version can be created. Exported reports are only exported in the expanded-all view.

1. From the Standard Reports tab, select a Report Number from the Reports data grid on one of the following reports:
   
   1. Profit & Loss
   2. Profit & Loss versus Budget
   3. Balance Sheet
   4. Cash Flow.
      
      In the sample screen below a Profit & Loss Report Number was selected.
      
      
      Note: Click here to view the above image in full screen. 
      
      
2. Click the Export drop-down list and select one of the following:
   
   1. Excel - the file downloads. It can be opened and saved to a desired location.
   2. PDF - the file displays. View the information and save, as necessary.
      
      The sample screens below include an Excel file and PDF file, respectively.
      
      
      Note: Click here to view the above image in full screen. 
      
      
      Note: Click here to view the above image in full screen. 

Return to top

Delete one or more Standard Reports

Up to 25 reports per page can be deleted by selecting the checkbox that displays to the left of the Report Number column heading and clicking the Delete Reports button. Otherwise, if you do not want to delete all the reports on a single page, you can select the checkbox next to each individual report and then click Delete Reports to delete the selected report(s).

Note: Click here to view the above image in full screen. 

Return to top