The reconciliation of Utility Bills is now available through BGL SmartDocs. This integrated AI features allows you to compare transactions recorded in entities to uploaded Utility Bill while allowing you to make adjustments.
BGL SmartDocs will analyse the uploaded utility bill model extracting data including the following.
- Property address
- Issue date
- Due date
- Total amount (due amount or discounted amount if paid before the due date)
- Invoice/bill number
- Account number
- Customer name
- Overdue amount (the amount if paid after the due date)
This will then be organised into a table comparing the statement to transactions already posted.
To begin, upload a Utility Bill using one of the methods in SmartDoc Documents
|Next from the Main Toolbar, go to Reports.
|Select Documents from the list.
1. Once the AI has identified and processed the document, click on the Utility Bill
Note: Categorising and Sorting via BGL SmartDocs
When opening any document that has been analysed by BGL SmartDocs, the options to add a Financial Year and Tags are available. Additionally, clicking Add Folders will also allow you to categorise this document by selecting an appropriate document type or account.
Any details saved with these options will be conveniently carried over to the Workpapers screen.
2. Ensure the correct Property Code, Start Date, and End date are selected correctly.
3. SmartDocs will generate a predicted account code for all transactions recognised. If required, change these accounts to the correct Expense account:
4. The Ledger and Statement amounts will display in a table. To adjust the ledger amounts, enter a negative or positive number into the "Adjustment" column:
5. If an income/expense account is not displayed, use the Add row button to add it to the table.
6. Finally, complete the reconciliation by adding a row that posts to a balancing account if required.
7. Once completed, click Post Adjustment Journal to post these adjustments.
This will post adjustments to the selected accounts with Credits and Debits equalling the positive and negative numbers added as adjustments respectively: