Use Wiise Financial Dashboards in Power BI 

Profit and Loss Metrics 

Metric 

Calculation 

Objective 

Total revenue 

Sum of General Ledger Entry amounts where Account Category = Income. 

The total income earned from sales before deducting expenses. This metric measures overall business performance, tracks growth, and shows how effectively the company is generating income. 

Total cost of goods sold 

Sum of General Ledger Entry amounts where Account Category = Cost of Goods Sold. 

The direct costs of producing goods or services sold. This figure is used to determine profit margins by showing how much it costs to generate sales revenue. 

Total expense 

Sum of General Ledger Entry amounts where Account Category = Expense. 

The total amount spent to operate the business, including costs beyond COGS. This helps assess overall profitability by showing the full cost of running the business. 

Gross Profit 

Gross Profit = Total Revenue - Total Cost of Goods Sold  

Helps you evaluate how efficiently your business produces goods or delivers services after accounting for the direct costs of sales. 

Net Profit 

Net Profit=Total Revenue - (Total Cost of Goods Sold + Total Expense) 

Helps you understand your company’s bottom-line profitability and its ability to generate sustainable earnings.  

Summary chart 

Income = Σ G/L Entry Amount for Income Statement 

This chart summarises your business’s financial performance by comparing income, expenses, gross profit, and net profit filtered by the account category and posting date. It helps you see how revenue translates into profitability. 

Gross Profit = Income – COGS 

Net Profit = Income – COGS - Expenses 

By GL account table 

Sum of G/L Entry Amounts for the month. 

This chart lets you filter and compare the financial outcomes of individual general ledger (GL) accounts over a selected period. 

Revenue trend 

Revenue for the selected period and the previous matching period  

This chart compares the last 12 months of revenue between the prior year and current year with values plotted monthly.  

You can identify growth patterns, peaks and performance gaps. 

Note: This is sourced from posted general ledger entries related to revenue. 

Top 5 expenses 

Percentage Expenses = (Expense for the G/L account / Total Expense of Top 5 G/L accounts) x 100% 

This pie chart displays the top five expense categories as percentages of total expenses for the selected period. It helps you quickly identify where most spending occurs. 

Note: You can set up custom Financial Reporting to identify the highest expense accounts 

Actual vs Budget Metrics 

Metric 

Calculation 

Objective 

Income actual 

Sum of all your G/L entries amount as per the date filter you set in your Period. 

Measures the total income earned before expenses, helping assess business performance and growth. 

Income budget 

Sum of all your G/L Budget Entries amount as per the date filter you set in your Power BI Period. 

Shows planned income for the period so you can compare against actual results. 

Income variance 

Income Variance = Actual income – Budgeted income 

Highlights the difference between actual and budgeted income, and shows trends compared to previous periods. Helps assess performance and identify areas where income is above or below expectations.  

Variance % = ((Actual income current period – Actual income previous period) / Actual income previous period) x 100% 

Expense actual 

This is the Total Expense that you can find in the Trial Balance report. 

This metric helps measure overall spending, track cost growth, and assess how efficiently the business is managing expenses. 

Expense budget 

This is the sum of all your G/L Budget Entries for expenses, based on the date filter you set in your Power BI Period. 

Shows planned spending to compare against actual expenses and track performance against targets. 

Expense Variance 

Expense Variance = Actual expenses – Budgeted expenses 

Highlights the difference between actual and planned spending, and shows trends compared to previous periods. Helps identify areas where costs are higher or lower than expected. 

Variance % = ((Actual expense current period – Actual expense previous period) / Actual expense previous period) x 100% 

Income chart 

Graph of actual income vs budgeted income for the selected period. 

Displays actual vs budgeted income. 

Expense chart 

Graph of actual expenses vs budgeted expenses for the selected period. 

Displays actual vs budgeted expenses. Helps you see if spending is on, over, or under target. 

Trending revenue 

Compare Trial Balance revenue between the current and previous periods. 

This chart shows how your business revenue is moving over time by comparing the current period with the previous period. 

Dimension 

Actual vs Budget by dimension (e.g., Department, Cost Centre) using G/L entries and G/L budget entries. 

Compares performance across dimensions to highlight which areas are over or under target. 

By GL account 

G/L Account Actual: Sum of posted income/expense for the period. 

Tracks actual vs budget at the account level to monitor financial performance. 

G/L Account Budget: Planned or forecasted amount from G/L Budget Entries. 

G/L Account Variance ($): Actual – Budget. 

G/L Account Variance (%): (Actual ÷ Budget) × 100%. 

Accounts Payable Metrics 

Metric 

Calculation 

Objective 

Cash on hand 

Cash balance in bank account - current liabilities 

Shows the cash is available to pay your bills. A negative amount means you don’t have enough cash to cover what you owe. 

Accounts Payable 

Σ (Outstanding vendor invoices) = Overdue + Not yet due. 

Shows the total amount your business owes suppliers. This helps you see what needs to be paid so you can plan your cash flow and avoid missing payments. 

Overdue payable 

Σ (Vendor Invoices past due date) 

Shows the total bills that are past their due date and late. These need to be paid quickly to avoid late fees and protect supplier relationships.  

Days payable outstanding (DPO) 

(Average Accounts Payable ÷ Cost of Goods Sold) x 365 days 

Shows the average number of days your business takes to pay suppliers. A value of 0 means no payments have been made in the past year 

Aging report 

Overdue = Σ (Invoices Past Due Date) 

This report helps you prioritise which invoices to pay first by showing what’s overdue versus what’s coming up soon. 

Due in 30 days = Σ (Invoices Due ≤ 30 days) 

Due in 60 days = Σ (Invoices Due 31 – 60 days) 

Due in 90 + days = Σ (Invoices Due > 90 days) 

By vendor 

Σ (Outstanding Invoices) grouped by vendor 

This report helps you identify which suppliers are owed the most and manage supplier relationships.  

Invoice status 

Σ (Invoices by status) -> Draft, Approved, Posted, Paid, Overdue 

Shows the progress of invoices for the month, from draft to paid. Helps you identify delays in the payment process early. 

AP funnel 

Total Payable = Σ (Outstanding Invoices) 

You can visualise how much of your total payables are on time versus how much is overdue. This helps you to address which payments are urgent.  

Not Yet Due = Σ (Invoices Dues >= Today) 

Overdue = Σ (Invoices Past Due Date)  

Payable turnover ratio 

Cost of goods sold ÷ Average Accounts Payable 

A low ratio means bills are being settled slowly. This could signal cash flow issues. A high ratio means your business can pay suppliers faster.  

Accounts Receivable Metrics 

Metric 

Calculation 

Objective 

Total overdue 

Σ (Remaining Amt. (LCY)) where Open = true and Due Date <= As-at Date 

This shows the total amount of money customers owe you that is past their due date. You can identify any overdue collections that need to be followed up.  

Total outstanding 

Σ (All Customer Invoices – Payments Received) 

This shows the total amount of money customers owe you. You can see what your receivables are and any upcoming cash inflows.  

Σ (Remaining Amt. (LCY)) where Open = true. 

Percentage overdue 

(Total Overdue ÷ Total Outstanding) x 100% 

You can see the percentage of the receivables that are overdue. A higher percentage means that there’s more risk to your cash flow.  

Days sales outstanding (DSO) 

(Average Accounts Receivable ÷ Total Credit Sales) x 365 

This is the average number of days it takes for your business to collect payments from customers. The lower the number of days, the faster you’re collecting payment.  

Aging report 

Breaks down receivables into time buckets like Accounts Payable metrics.   

Helps you prioritise collections by showing which invoices are overdue and which are coming due soon. 

Overdue = Σ (Invoices Past Due Date) 

Due in 30 days = Σ (Invoices Due ≤ 30 days) 

Due in 60 days = Σ (Invoices Due 31 – 60 days) 

Due in 90 + days = Σ (Invoices Due > 90 days) 

By customer 

Σ (Outstanding Invoices) grouped by customer 

You can see which customer owes your business the most and you can manage overdue accounts from here.  

Invoice status 

Σ (Invoices by Status) ->Draft, Approved, Posted, Paid, Overdue 

This diagram shows the progress of customer invoices and helps you to manage how much is billed, paid or overdue.  

AR funnel 

Total Receivable % = Σ (Outstanding Invoices) 

Total Receivable: This shows the total customer debt outstanding as at your selected period.  

Not Due Yet % = Σ (Not Due Yet ÷ Total Receivable) 

Overdue %: = Σ (Overdue ÷ Total Receivable) 

Not Due Yet:  This % forecasts cash inflows and helps you to plan cash in advance. 

Receivable turnover ratio 

Net Credit Sales by period ÷ Average Accounts Receivable 

The ratio measures how you can efficiently collect receivables. If the ratio is higher, you can get faster collections.