Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
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..
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.
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.)
Freelancer.com (formerly GetAFreelancer, Scriptlance and vWorker/Rentacoder) is the world's largest freelancing, outsourcing and crowdsourcing marketplace for small business. Hire freelancers to work in software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services.
Find freelance jobs and make money online! We have freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, custom programming, professional writing or affordable marketing has never been easier!
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)