Quickbooks and Excel

A great combination !

Supplier BACS payments

Ever since Intuit brought out Quickbooks 2008 in the UK, the supplier BACS payment feature has been absent.The last version in the UK which could generate BACS file was version 2006.

Although version 2006 could generate BACS file, it generated a file for each payment. This was of little use since the benefit of BACS payment is that you can send the bank one file of multiple payments. Furthermore, the format was not readily compatible with the layout that different banks required. This led to third-party applications being used to combine fragmented files and convert them to something that could be imported into specific bank software. Now there is no BACS file of any kind that can be converted.

However, there is a very simple way around this. All you need to do is generate a Quickbooks report which provides the supplier name, bank details, amount and payment date. Then, export to excel and run this report through a macro which converts it to a file that can be read by the bank’s software. I have written such a macro and you can follow the link below for more information.

Supplier BACS payment

April 13th, 2013 Posted by | supplier BACS | no comments