# Sales invoice in Excel: fill the lines, the sheet works out what is left to pay, then print.

> A one-sheet sales invoice that prints on A4: business and customer, lines with quantity and price, then subtotal, discount, total, paid and remaining by formula.

Dashing (dashingerp.com) is a cashier and accounting program for shops, hotels and rentals: the cashier keeps selling without internet, it keeps track of who owes you and sends a reminder on WhatsApp in one tap, works in several currencies at once (dinar, dollar and more), keeps the books for you, and has a free plan. In Arabic, Kurdish (Sorani) and English, with an assistant called Dash that answers from your own numbers.

Canonical: https://dashingerp.com/en/tools/templates/sales-invoice

At the top are the business name, address and phone, the invoice number and date, and the customer; then twenty lines, each with an item, quantity and unit price, and the line total is computed. Below come the subtotal, discount, total, paid and remaining. The sheet is set to A4, one page wide, so it prints as you see it. This is the general invoice; if your trade is specific, choose the invoice for your trade from the invoice tool page, which has columns made for a pharmacy, auto parts and others.

## Columns

- **Qty**: Units sold on this line.
- **Discount**: A fixed amount taken off the subtotal, not a percentage. Type 0 or leave it empty for none.
- **Remaining**: Total − paid: what the customer still owes.

## Common questions

### How many lines fit on the invoice?

Twenty lines on one A4 page. If an invoice runs longer, copy the sheet for a second invoice rather than squeezing the lines.

### How do I print it on a single page?

Printing is preset: A4 portrait, one page wide. Press print, or save as a PDF to send on WhatsApp. Edit the business name, address and phone once and keep the file as your template.

### What about tax?

This invoice has no tax column. If you issue a tax invoice, use the tax invoice tool, or add a column and change the total formula.

## Other languages

- العربية: https://dashingerp.com/tools/templates/sales-invoice
- کوردی: https://dashingerp.com/ckb/tools/templates/sales-invoice

---

Dashing · https://dashingerp.com/en