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.
Screenshots and Images
The printed version.
Open the template in Excel.
This free template is an editable version of the General Vendor Invoice Template published on the California State web site. The original version is an image titled as "Sample Vocational Rehabilitation Vendor Invoice". Our template is Excel spreadsheet. PDF version is downloadable too.
We create this template as a sample of customization, to show you how Invoice Manager for Excel can work with different form layouts and designs. This template is a direct successor of our cn003 service invoice template in Excel, which is a generic one in our Service Invoice Templates. We modify it to imitate the layout of the official vendor invoice, and meanwhile make sure the new layout work with Invoice Manager for Excel by following to the rules detailed on customizing invoice template. If you are a retail seller of commercial and vocational vehicles, some truck and truck bodies, trailer and semitrailer bodies and chassis and truck tractors, you may need to collect federal excise tax, visit FET Tax Invoice for a sample template.
On the vendor information section on top of the form, note a line of "Federal Tax I.D. Number" is added. This could be FEIN or SS#. In the "Bill To" section, we reuse the original "Client#" and titled it with "DOR Number". If you have both customer# and DOR authorization number to be included on your invoices, simply add a custom field for the DOR number to the "Invoice Header" database table. See How to add custom fields to "Invoice Header" database table for detailed tutorials.
We also add 3 columns to the original Excel invoice template, i.e. "Consumer Name", "Authorization #Number" and "Service Date". Please refer to General Vendor Invoice Template and Invoicing Guidelines for Vendors for more information on usage and purpose of these fields.
The "Signature" line on the bottom of the form is not a custom field. It is there for handwriting signature. This means anything you type into the field will not be saved to the backend Access (or Microsoft SQL Server) database.
The line of "California Sales Tax" is an additional line to the original official design. Making it a separate field enables you to add it to reports as a separate column. The default tax rate is set to 6.5%, as shown on California City & County Sales & Use Tax Rates and Research California Sales Tax Rates. To change you tax rate, click "Settings", and then go to the "Taxes" tab. Visit our tax invoice templates for more samples. For example, this Simple Tax Invoice Sample with Tax Rate List shows how to implement a drop-down list of all state names of the United States, so that you can easily change the tax rate by selecting a proper state name from list.
Format and Specification
|Name||Vendor Invoice Template for California|
|Category||Service Invoice Template|
|Release Date||Saturday, January 27, 2018|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||19.50|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|System||Windows 7 and later, and Excel 2007 and later.|
November 5, 2018
- Imported the "Accounts Receivable Aging Report" sheet into this template.
May 25, 2019
- Changed the color schema to "Violet".