Once your budget is set up, the budget invoices have been issued and actual charges have been processed, you're ready to run the budget reconciliation at the end of the budget period.
This step allows the system to compare what was invoiced to clients based on the budget, with the actual charges recorded during the budgeted period. If the two match, it means your clients have paid the correct amount in advance.
If actual charges are higher than budgeted, clients will owe the difference. If they are lower, the clients will have overpaid and will be due a refund.
The budget reconciliation process calculates these differences and lets you send budget reconciliation statements to your clients at the end of the budget period.
Prerequisites
Before running the budget reconciliation, make sure the following setup and processing steps have been completed:
- The accounting basis on the development is set to Budgeted.
- A suitable Charge Date Code has been set for billing budget items to clients.
- Appropriate Budget Headings were set up and used when creating the budget.
- All budget invoices have been run and issued to clients, covering the full budget period based on the selected Charge Date Code (e.g. yearly, quarterly, monthly).
- If your budget covers a year and you selected a yearly charge date code, you’ll generate invoices once at the start of the year.
- If you chose a quarterly or monthly code, you can either bill periodically or process all charges in one go at the start of the year, instead of invoicing each month or quarter.
- Transactions have been posted using the correct budget headings for any contractor charges related to the period and released from the hold file so they appear as charges in the clients' accounts.
- If any one-off charges weren’t included in the budget and needed to be billed earlier, they were invoiced via Amended Accounts.
All relevant charges and budget invoices should now be sitting in the Charge Transaction and Transaction Activity tabs for each client, ready to be included in the reconciliation.
Running a Budget Reconciliation
- Go to the main Clients tab > Global in the action bar:

- Select the Process Owners Charges for Budgeted tab.
- This will open the Process Budget Owners Charges screen.
This tab may appear in a different position within your Client Global Actions window.
- Select the Budget Recon radio button:

- Choose the correct Reconcile budget ending date to match the end of your budget period.
- It must match the end date of the budget to ensure accuracy.
To filter which developments to include, you can use:
- Property Manager – to run the reconciliation for one property manager.
- Office – to limit to developments for a particular office.
- Range of Developments – to define a range of developments using the From and To fields.
These filters are helpful if you're reconciling budgets in smaller batches, for example, if you manage a large portfolio.
Once you’ve entered your selections:
- Click the Budget Reconciliation button at the bottom right to run the process:

- Wait for the Complete notification to appear. Click OK to close it.
- Make a note of the batch number that appears in the BatchNo field. You'll need it for printing or emailing reconciliation invoices/statements:

The system has now compared your budgeted and actual charges and produced the reconciliation invoice or statement.
You can view the result under the Transaction Activity tab for each client.
Sending out Budget Reconciliations
To print or email the budget reconciliations, see instructions in this and this article.