Icon

EAR Audit Digitization

1. Open t-code ZBR2. Input all LEs and download ZBR per month (e.g. J-A-S)3. Select Change Layout > Remove Summation (Bank Account Balance, GL Balance,Difference)4. Export in Excel format5. Load the 3 excel files in Excel Reader**Note only: In Rule-based Row Filter - Filter Manual Bank Statement - It excludes non MNLbanks for RU - CEB, AIB, Gazprom, OTP, Emlak, Deniz6. In Value LookUp - SKB1 Check; Validate if the Match Found column contains all TRUEvalues7. In Row Sampling - Randomizer Node, confirm the Samples and Sampling Method 1. Open SAP HGP2. Open t-code ZSE16N3. Input table SKB14. Input Company Code and GL Account 0010+++++05 Go to settings - format list - choose fields and ticked off everything and only choose the ff(CoCode, G/L, Created On (optional), Created by (optional), Field status gp, HouseBank(optional), Account ID (optional), Account CCY (optional), OI Management, Posting Block6. Set width of ouput list and maximum no. of hits to max limit: 999999 7.Go to Edit > Download; Export in Excel format8. Load in Excel Reader Update LE list file for new entities and market owner 1. Update the Date File - All dates for the quarter2. In Row Sampling - Randomizer Node, confirm the Samples and Sampling Method 1. Open t-code ZGBSR_REPT2. Select Analysis Report for BSR Data3. Fill out the ff: BSR Period, Ledger - OL, Company Code - All LEs, Account Function -*TREASURY*4. Select Download with Comments Steps:1. Update the AA Tool for FX and OIX entries.2. Load them in the Excel Reader. 3. Export. Steps:1. Update the AA Tool for OIX entries.2. Load in the Excel Reader. 3. Export. Steps:1. Update the AA Tool for FX entries.2. Load in the Excel Reader. 3. Export. Steps:1. Update three AA Tool files for TF entries for each period.2. Load them in the Excel Reader.3. Export. Steps:1. Update three AA Tools for MFR - one for each period2. Load them in the Excel Reader. 3. Export. SKB1 TableZBR Month 1ZBR Month 2ZBR Month 3BGJOB or NTBRT-NumberExportCombine all ZBR FilesFilter H2H Bank Statement TF entriesfor P1TF entriesfor P2Remove blocked GL "X" in Posting BlockRemove "X" in OI ManagementSKB1 CheckRemove NON CASH in Field Status GPLE ListAdd Region and MarketConvert LE Code to StringOIX Entriesfor the quarterVLOOKUPmarket, regionand ownerRandomizer NodeRenamecolumnsDateExtract Day of WeekRemove SaturdayRemove SundayRandomizer Node H2HLE List with ownersBank Statement 1RenamecolumnsSKB1 CheckFilter Manual Bank StatementAdd Region and MarketExclude "TP" docsFilter those greater than> 5M USDUpdate T-Numberof entriescreated via JESLE List with ownersRandomizer NodeRemove SundayRemove SaturdayRandomizer Node ManualExtract Day of WeekBank Statement 2Node 45BR T-NumbersBSR 1 ALL REDSort fromhighestto lowestRandomizer NodeLE ListAdd Region and MarketConvert LE Code to StringRandomizer NodeBSR 2 RECONCILED AND REVIEWEDBSR 3 OVERALL BSR MANUALRandomizer NodeBSR 3 OVERALL BSR ACROSS ACCOUNT GROUPSBSR 4 WSS AccountsMore than 10,000Randomizer NodeNode 81Filter BR ManagersNAMLATAMRandomizer NodeCombineFX Entriesfor the QuarterFilter Based on"JE Created By"Exclude "TP" docsExclude "TF" docsExportFilter Based on"JE Created By"BGJOB or NTBRT-NumberLE List with ownersVLOOKUPmarket, regionand ownerSamplingbased onregion volumeSamplingbased onregion volumeOIX Entriesfor the QuarterExclude "TF" docsVLOOKUPmarket, regionand ownerVLOOKUPmarket, regionand ownerFilter Based on"JE Created By"BR ownersCombineRenamecolumnsConvert to NumberConvertto absolutevalueExportFilter those greater than> 5M USDUpdate T-Numberof entriescreated via JESLE List with ownersFilter Based on"JE Created By"BR ownersFX Entries for the QuarterCombineRenamecolumnsFilter Based on"JE Created By"BR ownersFilter Based on"JE Created By"BR ownersBR T-NumbersConvert to NumberConvertto absolutevalueTF entriesfor P3CombineReplace "#" to blank(Clearing Date column)Sampling based on Region's volumeLE List with ownersRemove header rowExportRemove header rowValue DateRemove header rowValue DateFilter Value Dateduring the quarterPosting Date &Clearing DateVLOOKUPmarket, regionand ownerComputeagingCombine allTFs with no Clearing Date yetValue DateFilter aging>5 daysOpen MFRs as ofPeriod 2Open MFRs as ofPeriod 3Combine all Excel filesAdd "Period 1"Add "Period 2"Add "Period 3" LE List with ownersRenamecolumnsVLOOKUPmarket, regionand ownerSamplingbased onPeriodOpen MFRs as ofPeriod 1Removeheaderrows Excel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Writer Concatenate Row Filter Excel Reader Excel Reader Row Filter Row Filter Value Lookup Row Filter Excel Reader Value Lookup Number to String Excel Reader Joiner Row Sampling Column Renamer Excel Reader Extract Date&TimeFields Row Filter Row Filter Row Sampling Excel Reader Excel Writer Column Renamer Value Lookup Rule-basedRow Filter Value Lookup Row Filter Row Filter String Manipulation Excel Reader Row Sampling Row Filter Row Filter Row Sampling Extract Date&TimeFields Excel Writer Excel Reader Excel Reader Row Filter Sorter Row Sampling Excel Reader Value Lookup Number to String Row Sampling Rule-basedRow Filter Rule-basedRow Filter Row Sampling Row Sampling Rule-basedRow Filter Row Filter Row Sampling Excel Writer Rule-basedRow Filter Row Filter Row Filter Row Sampling Concatenate Excel Reader ReferenceRow Filter Row Filter Row Filter Excel Writer ReferenceRow Filter Excel Reader Excel Reader Joiner Row Sampling Row Sampling Excel Reader Row Filter Joiner Joiner ReferenceRow Filter Concatenate Column Renamer String to Number Math Formula Excel Writer Row Filter String Manipulation Excel Reader ReferenceRow Filter Excel Reader Concatenate Column Renamer ReferenceRow Filter ReferenceRow Filter Excel Reader String to Number Math Formula Excel Reader Concatenate String Manipulation Row Sampling Excel Reader Row Filter Excel Writer Row Filter String to Date&Time Row Filter String to Date&Time Date&Time-basedRow Filter String to Date&Time Joiner Date&TimeDifference Concatenate Row Filter String to Date&Time Row Filter Excel Reader Excel Reader Concatenate ConstantValue Column ConstantValue Column ConstantValue Column Excel Reader Column Renamer Joiner Row Sampling Excel Reader Missing Value 1. Open t-code ZBR2. Input all LEs and download ZBR per month (e.g. J-A-S)3. Select Change Layout > Remove Summation (Bank Account Balance, GL Balance,Difference)4. Export in Excel format5. Load the 3 excel files in Excel Reader**Note only: In Rule-based Row Filter - Filter Manual Bank Statement - It excludes non MNLbanks for RU - CEB, AIB, Gazprom, OTP, Emlak, Deniz6. In Value LookUp - SKB1 Check; Validate if the Match Found column contains all TRUEvalues7. In Row Sampling - Randomizer Node, confirm the Samples and Sampling Method 1. Open SAP HGP2. Open t-code ZSE16N3. Input table SKB14. Input Company Code and GL Account 0010+++++05 Go to settings - format list - choose fields and ticked off everything and only choose the ff(CoCode, G/L, Created On (optional), Created by (optional), Field status gp, HouseBank(optional), Account ID (optional), Account CCY (optional), OI Management, Posting Block6. Set width of ouput list and maximum no. of hits to max limit: 999999 7.Go to Edit > Download; Export in Excel format8. Load in Excel Reader Update LE list file for new entities and market owner 1. Update the Date File - All dates for the quarter2. In Row Sampling - Randomizer Node, confirm the Samples and Sampling Method 1. Open t-code ZGBSR_REPT2. Select Analysis Report for BSR Data3. Fill out the ff: BSR Period, Ledger - OL, Company Code - All LEs, Account Function -*TREASURY*4. Select Download with Comments Steps:1. Update the AA Tool for FX and OIX entries.2. Load them in the Excel Reader. 3. Export. Steps:1. Update the AA Tool for OIX entries.2. Load in the Excel Reader. 3. Export. Steps:1. Update the AA Tool for FX entries.2. Load in the Excel Reader. 3. Export. Steps:1. Update three AA Tool files for TF entries for each period.2. Load them in the Excel Reader.3. Export. Steps:1. Update three AA Tools for MFR - one for each period2. Load them in the Excel Reader. 3. Export. SKB1 TableZBR Month 1ZBR Month 2ZBR Month 3BGJOB or NTBRT-NumberExportCombine all ZBR FilesFilter H2H Bank Statement TF entriesfor P1TF entriesfor P2Remove blocked GL "X" in Posting BlockRemove "X" in OI ManagementSKB1 CheckRemove NON CASH in Field Status GPLE ListAdd Region and MarketConvert LE Code to StringOIX Entriesfor the quarterVLOOKUPmarket, regionand ownerRandomizer NodeRenamecolumnsDateExtract Day of WeekRemove SaturdayRemove SundayRandomizer Node H2HLE List with ownersBank Statement 1RenamecolumnsSKB1 CheckFilter Manual Bank StatementAdd Region and MarketExclude "TP" docsFilter those greater than> 5M USDUpdate T-Numberof entriescreated via JESLE List with ownersRandomizer NodeRemove SundayRemove SaturdayRandomizer Node ManualExtract Day of WeekBank Statement 2Node 45BR T-NumbersBSR 1 ALL REDSort fromhighestto lowestRandomizer NodeLE ListAdd Region and MarketConvert LE Code to StringRandomizer NodeBSR 2 RECONCILED AND REVIEWEDBSR 3 OVERALL BSR MANUALRandomizer NodeBSR 3 OVERALL BSR ACROSS ACCOUNT GROUPSBSR 4 WSS AccountsMore than 10,000Randomizer NodeNode 81Filter BR ManagersNAMLATAMRandomizer NodeCombineFX Entriesfor the QuarterFilter Based on"JE Created By"Exclude "TP" docsExclude "TF" docsExportFilter Based on"JE Created By"BGJOB or NTBRT-NumberLE List with ownersVLOOKUPmarket, regionand ownerSamplingbased onregion volumeSamplingbased onregion volumeOIX Entriesfor the QuarterExclude "TF" docsVLOOKUPmarket, regionand ownerVLOOKUPmarket, regionand ownerFilter Based on"JE Created By"BR ownersCombineRenamecolumnsConvert to NumberConvertto absolutevalueExportFilter those greater than> 5M USDUpdate T-Numberof entriescreated via JESLE List with ownersFilter Based on"JE Created By"BR ownersFX Entries for the QuarterCombineRenamecolumnsFilter Based on"JE Created By"BR ownersFilter Based on"JE Created By"BR ownersBR T-NumbersConvert to NumberConvertto absolutevalueTF entriesfor P3CombineReplace "#" to blank(Clearing Date column)Sampling based on Region's volumeLE List with ownersRemove header rowExportRemove header rowValue DateRemove header rowValue DateFilter Value Dateduring the quarterPosting Date &Clearing DateVLOOKUPmarket, regionand ownerComputeagingCombine allTFs with no Clearing Date yetValue DateFilter aging>5 daysOpen MFRs as ofPeriod 2Open MFRs as ofPeriod 3Combine all Excel filesAdd "Period 1"Add "Period 2"Add "Period 3" LE List with ownersRenamecolumnsVLOOKUPmarket, regionand ownerSamplingbased onPeriodOpen MFRs as ofPeriod 1RemoveheaderrowsExcel Reader Excel Reader Excel Reader Excel Reader Excel Reader Excel Writer Concatenate Row Filter Excel Reader Excel Reader Row Filter Row Filter Value Lookup Row Filter Excel Reader Value Lookup Number to String Excel Reader Joiner Row Sampling Column Renamer Excel Reader Extract Date&TimeFields Row Filter Row Filter Row Sampling Excel Reader Excel Writer Column Renamer Value Lookup Rule-basedRow Filter Value Lookup Row Filter Row Filter String Manipulation Excel Reader Row Sampling Row Filter Row Filter Row Sampling Extract Date&TimeFields Excel Writer Excel Reader Excel Reader Row Filter Sorter Row Sampling Excel Reader Value Lookup Number to String Row Sampling Rule-basedRow Filter Rule-basedRow Filter Row Sampling Row Sampling Rule-basedRow Filter Row Filter Row Sampling Excel Writer Rule-basedRow Filter Row Filter Row Filter Row Sampling Concatenate Excel Reader ReferenceRow Filter Row Filter Row Filter Excel Writer ReferenceRow Filter Excel Reader Excel Reader Joiner Row Sampling Row Sampling Excel Reader Row Filter Joiner Joiner ReferenceRow Filter Concatenate Column Renamer String to Number Math Formula Excel Writer Row Filter String Manipulation Excel Reader ReferenceRow Filter Excel Reader Concatenate Column Renamer ReferenceRow Filter ReferenceRow Filter Excel Reader String to Number Math Formula Excel Reader Concatenate String Manipulation Row Sampling Excel Reader Row Filter Excel Writer Row Filter String to Date&Time Row Filter String to Date&Time Date&Time-basedRow Filter String to Date&Time Joiner Date&TimeDifference Concatenate Row Filter String to Date&Time Row Filter Excel Reader Excel Reader Concatenate ConstantValue Column ConstantValue Column ConstantValue Column Excel Reader Column Renamer Joiner Row Sampling Excel Reader Missing Value

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: moya.nt
Created at: 2025-10-09
On NodePit since: 2026-05-02
Last update: 2026-05-02
Created with KNIME version: v5.2.0
Tags: DATA CLASSIFICATION: BUSINESS USEPII: NOPRODUCTIVITY: PERSONALSOX: NOSTAGE: ACTIVE

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

Try NodePit Runner!