top of page

How can I separate the analysis of multiple accounts that use the same bank template?

At the analysis stage the data is combined (into Transactions1, Transactions2 etc) based on the bank_layout column; therefore to separate accounts that use the same bank template, the user must change the bank_layout value for each transaction that needs to be separated. This should be done at the validation stage of processing the data (after the data is extracted), then the amended Excel file must be updated within StatementReader (by right clicking on the StatementReader job and selecting ‘import your corrections from Excel’).

separate analysis multiple accounts same template

Recent Posts

See All

Improving Excel with Python (May 2022)

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page