Owner Account > Transaction Tab


Learn how to import charges from the Owner Account screen using Excel. 


Import Charges from Excel


Step 1. In the Owner Account-Transaction Tab, select the Add Charge icon.



Step 2. Complete the following fields in the Overview portion of the Add/Edit Account Charge window.


  • Association - Choose owner Association.

  • Date - Select the Date the account charge should be posted to the owner's account. 

NOTE-  You can only select a date in an open period.  

  • Amount - Enter the total amount of all charges. 

  • Memo - Enter a memo for the account charge.

NOTE-  This Memo will show in the general ledger, but not on the owner's account.

  • Description - Enter a description for the account charge.


Step 3. Click on the Import from Excel button. 



Step 4. Prepare your Excel Spreadsheet with the following column headers:


  • AccountId - Enter the Account ID for the homeowner account

  • Trans Type - Enter the name of the Transaction Type. 

NOTE- Only Trans Types set to a General Ledger account will properly upload.

  • Amount - Enter the Amount of the charge.

  • Memo - Enter a Memo to display on the account.



Step 5. Copy all data in the spreadsheet including the column headers, and paste into the text field. 


Step 6. Click the Save button to complete the upload. 


Step 7. Each entry on the spreadsheet will show up on a line item on the Account Charge Screen. Review the entries for accuracy. 



Step 9. Review the Open charges at the bottom of the screen to make sure the full amount has been entered. When completed correctly the Open amount should be $0.00.


Step 10. When all charges have been entered, click the Save and Post button to finalize.