Summary: This article with discuss how to set up percentage of ownership assessments.
For associations that bill their assessments based on a percentage of ownership structure, you can complete their billing by using a simple import, the Homeowner Charge Percentage import.
You will first start by setting up the assessment on the Association > Assessments page. Visit the How to Set Up a New Charge or Assessment article for more information on setting up the assessment.
Once your assessment charge is created, click on the dropdown arrow for that charge and click on New Rule.
Upon clicking the New Rule button, the Edit Assessment Rules screen will open, which will allow you to create your new percentage rate assessment rule. The Start Date will default to the first date of the current year. You can leave it as is or set a future date for the assessment to start. Select a frequency for the assessment. Then select Percentage (% APR) from the Type dropdown list as shown below.
Next, click New Date and enter the total amount to be billed to the entire association in the Amount column as indicated below.
In this example, the total amount to be billed in assessment charges each month is $10,000. Click Update to save your changes. The charge for each homeowner will auto-calculate based on the percentages you import.
Note that the total amount to be billed will be entered into the Amount column, not the Total column. The Total column is irrelevant for Percentage based assessments.
Once the rule is established with the total amount to be billed to all Homeowners, use the Excel sheet at the bottom of this article to import the Charge Percentages. For this import, only two columns are required:
- Account - This is the homeowner account number.
- Percentage - This represents the percentage of that total amount to be billed to the homeowner.
The sample spreadsheet used in this example is attached at the bottom of this support article for your reference.
Once the import spreadsheet is filled out, navigate to the Settings > Import screen and click + New Import.
This will open a pop-up screen where you can select the import type, select the Homeowner Charge Percentage Import type.
There are two import modes for the Homeowner Charge Percentage import:
- Append - This mode is used for the initial import.
- Replace - This mode can be used to overwrite any previously applied Homeowner Charge Percentage imports for the specific charge you have selected. This can be especially helpful if you need to revise or adjust the percentages you have originally imported.
After you select your Import Mode, select the association for which you want to import the percentages. Next, and select the correct assessment from the Charge dropdown. Next, click the Select Files button to search for and select the Homeowner Percentage Import spreadsheet that you configured with your charge percentages.
After you have selected your file, then spreadsheet will be uploaded into Vantaca and once the upload is complete, you will be taken to the Import Mode screen, as displayed below.
From the Import Mode screen, we can see the number of owners in the association reflected as Valid Records (47 in this example). This feature helps us to verify whether or not we are importing the correct number of billing records.
If you are satisfied with your import, click the Commit button to commit your import. If you would like to make changes to your import, you can either make those changes within the Import Mode screen, or you can click the Back button to back out and delete the import for uploading a replacement.
Note that you must click Save to save any changes you made to the import prior to committing your import. If you are clearing out error messages, they will not go away until you save your changes!
Once the import is successfully committed, refresh your Percentage rate rules by navigating to the Association > Assessments page. Click the dropdown on the charge you just committed the percentages to, click Rules then click Update.
Now that your percentages have been imported, you can also manually edit and manipulate the percentages for each owner specifically by going to the Homeowner's account and navigating to the Homeowner > Tags page and then updating the value in the Percentage Rate section for the chosen charge as shown below.