Financial Dashboard

Settings

User Settings

Navigation: Main Menu > Setup > Settings > Users (tab).

• Accounting: Financial Statements - Access Allowed: Options include Yes or No.

This module must be added to the menu by selecting Type = Fixed and Module = Financial Statements.

Default View

Buttons Explained

• View

  • Generates a report according to the selected Data Filters.

• Output

  • Output PDF documents. Main options include Print, Preview and Email. 

    • Sub-options include Financial Statements, Statement of Financial Position,  Statement of Profit and Loss for 2, 3, 6, and 12 periods or for the Financial 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.

Data Filters Explained

• Set: Select a period

• ⬅➡: Adjusts the period forwards or backwards depending on the option chosen under Set.

• Date: Allows users to customise the date for which the report is generated.

• 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: Tick to show all accounts, including those with zero balances.

• Budget: Dropdown list from which to select a budget.

Fields Explained: Accruals (tab)

This field shows all the accrual accounts. Typically on period end these accounts will be cleared and the balances transferred to income and expense accounts. 

Note these are accrual accounts used by the various modules, (as opposed to accounting accrual accounts that provide for outstanding expenses).

• Field Chooser (*): Allows users to add or remove columns.

• ID: The auto-generated account ID.

• Account: Name of the accrual account.

• Balance: The balance of the accrual account.

• Menu (Field is named Actions): Click the menu to display an eye. Click the eye  to view 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 auto-generated ID of 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 Reference.

• 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 accounts but are still in Pending Status. 

• ID: The auto-generated ID of 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 VAT Exclusive Amount of the transaction.

• Menu: Shortcut to open the transaction in the Ledger.

Fields Explained: Financial Statement Notes

• If any notes are created, they will be displayed in the block provided.

• Double click a note to open or edit it.

Fields Explained: Charts

• Statement of Profit or Loss: A visual representation of the major categories of the Statement of Profit or Loss for the selected period. 

• Statement of Financial Position: A visual representation of the major categories of the Statement of Financial Position for the selected period.

Fields Explained: Footnotes

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

Output Templates

The following data pipelines can be used from the Financial Statements module:

• FS_Filter - Exposes the Data Filter

• FS_Period - Exposes the Period column names

• IS_Level1 - Main Sections - Revenue, Cost of Sales, Etc.

• IS_Level2 - Account Groups and Accounts

• IS_Level3 - Accounts

• BS_Level1 - Main Sections - Assets, Liabilities and Equity

• BS_Level2

• BS_Level3 

• BS_Level4

• TrialBalance - Used for the default Accounts view

• TrialBalance_Detail - Used for the Transaction view

• TrialBalance_Category - Used for the Category view

• TrialBalance_Filter - Exposes the Trial Balance Data Filter.

Related Topics

• Tutorial: Financial Dashboard