New Acumatica Dashboards for Financial Management

acumatica dashboards

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:

acumatica AR clerk dashboard

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:

acumatica ap clerk dashboard

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:

acumatica controller dashboard

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.

Need Help with Acumatica?

Click below to find an Acumatica partner in your local area that can provide a demo, quote, consulting or software support.

 

Need ERP Support?

Click to find a Sage or Acumatica partner in your local area.

GET OUR NEWSLETTER!

Join your fellow Sage & Acumatica customers & partners who get our helpful tips sent straight to their inbox!

Success! Get ready for some great articles coming your way soon ...