In Progress

update payable spreadsheet, split pdf documents

I have scanned PDFs of bills/invoices.

Each invoice needs to be separated into separate PDF documents (and named as indicated below), and the following information from each recorded in ONE excel spreadsheet.

Names/Entities etc do not need salutation (mr/mrs etc)

values do not need a $ sign, but should be a decimal to 2 places without a comma.

The spreadsheet will require the following columns: Same Column Name Please.

Entity -This is the business name or persons name, business name has priority. No Salutations required (ie no MR/MRS etc)

Supplier

Invoice Date (format DD/MM/YYYY)

Due Amount – just decimal with 2 decimal places, no $

Overdue - just decimal with 2 decimal places, no $

Minimum Pmt - just decimal with 2 decimal places, no $

Due Date (format DD/MM/YYYY)

Reference – full account number, with no spaces.

Inv No

BPAY Details – (format BPAY: bpay number REF: referencenumber)

Other PMT Details (Only if no BPAY Details)

Details

Descriptions

------------------------------------

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 29 bills spread over a few scanned files. (note some of them are multiple pages, keep each bill together.)

This will probably be ongoing, with new invoices to be entered regularly. (perhaps twice a week), eventually data entered directly into a database.

Skills: Data Entry, Excel

See more: week end update, total bank, excel spreadsheet business, need business credit card, credit one bank, spreadsheet overdue payment, pay bank account, excel split columns, bank account name, business card case, update account details, spreadsheet 2, split, split bill, pdf invoice, pdf bank, mrs, just pdf, bpay, bill split, account spreadsheet, account payable, excel date reminder, spreadsheet business card entry, split file

About the Employer:
( 40 reviews ) Melbourne, Australia

Project ID: #1247229

Awarded to:

best4best

Please refer PMB.

$5 USD / hour
(95 Reviews)
5.5

69 freelancers are bidding on average $4/hour for this job

Kamalkishover

We can do perfectly pls provide source file. thanks

$5 USD / hour
(197 Reviews)
6.5
YourAssistant

{{(((Please read PM for further details)))}} …Thanks

$2 USD / hour
(91 Reviews)
6.0
RajHeartbeat

letz start..i have done similar jobs before..just send me scanned bills to start this job asap..Regards..Raj..!

$3 USD / hour
(50 Reviews)
5.7
siddhartha1

Hi, we are interested and can do this quickly,thanks

$6 USD / hour
(3 Reviews)
4.7
nena88

Hi, I am very much interested in this project. I am hardworking, reliable, and good with prompt communication for a good work relationship. I have experience in Excel and data entry with a high degree of accuracy for q More

$5 USD / hour
(15 Reviews)
4.6
dipak123

Dedicated freelancer team here to serve you the best.

$3 USD / hour
(27 Reviews)
4.4
accuraci

>>>>>>>Ready To Start Now.>>

$5 USD / hour
(4 Reviews)
3.8
Uthe2009

I'm available to work on your project.

$5 USD / hour
(10 Reviews)
3.4
brelamp

Sir, this is an easy task for me, I'm ready to start ASAP.

$2 USD / hour
(4 Reviews)
3.1
habayabah

Please read my PM for details of my bid.

$5 USD / hour
(3 Reviews)
3.1
EXPERTSCODERS

HI, I am ready to serve you. Thanks

$2 USD / hour
(4 Reviews)
2.7
yhangelco

sir i am interested thanks

$2 USD / hour
(1 Review)
1.6
lambadi09

Hi, Ready to start, well versed in pdf and excel. Laklshmi.

$4 USD / hour
(1 Review)
1.4
shoheb31

I can do it perfectly.Please refer to PM

$2 USD / hour
(1 Review)
1.0
hsinha82

Hi, I have more than 5 years of experience as Business Analyst. I am expert in MS-Excel. I have already worked on large database in excel. I can do this analytical work more perfectly. I will be happy to work with y More

$2 USD / hour
(1 Review)
1.0
KooriSha

Please find my bid herewith,

$5 USD / hour
(0 Reviews)
0.0
rebagrey

Respected Sir, consider your project done-I am a data entry expert with 5+ years experience, ton of references with a promise to give you best quality results at lowest price. Ready to start right away. Please check PM More

$2.5 USD / hour
(0 Reviews)
0.0
dushantha1985

i want to work with you

$2 USD / hour
(0 Reviews)
0.0
rajhwd123

entity-date-supplier-duedate so they can be tracked.

$2 USD / hour
(0 Reviews)
0.0
contact2haseeb

i have a team who will do this

$4 USD / hour
(0 Reviews)
0.0