How to Create an Invoice in Google Sheets
First and foremost, an invoice is a written verification of agreement sent by a provider of products or services to the purchaser. It is also an important document in your business's accounting and bookkeeping. Historically, an invoice form is a paper document mailed to the buyer. However, due to the boom of the Internet, sellers can now request payment online through electronic invoices.
Here are some guidelines that may help you in creating your electronic or printed invoice.
1. Include Invoice Number, Invoice Date, and Due Date
Never forget these details whenever you make an invoice because it clarifies obligations for both the seller and the buyer. An invoice number is a way to track the invoices you sent to the purchaser; just make sure that you don't repeat the number. The invoice date is the date of the document's issue. The date should be displayed to ensure that it is a reliable document and to prevent miscommunication between two parties. If you have a payment agreement about when you can get the compensation, then you can include a due date to your invoice.
2. Details of Provider and Purchaser
The details of the sender and the receiver are important in all written communication. These details include the company name, address, business phone number, and email address of both parties. If you are sending the invoice to a person, be sure to specify the recipient's name. If the sender has a business logo, you may include it in the header to the top left or top right of your business name.
3. Details of the Purchased Items
The details of the purchased items or services are necessary on any invoice since the latter represents an important business transaction. The following should be included in the document: name and description of your product and service, number per item, the price per unit (as shown in the price sheet), product number, net price, VAT if applicable, and the gross price.
4. Terms of Payment
Specify the date of sale, method of payment, the payment schedule, and the period allotted to a buyer to pay off the amount due. Having this part in your invoice allows you to know when a payment should be expected and on what method you can get the payment—through a check, card/debit, etc.
Some would insist that a signature is not necessary for a business invoice; however, if you want an assurance that the buyer would pay for the purchased items, then it is vital to attach the signatures of both parties.
6. Use Google Sheets
Google Sheets is a convenient site to use in creating your work order or sales invoice. On the site, you can create a spreadsheet so you can present an organized document. There are also comprehensive lists of built-in functions that you can use. When it comes to saving your work, you can save it to your Google account, then you can download it on your device so you can access it offline.