---
title: Loading Data from External Systems
description: There are several different methods for loading data from outside of your core system into FI Works. The method used is based on the structure of the data in the external system. FI Works stores data
---

[Skip to content](https://support.fiworks.com/loading-data-from-external-systems#main-content)

English

Show submenu for translations

![fiworks\_logo\_color\_hex-1.png\]](https://support.fiworks.com/hs-fs/hubfs/fiworks_logo_color_hex-1.png?height=40&name=fiworks_logo_color_hex-1.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Go to fiworks.com](https://www.fiworks.com/)

[Go to fiworks.com](https://www.fiworks.com/)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Center](https://support.fiworks.com/?hsLang=en)
2. [Administration Guide](https://support.fiworks.com/administration-guide?hsLang=en)

# Loading Data from External Systems

There are several different methods for loading data from outside of your core system into FI Works. The method used is based on the structure of the data in the external system.

FI Works stores data in a similar way to your core system. When we load information for external systems, it get loaded into the same structure:

| **Customer** | **Customer / Account** | **Account** |
| --- | --- | --- |
| - Customer ID - Name - Address - City - State - Postal Code - Tax ID - Birthdate - **Customer service (e.g. digital service** | - Customer ID - Application Code - Account Number | - Application Code - Account Number - Account Status - Product Code - Product Name - Class Code - Account ownership (personal vs business) - Balance - Interest Rate - Fees - **Account service (e.g. e-statements)** |

**Completely External Systems**

Some external systems are completely separated from the core system. In this case, we need customer, customer/account, and account data in order to load the data. The export capabilities of these systems is often limited and it may not be possible to separate the data into the structure above. While providing the data like this is preferred, it may be necessary to extract a single flattened file. FI Works can then load the data and break it down into the preferred structure.

**External Accounts Referenced in the Core**

Some institutions have information in the CIF/CIS that contain references to external accounts. In these cases, all of the information for customers that have external accounts are in the CIF/CIS with reference to the external account. FI Works can then load the account-level data and link it back to the data from the CIF/CIS. The application code and account number in the external must match the customer/account data in the core.

**External Customer Service**

In this scenario, the external system has information about a service (online banking, mobile banking, etc.) for a specific. We load this kind of information as a service attached to the customer. To load this data, FI Works just needs the Customer ID and the service name.

**External Account Service**

In this scenario, the external system has information about a service (e-statements, merchant services, etc.) for a specific account. We load this kind of information as a service attached to the account. To load this data, FI Works just needs the application code, account number, and service code/name.

- [Getting Started](https://support.fiworks.com/getting-started?hsLang=en#main-content)

    - [FI Works Overview](https://support.fiworks.com/getting-started?hsLang=en#fi-works-overview)
    - [Accessing the Application](https://support.fiworks.com/getting-started?hsLang=en#accessing-the-application)
    - [Getting Around](https://support.fiworks.com/getting-started?hsLang=en#getting-around)
- [User Guide](https://support.fiworks.com/user-guide?hsLang=en#main-content)

    - [Scorecards](https://support.fiworks.com/user-guide?hsLang=en#scorecards)
    - [Data Analytics](https://support.fiworks.com/user-guide?hsLang=en#data-analytics)
    - [Dashboards](https://support.fiworks.com/user-guide?hsLang=en#dashboards)
    - [Search](https://support.fiworks.com/user-guide?hsLang=en#search)
    - [Profiles](https://support.fiworks.com/user-guide?hsLang=en#profiles)
    - [Activities](https://support.fiworks.com/user-guide?hsLang=en#activities)
    - [Sales & Contact Management Tools](https://support.fiworks.com/user-guide?hsLang=en#sales-contact-management-tools)
    - [Leads and Prospects](https://support.fiworks.com/user-guide?hsLang=en#leads-and-prospects)
    - [Centers of Influence](https://support.fiworks.com/user-guide?hsLang=en#centers-of-influence)
    - [Sales Reporting and Analytics](https://support.fiworks.com/user-guide?hsLang=en#sales-reporting-and-analytics)
    - [Marketing Automation](https://support.fiworks.com/user-guide?hsLang=en#marketing-automation)
    - [Settings](https://support.fiworks.com/user-guide?hsLang=en#settings)
    - [Profitability](https://support.fiworks.com/user-guide?hsLang=en#profitability)
    - [Demographics](https://support.fiworks.com/user-guide?hsLang=en#demographics)
- [Administration Guide](https://support.fiworks.com/administration-guide?hsLang=en#main-content)

    - [Application Settings](https://support.fiworks.com/administration-guide?hsLang=en#application-settings)
- [FAQs](https://support.fiworks.com/faqs?hsLang=en#main-content)

    - [FAQs](https://support.fiworks.com/faqs?hsLang=en#faqs)
- [Announcements](https://support.fiworks.com/announcements?hsLang=en#main-content)

    - [Release Notes](https://support.fiworks.com/announcements?hsLang=en#release-notes)

# FI Works

fiworks.com Help Center

Copyright © 2025, FI Works