Step 1 - Create a Document AI Schema Config
Set up the Data 360 Document AI processor configuration for a bank statement data extraction. This configuration uses an LLM model to analyze an uploaded bank statement, define the structured fields for extraction, and ensure the output is delivered as a clean, structured JSON schema. Learn more about Document AI.
- On the App Launcher, find and select the Data 360 app (it may appear as Data Cloud).
- Go to the Unstructured Data tab (in some orgs, this may be labeled Process Content).
- On the left-hand navigation menu, click Document AI.
- Click New to create a new configuration.
- Choose how you want to create your document schema configuration by selecting Without a source object.
-
Prepare your bank documents for upload. In the document schema builder, click Upload Files and select your bank statement.
-
On the top left, select any LLM model. Gemini 2.0 Flash is recommended for PDF analysis.
-
Configure extraction fields:
- On the right, under Outputs, click Create Manually and then click Next. Alternatively, you can use auto-extraction and change the fields to reflect what is shown below.
- Click Add Field and add the following fields one-by-one.
| Name | API Name | Field Type | Prompt Instruction |
|---|---|---|---|
| Monthly salary | Monthly_salary | string | Based on the transactions, identify the average salary of the account holder. |
| home loan taken | home_loan_taken | boolean | 1 if there are EMI transactions for home loan. |
| auto loan taken | auto_loan_taken | boolean | 1 if there are EMI transactions for auto loan. |
Verify the results of the bank statement data extraction.
-
Click Test.
-
Document AI processes the uploaded file and extracts the defined fields. Review the output to verify that all fields are extracted correctly.
-
Save the configuration:
- Click Save.
- Enter a Document Schema Name and API Name:
bank_stmt_analyzer. Copy and save the API name for next steps. - Click Save.
You successfully created your Document AI processor configuration for bank statement data extraction. For an example JSON schema, see the complete document schema configuration.
Step 2 - Create Flow to Retrieve File ID from Email Address: Create a screen flow to identify the bank statement file from the customer's email address.