The full reconciliation breakdown is accessed by going to Financials > Reconciliation, and clicking Reconciliation PDF at the top right.
If you find a positive or negative balance that appears to be incorrect, there are two things to ensure before starting investigating the cause:
Ensure you reconcile
Ensure you have no unassigned lines
The steps below detail how to check both of these.
1. Checking the reconciliation total
Go to Financials > Reconciliation
At the top left, click Change end date
Change the end date to yesterday’s date
Scroll down and check the total on your reconciliation
Go to your bank account and check if the end-of-the-day total matches the reconciliation total
If these do not match, please follow our help article on what to do if the reconciliation balance does not match the bank balance.
2. Unassigned lines
Before checking for positive/negative balances on the reconciliation, ensure all bank lines are cleared from Financials > Unassigned lines.
3. Finding the positive and negative balances and determining the cause
If there are positive and negative balances to be reviewed on your reconciliation, the bank lines contributing to these balances can be found on the reconciliation page.
Go to Financials > Reconciliation.
Click on the category on the reconciliation page.
Click on the house icon to view these balances by property.
Under the Property balance column, find the negative/positive balance and click on the amount. This will bring up all bank lines contributing to this balance for this property.
For a £0.00 balance, each credit should have a corresponding debit and vice versa.
If there is a positive or negative balance, you can start by searching for that amount in the search bar to see if it is made up of only one bank line.
If this does not return any results, it may be that the positive/negative balance consists of more than one line without a corresponding entry.
Where there are many entries, you may find it easier to select ‘Export’; you can then interrogate the data in your spreadsheet software to find the entries.
4. Checking unmatched lines against a property
Finally, you may find an unmatched line against the property. Bank lines that are unmatched are manual lines, indicating that a payment has been instructed.
Once the relevant client line (payment in or out of your bank) is added to the software, it is then matched to the manual line.
If a manual line is unmatched, it can mean that a payment in or out of your account was missed, which may explain a positive or negative balance on your reconciliation.
To check unmatched lines against a specific property:
Navigate to Bank > View bank lines
From the top left, click the view filter and select Unmatched lines
From the top left, click to filter by the relevant property
Review any transactions listed that are more than 1 week old (more recent transactions may still be being processed within the bank)
If there are unmatched bank lines, please follow our help article on unmatched bank transactions.
Note: If there are positive or negative balances that you have not been able to resolve, please contact the Financial support team at [email protected] with the following information:
Property IDs
Bank line IDs that cause the positive or negative balance
Any relevant unmatched lines for the property
Any additional information you can provide that may be relevant to resolving the balance