top of page

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

  • Writer: David
    David
  • Feb 23, 2018
  • 1 min read

Updated: Nov 14, 2019


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).

Recent Posts

See All

Comentarios


Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page