The release of Acumatica ERP 2021 R1 earlier this year introduced a couple of new Financial Dashboards as well as a change in how they’re implemented. Starting with 2021 R1, Acumatica Financial Dashboards are now included with the core ERP product and no longer require a customization project. With that in mind, let’s take a closer look at the three new and powerful AR and AP Clerk Dashboards as well as a Controller Dashboard.
AR Clerk Dashboard
For the Accounts Receivable clerk focusing on customer management, sales and credit, the following new dashboard release in Acumatica 2021 R1 is now available:
Here’s a summary of just a few of the key performance indicators (KPIs) and visual charts that are available in this new dashboard:
Documents on Hold – All AR documents and payments with the On Hold status
Unreleased Documents in Prior Months – All unreleased AR documents, payments, and applications that are dated in prior months
Documents to Release (Current Period) – All AR documents, payments, and applications that are ready to be released
Rejected Funds – All customer refunds with the Rejected status
Payments to Apply – All AR payments with the Open status and without unreleased applications
Invoices to Print – All AR documents with the Balanced or Open status, and with the Printed and Don’t Print check boxes cleared on the Invoices and Memos form
Invoices to Email – All AR documents with the Balanced or Open status, and with the Emailed and Don’t Email check boxes cleared on the Invoices and Memos form
Statements to Print – All unprinted customer statements that have the ‘Don’t Print’ check boxes cleared on the Print Statements form
Statements to Email – All unsent customer statements that have the ‘Don’t Email’ check box cleared on the Print Statements form
Customers on Credit Hold – All customers with the Credit Hold status
Customers Exceeding Credit Limit – All customers for which Credit Limit or Limit and Days Past Due has been exceeded
Average Days to Pay – The average difference (in days) between the payment date and the invoice’s due date for all paid invoices (with the Closed status) starting from the first day of the quarter before the current one
Days Sales Outstanding – The average number of days that the company takes to collect revenue after a sale has occurred
Cash Inflow for 7 Days The summary of AR document balances that are overdue and due within seven days of today
AR Overdue – The summary of overdue customer balances as of the current day
AR Aging – The summary of AR document balances that are current and overdue as of the current day, split into aging buckets (30 days, 31 to 60 days, etc.)
Overdue by Salesperson – The 10 salespersons whose customers have the highest overdue balances, split by customer
And several other KPIs or charts not mentioned above.
AP Clerk Dashboard
For the Accounts Payable clerk focusing on vendor management and payments, the following new dashboard is now available:
Similar to the AR Clerk Dashboard but on the other side of the ledger in accounts payable, the new AP Clerk Dashboard includes similar KPIs and charts such as documents on hold, unreleased documents in prior months, documents to release, AP overdue, AP aging, etc.
That said, here are a few of the AP-focused KPIs included in this dashboard:
Bills to Pay – All overdue AP documents and documents that will be due within 7 days
Payments to Approve – All AP payments with the Pending Approval status
Rejected Payments – All customer refunds that have the Rejected status
Payments to Process – All AP payments that need to be printed (Pending Print status)
Vendors on Payment Hold – All vendors that have the Hold Payments status
Cash Discount to Take in 7 Days – The summary of cash discounts of the released and unreleased AP documents that can be taken within 7 days
Cash Outflow for 7 Days – The summary of AP document balances that are past due and due within 7 days of today
AP Overdue – The summary of overdue vendor balances as of the current day
Top 10 Overdue Balances – The 10 vendors with the highest overdue balances
Vendor Purchasing Trends – The seven vendors with the highest summary document amount during the quarter
Other metrics are included in the live Acumatica dashboards but not specifically listed above.
Controller Dashboard
For the Controller focusing on financial management, the following new dashboard is now available in Acumatica 2021 R1:
Key components of the Controller Dashboard include:
Quick AR and AP Access – quick and easy access to both AR and AP Clerk Dashboards (above) via clickable link.
Total AR and AR Overdue – The actual summary of customer balances as well as the summary of balances overdue as of the current day
Open SO Amount – summary of amounts of open sales orders, cash sales and invoice order types
Customers on Credit Hold – All customers with the Credit Hold status
Total AP and AP Overdue – summary of vendor balances as well as overdue vendor balances as of the current day
Open PO Amount and Payments to Approve – summary amount of open purchase orders as well as payments with Pending Approval status
Vendors on Payment Hold – All vendors with the Hold Payments status
Cash on Hand – The summary of cash account balances or all active cash accounts for the current month
Cash Demand 30 Days – The summary of balances of all overdue AP documents that will be due within 30 days
Unreconciled Transactions – The number of unreconciled transactions that are more than 30 days old
AR and AP Aging – summary of balances past due, in aging buckets
Expenses – several KPI components displaying expenses by category (class) for the current month, quarter, and year
Income vs Expense – comparison of income and expenses for each quarter as well as for each month
Cash Position – summary of cash account balances for all active cash accounts during the past 12 months
Acumatica 2021 R1
These new and powerful financial dashboards are now available in Acumatica ERP. Check out our notes and highlights on Acumatica 2021 R1 for the full range of new features in the latest release. Be sure to click below to find an Acumatica Partner in your local area if you need support, training, other help with the software, or just have a general question.
NEW: Check out the new Payroll Dashboards released in Acumatica 2021 R2
