RA Bill Calculator
Bill your client for the work done since the last bill: GST, retention, TDS and recoveries, and the net amount payable. For private and government work alike. The answer updates as you type.
Free · Download in Excel · Signed in, every bill is kept in My work
Not the right tool? Labour-only contract: labour bill. Paying workers by attendance: labour wages.
Keep this RA bill on this device?
Then you can come back to it, or start the next bill from it. Nothing is sent to InstaBOQ.
How the bill is calculated
- Quantity this bill = quantity done so far − quantity in previous bills.
- Value of work this bill = Σ(quantity done so far × rate) − Σ(quantity in previous bills × rate).
- Gross amount = value of work this bill + escalation or extra work.
- GST, if the contractor charges it = GST % × gross amount.
- Each deduction = its percentage × the gross amount of this bill, before GST, rounded to the paisa.
- Net payable = gross + GST − all deductions + any retention released.
- Retention held = retention in previous bills + retention on this bill − retention released.
Worked example — RA Bill No. 3
Eleven items of an RCC framed building (illustrative rates), two earlier bills, retention at 5%, income-tax TDS at 2% and labour cess at 1%. Computed by the same code as the calculator above, and identical to the sample sheet in the RA bill workbook.
| Value of work up to date | 59,70,250.00 |
| Less: work in previous bills | 41,46,950.00 |
| Gross amount of this bill | 18,23,300.00 |
| Less: Retention / security deposit @ 5% | 91,165.00 |
| Less: Income-tax TDS @ 2% | 36,466.00 |
| Less: Labour welfare cess @ 1% | 18,233.00 |
| Net amount payable | ₹16,77,436.00 |
| Retention held after this bill | 2,98,512.50 |
Questions
What is an RA bill?
A running account (RA) bill is the bill a contractor raises every month or stage for the work done so far. It is used on private and government work alike. Each bill measures the total quantity done to date, takes off what earlier bills already covered, and arrives at the amount payable after deductions.
How do you calculate the net amount of an RA bill?
Value this bill's work as the amount done to date less the amount in previous bills, and add any escalation or extra work. That is the gross amount. Add GST if the contractor charges it, subtract each deduction worked out on the gross amount, and add any retention being released. What is left is the net amount payable.
Is GST added or deducted in an RA bill?
Added. A GST-registered contractor charges GST on the gross amount of the bill. Retention, TDS and the other deductions are worked out on the amount before GST. GST TDS, which only notified deductors such as government bodies make, is a separate deduction.
What is a final bill?
The last bill on a contract. It bills whatever work is left, settles any remeasurement, and closes the account. Retention is often not returned with it: many contracts hold it until the defect liability period ends, so this calculator releases retention only when you enter an amount.
Why list the previous bills?
So the bill shows the totals to date: billed, paid and retention held. The retention held is what a final bill may release. Tick "Remember this bill on this device" and "Start next bill" adds this bill to the list for you.
Are deductions calculated on this bill or on the total to date?
On this bill. Applying the percentages to the total to date deducts again on work already deducted in earlier bills.
Can I download the bill as Excel?
Yes. "Download as Excel" gives you the free RA bill workbook with your items, quantities, MB pages, rates, previous bills and percentages already filled in, calculating the same net amount.