Loading
Feature degradation | Gmail Email delivery failureRead More
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Upload Financial Account Data Using Data Loader

            You are here:

            1. Salesforce Help
            2. Docs
            3. Financial Services Cloud Admin Guide

            Upload Financial Account Data Using Data Loader

            Add data about individuals’ financial accounts using Data Loader.

            Required Editions

            Available in: Lightning Experience
            Available in: Professional, Enterprise, and Unlimited Editions
            1. In Data Loader, export the Charges and Fees object to a CSV file. We recommend that you:
              1. Export the data to a new CSV file.
              2. Use the file name charge_fee.csv.
              3. Choose Select all fields when creating your SOQL query.
            2. In the resulting charge_fee.csv file, delete the Id, IsDeleted, CreatedDate, CreatedById, LastModifiedDate ,LastModifiedById, SystemModStamp, LastActivityDate, LastViewedDate, and LastReferencedDate columns.
            3. In the charge_fee.csv file, enter your data for Charges and Fees records.
              Note
              Note As records are created the value of OwnerID defaults to your user ID. To assign another team member as owner, set the OwnerID to the person’s user ID.
            4. In Data Loader, use Insert and identify that you are updating the Charges and Fee object with the data from your updated charge_fee.csv file. Then choose Create or Edit a Map and select Auto-Match Fields to Columns. Upload your data.
            5. In Data Loader, use the Export option to download the content or the Charges and Fees object. Call the exported file loaded_charge_fee.csv. You use this file to identify the ID of charges and feeds items related to Financial Accounts.
            6. In your org, create an initial financial account record for each type of financial account, associated with any client: investment account, bank account, and insurance policy. On one of the financial accounts, designate the client as a joint owner.
            7. In Data Loader, export the FinancialAccount object to a CSV file. We recomment that you:
              1. Export the data to a new CSV file.
              2. Use the file name financialaccount.csv.
              3. Choose Select all fields when creating your SOQL query.
            8. In the resulting financialaccount.csv file, delete the Id, CreatedDate, CreatedById, LastModifiedDate ,LastModifiedById, SystemModStamp, LastActivityDate, LastViewedDate, LastReferencedDate, and FinServHousehold__c columns.
            9. In the financialaccount.csv file, enter the rest of your financial account data.
              We recommend that you use the loaded_charge_fee.csv to determine the ID of Charges and Fees items and add that ID to the fscwmmain__FinancialAccountChargesAndFees__c column. In the client_contact.csv file that you exported during client data upload, copy the values from the AccountId column and paste them into the FinServPrimaryOwner__c column. For any jointly owned financial account, make sure that you enter the correct FinServJointOwner__c value from the AccountId column in the client_contact.csv file. Ensure that you enter the correct value for FinServOwnership__c, using the valid ownership values retrieved in your initial export of financial account data.
            10. In Data Loader, use Insert and identify that you are updating the Financial Accounts object with the data from your updated financialaccount.csv file. Then choose Create or Edit a Map and select Auto-Match Fields to Columns. Upload your data.
            11. In your org, check for the new financial account records to verify your upload.
            12. In Data Loader, export the FinancialAccount object to a CSV file. Choose the file name loaded_financial_accounts.csv. This export file is used later to relate cards, billing statements, financial account transactions, and financial holdings to financial accounts.
            13. If you have card data to upload:
              1. In Data Loader, export the Card object to a CSV file.
              2. Export the data to a new CSV file.
              3. Use the file name card.csv.
              4. Choose Select all fields when creating your SOQL query.
              5. In the resulting card.csv file, delete the Id, CreatedById, LastModifiedDate ,LastModifiedById, SystemModStamp, LastActivityDate, LastViewedDate, and LastReferencedDate columns.
              6. In the card.csv file, enter your data for Card records.
                To add the relevant references, update fscwmmain__AccountHolder__c with the card owner’s accountID, which you can look up in the client_contact.csv file. Then, update fscwmmain__FinancialAccount__c with the financial account’s ID, which you can look up in the loaded_financial_accounts.csv file.
              7. In Data Loader, use Insert and identify that you are updating the Card object with the data from your updated card.csv file. Then choose Create or Edit a Map and select Auto-Match Fields to Columns. Upload your data.
              8. In your org, check for the new card records to verify your upload.
            14. If you have billing statements to upload:
              1. In Data Loader, export the Billing Statement object to a CSV file.
              2. Export the data to a new CSV file.
              3. Use the file name statement.csv.
              4. Choose Select all fields when creating your SOQL query.
              5. In the resulting statement.csv file, delete the Id, IsDeleted, CreatedDate, CreatedById, LastModifiedDate ,LastModifiedById, SystemModStamp, LastActivityDate, LastViewedDate, and LastReferencedDate columns.
              6. In the statement.csv file, enter your data for billing statement records.
                To add the relevant references, update fscwmmain__FinancialAccount__c with the financial account’s ID, which you can look up in the loaded_financial_accounts.csv file.
              7. In Data Loader, use Insert and identify that you are updating the Billing Statement object with the data from your updated statement.csv file. Then choose Create or Edit a Map and select Auto-Match Fields to Columns. Upload your data.
              8. In your org, check for the statement records to verify your upload.
            15. If you have financial account transactions to upload:
              1. In Data Loader, export the Billing Statement object to a new CSV file using the file name loaded_statements.csv. This export file is used to find the details needed to relate financial account transactions to billing statements.
              2. In Data Loader, export the Financial Account Transaction object to a CSV file.
              3. Export the data to a new CSV file.
              4. Use the file name transactions.csv.
              5. Choose Select all fields when creating your SOQL query.
              6. In the resulting transactions.csv file, delete the Id, OwnerID, IsDeleted, CreatedDate, CreatedById, LastModifiedDate ,LastModifiedById, SystemModStamp, LastActivityDate, LastViewedDate, and LastReferencedDate columns.
              7. In the transactions.csv file, enter your data for account transactions records.
                To add the relevant references, update fscwmmain__FinancialAccount__c with the ID of the financial account the transaction is for and ook up financial account’s ID in the loaded_financial_accounts.csv file. Next, update fscwmmain__BillingStatements__c with the ID of the statement the transaction appears on and look up the statement ID in the loaded_statements.csv file. Then, update OwnerID with the user ID of the team member who owns the transaction.
              8. In Data Loader, use Insert and identify that you are updating the Financial Account Transaction object with the data from your updated transactions.csv file. Then choose Create or Edit a Map and select Auto-Match Fields to Columns. Upload your data.
              9. In your org, check for the transaction records to verify your upload.
             
            Loading
            Salesforce Help | Article