Financial Dashboard

Overview

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

Button	Description
View	Generates the information for the dashboard according to the selected Data Filters.
Output	Outputs PDF documents which can be printed, previewed or emailed. Dates must appear next to the top-row buttons (select a date from the filters and click View (button)). If no dates appear, an error message states 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)	Add notes.

Filter	Description
Set	Date and period options.
⬅➡	Adjusts the dates forwards or backwards depending on the option chosen under Set.
Date	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.
%	Select what 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 appear, including those with zero balances.
Budget	Dropdown list from which to select a budget.

Info

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	Description
Field Chooser (*)	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.

Info

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

Field	Description
Field Chooser (*)	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.

Info

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

Field	Description
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.

Note

Charts only appear after View (button) is clicked.

Field	Description
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.

Info

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

Field	Description
Key Metrics	These figures for the selected period: Revenue Cost of Sales Expenses Profit/Loss Assets Liabilities Equity Bank Balances