Try the worksheet
Replace the illustrative values. Entries stay in this browser session only. On small screens, scroll the table sideways to view all columns.
| Description | Quantity | Unit price (LKR) | Line total (LKR) | Remove |
|---|---|---|---|---|
| LKR 15,000.00 | ||||
| LKR 15,000.00 |
Use a traceable reference
Choose an invoice reference that your own register can track and retain the issue date, customer and agreed payment terms in your final document. Confirm scope and price against the order or contract before presenting the amount to the customer.
The CSV is a line-calculation draft. It does not fill in your legal business identity, customer details, tax registration, statutory wording or payment terms. Complete those separately and obtain appropriate review before using it as an issued invoice.
- Enter your draft reference and replace sample descriptions.
- Check each quantity and unit price against the customer agreement.
- Review the line totals and subtotal, then export the CSV.
- Add the required business/customer information in your final invoicing process.
Check units and omitted charges
A quantity can be fractional, such as 2.5 hours. Label the unit in the description so the customer understands the calculation. A fixed-fee project can use quantity 1 with the agreed unit price.
If delivery charges, discounts or taxes apply, this worksheet's subtotal is not necessarily the final amount payable. It contains no statutory tax engine. Do not represent it as a compliant VAT invoice just because the amounts are in LKR.
Keep an issued-document trail
After issue, retain the final invoice and its payment allocation. Correct an issued error using the business's approved process rather than silently overwriting the customer's copy.
Customer disputes often start with an unclear description or an unexpected fee. Comparing the draft lines to the accepted quote gives your team an opportunity to resolve those questions before collection begins.
Worked example
Two lines, one checked subtotal
Fictional services: 3 units at LKR 5,000 and 2 units at LKR 7,500. No taxes or discounts.
- First line total3 × 5,000.
- LKR 15,000.00
- Second line total2 × 7,500.
- LKR 15,000.00
- Invoice subtotalAdd the two line amounts.
- LKR 30,000.00
LKR 30,000 is the subtotal for the entered lines. Final invoicing requirements still depend on the business and transaction.
Frequently asked questions
Is this a VAT invoice template?
No. It does not determine tax status, calculate VAT or provide mandatory statutory fields. Use separately reviewed guidance for tax invoices.
Can I edit the CSV in Excel?
Yes. The exported rows contain the current descriptions, quantities, prices and totals. Changing the CSV later does not automatically recalculate the values unless you add spreadsheet formulas.
Sources and limits
A general invoice calculation only. It does not establish legal, tax or VAT compliance and does not issue or send an invoice.
- Finance Desk LK — current service scope
Current service boundaries. Confirm the work, exclusions and quotation in writing before an engagement begins.
Accessed: 2026-10-08