BoostExcel main content

Download

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.

Description Size Download

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

660 KB Download

Download this if you want this design to be set as the default template by the installer program.

6.28 MB Download

Screenshots and Images

The printed version.

Vendor Invoice Template for California

Open the template in Excel.

Vendor Invoice Template for California (IMFE Edition)

Detail

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

Template# c7036
Name Vendor Invoice Template for California
Category Service Invoice Template
Release Date Saturday, January 27, 2018
Format (XLS or XLSX) .xlsx
Feature Gallery
Columns 7
Lines 12
Line Height (Points) 19.50
Print Area $F$3:$N$49
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 22.68
Right 22.68
Top 45.35
Bottom 45.35
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.

Update History

November 5, 2018

  • Imported the "Accounts Receivable Aging Report" sheet into this template.

May 25, 2019

  • Changed the color schema to "Violet".