Management Reports & Dashboards

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 on your needs. It is a best practice to create your own folders for reports you frequently use, and to first 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.

Below are 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.

 

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.

Billed Opportunities

  • Shows opportunities that are closed/won and billed. This can be used to verify that all opportunities for that week/month have been fully billed. This can also be used to see what opportunities have not been billed.

Billing Aging by Customer - Current

  • Shows uncollected billings by aging category as of today. This is used to see the current open receivables and what is overdue so that you can follow up with your customers.
  • This report defaults to show only posted receivables. If you want to see unposted receivables, then adjust the Posting Status filter.

Billing Aging by Customer - Historical

  • Shows historical billings by aging category. This report will show open 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. 2018-01 for January for a calendar year business)

Billings by Customer and Period

  • 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

  • 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

  • Shows all cash disbursements grouped by its related batch.

Expiring Payment Methods

  • Shows payment methods grouped by expiration date.
  • This is beneficial to run prior to charging customer’s credit cards on file

Net Value of Fixed Assets

  • 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

  • Shows unpaid payables by 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 posted payables. If you want to see unposted payables, then adjust the Posting Status filter.

Payables Aging by Payee - Historical

  • Shows historical payables by 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. 2018-01 for January for a calendar year business)

Payables with Prepaid Expenses

  • 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

  • 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. 2018-01 for January for a calendar year business)

Project Net Profit

  • 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 Cards by Employee and Period

  • 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

  • Shows all transactions by GL account.
  • You may want to filter by a specific GL account and/or period.

Unapplied Cash Receipts

  • 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.



Accounting Dashboard Folder

There is 1 accounting dashboard that includes 9 reports. These can be modified as needed.

Current Open A/R Aging

  • This shows current open A/R by age bucket.

Historical A/R by Period

  • This shows the ending A/R balance by period.
  • The Enable Billing Period Sensitive Aging checkbox in the Accounting Settings tab must be checked. Also, the accounting period must be closed.

Billings by Period

  • This shows total amount billed to all customers by period.

Current Open A/P Aging

  • This shows current open A/P by age bucket.

Historical A/P by Period

  • This shows the ending A/P balance by period.
  • The Enable AP Period Sensitive Aging checkbox in the Accounting Settings tab must be checked. Also, the accounting period must be closed.

Payables by Period

  • This shows total payables amount to all vendors by period.

Current Cash Balances

  • This shows the current balance for all GL accounts that have the Bank checkbox checked.
  • You may want to filter this report to only show bank GL accounts and not credit card GL accounts. Add the GL account equals filter to do this.

YTD Revenue vs Goal

  • This shows revenues vs goals.
  • Edit this report to enter in the goals in the formatting tab.

YTD Net Profit vs Goal

  • This shows net profit (revenues minus expenses) vs goals.
  • Edit this report to enter in the goals in the formatting tab.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.