HOME

Financials Dashboard

Your financials dashboard provides you with instant information about how your business is doing.

Please note that the SmartPanels are not available when you have signed in for a Public Session. Furthermore, SmartPanels may not be available to you depending on the role you belong to.

Selected information described in this help document may not be available in all editions. For example opportunites are not displayed if you are using the BT3 Accounting edition.

Cash and Liquidity

The cash and liquidity SmartPanel displays key information about the company's current cash position and provides key indicators for working capital and liquidity. Furthermore, it also lists the current balance for all bank accounts.

Please note that Bank Overdrafts are classified as a current liability (included in other current liabilities) regardless of whether the balance of the account is positive or negative. If a Bank Overdraft account has a positive balance it will reduce other current liabilities and not increase bank and cash

Liquidity Analysis

Working capital management is concerned with making sure we have exactly the right amount of money and lines of credit available to the business at all times.

The liquidity ratios are an important part of working capital management. Cash is the life-blood of any business, no matter how large or small. If a business has no cash and no way of getting any cash, it will have to close down. It's that simple! Following on from this we can see that if a business has no idea of its liquidity and working capital position, it could be in serious trouble.

Working Capital

WORKING CAPITAL is current assets minus current liabilities; also called net current assets or current capital.

Calculation

Working Capital =
Current Assets - Current Liabilities

Current Ratio

CURRENT RATIO (or Working Capital Ratio), a comparison of current assets to current liabilities, is a commonly used measure of short-run solvency, i.e., the immediate ability of a firm to pay its current debts as they come due. Current Ratio is particularly important to a company thinking of borrowing money or getting credit from their suppliers. Potential creditors use this ratio to measure a company's liquidity or ability to pay off short-term debts. Though acceptable ratios may vary from industry to industry below 1.00 is not atypical for high quality companies with easy access to capital markets to finance unexpected cash requirements. Smaller companies, however, should have higher current ratios to meet unexpected cash requirements. The rule of thumb Current Ratio for small companies is 2:1, indicating the need for a level of safety in the ability to cover unforeseen cash needs from current assets. Current Ratio is best compared to the industry.

  1. Excellent is displayed when the current ratio is larger than 3.
  2. Good is displayed when the current ratio is between 2 and 3.
  3. Watch Out is displayed when the current ratio is between 1.2 and 2.
  4. Bad is displayed when the current ratio is less than 1.2.
  5. - is displayed when current liabilities is zero or less, or current assets is less than zero. This is because it will lead to division by zero or a negative ratio, which is not meaningful.

Calculation

Current Ratio =
Current Assets
Current Liabilities

Quick Ratio

QUICK RATIO (or Acid Test Ratio) is a more rigorous test than the Working Capital Ratio of short-run solvency, the current ability of a firm to pay its current debts as they come due. This ratio considers only cash, marketable securities (cash equivalents) and accounts receivable because they are considered to be the most liquid forms of current assets. A Quick Ratio less than 1.0 implies "dependency" on inventory and other current assets to liquidate short-term debt.

  1. Excellent is displayed when the quick ratio is larger than 1.5.
  2. Good is displayed when the quick ratio is between 1 and 1.5.
  3. Watch Out is displayed when the quick ratio is between 0.6 and 1.
  4. Bad is displayed when the quick ratio is less than 0.6.

Calculation

Quick Ratio =
(Current Assets - Stock)
Current Liabilities

Cash Ratio

CASH RATIO is a refinement to the QUICK RATIO. It is the ratio of cash and marketable securities to current liabilities. The CASH RATIO indicates the extent to which liabilities could be liquidated immediately. Sometimes called LIQUIDITY RATIO.

Please note that in SMARTEDGE only cash and bank is used to calculate the Cash Ratio, since there is no dedicated account group for other marketable securities.

Calculation

Cash Ratio =
(Cash and Bank)
Current Liabilities

Daily Cash and Receivables, Payables and Inventory grapsh

Two graphs are displayed showing daily cash balances and Receivables, Payables and Inventory respectively.

Daily Available Cash last year

This graph shows the cash balances and overdrafts available for individual days the last year. To display the exact amount for any given day move the mouse along the graph lines. The amount and date is displayed in the top right-hand corner of the graph and a dot indicates the day.

Please note that by default the graph displays available overdrafts. Available overdrafts is equal to overdraft limit less actual overdraft on that day. Please note that the overdraft limit needs to be set on all credit card and bank overdrafts accounts.

Daily Cash and actual overdrafts last year

To display the actual overdrafts instead of available overdraft, tick the checkbox Actual overdraft situated just above the graph.

Zooming the graphs

The graph can be zoomed by either clicking one of the zoom buttons in the top left-hand corner of the graph or drag the zoom range below the graph. Below this is illustrated.

Bank Balances

The Cash and Liquidity SmartPanel lists all bank accounts with the current balance. The last date indicates the last transaction date captured on the account.

Profitability

The profitability SmartPanel displays key information about your income, expenses and operating profitability.

Month To Date

This tells you the operating income and expenses excluding interest of the business so far this month. It also displays this month's operating profit.

Year To Date

This tells you the operating income and expenses exluding interest of the business so far in the current financial year. It also displays the operating profit.

(Operating) Margin

Operating margin is calculated from operating income and operating expenses exluding interest. The figures are before tax and any extraordinary items. Income is the sum of transactions on accounts belonging to account groups Sales Revenues, Other Operating Income and Other Financial Income. Expenses is the sum of transactions on accounts belonging to account groups Cost of Sales, Personnel Expenses, Other Operating Expenses, Write-Offs and Other Financial Expenses.

Calculation

(Operating) Margin =
(Income - Expenses) * 100
Income

Gross Profit Margin (GPM)

Gross profit margin is calculated from sales income and cost of sales expenses. The figures are before tax and any extraordinary items. Sales income is the sum of transactions on accounts belonging to account groups Sales Revenues. Cost of Sales is the sum of transactions on accounts belonging to account groups Cost of Sales.

Calculation

(Operating) Margin =
(Sales - Cost of Sales) * 100
Sales