Skip to main content

Date of Death Statement Import

This guide walks you through importing holdings for a deceased investment or bank account.

Updated over 6 months ago

TIP: Always verify the date of death in the intake page before validating to ensure accurate historical positions.

1. Accessing the Statement Import Feature

  • Navigate to Inventory or Accounting tab, depending on whether accounting is enabled for your file.

  • Locate and click the Statement Import tab at the top of your page.

2. Preparing to Upload

Before importing:

  1. Ensure you have created at least one deceased investment account or bank account that may contain holdings.

  2. Have a PDF statement ready that covers the period including the date of death.

3. Uploading the Statement

  1. Go to the Statement Import tab.

  2. Either click to upload or drag and drop the PDF file.

  3. Wait for the system to process the file.

  4. Once ready, click Validate Now.

4. Validating the Statement

  1. Select the deceased account (e.g., Charles Schwab) for which you are capturing the date-of-death positions.

  2. The upload will be processed as an initial position only.

  3. Review and confirm:

    • Statement period dates

    • Date of death (pulled from the file’s intake page)

      • If incorrect, update the date directly in the intake page.

  4. Click Next to proceed to holdings.

5. Reviewing Holdings During Import

On the Holdings tab, you will see:

  • Symbol (if applicable)

  • Description (from the statement)

  • Date of death quantity (orange values indicate adjustments due to post-death transactions)

  • Unit cost, market price, and market value (based on adjusted quantities at the date of death)

Key details:

  • Orange values = quantities as of the date of death (may differ from statement due to post-death sales/purchases).

  • Holdings with no quantity in orange = acquired only after the date of death (these will be deselected and excluded from inventory).

  • Holdings are displayed in the same order as the original statement.

6. Finalizing the Import

  1. Review all holdings and confirm accuracy.

  2. Click Validate.

    • If no required fields are missing, you can proceed.

  3. Click Next to prepare for syncing.

  4. Select Sync Now to import the validated data into the system.

  5. A confirmation message will display: “Good job, the document has now been synced.”

Did this answer your question?