top of page

How do excluded transactions affect other analysis areas?


If ExclusionFlagEOD_1_0 is set to 1 and ExclusionFlagEOD_type is set to ‘normal’, excluded transactions are removed from all EOD balances on or after the date of the excluded transaction. If ExclusionFlagEOD_1_0 is set to 1 and ExclusionFlagEOD_type is set to ‘exists’, all transactions are removed from the EOD balance for the date of any excluded transaction. If ExclusionFlagTO_1_0 is set to 1, transactions within the ‘excluded’ tab are removed from the debits and credits total and count summary area for the month in which they occur.


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