Excel form for proforma consolidated invoice

When I send a shipment to my dealer in another country, I send all the small orders combined in one shipment. For this combiend shipment I have to create an proforma consolidated invoice for the custom declaration.

Basically what I have to do is to sort all the items from the combined shipment in to the 5 different declaration numbers, and then calcualte the following:

- Total number of items in each declaration numbers group.

- Total cost price in declaration numbers group.

- Average item price in each declaration numbers group.

- Total price for all declaration numbers groups included the shipping cost.

I am not very good with these sorts of things, but I was thinking that maybe a Excel form could help this work? Or if any other solutions I am open for suggestions?

With Excel, additional to the shipping cost, I was thinking that I manually have to add the following information about each order-line:

- What declaration number group this item belong to

- How many of this item

- The sell price for this item

I was hoping that Excel could calculate each if the values I need and place them in correct place on the proforma consolidated invoice so that I can just print it out.

Is this possible?

Is there an easier and faster way to do this?

PS. Attached is the proforma invoice.

Skills: Data Entry, Data Processing, Excel

See more: consolidated excel, proforma form, excel consolidated, excel proforma, send an invoice, how to send an invoice, how to create data entry form in excel, how to create a data entry form in excel, how to create a data entry form, create excel form for data entry, create data entry form in excel, sort excel, invoice processing, excel small work, excel form, order entry dealer, dealer order entry, excel additional, invoice custom, excel custom number, excel line work, form invoice, excel number custom, excel add form, add form excel

About the Employer:
( 69 reviews ) Lørenskog, Norway

Project ID: #4957132

47 freelancers are bidding on average $125 for this job


Please check inbox. Thanks

$154 USD in 3 days
(526 Reviews)

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$147 USD in 3 days
(65 Reviews)

I look forward to discuss more details about the project

$252 USD in 7 days
(15 Reviews)

Hi Oxigenando. Being highly proficient in Excel I shall be able to develop a highly automated Excel Form for you where you don't have to do much work manually. I recently delivered a very similar project for another cl More

$160 USD in 3 days
(13 Reviews)

Hello! Thank you for considering my bid. I am an accounting and finance professional having more than 17 years experience and degree in accounting/MBA. I am passionate about using excel for simplifying business tasks. More

$90 USD in 3 days
(18 Reviews)

Why pick me? Outstanding feedback on all projects (without exception). I run my own Professional Excel & VBA consultancy business, Able to complete very quickly, with a minimum of fuss. Please More

$100 USD in 1 day
(10 Reviews)

Excel would be an excellent tool for what you need. But... You will be doing this often, so you want the 'tool' that does this for you to be separate from the documents it works with. [These would include your input d More

$145 USD in 5 days
(14 Reviews)

Hi, I am highly qualified for such task and I am eager to start.. Please check your Inbox for more details.. Thank you

$135 USD in 6 days
(1 Review)

To let you judge for yourself whether I can deliver, I am sending sample Excel 2010 file that generates Description, Commodity Code, Country of Origin, Price and Weight per Unit automatically when you select a Part, an More

$155 USD in 1 day
(2 Reviews)

Good Day!... I'm an Expert in Excel Automation. *****I've done Similar Projects*******Very Imp: Pls check my Private message to you.

$222 USD in 1 day
(7 Reviews)

Sir, this can be done in Excel using VBA. I have created similar project using VBA and Excel, you can check them in my portfolio. You can award me with trust.

$155 USD in 5 days
(3 Reviews)

please read my pm message

$133 USD in 3 days
(10 Reviews)

I can help you with this. This is essentially what I do. Try me you won't be disappointed

$105 USD in 1 day
(1 Review)

Easy Job for spending so much money. Im sending you a first glance of your project, lets begin.

$30 USD in 3 days
(2 Reviews)

Dear sir, I handles invoicing and accounting softwares in past. So I can do this for you.

$100 USD in 7 days
(1 Review)

In excel or if you want in access, I can do this project.

$95 USD in 2 days
(2 Reviews)

I am sure, I can do it excellent for You...

$105 USD in 5 days
(0 Reviews)

Hello Please read pm

$35 USD in 2 days
(0 Reviews)

I am an expert in Excel and could do this for you in about an hour. I have 7 years of experience in excel and can do this for you today.

$30 USD in 3 days
(0 Reviews)

Pls send me the details, i will send it in Half day...

$166 USD in 3 days
(0 Reviews)