I gang

Paypal CSV Invoice Processing Tool/Macro

The goal from this project is to automate invoice creation and sending invoices from all the transactions from paypal .csv file.

This script/software/macro you will develop must be run locally on our Windows 7 computer with Office 2010 installed. The sending of the invoices to the clients must be done with Outlook. The process must be as automated as possible.

We will deliver an invoice template in .xls format which will be used to build the invoices.

So basically, the finished “macro” or “software tool” you develop for us must allow us to import a paypal .csv file and then the tool will build the PDF invoices, create a PDF summary,add VAT, currency exchanges, and will put every email ready to send in Outlook drafts. We will go into detail on what exact details we need.

I’m not really sure which programming language can be used for a process like this, but maybe its possible with a macro in excel or a VBA script or program. Please give us some examples on how you think you can set this up for us

.

Everything that the tool must be able to do 100% automatically:

(everything will be explained in detail later for the project winner)

1.

Process the csv file we import. It wil add a couple of fields and make calculations. (VAT, daily currency exchange, USD/EURO, etc). We will provide the currency exchage rates in a .txt file that must be used to convert USD to EURO when needed. The details that are calculated from the CSV will be used in the invoices and summary’s.

2.

Automatically create invoices based on a .xls template we provide. All invoices need to contain specific details which must be calculated. More details below. Some details are in the .csv, some details need to be calculated.

3.

The created invoices must be saved to a folder on the harddrive with specific filenames.

4.

The created invoices must be send to the Outlook drafts folder so we can easily send them to the clients. Each transaction from the CSV will get a different email with the appropriate PDF invoice as attachment.

5.

A summary PDF must be created, with details like total sales, total VAT, total sales per product, return customers, etc etc. a Graph, etc. more details will be given.

6.

Maybe some minor additions

If you have great experience with csv, excel, macro's,VBA etc, or you think you can complete such a project for me. Please bid, and show some examples of related work and tell me how you would be able to do this.

I have more detailed requirements ready for the winner.

It would be great if you have some experience with invoices, VAT, etc yourself aswell, it will make you understand this project easier.

Færdigheder: .NET, C# Programmering, C++ Programmering, Visual Basic, Windows Skrivebord

Se mere: paypal csv invoice, macro paypal, macro paypal invoice template, paypal csv invoice import, invoice processing paypal, csv invoice template, process paypal csv, paypal invoice csv, create invoice paypal csv file, add vat paypal, what is vba programming, what is computer programming used for, what is a graph, what graph, visual programming language, visual basic net programming language, visual basic 6.0 programming language, vba programming pdf, vba programming language, vba programming in excel, vba excel programming, tool for programming, the c++ programming language pdf, the c programming language pdf, sending invoices

Om arbejdsgiveren:
( 54 bedømmelser ) Uithoorn, Netherlands

Projekt-ID: #933476

Tildelt til:

svet63

VBA developer since 1997. Can do. Regards, Svet.

$750 USD in 15 dage
(43 bedømmelser)
6.0

20 freelancers are bidding on average $538 for this job

srinichal

I would like to deliver the same

$500 USD in 8 dage
(84 bedømmelser)
6.9
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram.

$750 USD in 25 dage
(96 bedømmelser)
6.5
ineedWorkJob

sir plz check pm !

$400 USD in 7 dage
(144 bedømmelser)
6.5
agilitysoftwares

Please check your PMB after few minutes for more details.

$700 USD in 20 dage
(11 bedømmelser)
6.3
sandymra

Please check PM!

$550 USD in 7 dage
(36 bedømmelser)
6.1
aptecpymefree

Hi, I can create your tool, In .Net C#. I don't Have any example, but i can create your solution. I have 13 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certifie Mere

$750 USD in 20 dage
(20 bedømmelser)
5.6
koolsidz

Please see PMB

$450 USD in 3 dage
(40 bedømmelser)
5.0
djucuti

Hi, please check PM

$250 USD in 20 dage
(18 bedømmelser)
4.7
alexitkin

Experienced and like such kind of projects.

$300 USD in 14 dage
(24 bedømmelser)
4.4
bmircea

Please check PM

$650 USD in 15 dage
(1 bedømmelse)
3.8
vito2102

I propose to create an application in C # using the Microsoft Visual Studio Tools for the Microsoft Office System.

$500 USD in 7 dage
(0 bedømmelser)
0.0
IanMH

I have extensive experience in VBA .NET VBScript, ect with the purpose of automation. Please see PM. -Ian

$350 USD in 7 dage
(0 bedømmelser)
1.6
gpabst

I`m ready.

$570 USD in 18 dage
(0 bedømmelser)
0.0
VersatileSol

Hello Sir, We have gone through your requirement and we can definitely assist you in this project. Please send us more details about the project so we can get back to you with the precise quote as well as with TIMEL Mere

$650 USD in 6 dage
(0 bedømmelser)
0.0
dotfour

Hi, We have worked on projects that required similar skills .Please refer the PM for more details.

$350 USD in 4 dage
(0 bedømmelser)
0.0
techduple

Sir, please check PMB. Thank You.

$600 USD in 7 dage
(0 bedømmelser)
0.0
spalmer1

Dear koenders, Thank you for posting on Freelancer. Kind Regards, SPalmer

$550 USD in 14 dage
(0 bedømmelser)
2.2
quaditworld

Hello, After reviewed your description we understand your requirement with exact features to deliver your work with example. We would love to be working with you on your project requirements and finish it as soon as Mere

$537 USD in 20 dage
(0 bedømmelser)
0.0
dhakeratech

Please view PM

$600 USD in 15 dage
(0 bedømmelser)
0.0