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:
- 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:
- Period /Day – *Note if the Date is captured the system will automatically insert the Period/Day
At this time you may need to insert columns/headings to ensure you have the compulsory information captured i.e. Ref and Account.
- Note : You may use a “Suspense/Clearing” Account when compiling the Journal. Just remember afterwards to capture the “Correct” General ledger codes in the Transaction batch.
- Note : The Reference fields have been increased to 15 Characters.
- Note : The Details Fields have been increased to 250 Characters.
*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 :
ALWAYS run the Batch Manager Check to ensure all line items contain accurate/accepted information.