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
Accounting Dashboard
Add a new Dashboard Component

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 Name	Description
Accounting Period Recurring Tasks Report	This 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 Card	This 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 Results	This report shows the results from all of the automated jobs that are run, including links to the related exception reports detailing any failures.
Billing Opportunities	This 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 - Current	This 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.

Accounting Dashboard

Accounting Dashboard Report Names and Descriptions

Dashboard Chart Name	Salesforce Report Name	Description
Current Open A/R Aging	Current Open AR Dashboard	This shows the current open A/R by age bucket.
Current Open A/P Aging	Current Open AP Dashboard	This shows the current open A/P by age bucket.
Current Cash Balances	Cash Balances Dashboard Report	This 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 Period	Historical 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 Period	Historical AP Dashboard	This 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 Goal	Revenue Transaction Dashboard	This shows revenues versus goals. Edit this report to enter the goals in the formatting tab.
Billings by Period	Billings by Period Dashboard	This shows the total amount billed to all customers by period.
Payables by Period	Payables by Period Dashboard	This shows the total payables amount to all vendors by period.
YTD Net Profit vs Goal	Net Profit Transactions for Dashboard	This 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 Report	Accounting Period Recurring Tasks Report	This 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 Dashboard	Automated 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

Navigate to Accounting Home and click the Run Reports tab. Then, under the Custom menu, click Dashboards.
From the Accounting Dashboard, click Edit.
To add a new component, click + Widget. From the dropdown, select Chart or Table.
Search for and select the new item that you want to add. Then, click Select.

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.
Click Add.
Note: Once the new component has been added, you can rearrange the display of the Dashboards, if necessary.
Click Save.
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:

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

Return to top

Title

Management Reports and Dashboards

URL Name

304616301