add bill/invoice information to spreadsheet.

Project Description:
UPDATE PAYABLE SPREADSHEET project

I have scanned PDFs of bills/invoices.

These need to be separated into separate documents, and the following information from each recorded in an excel spreadsheet.

Entity - this is who the bill is sent to..
Supplier,
Invoice/Issue Date (some statements do not have this, in which case the date can be put as the END PERIOD date. ie credit card statement with a period 22/8/11 - 22/9/11 will have 22/9/11 as the invoice date.
Due Amount, (note, some bills will have an overdue amount or paynow amount, and another payable amount (ie minimum payment for credit card) please separate these, the TOTAL is not necessary. If a bill is an overdue/payment reminder, please put the due amount in the OVERDUE column, not the DUE AMOUNT column.
Overdue amount/pay now amount.
Due Date
Account Number.
Invoice Number - if available.
BPAY biller code
BPAY reference. THIS MUST BE CHECKED AND RECHECKED.
IF BPAY data not available, there will generally be a bank account deposit to…


please assign each file a filename ie - entity-date-supplier-duedate so they can be tracked.

There are about 50 bills (maybe 55) spread over a few scanned files. (note some of them are multiple pages, keep each bill together.)