Importing Homeowner Beginning Balances

Summary

This card describes how to use the Balance Import tool to import charges and credits from Excel.

File Format

First, the Excel file must have an extension of XLSX or CSV. The file must contain the following columns (Note: names don't matter since you can map the column to the correct field in the UI. Just make sure the first row in the Excel file is the header column and each column is unique).

The only way for the system to identify the correct owner to charge is by finding the unit via the address within the HOA, and then looking up the current owners tied to that unit that have the supplied Account Number. Then it posts the charge / credit via the Posted Date, Charge Code, and Amount.

Import Template:

Import Owner Balance Example.xlsx

Location

1. Log into https://office.smartwebs.com and navigate to the correct HOA
2. Click into the Communications area
3. Open the Owner Import area (note: you must have the right privileges to see this area, plus Smartwebs' Accounting must be enabled for this HOA)
4. Upload the Excel file
5. Map the columns (note: before you click run, you may want to save the mapping so you can use it later)
    
   Be sure to click Run, after setting and saving the mappings.
6. Complete the Import
7. You now need to navigate over "Receivables > Charges & Credits" to Post the batch: