Quickbooks and Excel

A great combination !

Importing Day Books

Many enterprises like to maintain a day book that logs all supplier invoices that come in. A sequential number is given to each document and the original document reference is also noted. I see this as an ideal scenario for automating the posting of supplier bills.

Provided all the information is on the Day Book (eg date, invoice ref, amount, details,nominal code, etc) and the Day Book is maintained on Excel, it is possible to customise a Day Book that would be used as an IIF import.

I have created such a template and it really does save time. I will write more on this

 

 

 

May 2nd, 2013 Posted by | IIF imports | no comments