Hello Mates and Experts.
Recently we have started a new project and the person who did all calculation is so confusing. I've attached the actual excel sheet which they created.
Now what i need is the follwoing.
We invoice to our client in a different way. Sometime progressive invoice and sometimes lumpsum.
I tried alot to make it traceable and easy to understand but no success. As an example i will explain the follwoing screenshot.
This picture is taken from Architectural work sheet (attached). Total Value of Contract for that particular item is showin in Amount column.
Q1-
I need to make progressive invoice of 10% for Screed Then later more progressive invoices with different percentage.
So this calculation will be for all the sheets available in attached workbook.
I need to Make an invoice which should contain: Current invoice Value & %, Previous invoiced Value & %, Total invoiced Value & %, Balance to be Invoiced Value & %. with % and Amount.
Also, When i make above invoice, the main sheet (attached(\) should be automatically updated accordingly with the data, like how much is invoiced and what is % of that.
Please Note, There will multiple invoices for each item.
Here is the link to download file: SUMMARY Villa 73.xlsx
I will be thankful if someone can help me on this ?
Recently we have started a new project and the person who did all calculation is so confusing. I've attached the actual excel sheet which they created.
Now what i need is the follwoing.
We invoice to our client in a different way. Sometime progressive invoice and sometimes lumpsum.
I tried alot to make it traceable and easy to understand but no success. As an example i will explain the follwoing screenshot.
This picture is taken from Architectural work sheet (attached). Total Value of Contract for that particular item is showin in Amount column.
Q1-
I need to make progressive invoice of 10% for Screed Then later more progressive invoices with different percentage.
So this calculation will be for all the sheets available in attached workbook.
I need to Make an invoice which should contain: Current invoice Value & %, Previous invoiced Value & %, Total invoiced Value & %, Balance to be Invoiced Value & %. with % and Amount.
Also, When i make above invoice, the main sheet (attached(\) should be automatically updated accordingly with the data, like how much is invoiced and what is % of that.
Please Note, There will multiple invoices for each item.
Here is the link to download file: SUMMARY Villa 73.xlsx
I will be thankful if someone can help me on this ?
