Step 1. Navigate to Accounting > Financial > Manage Journal Entry

Step 2.  Select Add Entry from the Page Actions drop down menu to open the General Journal Entry page. 

Step 3. Click Import from Excel at the bottom of the page.

Step 4. In order to import data your spreadsheet must contain the following Column Headers:

  • GL Account - Enter general ledger account number.

  • GL Department (Optional)- If the Association uses Departments to categorize expenses this column must be included. Enter the department number.

  • Memo - Enter a short description of the reason for this journal entry.  

NOTE- This memo will display on the general ledger.

  • Debit - Enter debit amount.

  • Credit - Enter credit amount.

Step 5. Copy and paste your data, including the required column headers into the text box.

Step 6. Click the Save button at the bottom.

 Step 7. Review your journal entry for accuracy.

Step 8.  Click Save or Save and Post when completed. Save will save your Journal Entry without posting to the General Ledger. Save and Post saves journal entry and posts to general ledger.