Skip to content

STATEMENT & LEDGER IMPORTS

From source records to reviewed treasury information.

Prepare supported AIF and PMS statements and ICF ledger exports, then use the review process for that investment workflow.

Choose the format for your workflow

AIF: CAMS statement PDFs

Use the supported CAMS AIF statement-of-account PDF format. Review extracted statement information, transaction rows and reconciliation details in the ingestion batch before application.

Explore AIF coverage

PMS: holdings CSV

Prepare holdings using the supported PMS CSV template. Review the uploaded statement and reconciliation information for the selected managed portfolio before applying it.

Explore PMS coverage

ICF: ERP Party Ledger / SAP Confirmation

Choose a certified ledger profile for the selected ICF deal. Supported workbook profiles include ERP Party Ledger and SAP Confirmation of Accounts; confirm that your particular SAP or Tally export matches an available profile.

Explore ICF coverage

A practical preparation checklist

  1. Match the source format

    Use the template or certified format offered in the relevant upload screen. A file extension alone does not establish compatibility: column names, document layout and the meaning of the source values matter.

  2. Confirm the record and period

    Check the entity, fund or portfolio, and the deal or account associated with the upload. Review the statement date or ledger period against the records you intend to update.

  3. Inspect the review results

    Compare extracted or imported information with the original source. Review validation messages, duplicate or matching information and any reconciliation differences shown for that workflow.

  4. Complete the applicable review

    Follow the upload screen’s review and application steps. AIF ingestion, PMS statement reconciliation and ICF ledger application have distinct controls; governed actions use the applicable approval process.

Check the format before changing the file

These workflows accept supported files uploaded by your team. They do not establish a direct connection to SAP or Tally, or support every statement provider and export layout.

If your file is rejected or its layout is unfamiliar, retain the original and check the supported format with your treasury administrator or Help & Support. Include the format name and validation message when describing the issue.

Discuss your source formats

LET’S TALK TREASURY

Start with the records you use.

Tell us which investment statements and ledger exports your team works with so we can discuss the relevant workflow.

Explore a demo