Icon

Solution 3 - Perform Month-End Adjustments and Visualise

<p>In this exercise, you will calculate the month-end adjustments and visualise the results</p>
Exercise 3 - Perform Month-End Adjustments and Visualise Learning objective: In this exercise, you will calculate the month-end adjustments and visualise the resultsYou will find the instructions to the exercises in the yellow annotations. Activity I: Import and Process Trial BalanceRead the month_end_adjustments_journal.csv file. You canfind it in the data folder.Using a Column Splitter node, split the adjustments into Debitsand Credits Activity II: Handle and Join the DebitsMake the Amount Debited column negative*Use a Joiner node to join the Trial Balance to the Month EndDebit AdjustmentsUse the Account Name as joining columnPerform a left outer join, in order to also include the rows fromthe trial balance that do not have a match in the adjustmentfile.*Note: You can do this operation with a Math Formula or aColumn Expression node Activity III: Join the Credits and Calculate the Balance PostAdjustmentsUse a Joiner node to join the trial balance (and the debits) tothe Month End Credit Adjustments.Calculate*the Adjusted Balancethe Absolute BalanceNote*: You can do this operation with two Math Formula nodesor just one Column Expression node Activity IV: StatisticsUse a Statistics View node to visualise the basic columnstatistics Import and Manipulate Journal ExtractThis part is covered in Exercise 1 Reconcile to Trial BalanceThis part is covered in Exercise 2 Activity V: Pie Chart VisualizationsFilter the Debts with a Row Filter nodeVisualise the Monthly Expenses in a Pie ChartFilter the Credits with a Row Filter nodeExclude the Cash account typeVisualise the Monthly Expenses in a Pie Chart Raw Journal ExportTrial BalanceNode 125View Basic column statisticsMake debits negativeAdjustmentsFileJoin Trial Balanceto the Month End DebitadjustmentsSplit adjustments intoDebits and CreditsCalculateBalance PostAdjustmentsJoin Trial Balance to Month End CreditadjustmentsNode 139Monthly ExpensesMonthly incomeFilter DebitsFilter CreditsExclude "Cash"Account Type CSV Reader CSV Reader Process Journal Statistics View Math Formula CSV Reader Joiner Column Splitter Column Expressions Joiner Reconcile toTrial Balance Pie Chart Pie Chart Row Filter Row Filter Row Filter Exercise 3 - Perform Month-End Adjustments and Visualise Learning objective: In this exercise, you will calculate the month-end adjustments and visualise the resultsYou will find the instructions to the exercises in the yellow annotations. Activity I: Import and Process Trial BalanceRead the month_end_adjustments_journal.csv file. You canfind it in the data folder.Using a Column Splitter node, split the adjustments into Debitsand Credits Activity II: Handle and Join the DebitsMake the Amount Debited column negative*Use a Joiner node to join the Trial Balance to the Month EndDebit AdjustmentsUse the Account Name as joining columnPerform a left outer join, in order to also include the rows fromthe trial balance that do not have a match in the adjustmentfile.*Note: You can do this operation with a Math Formula or aColumn Expression node Activity III: Join the Credits and Calculate the Balance PostAdjustmentsUse a Joiner node to join the trial balance (and the debits) tothe Month End Credit Adjustments.Calculate*the Adjusted Balancethe Absolute BalanceNote*: You can do this operation with two Math Formula nodesor just one Column Expression node Activity IV: StatisticsUse a Statistics View node to visualise the basic columnstatistics Import and Manipulate Journal ExtractThis part is covered in Exercise 1 Reconcile to Trial BalanceThis part is covered in Exercise 2 Activity V: Pie Chart VisualizationsFilter the Debts with a Row Filter nodeVisualise the Monthly Expenses in a Pie ChartFilter the Credits with a Row Filter nodeExclude the Cash account typeVisualise the Monthly Expenses in a Pie Chart Raw Journal ExportTrial BalanceNode 125View Basic column statisticsMake debits negativeAdjustmentsFileJoin Trial Balanceto the Month End DebitadjustmentsSplit adjustments intoDebits and CreditsCalculateBalance PostAdjustmentsJoin Trial Balance to Month End CreditadjustmentsNode 139Monthly ExpensesMonthly incomeFilter DebitsFilter CreditsExclude "Cash"Account Type CSV Reader CSV Reader Process Journal Statistics View Math Formula CSV Reader Joiner Column Splitter Column Expressions Joiner Reconcile toTrial Balance Pie Chart Pie Chart Row Filter Row Filter Row Filter

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: J Crossman-Smith
Created at: 2024-03-25
On NodePit since: 2025-11-04
Last update: 2025-11-04
Created with KNIME version: v5.3.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!