Financial Reporting Dashboard Tutorials

• The dashboard displays transactions or accounts that need further processing.
• On the left a list of transactions that are either out of balance or have allocation errors is displayed.
• On the right, the accrual accounts that need to be reconciled are displayed. The accrual accounts that are shown are those for which the default Accrual was selected in the Chart of Accounts. 

Navigation Example: Main Menu > Accounting > Financial Reporting > Menu (button) > Dashboard

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

---

How to Display 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 Display Out-of-Balance Transactions 

Out-of-balance transactions are also referred to as Trial errors, or Trial Balance errors. It happens when an account was not selected to either debit or credit (depending on the transaction). The result is that posting the transaction causes the Trial Balance to go out of balance.

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting). 
2. Click Menu (button) > Dashboard.
3. Click View (button).
4. On the left, on the Transaction Errors section, any transactions that are out of balance will be displayed with the error message 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).
4. On the left, on the Transaction Errors section, any transactions that are out of balance are displayed.
5. Right click an entry on the list and select Open Transaction from the context menu.
6. When the transaction is opened, a warning bar at the top shows where the problem is.
7. If the transaction can no longer be edited, note what the status is, and then change the transaction back to an editable status.
8. Navigate to the specific line item and select accounts for both the debit (Dr Account) and credit account (Cr Account) fields.
   • Note: If the fields are not displayed, use the Field Chooser (*) in the first column and check the boxes next to Dr Account and Cr Account.
9. Change the status of the transaction back to the status it was before you edited it.

---

How to Display Transactions with Allocation Errors

Allocation errors occur when allocations exceed the invoiced amount. When processing receipts or payments, the amounts that were prepaid (e.g. deposits) or overpaid, can be left unallocated to avoid this type of error. (They can be allocated to future invoices as those are created.)

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting). 
2. Click Menu (button) > Dashboard.
3. Click View (button).
4. On the left, on the Transaction Errors section, any transactions that have allocation errors are displayed with the error message 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).
4. On the left, on the Transaction Errors section, any transactions that have allocation errors are displayed.
5. Right click an entry on the list and select Open Transaction from the context menu.
6. If the transaction can no longer be edited, note what the status is, and then change the transaction back to an editable status.
7. Click Allocation (button).
8. If you are on an invoice edit the amounts in the Allocated column to match the transaction amount.
9. If you are on a receipt or payment, click Remove (button) to clear the allocations. Re-allocate the payment or receipt as needed.
10. Change the status of the transaction back to the status it was before you edited it.

---

How to Display Accrual Account Balances 

1. Navigate to Financial Reporting (e.g. Main Menu > Accounting > Financial Reporting). 
2. Click Menu (button) > Dashboard.
3. Click View (button).
4. On the right, on the Account Accruals section, all the accrual accounts and their balances are displayed.

---

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. Scroll down the list of accounts to the Statement of Financial Position.
4. Find the entry you want to display and click the Default column in the same row as the entry. 
5. Select Accrual from the dropdown list.
6. Click Save (button) if it is not greyed out.

---