CMS - How To: Upload Additional Recoveries

Created by Mienette van Heerden, Modified on Thu, 13 Jun, 2024 at 2:16 PM by Glennise Pretorius

1. Uploading Additional Recoveries

Navigation: Community Level> Finances > Additional Recoveries, listed under the Billing settings.




1.1 Download Additional Recoveries Template

Navigation: click on the hyperlink on the Screen




Download the template by clicking on the "Download template file here", option in the pop-up screen.




An Excel document will be downloaded - which will look similar to the following.



1.2 Capturing the Additional Recoveries Template

Navigation: Open the downloaded Excel sheet




The only fields required to be completed for upload are columns A and E. Therefore bulk billing like Reserve Fund Levy or any amount for a bulk upload on the billing screen will be done from here.

  • Column A: header naming (door number) may differ from community to community, as this reflects the "Unit Addressing" selected at the Take-On Process. 
  • Column B - D: Is only applicable when uploading Utilities under Water Readings or Electricity Readings 
  • Column E: the amount that needs to be charged. Please note that it should only be the value and no currency symbols to be included.
  • Column F: Description bypass can be used if recoveries need unique descriptions on their invoices, this will bypass the default description to be set up upon upload of the template.




Please note: Do not change or edit any of the column headers naming or the order, as the system performs data validation checks upon upload to ensure the accuracy of data. Do not remove any of the columns, even if it is irrelevant to your upload.




Once all the relevant information has been added, please save the Excel document.



1.3 Uploading the Additional Recoveries Template

Navigation: Open WeconnectU> Finance > Additional Recoveries - upload new additional recoveries




  • Drag and drop this file OR click to upload the file.
  • If the upload is for utilities, choose the date range the readings are for. If these dates need to reflect on the invoice, toggle the tick box next to Show dates on invoices. For other additional recoveries, you can ignore the date range, this will not reflect anywhere when the tick box has not been ticked 
  • For the Account field: Select the ledger account that these amounts need to be allocated to, once the invoice has been raised.
  • For the Description field: when left blank there will be no description reflecting on the invoice, alternatively, if description bypass was filled in on the Excel document, that description will override the description filled in on this screen, otherwise the description will default to what was filled in for this field.
  • Select Recurring if this is relevant - (if the additional recovery is recurring for the same amount i.e parking levy)



Please wait for the document to load, once all the line items have been loaded as per the below, scroll down to upload. - Please note that even if it reflects zero you can still upload.





1.4 Billing Status of the Additional Recoveries Template

Navigation: Open WeconnectU> Finance > Additional Recoveries 


The billing status will differ, as this depends on if Recurring was selected or if this was a once-off recovery. If the recurring option has not been selected then it will only be billed once. After the billing has been billed the status will change to complete.


The billing can only be deleted or viewed, this can not be edited. To edit the data, the relevant recovery needs to be deleted and the new additional recovery Excel sheet uploaded. After the adjustments, billing can be run.






2. Additional Recoveries on the Billing screen

Navigation: Individual Community > Finances > Run Billing


On the billing screen, the additional recoveries will be added in a new column, with the description being the header of the new column added. At the bottom of the column, it will indicate the total recovered.




The invoice the owner receives, will reflect as follows:




3. Examples

 

Below is an example of additional levies that have been charged on the billing to each owner's account. This is great for multiple different amounts to be charged to a few owners that cannot be split by PQ, evenly, or per unit.


In this example, there are additional parking levies loaded for a few different owners. The recurring option was chosen for these amounts, only once the amounts have been deleted they will no longer be part of the billing run.




This amount will be reflected against the relevant units.




Alternatively, this can be used for utility readings. When the recurring option is not chosen, it will reflect as below. After the billing has been sent, a green complete status will appear under Billing Status.




Another example is reserve fund levies can be set up as an Additional Recovery. Please note, this is the manual upload, therefore if the budget amounts are updated this amount will not change, this is a set amount. Please re-upload the reserve fund levy here when the budgets are being updated.





Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article