Activities > Find Account - Transaction Tab or 


Dashboard > Account Search - Transaction Tab


Learn how to upload Payments to an Owner’s Account.


You can upload payments from an Excel spreadsheet directly to an Owner’s account using the Add Payment hyperlink on the Transaction Tab.


NOTE- This page details how to add Payments to a single account. To add Payments to multiple accounts use the Manage Cash Receipts page. CLICK HERE for more information.


Upload Payments


Step 1. Navigate to Activities > Find Account or Dashboard > Account Search.


Step 2. Use the Search fields to locate the correct Account. 


Step 3. Click the hyperlink corresponding to the account.

 


Step 4. Click on the Transaction Tab.


Step 5. Click the Add Payment hyperlink to open the Cash Receipt window.  

 Step 5. Complete the following fields in the Overview portion of the Add/Edit Cash Receipt window


  • Association - Choose owner Association.

  • Type- Select the correct Type from the dropdown menu. This Type refers to the source of the payment. 

  • Payment Type- Select the correct Payment Type from the dropdown menu. 

  • Date - Choose Date that Account Charge needs to be posted to the owner account. 

NOTE-  Can only choose Date in open periods.

  • Amount - Enter Total Amount of all Payments. 

  • Bank Account- Select the Bank Account the payment was deposited to from the dropdown menu.

  • Posted- 

  • Memo - Enter Memo for Account Payment.

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

  • Description - Enter Description for Account Payment.

Step 6. Click Import from Excel in the Account section. 


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


NOTE- Required fields are in bold in the Import from Excel screen. 


  • AccountId - Enter the Account ID for the homeowner account.

  • Amount - Enter the Amount of the payment. 

  • Type - Enter the name of the Transaction Type. 

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

  • Date- Enter the date the payment should post to the Owner Account.

  • CheckNumber- Enter the check number of the payment. 

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



Step 8. Copy all data in the spreadsheet along with the column headers and paste into the text field. 


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


Step 10. Each entry on the spreadsheet will show up as a line item in the Account section.. Review the entries for accuracy. 



Step 11. 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.