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 ERP 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 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. |
| Vendor Merchant Analysis |
This report will be used as part of your onboarding with AP Automation. Our onboarding team will ask you to run this report, which they will send to Edenred Pay for Vendor Analysis. Our team will report back to you with information from Edenred regarding potential savings and rebate opportunities for the business. |
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 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. |
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 + Component.
- Search for and select the new component 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 component displays as part of the Accounting Dashboard.
____________________
Summer '24 Release
The Vendor Merchant Analysis Report was added.
Comments
1 comment
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,
Please sign in to leave a comment.