The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
If your business is selling to several states or countries, you may need to change the tax rates from invoice to invoice depending on shipping destination. This sample shows you how to implement a drop list to simplify the selection of tax rate.
With a drop down list, you select values from a list, instead of typing in manually. This is a great way to prevent typo errors. With the default sales invoice template shipping with Invoice Manager for Excel, the tax rate is fillable when you create an invoice; but it is not implemented as a dropdown list.
With this Simple Tax Invoice Sample with Tax Rate List, we'll create the drop down list of tax rates by using Excel's data validation features. There are already samples of using drop down list here on InvoicingTemplates.com, such as Auto Repair Invoice Template (2), which adds a "Model" drop down list to the basic template Auto Repair Invoice Template, allowing to select car or vehicle model. Note that the drop down list will not be implemented in the PDF invoice template.
With this sample, we'll focused on the steps of creating the tax rate drop down list. The basic template of this demonstration is c4051 Simple Invoice Template - Discount Amount Field - i.e. we'll use the result of c4051 as the starting point of this customization. The billing form created here can be downloaded for free.
For a template support mixed tax rates on one same billing form / receipt format (for example, beverage tax must be at 3.0% and non-beverage tax rate must be at 5.0%; or if you are selling both general products (goods) and labor (service) to customers, which are two types of taxable items and should be charged with different tax rate), visit Mixed Tax Rates in an Invoice If you need to detail the tax amount for each invoicing item, try Invoice Template with Tax Column.
The base template supports two taxes on the bottom of the form (The default tax names are set to PST - Provincial sales tax, and GST - stands for Goods and Services Tax. It is a federal sales tax, although you can easily change this via the Settings dialog box). For the purpose of this demonstration, we'll use only one tax.
Let's see how the tax rate drop down list is created.
Move out the contents that are already on the columns, i.e. the comment text starting with "To create an invoice" etc. To do this, drag your mouse to select all the content you want to move, and then drag the border of the select area to move it to the new location.
For the purpose of this demonstration, we copied the tax rates from State Sales Tax Rates | Sales Tax Institute (As of 3/1/2016). . Sales and use tax rates change on a monthly basis. This chart is for informational purposes only. As the source origin statement shows, specific questions should be addressed to your tax advisor or a State Department of Revenue, such as Texas Sales Tax. The rate chart gives tax rate for the following states: Alabama, Alaska, Arizona, Arkansas, California, Colorado, Connecticut, Delaware, District of Columbia, Florida, Georgia, Hawaii, Idaho, Illinois, Indiana, Iowa, Kansas, Kentucky, Louisiana, Maine, Maryland, Massachusetts, Michigan, Minnesota, Mississippi, Missouri, Montana, Nebraska, Nevada, New Hampshire, New Jersey, New Mexico, New York, North Carolina, North Dakota, Ohio, Oklahoma, Oregon, Pennsylvania, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Vermont, Virginia, Washington, West Virginia, Wisconsin, Wyoming. No matter what business you are running - attorney / legal, medical, catering, restaurant, law firms (whether small or big), health insurance billing or statement / timesheet, car / vehicle sales, graphic designs, freelance, plumbing, marketing, business plans, accounting, house rent (yearly or monthly), or even home businesses for monthly bill, it is import for you to making taxation correct on your invoices.
As you can see from this sample, while Microsoft Word (and other programs, like Publisher, Microsoft Works, Adobe Acrobat (PDF), or even Photoshop could be used to create beautiful invoicing forms, Excel is far more easier than others when it comes to do calculations. By using Excel formulas, you can easily define the relationship between fields for Invoice Manager for Excel.
With this solution, Invoice Manager for Excel does not save the tax rate table to database along with each invoice. This means that, if you 1) - Save an invoice which sells products to a state, say Iowa; 2) - Several months later, you update the tax rate of Iowa; 3) - You reload the invoice using the Excel billing form; 4) - You save the invoice again (the default implementation of Invoice Manager for Excel does not allow to save paid invoice, but we do have hacks / workarounds for this is a customer asked). In this situation, the bill that is re-calculated with the new rate table will differ from the original invoice. To overcome this, you need to save the entire rate table using custom fields.
A sales tax is a tax paid to a governing body for the sales of certain goods and services. Usually laws allow (or require) the seller to collect funds for the tax from the consumer at the point of purchase. Besides state tax, you may also need to consider local sales tax. For example, Texas imposes a state sales tax on all retail sales, leases and rentals of most goods, as well as taxable services. Texas cities, counties, transit authorities and special purpose districts have the option of imposing an additional local sales tax for a combined state and local tax rate of up to 8 1/4% (.0825). Taxation itself is a complex topic. If your business is located in Australia, try Australian GST Invoice Template.
|Name||Simple Tax Invoice Sample with Tax Rate List|
|Category||Sales Invoice Template|
|Release Date||Monday, February 8, 2016|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|
November 5, 2018
May 25, 2019