Note: This option only works well if capturing in arrears, as bank statement entries/positions fluctuate when printing interim statements.

Login per normal Internet login to your own Financial Institution.

Look for Print/Download Statement


Save file to suitable location on your computer.

Open file in Excel or Calc:

*Note the CSV file might contain entries which do not need to be recorded in your Cashbook.

*Note that some financial institutions swap their signs around (e.g Debits shows as – (minus) Figures and Credits as + Figures)

Clear or delete unnecessary fields/rows.

Refer to Help section for Compulsory Fields:

  1. Start by adding the Table Tag – This tells QuickTrav to read/interpret all information to follow:

Enter in Row Number 1, Column A: <TABLE>

2. Charge/create the Headings to accepted headings: (Order of Columns do not matter) Following fields are Compulsory:

At this time you may need to insert columns/headings to ensure you have the compulsory information captured i.e. Ref and Account.

*Handy hint : Instead of Retyping the date simply use the “Find & Replace” function in Excel to get rid of unwanted characters such as “#” etc.

Once the Find & Replace function is completed the date format will be acceptable to QuickTrav.

Close off Excel Journal with </TABLE>

Save CSV file as an Excel/Calc file to a folder you will find.

Time to import the Bank statement created as Excel journal into WinGL: Open the Transaction batch you wish to import into:

Select the “Import”:

Find the file you want to import:

Click on Read Excel:

System will populate Batch worksheet with transactions from the Excel file :

Click on

ALWAYS run the Batch Manager Check to ensure all line items contain accurate/accepted information.