{{ summaryTitle }}
{{ primaryMetric }}
{{ summaryLine }}
{{ documentLabel }} {{ billingRows.length }} line items {{ taxRateDisplay }} tax
Billing document inputs
The selected type changes the heading and reference wording in the draft.
Use the name that should appear in the copied document body.
Use a real document number or a temporary draft reference.
Use one item per line, for example: Consulting, 6, 150.
Enter a percentage such as 8 or 6.5.
%
{{ draftText }}
Line Item Quantity Rate Total Copy
No line items entered
Add at least one item, quantity, and rate to populate the ledger.
{{ row.line }} {{ row.item }} {{ row.quantity }} {{ row.rate }} {{ row.total }}
Field Value Document note Copy
{{ row.field }} {{ row.value }} {{ row.note }}
Customize
Advanced
:

Introduction:

A billing document is part request, part record, and part control point. It names the commercial action, identifies the customer or vendor, gives the transaction a reference that can be matched later, and turns individual charges into a total someone can review. When those pieces are clear, a buyer can approve what was ordered or received, a seller can follow up on payment, and both sides have something that can be compared against a contract, receipt, purchase order, or accounting entry.

Invoices and purchase orders often contain similar row tables, but they sit at different points in the buying cycle. An invoice usually asks for payment after goods or services have been supplied. A purchase order usually records what a buyer has authorized a vendor to provide. Mixing the two labels can cause avoidable confusion because a recipient may treat an invoice as a payable debt and a purchase order as permission to supply.

Line items carry most of the practical meaning. A single total may be enough for a casual note, but business review usually depends on what was sold, how much was counted, what rate was used, and what tax treatment applies. A consulting invoice for six hours plus one hosting charge should not be checked the same way as a purchase order for twelve replacement parts, even if the final totals happen to match.

Core parts of a billing document and why each part matters
Part What it answers Common mistake
Document identity Is this an invoice, purchase order, quote, credit note, or another record? Using an invoice label for an order approval, or a purchase-order label for a payment request.
Party and reference Who is the document for, and what reference should be matched later? Sending a draft with a placeholder name, missing PO number, or duplicate invoice reference.
Line items Which goods, services, quantities, and rates create the subtotal? Hiding several charges inside one vague description.
Tax and total What amount is before tax, what tax is added, and what final amount is due or authorized? Applying a single tax rate when exemptions, reverse charge, or tax-inclusive pricing apply.
Billing document anatomy with identity and line details flowing into subtotal, tax, and total.

Tax and compliance rules are the part most likely to outgrow a quick draft. A basic line-item total does not decide whether a sale is taxable, whether the buyer needs a purchase-order number, whether an electronic invoice must follow a structured standard, or which fields a local tax authority requires. Treat the draft amount as a review aid, then confirm the legal seller, buyer, currency, dates, tax identifiers, payment terms, approval status, and required filing process before sending an official document.

How to Use This Tool:

Start with the document identity, then use the ledger and totals views to catch row-entry mistakes before copying or downloading anything.

  1. Choose Document type. Invoice changes the draft heading to a payment request, while Purchase order changes the wording for an ordering document.
  2. Enter Customer or vendor and Reference. The summary line should show the selected document label, the reference, and the named party.
  3. Add Line items with one item per row in the form item name, quantity, rate. Avoid commas inside the item name because the row parser uses commas to separate the three parts.
  4. Set Tax rate as the percentage to add to the subtotal. Use 0 for a no-tax draft or when tax will be handled somewhere else.
  5. Read Billing Draft for the copy-ready text, then switch to Line Ledger to confirm every item name, quantity, rate, and line total.
  6. Check Total Breakdown before sharing. Subtotal, Tax, and Total should match the draft text exactly.
  7. If a row looks wrong, fix the source row and recheck the ledger. Missing quantity becomes one, missing or invalid rate becomes zero, and a blank item name becomes a numbered item label.

After the numbers and wording look right, copy the draft text or export the ledger, total breakdown, or JSON for the next handoff step.

Interpreting Results:

The Total is the final arithmetic amount after the entered tax percentage is added. Use Subtotal to review the untaxed line-item sum, and use Tax to confirm that the percentage was applied to the subtotal rather than built into each price. The Line Ledger is the best place to inspect parsing problems because it separates each item, quantity, rate, and line total.

A clean total does not mean the document is ready for accounting, tax filing, or procurement approval. It only means the entered rows were multiplied, summed, and taxed according to the visible fields. If a buyer requires a purchase-order match, an invoice can still be rejected even when the arithmetic is correct.

  • Check any Line Ledger row with a zero total; it usually means the rate is missing or not numeric.
  • Check item names that contain commas. Extra commas can shift the quantity and rate into the wrong positions.
  • Check the displayed dollar sign against the real transaction currency. The draft formats money with a dollar symbol but does not choose a legal currency.
  • Keep the source agreement, purchase-order approval, receipt, or accounting record with the exported draft when the amount affects payment or audit review.

Technical Details:

For a simple billing draft, the core operation is line extension: quantity multiplied by rate. The line totals are then summed into a subtotal, and a single tax percentage is applied to that subtotal. This is tax-exclusive arithmetic, meaning tax is added after the line prices rather than extracted from prices that already include tax.

The parsing rule is intentionally light. Each nonblank row is split at commas, and the first three parts are read as item name, quantity, and rate. That makes rough drafting fast, but it also means commas inside an item name can move values into the wrong columns. Quantity and rate can be decimal values, and negative quantities or rates are not blocked, so any discount-like adjustment should be reviewed as an accounting decision rather than treated as a formal credit note.

Formula Core:

The total follows a short chain from line extension to tax amount.

Li = Qi×Ri S = i=1nLi reff = max(0,r) A = S×reff100 G = S+A
Formula symbols used for billing document totals
Symbol Meaning Visible output
L One line total, calculated from quantity and rate. Total in Line Ledger.
S Sum of all line totals before tax. Subtotal in Total Breakdown.
r Entered tax percentage. Tax rate input and summary badge.
A Tax amount added to the subtotal. Tax in Total Breakdown.
G Grand total after tax is added. Total in the summary, draft, and breakdown.

With Consulting, 6, 150 and Hosting, 1, 80, the line totals are 900 and 80. The subtotal is 980. At an 8 percent tax rate, tax is 78.40, so the final total is 1058.40. Displayed money is rounded to two decimal places for review.

Billing row parsing and boundary rules
Condition Rule Review impact
Blank row Ignored. No ledger row is created.
Missing item name Uses Item 1, Item 2, and so on. Replace placeholder labels before sharing.
Missing or invalid quantity Uses 1. Can hide a malformed row because a total is still produced.
Missing or invalid rate Uses 0. Creates a zero-value line that should be fixed.
Negative tax rate Treated as 0%. Tax cannot be used as a discount field.
Extra comma in a row Only the first three comma-separated parts are used. Item names with commas can shift or discard values.

The JSON view carries the same draft values in a structured form, including document type, party, reference, parsed line items, subtotal, tax rate, tax amount, final total, and draft text. It is useful for handoff to another worksheet or system, but it does not add validation beyond the visible ledger and total checks.

Accuracy and Privacy Notes:

This is a drafting and arithmetic aid, not a jurisdiction-specific invoicing system. Official invoices, e-invoices, and procurement documents may require fields and validation steps that are outside the draft.

  • Confirm tax rate, exemption, reverse-charge, withholding, and tax-inclusive price rules before using the amount in an official document.
  • Confirm required invoice fields such as seller and buyer details, unique invoice number, supply date, tax identifiers, currency, and payment terms where they apply.
  • Confirm purchase-order approval and matching rules before sending an invoice to an organization that requires a PO number.
  • The calculation runs in the browser without a server lookup. Keep confidential billing details within the device, browser, and sharing workflow your organization permits.

Worked Examples:

Service invoice draft. A consultant keeps Document type set to Invoice, enters Acme Sdn Bhd and INV-1001, then adds Consulting, 6, 150 and Hosting, 1, 80. With Tax rate set to 8, Line Ledger shows line totals of $900.00 and $80.00. Total Breakdown shows $980.00 subtotal, $78.40 tax, and $1058.40 total.

Purchase order with no tax added. A buyer switches Document type to Purchase order, enters a vendor name, and uses a reference such as PO-2026-014. A row such as Replacement filters, 12, 18.50 produces a $222.00 subtotal and, with Tax rate set to 0, a $222.00 total. The draft can support review, but delivery address, buyer approval, and procurement terms still need to come from the purchasing process.

Comma problem in an item name. A row written as On-site support, travel, 2, 75 does not mean two units at 75. The ledger reads the item as On-site support, treats travel as an invalid quantity, uses one, reads the rate as 2, and ignores the final value. Rewrite the row as On-site support travel, 2, 75 so Line Ledger shows the intended $150.00 total.

FAQ:

Can this create a legally compliant invoice?

It creates a draft and arithmetic ledger. Add any required seller, buyer, tax, address, supply-date, currency, payment, and e-invoice details in the official system or workflow you use.

Why did a line total become zero?

The rate is missing or not numeric. Use item name, quantity, and rate in that order, separated by commas, then check the corrected row in Line Ledger.

Does the tax rate handle tax-inclusive prices?

No. The tax percentage is added to the subtotal. If the entered prices already include tax, calculate the tax-exclusive amounts separately before drafting the document.

What currency does the draft use?

Money is displayed with a dollar sign and two decimal places. The draft does not set a legal currency, exchange rate, or multi-currency rule, so confirm the currency before sharing.

Can I enter discounts or credits?

The form does not include a formal discount, credit note, or withholding model. Negative quantities or rates can change the arithmetic, but official adjustments should be handled in an accounting workflow.

Are my line items sent to a billing service?

The calculation does not require a server lookup. Treat the copied text and downloads like any other business document, and store or share them only through approved channels.

Glossary:

Invoice
A billing document that usually asks a customer to pay for goods or services supplied.
Purchase order
A buying document that usually records what a purchaser has authorized a vendor to provide.
Reference
The invoice number, purchase-order number, or internal identifier used to match the document later.
Line item
One charged good, service, fee, or purchase row with a name, quantity, and rate.
Subtotal
The sum of line-item totals before tax is added.
Tax-exclusive
A pricing approach where tax is added after the untaxed subtotal instead of being included inside each price.

References: