Icon

Incorrect Totals

<p><strong>Incorrect Totals</strong></p><p>This workflow is useful to identify transactions that contain incorrect total amounts. It can be applied to a wide variety of data (e.g., invoices, purchase orders, accounts receivable etc.)</p><p>This analytic identifies transactions where the total amount is incorrect based on a comparison with the calculated amount (unit quantity multiplied by unit price). These types of errors can be either unintentional or deliberate.</p>

Incorrect Totals

This workflow is useful to identify transactions that contain incorrect total amounts. It can be applied to a wide variety of data (e.g., invoices, purchase orders, accounts receivable etc.)

This analytic identifies transactions where the total amount is incorrect based on a comparison with the calculated amount (unit quantity multiplied by unit price). These types of errors can be either unintentional or deliberate.

Data Reading

Upload your own Excel file, or try the workflow with a provided sample file.

Data Exploration

Data Validation

Identify Transactions with Incorrect Totals

Dashboard & Report Generation

Select the type of reportyou want to generate
Analysis Dashboard & Report
For numeric columns:it checks missing values andcomputes summary stats
Statistics of Dataset
Upload your Excel file
File Upload
Apply different teststo validate data (numeric,strig, date&time,missing values, etc.)
Data Validation
View dashboardwith results
Incorrect Totals
Select fields(e.g., quantity, unit price,invoice totals, etc.)
Field Selection

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: Brijesh AH
Created at: 2025-05-14
On NodePit since: 2025-10-03
Last update: 2025-10-22
Created with KNIME version: v5.7.0
Tags: AuditFinanceTotal amountsaccounting

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

Try NodePit Runner!