You are safe to download the resources. We've added our digital signatures to the files.
Without database file. How to download and use
Download this if you have already installed UIS, but are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
This insurance agency quotation template is created based on c3004 insurance agency invoice template. While Uniform Invoice Software is basically designed for invoicing, it is able to handle any forms that adhere to the design rules.
In the How To Create Invoice Template we describe the rules to follow to make sure the template or form with Uniform Invoice Software, which is our Excel invoicing software program. First of all, a template works with Uniform Invoice Software contains a hidden Excel sheet that details the connection with the back end Access (or Microsoft SQL Server) database, template version, and other specifications.
This means that, in order to make it work with Uniform Invoice Software, you cannot create a template from scratch. You have to copy an existing template, which has the form layout similar to the design you want to create. In this quotation sample, we copy c3004 insurance agency invoice template to create the agency quotation template.
In fact it is fairly easy to create the quotation template from the invoice template. All we need to do is to change the big title from "INVOICE" to "QUOTATION", and then move out the "Paid" and "Total Due" cells. Visit How To Create Invoice Template to find out the details.
Both this template and c3004 agency invoice template are based on the C3-004 originally published on office-kit.com. So we revisited the document from office-kit.com to help you get a better understanding.
A car insurance agency needs an invoicing program to replace their receipts as well as generating reports for earnings. The invoicing program should separate earnings from the money that they pay to the companies that they work for. For example, a customer comes to buy a new insurance. The insurance agency looks for a company and charge the customer what the company asks for (56.00) plus the broker fee (10.00). The total invoice would say 66.00. Yet the earning and lost are included in the same invoice, but not visible to the customer. This template for car insurance agency is built with this situation in mind.
Below we'll look at how to create this template (C3-004) based on the standard invoice template shipped with Uniform Invoice Software..
The invoices for insurance agency don't require the "" fields, and many other fields in the default template, should be moved to better meet the business requirements of an insurance agency.
The most powerful and flexible feature provided by Microsoft Excel, and supported by, is that you can move cells/controls to quickly get a new invoice form based on an existing form you already have. Moving a cell means to assign a new cell (the target cell) all the properties of the source cell, including fonts, formats, formulas, names, borders, lock/unlock properties, etc., and once the moving operation is done, clear all the properties on the source cell.
To move a cell or control in the invoice template, follow the steps below.
This template requires an additional column,, which is not printed or included in the extracted version, but saved to database. You enter " " and manually, and , which is the money that the agency pays to the companies that the agency works for, is calculated automatically.
"" is a custom field that calculates the sum of all the on the form ( invoice, receipt or quotation). This field can be added to etc.
|Table name||Field name||Field type|
For each product, you can set a default broker fee, which is loaded when you choose the product (insurance) by clicking the select-a-product icon button. You can also enter aas a reference for manually entering .
The link between the backend database and the front end Excel form is created by using names. For example, a database field namedshould be named on the Excel form, where " " is a prefix, which must be present for all the cell names recognized by , and " " is just the database field name. For new columns, you add a field, such as to the ( ) database table, and then name the cells on the body part of the invoice form , , , and so on.
Like other form designs here on InvoicingTemplate.com, Agency Quotation Template is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Category||Other Invoice Template|
|Release Date||Wednesday, March 22, 2017|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|