Importing Missing Files

Overview

There may be times when you need to import a missing days’ worth of files, even though you have imported and posted data after the date you are missing.  Refer to the instructions below based on whether you have position files for the missing files.

Importing missing days’ worth of transactions with position files

The steps below will only work for custodians that receive a full position file daily. This process will not work for Pershing or DST unless the missing date range is an entire week or month respectively.

  1. Import with the following dates:

    Start Date:   First day that is missing.
    End Date:   Last day that is missing (as long as there are no transaction files in between that have been posted; if so, then this process will need to be completed for each missing date range).

    Note: Keep track of your Start Date prior to importing this data, as you will need to set the Start Date to the correct date once you pick back up with your normal importing.

  2. Go to the Failed Blotter and click Reconcile Historical Date. This will reconcile your data as of the end date you are importing and transactions imported in a file after the end date will be ignored. Click here for more information on Reconciling Historically. 

  3. If warnings have been addressed and reconciliation looks correct for the day’s you are importing, you can Post your data.

Importing missing days’ worth of transactions without historical position files

If you have to import missing files, but you do not have position files for that day, then you can import the files to current and remove the transactions that have already been posted. This will allow you to reconcile to current, prior to posting these missing transactions. Refer to the steps below.

  1. Import with the following dates:

    Start Date:   First day that is missing.
    End Date:   Last Custodian File Date (last file date that was posted).

  2. You will get a warning saying “Importing transactions prior to the default start date may result in duplicated transactions.  Are you sure you want to continue with this start date? “, click OK.

  3. When the data loads into the blotter, you will get a warning saying “You have already posted transactions to one or more of these accounts for the custodian file date. Would you like to verify these accounts? Click Yes to verify on Account Blotter. Click No to continue to Transaction Blotter." Click No to go to the Transactions Blotter.

  4. In the Transactions Blotter, find the Transaction File Date column.

  5. Sort the column by double clicking on the header.

  6. Select all the days that have already been posted. 

    Note: To select a group of transactions, select the first transaction, hold the shift key down and select the last transaction.  This will select all the transactions in between.

  7. Delete the selected transactions.

  8. Reconcile. You will be doing a current reconciliation (as of the Last Custodian File Date), while importing only the missing transactions.

  9. If warnings have been addressed and reconciliation looks correct for the day’s you are importing, you can Post your data.