Management Reports and Dashboards

Body

Overview

After Accounting Seed is installed, there will be two new report folders, Accounting Reports and Accounting Dashboard. The Accounting Reports folder will include some helpful reports that can be easily modified based upon your needs. 

Note: If you have the Orders & Inventory package installed, the Accounting Seed ERP report folder will also be available.

Best Practice: Create your own folders for reports you frequently use. Also, clone and rename one of the out-of-the-box reports before modifying it so that you will always have access to the original report.

This article provides some basic information about Management Reports and Dashboards. For more extensive information, refer to Salesforce's Trailhead Learning, which include modules such as the following:

Below is a listing of the included reports, a brief description, and guidance on how to use them. If you have any questions about the out-of-the-box reports, please submit a ticket to our Support Team. If you have questions about custom reports, it is best to reach out to the creator of that report.

For additional information, click a link below: 

Accounting Reports Folder

Some of these reports have a required filter that must be populated before the report will return any results. This will be noted in the report description below.

To access the reports folder, navigate to Accounting Home and click the Run Reports tab. Then, under the Custom menu, click Management Reports, and select All Reports. From this point, you can search for a select the desired Report Name.

Report NameDescription
Accounting Period Recurring Tasks ReportThis shows the Accounting Period Recurring Tasks by task name, username who was assigned to the task, the subject, date, priority, and status.
Actual and Budget Time CardThis report includes Time Card information with Time Card Lines for Actual and Budget Time Cards, along with the Project/Project Tasks, and Total Hours.
Automated Job ResultsThis report shows the results from all of the automated jobs that are run, including links to the related exception reports detailing any failures.
Billing OpportunitiesThis report shows opportunities that are closed/won and billed. This can be used to verify that all opportunities for the week/month have been fully billed. This report can also be used to see what opportunities have not been billed.
Billing Aging by Customer - CurrentThis report shows uncollected Billings by the aging category as of today. This is used to see the current open Account Receivables and what is overdue so that you can follow up with your customers. This report defaults to show only posted Account Receivables. If you want to see unposted receivables, then adjust the Posting Status filter.
Billing Aging by Customer - Historical

This report shows historical Billings by the aging category. This report will show open Account Receivables for a prior period. For example, if a receivable was open at the end of January, but payment has since been received, then it will not show up on the Billing Aging by Customer - Current report, but it will show up on this Historical report if it is ran for January.

Required Filter: Accounting Period (i.e. 2021-01 for January for a calendar year business)

Billing Email Exception Report This report shows all Billings that failed to send an email based upon the Automated job.
Billings by Customer and Period

This report shows all open and closed Billings by Customer and Accounting Period.

You may want to add an Accounting Period filter to narrow the results.

Billings with Deferred Revenue

This report shows all Billings that have Deferred Revenue entries.

You may want to filter by Customer Account and Accounting Period to narrow the results.

Cash Disbursements by Batch This report shows all Cash Disbursements grouped by the related batch.
Exceptions: AP Recurring Tasks This report shows exceptions for the Accounting Period Recurring Tasks that failed to create a task during the Automated job.
Exceptions: Automated Email Billing Job This report shows exceptions for all Billings that failed to send a Billing PDF Email during the Automated job.
Exceptions: Consolidations Routine
This report shows exceptions for the Run Consolidations routine that failed to complete after the Run button was clicked to run the routine.

Note: The Last Period Run: Accounting Period Name column identifies the last period for which the Consolidations Routine was attempted, regardless of whether it ran successfully or failed. The Last Period: Accounting Period Name (without the word “run” as a suffix) column identifies the last period for which the routine ran successfully.
Exceptions: Recurring Billing Job This report shows exceptions for Recurring Billings that failed to create a Billing during the Automated job.
Exceptions: Recurring Journal Entry Job This report shows exceptions for Recurring Journal Entries that failed to create a Journal Entry during the Automated job.
Exceptions: Recurring Payable Job This report shows exceptions for Recurring Payables that failed to create a Payable during the Automated job.
Exceptions: Scheduled Post Job - APD This report shows exceptions for AP Disbursements that failed to post during the Schedule Post job.
Exceptions: Scheduled Post Job - BCR This report shows exceptions for Billing Cash Receipts that failed to post during the Schedule Post job.
Exceptions: Scheduled Post Job - Billings This report shows exceptions for Billings that failed to post during the Schedule Post job.
Exceptions: Scheduled Post Job - CD This report shows exceptions for Cash Disbursements that failed to post during the Schedule Post job.
Exceptions: Scheduled Post Job - CR This report shows exceptions for Cash Receipts that failed to post during the Schedule Post job.
Exceptions Scheduled Post Job - JE This report shows exceptions for Journal Entries  that failed to post during the Schedule Post job.
Exceptions: Scheduled Post Job - Payables This report shows exceptions for Payables that failed to post during the Schedule Post job.
Exceptions: Scheduled Post Job - Time Cards This report shows exceptions for Time Cards that failed to post during the Schedule Post job.
Exceptions: Scheduled Post Job - Amortization This report shows exceptions for Amortizations that failed to post during the Schedule Post job.
Expiring Payment Methods This report shows Payment Methods grouped by expiration date. This is beneficial to run prior to charging a customer’s credit card(s) that is on file.
Next Value Of Fixed Assets This report shows Fixed Asset original value along with depreciation and net value.
If there are future depreciation entries in the system, then you will want to filter this report by the Accounting Period to only include the related depreciation entries.
Payables Aging by Payee - Current

This report shows unpaid Payables by the aging category as of today. This is used to see the current open Payables and what is overdue to your vendors.

This report defaults to show only the posted Payables. If you want to see unposted Payables, then adjust the Posting Status filter.

Payables Aging by Payee - Historical

This report shows historical Payables by the aging category. This report will show open Payables for a prior period. For example, if a Payable was open at the end of January, but has since been paid, then it will not show up on the Payable Aging by Payee - Current report, but it will show up on this Historical report if it is ran for January.

Required Filter: Accounting Period (i.e. 2021-01 for January for a calendar year business)

Payables with Prepaid Expenses

This report shows all Payables that have Prepaid Expense entries.

You may want to filter by Vendor Account and Accounting Period to narrow the results.

Profit & Loss by Variable

This report shows P&L with Variable 1 as a column. This can be replaced with a different Variable, if necessary.

Required Filter: Accounting Period (i.e. 2021-01 for January for a calendar year business)

Project Net Profit

This report shows inception to date Project profitability for all active Projects.

You may want to filter by Period and/or Customer to narrow the results.

Time Card Budget v Actual (Project) This report shows the Actual versus Budget Time Card by Project.
Time Card Budget v Actual (Project Task) This report shows the Actual versus Budget Time Card by Project and Project Task.
Time Card Budget v Actual (by Date) This report shows the Actual versus Budget Time Card by Project and Date.
Time Card Budget v Actual (by Period) This report shows the Actual versus Budget Time Card by Time Card Period.
Time Cards by Employee and Period

This report shows all Time Cards by Employee by Time Card Period.

You may want to filter by Period and/or Employee to narrow the results.

Transaction Detail by GL Account

This report shows all transactions by GL Account.

You may want to filter by a specific GL Account and/or Period.

Unapplied Cash Receipts

This report shows all unapplied Cash Receipts grouped by type. This is beneficial to run at the end of the month to see if any Cash Receipts should be applied to open Billings.

You may want to add a Period filter.

Return to top

Accounting Dashboard

The Accounting Dashboard is built on top of pre-configured Salesforce reports. The Accounting Dashboard presents a unified set of data about a series of different reporting topics, with a separate Dashboard for each topic. This provides a quick and easy way to monitor what is happening with system data, such as Billings and A/R Aging (Current Open A/R Aging Dashboard) or Payables and A/P Aging (Current Open A/P Aging Dashboard). Once you review a Dashboard, if more information is needed, a hyperlink to a report for viewing detailed data is available. Benefits of viewing the Accounting Dashboard included the following:

  • Timesaving and efficient way to view statistical data at a glance
  • Quick way to view key performance indicators
  • Provides real-time customer analysis data, which might be used for forecasting

The Accounting Dashboard is available in the Lightning UI. If a Dashboard was created in the Classic UI and it is edited in the Lightning UI, the message below displays. If you choose to continue to edit and save the Dashboard, it will automatically become a Lightning Experience Dashboard. As indicated by the message, a Lightning Experience Dashboard cannot be edited in the Classic UI. If it is a shared Dashboard, you might want to clone it instead.

DB_1.png

Accounting Dashboard

DB_2.png

Accounting Dashboard Report Names and Descriptions

Dashboard Chart NameSalesforce Report NameDescription
Current Open A/R AgingCurrent Open AR DashboardThis shows the current open A/R by age bucket.
Current Open A/P AgingCurrent Open AP DashboardThis shows the current open A/P by age bucket.
Current Cash BalancesCash Balances Dashboard ReportThis shows the current balance for GL accounts that have the Bank checkbox selected. 

You may want to filter this report to only show bank GL accounts, and not credit card GL accounts. To do this, add the GL account equals filter. 
Historical A/R by PeriodHistorical AR Dashboard This shows the ending A/R balance by period. 

The Enable Billing Period Sensitive Aging must be set to "On." Also, the accounting period must be closed.
Historical A/P by PeriodHistorical AP DashboardThis shows the ending A/P balance by period.

The Enable AP Period Sensitive Aging must be set to "On." Also, the accounting period must be closed.
YTD Revenue vs GoalRevenue Transaction DashboardThis shows revenues versus goals. Edit this report to enter the goals in the formatting tab. 
Billings by PeriodBillings by Period DashboardThis shows the total amount billed to all customers by period.
Payables by PeriodPayables by Period DashboardThis shows the total payables amount to all vendors by period.
YTD Net Profit vs GoalNet Profit Transactions for DashboardThis shows the net profit (revenues minus expenses) vs goals. Edit this report to enter in the goals in the formatting tab.
Accounting Period  Recurring Tasks ReportAccounting Period Recurring Tasks ReportThis shows the Accounting Period Recurring Tasks by task name, username who was assigned to the task, the subject, date, priority, and status.
Automated Job Results DashboardAutomated Job Results Dashboard This shows the Automated Job Results by date and Job Type with the sum of each job that processed, succeeded, or failed.

Return to top

Add a new Dashboard Component

  1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Custom menu, click Dashboards.
  2. From the Accounting Dashboard, click Edit.

    Dashboard_01.png 
  3. To add a new component, click + Widget. From the dropdown, select Chart or Table.



  4. Search for and select the new item that you want to add. Then, click Select.

    Dashboard_02.png 

    You can select a Display As option. For example, when adding the Automated Job Results Dashboard, you might want to select the Lightning Table for the Display As option. Then, view the Preview panel on the right to determine how the Dashboard will display on the Accounting Dashboard. Additionally, you can adjust the Columns, Sort By, and other information from the left panel.

    Dashboard_04.png  

  5. Click Add.
    Note: Once the new component has been added, you can rearrange the display of the Dashboards, if necessary.
  6. Click Save.
  7. Click Done. The newly added Widget displays as part of the Accounting Dashboard.

View Dashboard As Setting

The View Dashboard As setting controls whose data the Accounting Dashboard displays when viewed. Salesforce offers three options:

  • Me: The dashboard displays data as the dashboard owner. All viewers see the same data regardless of who is logged in.
  • Another Person: The dashboard displays data as a specific user you designate.
  • The dashboard viewer: The dashboard displays data as the person currently logged in, so each viewer sees their own data. Salesforce calls this a dynamic dashboard and limits the number of dynamic dashboards allowed per org.

As of Summer '26, the Accounting Dashboard defaults to View Dashboard As: Me. This prevents installation failures in organizations that have reached Salesforce's dynamic dashboard limit.

Note: Organizations upgrading to Summer '26 retain their existing View Dashboard As setting. For new installations, View Dashboard As: Me is applied automatically.

To change the View Dashboard As setting:

  1. Navigate to Accounting Home and click the Run Reports tab.
  2. Under the Custom menu, click Dashboards.
  3. From the Accounting Dashboard, click Edit.
  4. Click the gear (Edit Dashboard Properties) icon.
  5. Under View Dashboard As, select Me, Another Person, or The dashboard viewer.
  6. Optionally, select Let dashboard viewers choose whom they view the dashboard as to allow viewers to switch the setting themselves.
  7. Click Save.

 

Return to top

 

Title
Management Reports and Dashboards
URL Name
304616301
ReportingReports Overview
Skip Feed

  1. kkampmann1 (Customer)

    February 23, 2021 at 11:55 AM

    In the past, you used to supply starter management reports for the balance sheet, but you no longer do. Any reason for that? 

    For those balance sheet starter reports, you used the Financial Cubes With and Without Financial Cube Transactions as the report type. Is that still the correct report type to use if we want to create a balance sheet report in Salesforce? 

    Thanks, 

    End of Feed
    1 Chatter Feed Items