The general idea of reconciliation is to compare two sets of data and check whether the entries in one dataset equal the entries in the other.
When it comes to account reconciliation, you’re comparing two financial records and want to confirm they are consistent and complete so that only correct values are reported in the general ledger. Discrepancies will uncover mistakes from simple errors through to fraudulent activities.
This blueprint workflow can be deployed as a data app and lets users perform bank reconciliation, one of the most popular types of account reconciliation which compares the company’s internally recorded transactions, e.g. in the cash book with transactions recorded externally, e.g. bank statements provided by the bank.
This workflow being deployed as a data app lets the user interact easily with the underlying workflow. For example, upload their own bank statement and cash book data, or define a specific time period for the bank reconciliation to be performed
The workflow uses example data available on Kaggle.
Read more on the topic Bank Reconciliation on the KNIME Blog: https://www.knime.com/blog/knime-finance-bank-reconciliation
URL: Kaggle dataset https://www.kaggle.com/datasets/fozianazar/bank-reconciliation-statement
URL: KNIME Blog: Bank Reconciliation https://www.knime.com/blog/knime-finance-bank-reconciliation
To use this workflow in KNIME, download it from the below URL and open it in KNIME:
Download WorkflowDeploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.
Try NodePit Runner!Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com.
Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.