BACS files for supplier payments - Quickbooks UK 2010 + 2012 (by Daniel Didier)

As most long-standing users of Quickbooks know, Intuit took out the BACS facility when they introduced Quickbooks 2008. The last version which produced supplier payments BACS files was version 2006 - or dit it ? It certainly produced fragmented files which then had to be merged using a third-party tool and then had to be formatted by a third party app in order to input into your bank software. For most people this process was not visible, as it was all part of the BACS service they were subscribing for.

Well, I have managed to create an excel tool that does the job very well , if you have QB 2010 or QB 2012.

The process is as follows :-

1)Pay suppliers in the normal way. You may want to type the word BACS in the cheque number field , although not necessary.

2)Generate a report using a customised template that I have created, which gives the necessary data (sort code, a/c no, amount,etc)

3)Export that report to a pre-configured excel file in which I have embedded a macro tool.

4)Click on the tool worksheet to open the BACS tool

5)Click on the "Import payments" button

6)Click on the "Generate BACS File" button. A pop up window asks you where you want to save the BACS file. Browse to the chosen folder and save.

7)Open your Barclays Direct IP software and load the file.

It works very well with Direct IP. I should be able to configure the tool for any bank's software.

See clip below