Invoice in BDT
Bill in taka with 15% VAT, a BIN, BEFTN details and lakh formatting.
Google Sheets Invoice Template
A block of cells and formulas to paste straight into a blank Google Sheet.
Your invoice
Saved in this browser onlyPaste this into a blank sheet
Copy the block, open a new Google Sheet, click cell A1 and paste. Sheets splits the tabs into columns and keeps the formulas live — the references are relative to A1, so pasting lower down will point the sums at the wrong rows.
Preview
Exactly what printsQuick Tool Overview
The Google Sheets Invoice Template gives you a tab-separated block with live formulas to paste into cell A1 of a blank sheet — three seconds rather than a download, an upload and a conversion — with the .xlsx there too if you would rather import.
- What it does
- Produces a paste block for Google Sheets
- You give it
- The invoice lines and the tax rate
- You get back
- Cells and formulas ready to paste
- Best for
- People who keep their books in Sheets
About the Google Sheets Invoice Template
Google Sheets imports an .xlsx perfectly, so a Sheets template does not really need to be another file. What it needs to be is a block you can paste into a blank sheet with the formulas already pointing at the right cells — which is what this produces.
Copy it, click A1 in a new sheet, paste, and you have an invoice with working formulas: each line total is quantity times price less discount, the subtotal sums the range, and the tax and grand total follow. Sheets recognises the tabs as columns and the leading equals signs as formulas, so nothing has to be retyped.
The .xlsx download is here too, for when you would rather open a file than paste a block — File, Import, Upload, and Sheets converts it with the formulas intact. Everything is generated in your browser, and no part of your invoice is sent to Google or to anyone else by this page.
Key features of the Google Sheets Invoice Template
Paste straight into A1
Sheets splits the tabs into columns and keeps the formulas live.
Formulas already pointing right
Line totals, subtotal, tax and grand total.
Or import the .xlsx
File, Import, Upload — everything comes across.
Plain numbers
So Sheets never reads a currency symbol as text.
Nothing sent to Google
The block is generated here; you paste it yourself.
How to use the Google Sheets Invoice Template
-
1
Build the invoice here
Lines, quantities, prices, discount and tax rate.
-
2
Copy the block
One button. The columns are tab-separated and the formulas are live.
-
3
Paste into cell A1
In a new, blank Google Sheet. Sheets splits the tabs into columns automatically.
-
4
Format the money columns
Select them and choose the currency format you want.
-
5
Or import the .xlsx
File, Import, Upload — formulas and formats come across.
Frequently asked questions
Because Sheets already imports .xlsx, so a separate Sheets file adds nothing. A paste block skips the download, the upload and the conversion entirely — it is three seconds rather than thirty.
Yes, as long as you paste into cell A1 of a blank sheet. The references are relative to that position, so pasting lower down shifts them and the sums will point at the wrong rows.
Select the price and amount columns and use Format, Number, Currency, then pick the currency. The paste block carries plain numbers so that Sheets does not interpret a symbol as text.
You can, but send a PDF instead. A shared spreadsheet invites editing, shows your formulas and your revision history, and is not a document either side can rely on later.
Reviews of the Google Sheets Invoice Template
What people who use the Google Sheets Invoice Template think of it. Reviews come from visitors and are posted as written.
No ratings yet
Yours would be the first.
- 5 0 reviews rated 5 stars
- 4 0 reviews rated 4 stars
- 3 0 reviews rated 3 stars
- 2 0 reviews rated 2 stars
- 1 0 reviews rated 1 star
0 reviews
Newest first
No reviews yet
Be the first to rate the Google Sheets Invoice Template. It takes half a minute and no account.
Write the first reviewMore invoice tools
Invoice Status Checker
Work out the status of every invoice: draft, sent, due, overdue, part paid or settled.
Repair Invoice Generator
Diagnosis, labour, parts and warranty on a repair invoice for anything.
Invoice PayPal Link Generator
A PayPal.me link with the amount and currency built in, plus a QR code.
Invoice Generator with PayPal
An invoice with a PayPal.me link that already contains the amount and currency.
Invoice to PDF
Turn invoice data — JSON, XML, UBL or CSV — into a printable PDF invoice.
Invoice Watermark Generator
Watermark an invoice PDF — COPY, DRAFT, CONFIDENTIAL — on every page, in your browser.
Invoice PDF Splitter
Split a PDF of many invoices into one file each — including where each invoice starts.