Support Center

How to import into The Financial Edge

Last Updated: May 16, 2014 07:03AM CDT
Import allows you to add multiple new records and update existing records from a Comma Separated Value (CSV) file. This solution provides step-by-step instruction on the import process within the Financial Edge.

Answer

  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 (BB749156).
  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: The Import parameter can be saved for future use, but it is not required.
For sample files for specific modules, click the links below:
  1. General Ledger Imports
    • Accounts 
    • Account Codes 
    • 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

Contact Us

  • Email Us
  • Congregation Connect support is available via email. Please email support@congregationconnect.com and one of our Support Specialists will respond as quickly as possible.
https://cdn.desk.com/
false
cloud4good
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete