How do I remove or include the excluded transactions from the balance and turnover figures in Excel?

The user can decide to ignore the transactions identified on the ‘Excluded’ tab by changing the named value ‘ExclusionFlag_1_0’ within Excel (Formulas -> Name manager); this accepts 0 or 1 (0 to ignore, 1 to add back excluded payments and deduct excluded receipts).

#Transactionsummary #All

Knowledge

Recent Posts

Can't copy and paste from a Barclays bank statement PDF

Copying and pasting gives different text - Extracting transactions from encrypted bank statements

Select the text from your PDF bank statement, copy, then paste into notepad - if you see gibberish or different characters in notepad, then read on. When reading searchable PDF documents StatementRead

Excel Top Tip #10 - Hide #N/A, #VALUE and #DIV/0, and more tips