Financial Dashboard

Overview

The Dashboard for Financial Statements provides an interface from which accruals, errors, and pending transactions can be managed.

Navigation: Main Menu > Accounting > Financial Statements > Menu (button) > Dashboard

Table of Contents

Buttons Explained

  • View: Generates the information for the dashboard according to the selected Data Filters.
  • Output: Outputs PDF documents which can be printed, previewed, or emailed. There must be dates displayed next to the top-row buttons (select a date from the filters and click View (button)). If there are no dates displayed, an error message is returned that the report cannot be generated. The available reports are:
    • Financial Statements
    • Statement of Financial Position
    • Statement of Profit or Loss - 12 Periods
    • Statement of Profit or Loss - 2 Periods
    • Statement of Profit or Loss - 3 Periods
    • Statement of Profit or Loss - 6 Periods
    • Statement of Profit or Loss - Fin Year
  • Menu:
    • Reset Data Filters: Resets any changes to the data filters.
    • Hide decimal Values: Toggles showing or hiding decimal values.
    • Views
      • Dashboard
      • Statement of Profit or Loss
      • Statement of Financial Position
      • Trial Balance
    • Layout & Grids
      • Email Excel
      • Export Grid
      • Save
      • Save (All Users)
      • Restore Default (All Users)
  • Add (next to Financial Statement Notes): Allows users to add notes.

Filters Explained

  • Set: Date and period options.
  • ⬅➡: Adjusts the dates forwards or backwards depending on the option chosen under Set.
  • Date: Allows users to customise the dates.
  • Report: A dropdown list with custom-created Accounting Reports.
  • Show: A function of the custom reports to select the number of months.
  • %: A dropdown list allowing users to display:
    • None
    • Change: The % change from the month on the left to the month on the right or from the budget.
    • Revenue: The % of revenue.
    • Budget: Shows the amounts budgeted for the selected period.
      • This option is only available if the date is set to Fin Year (Months) and a budget is selected.
  • Show all Accounts: Checkbox. If checked all the accounts are shown, including those with zero balances.
  • Budget: Dropdown list from which to select a budget.

Fields Explained: Accruals (tab)

ℹ️ Accrual accounts hold temporary entries which should be cleared at the end of each month.

- The accounts displayed on this tab are those for which the default Accrual was selected when creating accounts.

- Accrual accounts may also include accounts that are used for stock acquisitions and movements.

  • Field Chooser (*): Allows users to add or remove columns.
  • ID: The auto-generated number for the account.
  • Account: The name of the accrual account.
  • Balance: The balance of the accrual account.
  • Menu (...): Click the menu to display an eye. Click the eye to open the ledger account.

Fields Explained: Errors (tab)

ℹ️ This tab displays all the transactions that only have a single-entry (as opposed to a double-entry).

  • Field Chooser (*): Allows users to add or remove columns.
  • ID: The system-generated number for the transaction.
  • Status: The status of the transaction.
  • Type: A code indicating the Transaction Type and the Transaction Number.
  • Date: The date of the entry.
  • Company: The Customer of Supplier account name.
  • Entity: The Entity the transaction belongs to.
  • Description: The user-provided transaction description.
  • Reference: The user-provided transaction description.
  • Trial Errors: The Amount that is out of balance.
  • Menu (...): Shortcut to open the transaction in the Ledger.

Fields Explained: Pending (tab)

ℹ️ This tab displays all the transactions that could potentially affect the financial statements but are incomplete (Pending Status).

  • ID: The system-generated number for the transaction.
  • Status: The status of the transaction.
  • Type: A code indicating the Transaction Type and the Transaction Number.
  • Date: The date of the entry.
  • Company: The Customer or Supplier account name.
  • Entity: The Entity the transaction belongs to.
  • Description: The user-provided transaction description.
  • Reference: The user-provided transaction reference.
  • Total (Exc): The transaction's VAT Exclusive amount.
  • Menu (...): Shortcut to open the transaction in the Ledger.

Fields Explained: Financial Statement Notes

  • If there are notes, they are displayed in the block provided.
  • Notes can be added using Add (button).
  • Notes can be edited by double-clicking them.

Fields Explained: Charts

ℹ️ Charts are only displayed after View (button) is clicked.

  • Statement of Profit or Loss: Displays the Net Profit/Loss, Cost of Sales, and Expenses as bar charts for the selected period and previous year.
  • Statement of Financial Position: Displays the Assets, Liabilities, and Equity as bar charts for the selected period and previous year.

Fields Explained: Footnotes

ℹ️ Footnotes are displayed at the bottom of the Dashboard screen and provide figures for the charts displayed on the right.

  • Key Metrics: Revenue, Cost of Sales, Expenses, Profit/Loss, Assets, Liabilities, Equity, and Bank Balances for the selected period.

Related Topics