Financial Reporting Dashboard Tutorials

• The dashboard shows transactions or accounts that need further processing.
• The left side shows a list of transactions that are either out of balance or have allocation errors.
• The right side shows the accrual accounts that need to be reconciled. The accrual accounts shown are those with the default Accrual (VAT Inc) in the Chart of Accounts.

💡These tutorials explain how to view and use the various Dashboard sections.

How to View the Dashboard#

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting).
2. Click Menu (button) > Dashboard.
3. Click View (button).

How to View Out-of-Balance Transactions#

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting).
2. Click Menu (button) > Dashboard.
3. Click View (button).
   • Note: Any transactions that are out of balance appear on the left, in the Transaction Errors section, with the error Trial Balance.

How to Fix Out-of-Balance Transactions#

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting).
2. Click Menu (button) > Dashboard.
3. Click View (button).
   • Note: Any transactions that are out of balance appear on the left, in the Transaction Errors section.
4. Right-click an entry on the list and select Open Transaction.
   • Note: A warning bar at the top of the transaction shows where the problem is.
5. If the transaction can no longer be edited, note its status, and then change it to an editable status.
6. On the entry, select accounts in both the Dr Account and Cr Account fields.
   • Note: If the fields do not appear, click Field Chooser (*) in the first column and check the boxes next to Dr Account and Cr Account.
7. Change the transaction back to the status it had before you edited it.

How to View Transactions With Allocation Errors#

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting).
2. Click Menu (button) > Dashboard.
3. Click View (button).
   • Note: Any transactions with allocation errors appear on the left, in the Transaction Errors section, with the error Allocation.

How to Fix Transactions With Allocation Errors#

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting).
2. Click Menu (button) > Dashboard.
3. Click View (button).
   • Note: Any transactions with allocation errors appear on the left, in the Transaction Errors section.
4. Right-click an entry on the list and select Open Transaction.
5. If the transaction can no longer be edited, note its status, and then change it to an editable status.
6. Click Allocation (button).
7. If you are on an invoice, edit the amounts in the Allocated column to match the transaction amount.
8. If you are on a receipt or payment, click Remove (button) to clear the allocations, and reallocate the payment or receipt as needed (see Transaction Allocations).
9. Change the transaction back to the status it had before you edited it.

How to View Accrual Account Balances#

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting).
2. Click Menu (button) > Dashboard.
3. Click View (button).
   • Note: All the accrual accounts and their balances appear on the right, in the Account Accruals section.

How to Add Accrual Accounts to the Dashboard#

1. Navigate to the Chart of Accounts (Main Menu > Setup > Accounting > Accounts (tab)).
2. Click the + next to Grid View (button) to expand the view if it is collapsed.
   • Note: If the Grid View button shows Tree View, click the button to switch views.
3. Click Add/Edit (button) on the top row unless it is blue.
4. Scroll down the list of accounts to the Statement of Financial Position.
5. Find the account you want to show and click its Default column.
6. Select Accrual (VAT Inc) from the dropdown list.
7. Click Save (button) if it is not greyed out.