Finance Power BI App for Aptean Equipment DMS
The Finance Power BI App for Aptean Equipment DMS provides a clear and centralized view of key financial metrics. It supports users in analyzing revenues, costs, liquidity and financial results, serving as a reliable foundation for controlling, financial reporting and strategic management decisions. This chapter describes the following report pages:
Shared Filters
The following page filters are displayed on multiple pages. They work the same way throughout the report and are documented here once.
| Filter | Function | Available on |
|---|---|---|
| Fiscal Year | Selects the fiscal year shown on the page | All pages |
| Global Dimension 1 & 2 | Filters by your company's two main analysis dimensions (typically Department and Project/Cost Center) | Cash Flow Forecast, Customer Payment Behavior |
| Shortcut Dimensions 3–8 | Additional dimension filters. Labels follow the dimension names configured in your system | Cash Flow Forecast, Customer Payment Behavior |
Cash Flow
The Cash Flow page gives you a running view of your actual liquidity across the fiscal year. It distinguishes between what money is owed to you (receivables) and what you owe to others (liabilities) and lets you compare a year's cash position against the previous year.
Note
Only G/L accounts tagged with a TRASER Cash Flow account type (Liquidity, Receivable, or Liability) are included on this page. This is a background setting configured by your system administrator.
| Visual | KPI / Field | Description |
|---|---|---|
| Cash Flow I and II with Liabilities and Receivables | Receivables | The total amount expected each month from accounts classified as receivables. |
| Liabilities | The total expected outgoing payments each month from accounts classified as liabilities, shown as a positive value. | |
| Cash Flow I | Running (cumulative) cash position built from bank and cash account movements only. This is your pure cash balance over time. | |
| Cash Flow II | Running liquidity including open items: Cash Flow I plus receivables minus liabilities, accumulated over the year. This is your projected liquidity once all open items are settled. | |
| Cash Flow I / II Last Year | The same Cash Flow I and II lines for the previous fiscal year, for direct year-over-year comparison. | |
| Year / Month | Time axis – one data point per month of the fiscal year. |
Cash Flow Forecast
The Cash Flow Forecast page provides a projection of your future cash movements based on the Microsoft Dynamics Business Central Cash Flow Forecast worksheet. By combining your forecast entries with your current bank balance, it estimates what your bank balance will be at the end of each month.
| Visual | KPI / Field | Description |
|---|---|---|
| Cash Flow Forecast Chart | Cash Flow Forecast Amount | Total expected money movement per month from the forecast – projected inflows and outflows from receivables, payables, orders, liquid funds, budgets, and more. Displayed as colour-coded columns. |
| Bank at End | Projected bank balance at the end of each month: actual bank balance plus accumulated forecast amounts from the start of the fiscal year. Displayed as a line. | |
| Source Type | A colour-coded legend breaking down the forecast columns by cash-flow source type: Liquid Funds, Receivables, Payables, Sales/Purchase Orders, Fixed Assets, G/L Budget, Services, Jobs, and Tax. | |
| Year / Month | Time axis (calendar year and month). |
Profit & Loss
The Profit & Loss page provides a structured overview of your income statement. You can view revenue, cost of goods sold (COGS), expenses and EBITDA as both monthly breakdowns and annual totals and compare the results with the previous year and your budget.
Page-Specific Filters:
- Budget Name – Select which Microsoft Dynamics Business Central G/L budget to compare against the actual figures.
- Only G/L entries belonging to the TRASER P&L reporting structure are included. This background filter is configured by your system administrator.
| Visual | KPI / Field | Description |
|---|---|---|
| P&L Monthly Overview | Current Year | Actual general ledger amounts per P&L reporting line, spread across the months of the fiscal year. |
| Month (short) | Months of the fiscal year displayed as columns. | |
| Reporting Type / Subtype | The P&L reporting structure used as row labels, covering Revenue, COGS, Expenses, EBITDA and their subtypes. | |
| P&L Totals Overview | Current Year | The total actual general ledger amount for each reporting line in the selected fiscal year. |
| Previous Year | The same actual amounts for the previous fiscal year, for year-over-year comparison. | |
| Budget Current Year | The budgeted amount for each reporting line in the current fiscal year. | |
| Budget Previous Year | The budgeted amount for each reporting line in the previous fiscal year. | |
| "Selected Line" – Current/Previous Year | Current Year | Monthly actual amounts for the P&L line you select in the totals overview (revenue shown as positive). |
| Previous Year | Same figure for the previous fiscal year (year-over-year view). | |
| Year / Month | Monthly time axis. | |
| "Selected Line" Budget – Current/Previous Year | Budget Current Year | Monthly budgeted amounts for the selected P&L line (defaults to EBITDA). |
| Budget Previous Year | The same budgeted amounts for the previous fiscal year. | |
| Year / Month | Monthly time axis. |
Customer Payment Behavior
The Customer Payment Behavior page helps you monitor outstanding invoices and evaluate how reliably your customers pay. You can filter the data by customer or invoice number to focus on specific open receivables.
Page-Specific Filters:
- Customer / Document No. – Filter to a specific customer or invoice document number.
- Payment and refund entries are excluded so the page focuses on invoices and credit memos. This is a background filter.
- The Open Invoices table automatically shows only open, overdue invoices. This is a background filter.
- The Customer With Open Invoices table automatically shows only customers with at least one open invoice. This is a background filter.
| Visual | KPI / Field | Description |
|---|---|---|
| Customer With Open Invoices | Open Invoices (count) | The total number of open, unpaid invoices for each customer. |
| Average Days Late | The average number of days a customer's invoices are paid late, indicating how reliably the customer pays on time. | |
| Open Amount | The total outstanding receivable for each customer – the sum of all amounts still owed. | |
| Customer No. / Name | The customer's identifying details, sourced from the Microsoft Dynamics Business Central customer card. | |
| Open Invoices | Invoice Amount | The original amount charged on each invoice. |
| Days Late | How many days the invoice is or was overdue: from the due date to the payment date – or to today if it is still unpaid. Never shown as a negative value; applies to invoices only. | |
| Document No. / Customer Name / Document Date / Due Date | Key identifying details for each invoice, drawn from the Microsoft Dynamics Business Central customer ledger. |