top of page

How do I create a template for Barclays duplicate statements with column dashes?

This template hasn’t been released as this format often changes depending on which branch printed the bank statements. Here are some tips on creating your own template:

First, if possible create a searchable PDF document from your scanner.

Then, select the built-in template creation tool within StatementReader to create your own template. A screenshot of the template creation process using a similar bank statement is available on request.

Note that by placing the columns over the dashes next to the date (and ticking the correct option) these dashes will be removed. It is also important to tick the 'bottom date' option for this format. Remember to process the file with 'run as full page table' ticked, if some pages don't have any column headers.

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