Icon

Financial Modelling Basics

Final Initial

Journals

Final Second

Journals

Final Table

1. Read Data
Excel Reader
2. Add Columns forCost / Rev RecognitionpRevenuespAccountsReceivablepCostsofGoodsSoldpAccountsPayable
Expression
3. "Explode" data set:For each original row, createadditional rows equal to Duration
One Row to Many
4b. Split at pos 6,before 6: col x,after 6, col periodNo
Cell Splitter By Position
4a. Extract rowIDs to column"periodNumberMapping"
RowID
4c. convertperiodNo to Intand deduct 1
Expression
4d. Shift Start Dateby periodNo
Date&Time Shift
4e. Clean Up:Remove columns not required
Column Filter
5b. Shift Start Date by1 monthsfor Cash In
Date&Time Shift
5b. Shift Start Date by2 monthsfor Cash Out
Date&Time Shift
5a. Keep AR
Column Filter
5a. Keep AP
Column Filter
5c Add Bank = ARThen:Invert AR
Expression
5c Add Bank = APThen:Invert AP
Expression
6a. Rename Start Dateto date
Column Renamer
6a. Rename Start Dateto date
Column Renamer
6a. Rename Start Dateto date
Column Renamer
6b. UnpivotValue Columns
Unpivot
6b. UnpivotValue Columns
Unpivot
6b. UnpivotValue Columns
Unpivot
6c. Combine all Data Sets
Concatenate
RenameColumn Names => AccountColumn Values => Value
Column Renamer

Nodes

Extensions

Links