Road Project Bill Verification
| Item Description | Contract (₹) | This Month (₹) | Remaining Balance |
|---|---|---|---|
| 1. Sub-Total Amount (Gross) | 0.00 | - | |
| 2. Negotiation Amount (4.59%) [Deduction] | - 0.00 | - | |
| 3. Final Total Amount (Excl. GST) | 0.00 | - | |
| 4. GST Amount (18%) on Final Total | + 0.00 | - | |
| NET PAYABLE AMOUNT (FOR BILL NO. 1) | ₹ 0.00 | - | |
Project History & Edit Options
| Date | Project | Bill No | Amount | Actions |
|---|
How to Use the PWD Road Project Bill Verification Tool
A practical guide to monthly bill preparation, item-wise balances, negotiation deduction, GST, budget monitoring, bill history, and complete PDF reporting.
1. Introduction and purpose
The PWD Road Project Bill Verification tool is a browser-based calculator intended to help prepare and review monthly bills against a project budget. It combines editable project settings, an item-wise bill schedule, automatic arithmetic, cumulative saved-bill tracking, and a PDF report of the current calculations.
The tool is designed to make the arithmetic visible and repeatable. It does not replace measurement books, contract conditions, sanction orders, tax advice, departmental checklists, or approval by the competent authority. The user must verify the applicable contract provisions, tax treatment, deductions, and supporting records before certifying or paying a bill.
2. Main sections of the tool
| Section | Purpose | User action |
|---|---|---|
| Project configuration | Stores project cost, allocation percentage, negotiation percentage, and GST rate. | Confirm the sanctioned/project cost and enter the rates applicable to the bill. |
| Bill header | Shows project name, automatically derived bill number, cumulative previous payments, and budget limit. | Select or type the project name and check the displayed values. |
| Item-wise schedule | Lists contract amount, current-month amount, and calculated balance for each line item. | Enter or correct current-month amounts and contract values as supported by records. |
| Calculation summary | Shows gross subtotal, negotiation deduction, amount excluding GST, GST, and net payable. | Review each intermediate amount rather than checking only the final figure. |
| Project history | Lists saved bills and offers load/edit and delete actions. | Load the correct saved record or review the bill sequence and amounts. |
| PDF and JSON exports | PDF documents the current calculations; JSON backs up saved history records. | Export the PDF for review and retain JSON backups separately. |
3. Project budget and allocation
The project cost and allocation percentage determine the budget limit used by the tool.
Example: if the project cost is ₹7,42,25,000 and allocation is 100%, then:
If allocation is 60%, the limit becomes ₹7,42,25,000 × 0.60 = ₹4,45,35,000. The tool uses this calculated limit when checking cumulative liability.
4. Item-wise contract values and current-month bill
The default schedule contains eleven cost heads: Professional Staff, Supporting Staff, Transportation, Duty Travel, Office Rent, Office Supplies, Office Furniture, Reports & Printing, Road Survey Equipment, Training Costs, and Contingencies.
Each row contains three relevant values:
- Contract (₹): the contract/budget amount entered for that line item.
- This Month (₹): the amount claimed for the current bill under that item.
- Remaining Balance: the tool calculates the contract amount minus the current-month amount.
Example: contract amount ₹5,00,000 and current-month amount ₹1,25,000 gives a displayed balance of ₹3,75,000.
Check that current-month amounts are supported by the relevant bill, invoices, deployment records, measurement records, or other contractual evidence. The calculator does not validate those documents.
5. Gross subtotal
The gross subtotal is the sum of all current-month amounts entered in the item table. Let \(C_i\) be the current-month amount for item \(i\), and let \(n\) be the number of items.
For example, if three items have current-month values of ₹40,000, ₹35,000, and ₹25,000, and all other items are zero:
This gross subtotal is the starting point for the negotiation deduction in the tool.
6. Negotiation deduction
The tool treats the entered negotiation percentage as a deduction from the gross subtotal. If the negotiation rate is \(r_n\%\), the deduction is:
Here, \(N\) is the negotiation amount and \(E\) is the amount after negotiation but before GST.
Worked example: gross subtotal \(S=₹1,00,000\), negotiation rate \(r_n=4.59\%\).
7. GST calculation and net payable
The GST rate is applied to the amount remaining after the negotiation deduction. Let \(r_g\%\) be the GST rate.
Here, \(G\) is the calculated GST amount and \(P\) is the net payable amount shown by the application.
Continuing the example: \(E=₹95,410\) and GST rate \(r_g=18\%\).
| Calculation stage | Formula | Example amount |
|---|---|---|
| Gross subtotal | Sum of current-month items | ₹1,00,000.00 |
| Negotiation deduction | ₹1,00,000 × 4.59% | −₹4,590.00 |
| Amount excluding GST | ₹1,00,000 − ₹4,590 | ₹95,410.00 |
| GST | ₹95,410 × 18% | +₹17,173.80 |
| Net payable | Amount excluding GST + GST | ₹1,12,583.80 |
This example demonstrates the software arithmetic only. The applicable GST rate, taxable value, tax type, and invoicing requirements must be verified for the actual transaction.
8. Cumulative previous payments and budget warning
For the selected project, the application retrieves saved records from its browser database and adds their stored net amounts to calculate cumulative previous paid:
Here, \(P_j\) is the saved net amount for each matching project record. The tool then calculates current cumulative liability by adding the current bill's net payable:
If \(L\) exceeds the budget limit, the tool displays a budget warning and disables the save button. If liability does not exceed the limit, the warning is hidden and the save button is enabled.
9. Bill numbering and project history
When the project name is selected, the tool filters saved records by that project name. It finds the highest saved bill number for that project and displays the next number. It also totals saved net amounts for those matching records to show cumulative previous paid.
- Use a consistent project name for all bills belonging to the same project.
- Differences in spelling, spaces, abbreviations, or punctuation may cause records to be treated as separate projects.
- Edit/Load loads the stored project settings and item values into the form after confirmation. Review the loaded values before exporting or saving.
- Delete permanently removes a selected saved record from this browser database after confirmation. Export a JSON backup first if the record may be needed later.
10. Exporting the complete calculations to PDF
The PDF feature creates a landscape A4 report using jsPDF and its AutoTable plugin. The report is intended to preserve the calculation trail in a document that can be reviewed, printed, or attached to a bill file.
The export is based on the values currently displayed in the form, including unsaved changes. Therefore, the PDF can represent a draft calculation and does not by itself prove that a bill has been saved, approved, or paid.
Recommended export procedure
- Open the tool in a supported modern browser.
- Choose the correct project and verify the bill number and previous paid amount.
- Check project cost, allocation, negotiation rate, and GST rate.
- Enter each current-month amount and review the remaining balances.
- Verify the gross subtotal, deduction, taxable amount, GST, and net payable.
- Check the cumulative budget warning.
- Click Export Entire Calculations to PDF.
- Open the PDF and verify that the project details, item table, equations, totals, and budget figures are legible and correct.
- Save the PDF with the bill records and supporting documents in the appropriate project file.
11. Exporting and importing JSON backups
The JSON backup function exports saved bill-history records from the browser database to a file. It is different from the PDF export:
| PDF report | JSON backup |
|---|---|
| Human-readable calculation report for review and printing. | Structured data intended to back up or transfer saved history. |
| Reflects the current form values at the time of export. | Exports records already stored in the local database. |
| Useful for bill scrutiny and documentation. | Useful for preserving saved records and importing them into the tool. |
Keep backups in a secure project folder and follow departmental records-management requirements. When importing a JSON file, use a trusted backup from this application. Importing the same backup more than once can create duplicate records because imported records are added as new entries.
12. Process flow
flowchart TD
A([Open bill manager]) --> B[Select or enter project]
B --> C[Verify cost, allocation, negotiation and GST]
C --> D[Enter contract and current-month item values]
D --> E[Calculate gross subtotal]
E --> F[Deduct negotiation amount]
F --> G[Calculate GST on post-negotiation amount]
G --> H[Calculate net payable]
H --> I[Add previous saved net amounts]
I --> J{Cumulative liability above budget?}
J -- Yes --> K[Display warning and disable save]
J -- No --> L[Save button remains enabled]
K --> M[Review and correct figures or allocation]
L --> N[Save bill if appropriate]
M --> O[Export current calculations to PDF]
N --> O
O --> P[Review PDF and retain records]
13. Important controls and limitations
- Input accuracy: incorrect item values or rates produce incorrect calculations. Check entries against approved documents.
- Item balances: displayed balance is contract value minus the current month's amount only; it is not cumulative across previous bills.
- Previous payment totals: the cumulative value is based on saved records found under the exact project name in the browser database.
- Budget validation: the tool checks the calculated budget limit against previous saved net amounts plus the current net amount. It does not check all possible financial commitments or unpaid bills.
- Tax and contract treatment: the programmed sequence deducts negotiation first and applies GST to the resulting amount. Verify that this matches the governing contract and applicable tax rules.
- Approval status: saving or exporting a bill is not the same as technical scrutiny, administrative approval, financial sanction, or payment authorization.
- Data protection: use the tool on an authorized device, preserve JSON backups, and avoid relying on browser history as the only record copy.
- PDF generation: the PDF libraries require successful loading from the configured CDN.
14. Pre-submission checklist
- Project name is consistent with previous bills.
- Project cost and allocation percentage are correct.
- Negotiation and GST rates are verified against the contract and applicable rules.
- All current-month line-item amounts reconcile with supporting records.
- Gross subtotal and each intermediate calculation have been checked.
- Previous saved bill amounts and bill number have been reviewed.
- Budget warning status has been considered and any discrepancy resolved.
- PDF has been opened and checked for completeness and legibility.
- JSON backup has been taken when preserving or transferring saved history is necessary.
- Required measurement, invoice, certification, approval, and other supporting documents are attached separately.
15. Conclusion
The PWD Road Project Bill Verification tool provides a compact workflow for calculating monthly bill values, applying a configured negotiation deduction, calculating GST, monitoring saved net amounts against an allocation-based budget, and producing a complete PDF calculation report. Its value is greatest when users maintain consistent project names, enter verified data, inspect every intermediate result, and preserve both the PDF report and a JSON backup.
Posts
0 Comments
If you have any doubts, suggestions , corrections etc. let me know