1. Determine the type of records to import or update and create the csv file.
  2. Select the correct module to import into (e.g. General Ledger, Accounts Payable, Payroll...).
  3. Select Administration from the navigation bar.
  4. Click the Import records link.
  5. Select the type of record to import from the list underneath its bold header, double click or choose New Import from the action bar. A new Import parameter will appear.
  6. To Import new records, mark the radio button to "Import new records". To update existing records, mark the radio button for “Update existing records”.
  7. To validate the data before importing, mark the "Validate data only" box.
  8. Select the file to import, by choosing the ellipses in the "Import file" field, below "What file do you want to import?".
  9. In the "Use" field, select appropriate option for the Import ID or Record number based on what is located in the .csv file.
  10. Select the radio button for "Delimited" under "What is the format of this import file?".
  11. Select Next or Click the 2.File Layout tab header, you can preview the file layout and fields that will be imported.
  12. Select Next or Click the 3. Fields tab. On the fields tab, the "Field to Import" column must be mapped the matching "Import Field".
  13. To map the fields, highlight the first row in the "Import these fields:" grid, double click or choose the "Select" button on the correct field under "Available fields". The available field will then be populated in the "Import Field" column. For more information on the Fields tab, review How to map fields to import.
  14. Once all of the Fields to Import are mapped to an Import Field, choose "Validate Now" or "Import Now".
  15. Once the process is complete, the control report can be viewed to view exceptions. If there are no exceptions, the records imported or validated successfully.

Note: When importing, each row in Excel represents a record. If your record has multiple lines of distribution, columns will need to be added for the additional account number(s), amount(s) and project(s) to be distributed to.

For sample files for specific modules, click the links below:
  1. General Ledger Imports
    • Accounts 
    • Account Codes
    • ADP Transactions
    • Projects 
    • Transactions 
    • Budgets 
  2. Accounts Payable Imports
    • Products  
    • Vendors  
    • Invoices  
    • Credit Memos 
    • Recurring Invoices  
    • Purchase Orders 
    • Receipts 
    • Adjustments 
  3. Accounts Receivable Imports
    • Adjustments
    • Clients 
    • Charge
    • Products and Billing Items
    • Invoices
    • Refund
    • Payments
    • Recurring Invoices
  4. Cash Receipts Imports 
    • Payments
  5. Fixed Asset Imports 
    • Assets
    • Transactions
  6. Payroll 
    • Positions
    • Employee Compensation
    • Employees 
    • Time Entry
    • Historic Entry
  7. Student Billing
    • Adjustments
    • Advance Deposits
    • Billing Schedules
    • Charges
    • Credits
    • Financial Aid
    • Payments
    • Product and Billing Items
    • Records
    • Refunds

For complete information, refer to the following: