Skip to main content

Statement import user guide

Import holdings and transactions from investment statements directly into Estateably using the Statement Import feature. This guide covers file requirements, uploading, reviewing, validating, and syncing data.

Note: This feature is available for organizations that have opted into the financial statement import beta.

Key benefits

The Statement Import feature lets you significantly reduce manual data entry, minimize transcription errors, review and adjust parsed data before import, maintain accurate historical records, and streamline reconciliation.

File requirements

  • Format: PDF only (lowercase .pdf)

  • Max size: under 50 MB and 99 pages or fewer

  • Naming: avoid special characters or spaces in filenames

  • Account structure: one account per file

  • Statement periods: ideally one statement period per PDF

For multiple statement periods in one file: organize statements chronologically (oldest to newest), include transaction history from each statement, include holding details from the last period only, and combine into a single PDF. Upload individual statements in chronological order to maintain accuracy and facilitate reconciliation.

Upload a statement

  1. Select your matter and go to the Accounting section.

  2. Ensure the account you plan to populate is added to the file's Assets page and is in Managed status (Estates only). For deceased accounts, click Manage to make them available.

  3. Select the Statement Import tab.

  4. Click Upload Statement and select your PDF file.

  5. The system confirms it is extracting information and shows a status of Uploading. You can navigate away and return when the notification arrives.

  6. Once parsing is complete, the extracted transaction and holding counts appear with a status of Pending Review.

  7. Click Start Review to begin.

Initiate file review

Estate matters: Select the account from the dropdown. Specify upload type: Initial Position or File Update. Enter statement start and end dates. For a Deceased Investment account, review or enter the Opening Cash Balance (optional). The Date of Death field is read-only — update it in Intake if needed. Click Next.

Trust matters: Select the account. Enter statement start and end dates. Trust Start Date is read-only — update in Intake if needed. Click Next.

Powers of Attorney matters: Select the account. Specify upload type: Initial Position or File Update. Enter statement start and end dates. For a Grantor Investment account, enter the Opening Cash Balance if applicable. PoA Start Date is read-only — update in Intake if needed. Click Next.

Review parsed holdings

  1. The system displays holdings parsed from the statement's Asset Detail section.

  2. Review each holding (sorted in source statement order).

  3. Click Edit to modify Symbol, Description, Quantity, Unit Cost, Market Price, or Market Value. Edit one row at a time and save before selecting another.

  4. Click Save to keep changes or Cancel to revert.

  5. Uncheck any holdings you do not want to import.

Review parsed transactions

  1. Click the Transactions tab.

  2. Review each transaction. Rows highlighted in red require attention.

  3. Click Edit to modify Date, Description, Category, Holding, Money Type, Quantity, or Amount. Edit one row at a time.

  4. Click Save or Cancel.

  5. Uncheck any transactions you don't want to import.

Validate selected holdings and transactions

  1. Click Validate.

  2. The system checks that required fields are complete and that quantities are consistent. If the end-of-period holding quantity in the statement differs from the system's total, you receive a warning.

  3. If no errors are found, a confirmation message appears.

  4. Click Next to proceed to syncing, or Cancel to make changes.

Sync data into Estateably

  1. Click Sync to import all validated holdings and transactions.

  2. The system confirms when syncing is complete.

  3. Click OK to return to the account's Holdings List page.

  4. Validate the imported holdings and transactions.

  5. Click the Statement Import tab to review and import subsequent statements.

Special handling: dividend reinvestments

When a dividend reinvestment transaction is detected, the system asks whether the transaction description reports the price per unit of each additional unit acquired, or the total price paid. Select the relevant option and click Next.

Estateably records dividend reinvestments as two separate transactions: Dividend Income and Investment Purchase. The same applies to interest reinvestments and capital gain distribution reinvestments.

Special handling: Trusts — importing existing holdings without transaction history

For Trust matters, the system automatically determines if any holdings should be classified as Funding Assets to allow importing pre-existing holdings without their transaction history.

After validating and clicking Next, if the system finds holdings where the end-of-period quantity is greater than 0, there are no related purchase/transfer-in/stock split transactions, and the holding doesn't already exist in the selected account, it loads the Review Funding Assets page.

For each listed holding:

  • Keep it as a Funding Asset (recommended if you're not entering older transaction history).

  • Edit the Funding Date if needed.

  • Edit the Quantity if only some units should be treated as funding.

  • Enter the Adjusted Cost Base per Unit for every listed holding.

  • If you plan to enter missing transactions later, clear the Funding Date for that holding — the system will not import those units.

Click Next. If any holdings still have units with no transaction history and are not marked as funding assets, the system warns you. Choose Cancel to fix the Funding Assets page (recommended), or Continue to Sync to proceed.

Important: Units not confirmed as Funding Assets are excluded from the import. Holdings balances in the account will be lower than the statement.

Conclusion

All validated holdings and transactions are now imported. Contact [email protected] if you need help.

Related articles

Did this answer your question?