Importing Journal Entries

This is how to use the Journal Entry Import tool to import Journal Entries from Excel.

File Format

First, the Excel file must have an extension of XLSX or CSV. The file must contain the following columns (Headers for each column must match exact):

•  GL_Code
  • Required
• Cost_Center
  • Required
• Note
  • Column is required, however note for each line is optional
• Amount
  • Required
  • POSITIVE values = DEBITS
  • NEGATIVE values = CREDITS
  • Sum of all amount values must equal zero.

Location

1. Log into https://office.smartwebs.com and navigate to the correct HOA
2. Click on the Accounting Icon
3. Go to GL > Journal Entries

Steps

1. Click on Add a Journal Entry and select Import JE From File
2. Choose your date and fill in the memo.
3. Click the upload arrow or drag and drop your file into the drawer
4. Click Post.