The printed version.
Agency Quotation (c3021)
c3021 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open agency-quotation.xlsx
.
Agency Quotation - IMFE edition
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 want this design to be set as the default template by the installer program. | 3.35 MB | Download |
Without database file. How to download and use | 102 KB | Download |
Download this if you have already installed IMFE, but are looking for additional customized templates. | 354 KB | Download |
This insurance agency quotation template is created based on c3004 insurance agency invoice template. While Invoice Manager for Excel (namely 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 Invoice Manager for Excel (namely Uniform Invoice Software), which is our Excel invoicing software program. First of all, a template works with Invoice Manager for Excel (namely 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 Invoice Manager for Excel (namely 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 Invoice Manager for Excel (namely Uniform Invoice Software).
.The invoices for insurance agency don't require the "Ship To" 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 Invoice Manager for Excel (namely Uniform Invoice Software), 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, BrokerFee, which is not printed or included in the extracted version, but saved to database. You enter "Line Total" and BrokerFee manually, and Cost, which is the money that the agency pays to the companies that the agency works for, is calculated automatically.
"Total BrokerFee" is a custom field that calculates the sum of all the BrokerFee on the form ( invoice, receipt or quotation). This field can be added to Sales Report etc.
Table name | Field name | Field type |
---|---|---|
InvHdr | TotalBrokerFee | decimal (15,4) |
InvBdy | BrokerFee | decimal (15,4) |
Product | BrokerFee | decimal (15,4) |
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 a Price as a reference for manually entering Line Total.
The link between the backend database and the front end Excel form is created by using names. For example, a database field named TotalBrokerFee should be named oknTotalBrokerFee on the Excel form, where "okn" is a prefix, which must be present for all the cell names recognized by Invoice Manager for Excel (namely Uniform Invoice Software), and "TotalBrokerFee" is just the database field name. For new columns, you add a field, such as BrokerFee to the Invoice Body (InvBdy) database table, and then name the cells on the body part of the invoice form oknBrokderFee_1, oknBrokderFee_2, oknBrokerFee_3, 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.
Template# | c3021 |
Name | Agency Quotation |
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 |
Columns | 3 |
Lines | 18 |
Line Height (Points) | 18.00 |
Print Area | $F$3:$N$51 |
Papaer Size / Orientation | Portrait |
Default Margins (Points) | |
Left | 22.68 |
Right | 22.68 |
Top | 45.35 |
Bottom | 45.35 |