Get a Freelance Job

My requirement is for a multi page invoice script to be web hosted.

The invoice design MUST follow EXACTLY the template I will send to you. The current template is in MS Word.

We work with many subcontractors and we must include details of each subcontractor in the main invoice.

The average invoice is 10 pages. These consist of:

Top sheet: the master invoice to our client
2nd Sheet: travel/meal expenses for ourself
3rd sheet: details of work done by subcontractor #1
4th sheet: travel/meal expenses for contractor #1
5th sheet: details of work done by subcontractor #2
6th sheet: travel/meal expenses for contractor #2
7th sheet: details of work done by subcontractor #3
8th sheet: travel/meal expenses for contractor #3
9th sheet: details of work done by subcontractor #4
10th sheet: travel/meal expenses for contractor #4

Top sheet, 3rd sheet, 5th, 7th and 9th sheet will each have about 47 fields. About half are common to every sheet. These will be drop down choices. The the balance will be manually filled in and are either numeric or date fields.

The remaining travel/ meal sheets will share 6 fields of common data ie: client name, date, address, manager. There will also be 30 fields for data. 10 will be for date. 10 will be for description (drop down field). 10 will be for amount. 10 will be Yes/No fields. 1 field will be total.

In addition, the script MUST have the ability to add PDF pages in between pages 2/3, 4/5, 6/7 and 8/9. This will be meal/bus/train receipts.

The script MUST be able to generate the whole invoice as a single PDF file for download.

Finally, the script must be able to do basic accounting to keep track of payment received YES/No

Interested bidders can get a copy of the MS Word template from me so that they can see the exact layout.

I will require samples your work on a similiar project before you are even shortlisted. ** Bidders who bid without any experience will be blacklisted.

I prefer if you are able to customize an existing script with a solid backend.

Thank you in advance for your bids.

I need a spreadsheet that I cannot alter except for defined fields for input actions only.

1) I will begin by inputting the revenue from a job, then the spreadsheet needs to subtract the “job expenses” of that job which will produce result 1A. The revenue will begin with labor, which will be a gross amount, so I will input the gross amount, then the program needs to calculate the government sales tax (GST) from that gross amount which will be preset to 5% but must be easy to change if necessary. Then the next revenue I input will be materials, and the calculator will calculate the 2 taxes, which is 5% again, and an additional 7% for Provincial Sales Tax (PST). This net amount will be result 1B.

2) Then, a number of “business expenses” will be subtracted from result 1B, which will produce result 2, the “bonus fund”
Some of these expenses are fixed and some fluctuate and I need the ability to add or delete expenses.

3) Then I need another sheet that tracks employees including myself, our rate, how many hours each of us worked in a calendar month, and the gross amount we were paid. Hours for all employees will then be totaled & then a result will be produced to provide a percentage of hours worked by each employee. So if I have 3 employees, and we worked 1000 hours in total for January, and I worked 413 hours, then I need the spreadsheet to provide the percentage, which in this case would be 41.3%… and then to provide the percentages for the other employees as well.
I need the ability to easily add or delete employees.
There are some expenses related to certain employees earnings, for example, employment insurance is $4.10/$100 of earnings for each registered employee… so I need the program to calculate this number for me and make it optional for each employee.

4) Then the spreadsheet will take result 2 “bonus fund” and multiply that by each employees percentage and produce the amount of money they would receive as a “bonus.”

A simple and easy user interface is important with summary pages.

5) Then I need another sheet… this one will take all the income I was paid (results from #3), then add the bonus on top to provide the gross income. Then it will subtract my personal expenses, taxes, debt payments, etc. and provide me with a result.

The bonuses are paid monthly, so it would be nice if the program knew that it was the start or end of the month and would automatically begin calculating everything for the next month and not add it onto the previous month.

I need to be able to create pdf format.

There is more I would like to do with the last sheet, but lets start with this… unless you have some ideas as far as the program keeping track of debt balances as I make regular payments and make extra payments.

Thanks,

Davyn

I need a spreadsheet that I cannot alter except for defined fields for input actions only.

1) I will begin by inputting the revenue from a job, then the spreadsheet needs to subtract the “job expenses” of that job which will produce result 1A. The revenue will begin with labor, which will be a gross amount, so I will input the gross amount, then the program needs to calculate the government sales tax (GST) from that gross amount which will be preset to 5% but must be easy to change if necessary. Then the next revenue I input will be materials, and the calculator will calculate the 2 taxes, which is 5% again, and an additional 7% for Provincial Sales Tax (PST). This net amount will be result 1B.

2) Then, a number of “business expenses” will be subtracted from result 1B, which will produce result 2, the “bonus fund”
Some of these expenses are fixed and some fluctuate and I need the ability to add or delete expenses.

3) Then I need another sheet that tracks employees including myself, our rate, how many hours each of us worked in a calendar month, and the gross amount we were paid. Hours for all employees will then be totaled & then a result will be produced to provide a percentage of hours worked by each employee. So if I have 3 employees, and we worked 1000 hours in total for January, and I worked 413 hours, then I need the spreadsheet to provide the percentage, which in this case would be 41.3%… and then to provide the percentages for the other employees as well.
I need the ability to easily add or delete employees.
There are some expenses related to certain employees earnings, for example, employment insurance is $4.10/$100 of earnings for each registered employee… so I need the program to calculate this number for me and make it optional for each employee.

4) Then the spreadsheet will take result 2 “bonus fund” and multiply that by each employees percentage and produce the amount of money they would receive as a “bonus.”

A simple and easy user interface is important with summary pages.

5) Then I need another sheet… this one will take all the income I was paid (results from #3), then add the bonus on top to provide the gross income. Then it will subtract my personal expenses, taxes, debt payments, etc. and provide me with a result.

The bonuses are paid monthly, so it would be nice if the program knew that it was the start or end of the month and would automatically begin calculating everything for the next month and not add it onto the previous month.

I need to be able to create pdf format.

There is more I would like to do with the last sheet, but lets start with this… unless you have some ideas as far as the program keeping track of debt balances as I make regular payments and make extra payments.

Thanks,

Davyn

DESIGN NOTES:

1. Columns c and d can be deleted as long as columns H and P are calculated correctly by dividing by 30.

2. There should be 30 rows 1 for each Expense category, plus the header and footer row.

3. The Total for Row F is a combination of Totals from
Row N and Totals from Row F.

Overview: The Idea behind this is that the user inputs Monthly Living Expenses, and Dream Lifestyle Expenses, as well as Monthly Income Streams.

Monthly income streams from both sides (BLUE and YELLOW) will effect monthly living expenses first (lowest dollar amount to highest), and then Dream Lifestyle Living Expenses (lowest dollar amount to highest).

Both the yellow and Blue Income streams will go FIRST toward meeting, and then exceeding the Yellow monthly Living Expenses side.

After the monthly living expenses side (yellow side) has been covered and exceeded by a combination of both or either of the Yellow or Blue income streams, then the income streams totals will be directed to the Blue Side Dream Lifestyle expenses.

If the income streams cover a expense (starting at the lowest dollar amount Living Expense monthly Yellow side), then the category field in column B would turn GREEN).

If the category is reached by the income streams, but not quite covered, then the field category would turn (YELLOW).

If the category is not even hit by the income streams, then the field category would turn (RED).

Once the user inputs the Living Expense Text Column and monthly Dollar amount, as well as the Dream Lifestyle Text column and Dollar amount, the GREEN [Click Here To Crush Your Job!] button is clicked, and the function would calculate all the rows and columns.

The exact calculations would also apply to the Blue Side Dream Lifestyle, after the Yellow side Monthly living expenses have been met.

It would be nice if a sound or visual effect could be added ..like a cash register adding up, and or Flashing [GREEN BUTTON].