Icon

SAP_​001_​Bank_​Reconciliation

🎯 Technical Objective

To automate the monthly bank reconciliation process by dynamically reading and joining multiple files based on variable file paths and filtering criteria.

🛠️ KNIME Nodes to Use

  • File Handling & Iteration: List Files, Path to String,Table Row to Variable Loop Start

  • Data Reading: CSV Reader (configured with flow variables for file path)

  • Loop Control: Loop End

  • Data Cleaning: String Manipulation, GroupBy

  • Data Transformation & Joining: Joiner

  • Computation and Checks: Row Filter, Math Formula

  • Date Tagging: Date&Time Part Extractor, String to Date&Time

  • Output: Excel Writer (optional, for unmatched transactions)

Nodes

  • No nodes found

Extensions

  • No modules found

Links