Programmer-Designer »   Register   Login   Logout   FAQ 
 Buyer-Project Manager »   Signup   Login   Post a Project   Logout   FAQ 
Browse Recent projects :: Post your Project :: Testimonials onmouseover="status='Click in Explorer -OR- press Ctrl and D in Netscape.';return true" onmouseout="status=' ' ">bookmark :: tellafriend :: affiliate programaffiliate program :: contactus :: homepage
programmingbids.com

Project: Automated Outstanding Invoices

ID: 1239592618
email this project to your friends
View Message Board for this Project click on the view message board button to post a message for this project View Message Board for this Project
Messages Posted: - You may use the message board to discuss or clarify any further details/requirements regarding this project. Price negotiations and/or direct contact with each others is not allowed including via email, AIM, chat, etc., and until a bidder has been chosen.

Status: Frozen (No bidding. Waiting for action from project owner.)
Budget: N/A
Created: 4/12/2009 at 21:16 (MST)
Bidding Ends: 4/23/2009 at 21:16 (MST)(expired)
Project Creator: mds1021
Rating: (No Feedback Yet) --- login to your account to pick a bid, when you are ready.
Description:
«Login» to edit the description

We do inspection work for a company in another state and need a way to see if we're getting paid for all our work

We receive work orders (WO's) over the internet with WO#'s, house address, code for type of inspection and other info.

After we submit the finished inspection (on their form via the internet), we daily, or up to monthly can print out a PDF file of the details of the amount of inspections we did (WO#, address, code, etc.) along with each of their fees.

The company pays us by check sent by snail mail, but they send us an email with a list of the WO#'s, some other information, the date they received the inspection, the amount being paid (mostly single digit dollars each, occasionally double digit dollars); and of course the total of the check with check date, etc. I've tried to scan the emails to OCR - even after printing them - it doesn't work. I found if I convert them (the emails) to a PDF, then they are workable into an Excel spreadsheet.
As for the invoice list PDF's the company's website allows me to print out, I can manipulate them page by page (by selecting columns and copy/pasting them to a spreadsheet), but when a month has as many 35 pages, I can't do them too well.
But, getting the invoice list and email payment list into a single spreadsheet isn't what we're looking for - our goal is to see if they are actually paying us for every invoiced inspection we perform.

We need to come up with a list of WO#'s to send them asking why any particular WO# wasn't paid, or when will it be paid.

Basically we need to match every payment line (WO#) on the check payment detail with every WO# line of every invoice sent in, in order to find any which one don't have a match.

I imagine I can "post" the invoice submissions every day, but even then, it may be more than a page long , and we'd rather do it maybe once a week, or so, on a 'batch' basis.

We get a check from them about every week or so each check represents quite a few WO#s.
Project Type:
  • Applications
  • PDF Related
  • Spreadsheets
OS-Platform: Windows
Programming Language: Please Suggest One
Database Type: None
View Message Board for this Project click on the view message board button to post a message for this project View Message Board for this Project
Messages Posted: 1 - You may use the message board to discuss or clarify any further details/requirements regarding this project. Price negotiations and/or direct contact with each others are not allowed including via email, AIM, chat, etc., and until a bidder has been chosen.

Programmer Bids for this project

Programmers/Freelancers Bid Delivery Within Time of Bid
Rating
silverious USD 300 10 day(s) from closing 4/17/2009 at 8:38 (MST)
(No Feedback Yet)
This involves pdf binary parsing and automation. See my message.
If [silverious] is in violation of our policies (providing/asking for email, contact info. etc.,) send us a report - Thank You!


m13badry USD 700 10 day(s) from closing 4/23/2009 at 6:44 (MST)
9.5/109.5/109.5/109.5/109.5/109.5/109.5/109.5/109.5/109.5/10
(30 reviews)
we can help you. Payment will be via WIRE TRANSFER ONLY.
If [m13badry] is in violation of our policies (providing/asking for email, contact info. etc.,) send us a report - Thank You!


mamoon USD 750 21 day(s) from closing 4/20/2009 at 2:34 (MST)
9.8/109.8/109.8/109.8/109.8/109.8/109.8/109.8/109.8/109.8/10
(40 reviews)
ok
If [mamoon] is in violation of our policies (providing/asking for email, contact info. etc.,) send us a report - Thank You!




Share |



 Affiliate $19.95/programmer sign-up and 30% commission (every time) - perfect for web hosting providers and programmer resource or service provider websites.

Site Terms : Your use of this website constitutes your agreement to the terms and conditions of Programmer Bids. Any bids/quotes provided by individual freelancers, programmers, web designers and consultants on this website are not recommendations by Programmer Bids - we neither provide any quotes directly to the buyer, nor do we recommend any "specific" service provider registered on our web site. Buyers and corresponding freelancers, programmers, web developers and consultants must assume responsibility for the delivery of work and payment transactions. Programmer Bids.com only provides a buy/sell marketplace for interested buyers, freelance programmers and web designers to buy or sell programming and web development services, on our website. Please read and accept Terms & Conditions before using our service.

 Copyright © 2001-Current, Programmer Bids.comSM ¤ Terms of Use ¤ Contact Us ¤ Tell Friends ¤ Affiliate Program Home