Icon

Main_​Workflow

Step 1: Read Bank Statements- Select file- Set correct row as column headers
Step 2: Clean up- Remove empty columns- Remove irrelevant or empty rows
Step 3: Standardise bank statement formats- Rename columns to be the same- Concatenate text columns
Step 4: Use LLM to extract customer name from description text to link with ledger
Side note:By concatenating, we can see that the columns in these disparate data sources end up with the same column names and types
Step 4.2: Create prompt.Tell the LLM to extract the name from the description field. (Also concatenate the prompt instrutions with the description field).
Read Ledger:A ledger example to show how to link bank statements against
Step 5: Join ledger with the bank statement. We use the properties:- Date- Amount (Debit)- Customer name -> Extracted from the description fields using the LLMOne might also use a reference number, however it's possible that this might either not be present or isn't unique enough.
Step 4.1: Authenticate access to LLM
Step 4.3: Send prompt to the model and get a response
LLM Bonus: Visualise the 'meaning representation' of the Description test as a scatter plot.
Statement 1
Excel Reader
Statement 2
Excel Reader
Remove rowswith missing date
Row Filter (deprecated)
Remove columnswhich we don't need and empty columns
Column Filter
Remove columnswhich we don't need
Column Filter
Remove rowswith missing date
Row Filter (deprecated)
Remove rowthat is just formatting
Row Filter (deprecated)
Remove rowswith missingamount
Row Filter (deprecated)
Remove rowswith missingamount
Row Filter (deprecated)
Convert text toembedding
Text Embedder
Rename 'Amount'to 'Debit'
Column Renamer
Reduce from 1536dimensions/numersdown to 2dimensions
PCA
String to Date&Time (deprecated)
Configure settingsfor LLM embeddings
OpenAI Embedding Model Selector
Put Credit andDebit in sametable
Concatenate
Make sureDecription isthe RowID soit is visible inthe scatter plot
RowID
Rename columnsinto the unified names
Column Renamer
Only extract 'Bank' records
Row Filter
Split embeddinginto columns
Split Collection Column
Rename 'Amount #1'to 'Credit'
Column Renamer
Scatter Plot
Query LLM
LLM Prompter
Log-in
OpenAI Authenticator
Configure settings for LLM
OpenAI LLM Connector (deprecated)
Create prompt
String Manipulation
Clean up accountnumber which hasother characters
String Manipulation
Concatenate
Sample Ledger
Excel Reader
Rename columnsinto the unified names
Column Renamer
Ensure correcttype of numericalvalues
String to Number
Create prompt
String Manipulation
OpenAIAPI Key
Credentials Configuration
Rename columnsinto the unified names
Column Renamer
Get debit records
Column Filter
String to Number
Get credit records
Column Filter
Convert special stringdate format toKnime Date format
String to Date&Time (deprecated)
Query LLM
LLM Prompter
Convert special stringdate format toKnime Date format
String to Date&Time (deprecated)
Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: jacobcoles
Created at: 2024-10-09
On NodePit since: 2025-09-16
Last update: 2025-09-16
Created with KNIME version: v5.7.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!