Business Insights

Income

This view shows your revenue sources and sales activity.

Total income: All revenue recorded during the selected period (account category 4-0000). The chart compares your monthly income to the same months last year.

Income streams: Your top revenue sources for the selected period, broken down by income account (Level 2 categories under Income).

Total invoices: The number of invoices issued during the selected period, including both positive invoices and credits.

Average invoice value: Total invoiced amount divided by the number of invoices issued.

Formula: Total Invoice Amount (GST exclusive) ÷ Number of Invoices

Highest-spending customers: Your top 3 customers ranked by total invoiced amount during the selected period, showing each customer's spend and percentage of total invoices value.

Formula for share of income: (Customer Invoice Amount ÷ Total Invoice Amount) × 100

Most sold products: Your top 3 products ranked by sales amount during the selected period, showing each product's revenue and percentage of total income.

Formula for share of income: (Item Sales Amount ÷ Total Income) × 100

Expenses

This breaks down where your money goes.

Total expenses: The sum of all operating expenses recorded during the selected period (account category 6-0000). The chart compares your monthly expenses to the same months last year.

Main expenses: Your top expense categories for the selected period. Up to 4 Level 2 expense categories are shown individually, sorted by highest dollar value. Remaining categories are summed under "Other."

Cash

This view shows your total cash position and how quickly money moves through your business.

Total cash: The combined balance of all your bank accounts connected via bank feeds as of the date shown. The chart tracks how your cash balance has changed over the selected period.

Cash runway: How long your current cash balance will last based on your recent spending patterns. Measured in months.

Formula: Cash Balance ÷ Monthly Operating Expenses

Average time to get paid: The average number of days between sending an invoice and receiving payment from your customers.

Formula: (Average Accounts Receivable ÷ Total Income) × Days in Period

Where Average Accounts Receivable = (AR Balance at Start Date + AR Balance at End Date) ÷ 2

Average time to pay suppliers: The average number of days between receiving a bill and paying your suppliers.

Formula: (Average Accounts Payable ÷ Total Bills) × Days in Period

Where Average Accounts Payable = (AP Balance at Start Date + AP Balance at End Date) ÷ 2

Profit

This view shows your net profit and profit margin over the selected period.

Net profit (total amount): Your total income minus total expenses for the selected period. The chart compares your monthly net profit to the same months last year.

Formula: (Total Income + Total Other Income) − (Total Cost of Sales + Total Expenses + Total Other Expenses)

Profit margin (net profit margin): Net profit as a percentage of total income. Shows how much of each dollar earned you keep after expenses.

Formula: (Net Profit ÷ (Total Income + Total Other Income)) × 100

Income: Total revenue recorded during the selected period (account category 4-0000).

Cost of sales: Direct costs tied to producing goods or services you sold (account category 5-0000). Displays "N/A" if no cost of sales accounts are set up.

Gross profit margin: Income minus cost of sales, expressed as a percentage of income. Shows profitability before operating expenses.

Formula: ((Income − Cost of Sales) ÷ Income) × 100

Or: (Gross Profit ÷ Income) × 100

filter information in tables

Click a column heading to sort the table information.

update with recent information

Click Refresh. All information entered since you opened Business Insights or last refreshed the window will be displayed.

see totals in graphs

Hover over the graph bar or column to see its total.

save graphs as images

Right-click a graph and click Save As. Choose where you want to save the image and click Save.You can then print the image or insert it into a document, such as an Excel spreadsheet, later.

paste graphs into another document

Right-click a graph and choose Copy to Clipboard. You can then paste the copied image immediately into another document.

paste table data into another document

Right-click a table and choose Copy to Clipboard. You can then paste the data into another document, such as an Excel spreadsheet, where you can edit it. Note that column totals are not included in the pasted data.