Em Andamento

Excel invoice and sales list generator

The project is for a business that provides language training to approximately 50 companies.

Often (but not always) the training sessions will include people from different departments/subsidiaries of the same company, and each department needs to be billed separately according to how many of their people attend the sessions. The number of participants may change each month as people join or leave the company.

Example

Company A has 7 subsidiaries and 25 groups running once or twice a week.

A typical scenario

Group 1 has 10 participants, 3 from subsidiary W, 2 from sub X, 1 from sub Y and 4 from sub Z.

The monthly cost for the group is €400, which needs to be split as €120 for subsidiary W, €80 for sub X, €40 for sub Y and €160 for sub Z.

I have to produce a monthly invoice for each subsidiary that shows

Course title

course reference number

No of hours programmed for the course

The duration of the course

The number of participants from the department

An example of what we currently produce is shown in the pdf attached. It does not need to be in exactly the same format but it does need to contain all the same information.

So in summary I need to be able to produce invoices (like the one described and attached), either from scatch or copied from a previous invoice, and then save them in a list to produce a monthly report.

You will notice from the pdf attached that the language used is Spanish, however if the project can be written in English and edited, I can change headings into Spanish where necessary.

As a final note, I know there are lots of free invoice generators that can do 95% of what I'm asking for which will just require me to set up a monthly template and edit it accordingly, however I have not found one that will automatically split the costs between each subsidiary.

Habilidades: Excel

Ver mais: excel invoice template with automatic invoice numbering, excel invoice template with database free download, how to create an invoice in excel 2010, excel automated invoice system, create invoice from excel data, create invoice from excel database, how to make invoice in excel 2007, automated invoice in excel, sales list generator, invoice packing list generator, excel invoice product list, sample shipping invoice packing list excel, invoice packing list template excel, excel create invoice stock list, excel based sales invoice

Acerca do Empregador:
( 0 comentários ) Sant Boi de Llobregat, Spain

ID do Projeto: #15372560

Premiar a:

paris2785

Hi, I am Paris. I can develop a macro-enabled spreadsheet that will take into account the participants, subsidiaries, and groups and will generate the necessary invoices by clicking one button. Relevant Skills and Exp Mais

€180 EUR em 7 dias
(112 Avaliações)
6.4

36 freelancers are bidding on average €161 for this job

someka

Hello. You are correct, there are lots of free invoice generators. But those still need lots of manual work. I will set up the invoice generator tempate which will minimize your manual work. (Customer database, course Mais

€250 EUR in 5 dias
(137 Comentários)
7.0
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.

€200 EUR in 3 dias
(203 Comentários)
6.8
€277 EUR in 3 dias
(76 Comentários)
5.4
SShtv

Your task is clear to me and I am ready to execute the project for 50 EUR for 2 days. Relevant Skills and Experience I have successful experience performing similar work. This is one of them. [url removed, login to view] Mais

€50 EUR in 2 dias
(22 Comentários)
4.6
farisyasrab

Hello, With years of experience I believe I can offer you the quality solution you need. Please consider me for this job. BR, [url removed, login to view] Relevant Skills and Experience Hello, With years of experience I Mais

€250 EUR in 5 dias
(2 Comentários)
4.1
shivaparvathi108

Good at excel reporting and advanced VBA. Have experience in similar projects in the past. Relevant Skills and Experience Excel Reporting; VBA Proposed Milestones €55 EUR - Satisfy Employer Needs When shall we start Mais

€55 EUR in 3 dias
(30 Comentários)
4.2
pm9887

As per given details Its Data entry task. I have great experience in Internet research. Relevant Skills and Experience Hi, I have vast experience in lead generation, internet research, market research, data entry, dat Mais

€70 EUR in 3 dias
(9 Comentários)
3.5
mpunn2007

A proposal has not yet been provided

€166 EUR in 7 dias
(7 Comentários)
3.0
Rajendra1887

Hi, I am am good at Excel and on accounts as well. I have experience of similar work and can fulfil your requirement. Please let me know if you want to discuss for the same. Thanks

€122 EUR in 3 dias
(5 Comentários)
2.7
sasinimal

The Excel invoice and sales list generator will be designed with your input for automatic updating and preparing the invoice in the required format. Committed to Quality, Delivery, & response. Relevant Skills and Expe Mais

€133 EUR in 3 dias
(1 Comentário)
2.1
€34 EUR in 3 dias
(4 Comentários)
2.0
ReneRondon

Hello. I bid for this project because I'm an Chartered Accountant with lot of experience in MS Excel and VBA programming (macros) Habilidades y experiencia relevante I guarantee you an accurate job, full functionality Mais

€110 EUR in 2 dias
(5 Comentários)
2.4
stivens

Hello, I read the full requirements for the project and I can accomplish this task. I may have some suggestions to do this more effectively if it is not required to be in excel. Please message me for Relevant Skills a Mais

€225 EUR in 3 dias
(1 Comentário)
2.0
AhmedHassan1122

Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones €111 EUR - Full Price

€111 EUR in 3 dias
(2 Comentários)
1.4
jlmeseguer

Buenas Me llamo José Luís, soy doctor ingeniero y os puedo hacer una macro en vba de lo que necesitáis. Es fácil y sencillo. Al ser español será más fácil a comunicación. Un saludo

€144 EUR in 4 dias
(1 Comentário)
0.8
Shashankmishrass

I am well experienced Relevant Skills and Experience I would be very profitable for you according to your project

€155 EUR in 3 dias
(0 Comentários)
0.0
€218 EUR em 1 dia
(0 Comentários)
0.0
€155 EUR in 3 dias
(0 Comentários)
0.0
€155 EUR in 3 dias
(0 Comentários)
0.0
josekenny2000

I hereby apply for this project. I am keenly interested in this project and I promised to deliver the project in five days. I will be grateful if you can considered me for this project. Thanks. Relevant Skills and Ex Mais

€222 EUR in 5 dias
(0 Comentários)
0.0