These checks are created based on the mapping in your Client’s Configuration settings for Tax & Control Accounts. They are a visual representation of your PAYE, Net Wages, Pension liability status and update on Directors Loan account balance.
What you need to know:
- Ensure you have mapped your accounts first under your Client’s Configuration – Tax & Control Accounts section.
Control Accounts Explained
- PAYE Status
- Net Wages Status
- Pensions Status
- Payroll alerts explained
- Directors Loan Account
- How to build a Custom Report using Practice Dashboard
This check balances manual journals against detected payments with PAYE account codes to ensure a correct PAYE status at a point in time. For Xero integrations, by default, the check calculates the PAYE control account balance based on account codes found under the reporting code LIA.CUR.TAX.OTH.
Expanding the check shows the detailed grid of PAYE transaction history for the last 6 months.
Remember: You can change the account codes used by clicking the small cog next to the card title, where Dext Precision will suggest a number of account codes for easy setup.
This check balances manual journals against detected payments with Net Wages account codes, to ensure that it reconciles to 0 or the balance is as expected.
Note: The balance may reflect your current liability if you are reviewing this check before the liability has been paid to HMRC. If this is the case then this account would be correct. If you are looking for a 0 balance you may need to adjust the Reporting Date at the top of the page to when you expect the liability to have been paid (ie 15th of the month).
Expanding the check shows a chart of money in and money out, and the detailed grid of Net Wages transaction history for the last 6 months.
This check balances manual journals against detected payments with Pensions account codes, to ensure that it reconciles to 0 or the balance is as expected.
Expanding the card shows a chart of money in and out of the control account, and the detailed grid of Pensions transaction history for the last 6 months.
- Green = All is well: if the Control Account balance is 0 and there is a Manual or GL Payroll Journal present in the last complete month
- Green = All is well: the Control Account balance is equal to the amount posted in the Manual or GL Payroll Journal(s) in the last complete month, and (if relevant) the snapshot date is well in advance of the HMRC Deadline
- Yellow = Warning: Contol Account and Journals balance, but a payment due date is approaching
- Red = No Manual or GL Payroll Journal found in the last complete month
- Red = No payment detected, and a payment deadline is past due
- Red = Control Account balance is non-zero and does not reconcile with balance of Manual or GL Payroll journals
Note: if no journals are posted or payments detected the reconciliation status will show as ‘no’.
A Directors Loan is allowable in a UK business only up to £10,000; once the loan is over £10,000 the business is liable to high tax charges. This represents a significant pay point for the SME, and therefore a key area for accountants to advise. Accountants should therefore keep an eye on the DLA throughout the year. To help you with this, Dext Precision creates an alert when a DLA exceeds the £10,000 mark.
As per the other control accounts, Dext Precision will show a graph of the history of the control account as well as the journals and payments detected in the previous month.
The alert level relates to the extent to which the DLA is overdrawn:
- If the DLA is overdrawn over the limit of £10,000, Dext Precision will show a RED alert.
- If the DLA is overdrawn below £10,000, Dext Precision will show an AMBER warning.
- If the DLA is not overdrawn, with a positive balance, Dext Precision will show a GREEN check.
Note: To monitor multiple DLA accounts, you can select multiple account codes for this check, and each will appear as a separate card within the check with its own graph.
Clearing the Dashboard
- Go to Team Home – Practice Analysis – Practice Dashboard
- Clear the Dashboard by unticking all the columns selected on the right hand side of the board under Columns. (TIP: check that all the boxes are checked then in the column list you can deselect ALL by removing the tick in the checkbox next to the search bar. Sometimes there are a couple that are unticked by default.)
- Once you have cleared the dashboard you can start to select the accounts you want to create a report showing DLA accounts.
Building the Custom Dashboard
Select the following from the Columns tab:
Under General tick;
- Client Name
- Health Score
- Year End
- Directors Loan Accounts
- Dividends Detected
- Net Assets
Saving the Custom Dashboard
Once the columns have been selected, go to Save in the top right of the dashboard.
Name the dashboard (for example, “Overdrawn Directors Loan Account Check”)
Decide whether you’d like to “share with your team” – this box will allow others on Precision to view your report.
Include these checks inside a Flow Templates as part of your standardised processes.