Skip to main content
InvoicingTemplate.com main content

Commercial Invoicing Templatec7015

Commercial Billing Form

"Commercial Billing Form" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 92.

...(35) Once the form is unprotected and switched to design mode, you simply type in your own business name, address, city state and ZIP, contact phone and web site etc., on the top of the form.

Web-hosting Invoicing Templatec2007

Web-hosting Billing Form

"Web-hosting Invoicing Template" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 88.

...(64) The template has 6 lines on the invoice body. If you enter a description, the amount cell shows the word 'Free'. If you enter the actual amount in the cell outside the print area, the entered amount appears in the print area. This feature makes it possible for you to clearly display the word 'FREE' for the products or services you offered for free.

Contractor Billing Formatc3009

Contractor Billing Format

"Contractor Billing Format" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 86.

...(74) This template has two taxes like the default template shipped with Uniform Invoice Software. However unlike the default template, where the two taxes applied to all taxable items added to the invoice detail section, Contractor Billing Format applies each tax to one section. In this implementation, "Tax 1" was applied to the "Service" section, and "Tax 2" was applied to the "Expense" section. All the tax-calculation formulas are modified according to this design requirement.

Catering Invoice Templatec4045

Catering Billing Format

"Catering Invoice Template" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 85.

...(31) However, if you don't have Uniform Invoice Software installed, you should go to design mode manually in order to replace the default logo image that has the text "InvoicingTemplate.com" on it.

Engineering Invoice Templatec2006

Engineering Billing Template

"Engineering Invoice Template" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 73.

...(70) Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

Welder Invoicing Templatec7021

Welder Billing Form

"Welder Billing Form" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 62.

...(96) Adding a custom field to the "InvHdr" table in the database makes it possible to save the field value to database along with the other data of an invoice record. For example, adding the custom field Company Name to the "InvHdr" database table allows you to save the company name of a customer to the database when you save an invoice. If you use Uniform Invoice Software version template Welder Invoicing Template and add the custom field, the value is saved from or retrieved to Welder Invoicing Template whenever you save or reload an invoice record.

Notary Invoice Templatec3007

Notary Invoice Template

"Notary Invoice Template" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 53.

...(161) If you use the Uniform Invoice Software version of Notary Invoice Template, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Musician Invoice Templatec2036

Musician Invoice Template

"Musician Invoice Template" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 52.

...(101) The "Advertisement" section is an auxiliary section, which is not directly related to your bills or invoices, but allows you to put a brief description about your business and service, or you can also put your payment term, service term here. Note that this is a static text section - you can modify it once the template is switched to design mode, but when you are creating invoices, this section is protected and thus couldn't be modified. This also means that the section is not defined as a field in the database, and thus cannot be changed from invoice to invoice.

Simple Sample - Discount Amount on Sales Reportc4055

Simple Invoicing Template - Discount Amount on Sales Report

"Simple Sample - Discount Amount on Sales Report" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 40.

  1. Backup the invoice template.
  2. Open the template.
  3. Activate / switch to the "Sales Report" worksheet.
  4. Activate / Switch to Excel "View" ribbon tab.
  5. Check "Gridlines" and "Headings" in the "Show" ribbon group.
  6. Click to select the "Balance Due" report heading cell ($N$11).
  7. Click the "Format Painter" button in the "Clipboard" group on Excel "Home" ribbon tab.
  8. Click the cell next to "Balance Due" on the same row - in this sample, it is $R$11. This copies the forma the "Balance Due" cell to the new / empty cell.
  9. With the new cell still selected, enter text "Discount" into this cell, and then enter the cell name "oknRsDiscountAmount" into the name box on the left-hand of Excel formula bar. This assign the specified name to the cell. In this name, "oknRs" is the prefix of the name, "DiscountAmount" is the database field name.

    When adding a custom field to the Invoice worksheet, we leant that the mapping between an Excel cell on the Invoicing form and the backend database field is established by names. For example, the database field "DiscountAmount" in the "Invoice Header" database table is mapped to the cell name "oknDiscountAmount" on the "Invoice" worksheet.

    Likewise, a report column is mapped to a database field using names. In this sample, we name the report heading cell "oknRsDiscountAmount", which maps the report column to the database field "DiscountAmount".

    "oknRs" is the name prefix of the "Sales Report". Each report has its own name prefix, as detailed below.

    • Sales Report - oknRs
    • Customer Report - oknRc
    • Product Report - oknRp
    • Customer Rep. Report - oknRr
  10. The default Sales Report is designed to be printable on standard A4 paper. Adding the Discount field makes it too wide on the horizontal direction. To make sure it fits into one single page on horizontal direction, we need to hide a column. To do this, click the "Columns" button on the taskpane, and then uncheck the column that you want to hide. In sample, we hide the "Sales Rep." column. You can also adjust the column widths to make the report suitable for the paper size.
  11. Once everything is done, go to Excel "View" ribbon tab and uncheck "Gridlines" and "Headings".
  12. Save the template by clicking the "Save" button on Excel quick access toolbar.

Jewelry Receipt Templatec4102

Bill Format for Jewelry Shop

"Jewelry Receipt Template" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 32.

...(54) The templates includes 12 rows on the detail section, each of the row allows you to enter multiple lines of text to description the items. Gems are expensive so usually it is important to describe the item as detail as possible, whether it is bracelet, diamond, earring, gemstone, necklace, ring, wedding & engagement ring.

Recipient Created Tax Invoices Formc4077

Recipient Created Tax Invoices Form

"Recipient Created Tax Invoices Form" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 30.

...(58) As you can see, while PDF formatted documents has advantages in the business world, on creating invoices Excel formatted invoice template is much easier and saves time by doing automated calculations using formulas. And, with Uniform Invoice Software, you can simply click the "Extract/Email" button within the Excel spreadsheet to send PDF invoices using email in electronic format.

Transportation Invoicec5014

Transportation Bill Format

"Transportation Bill Format" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 27.

...(32) To make the default invoice template suitable for use by transportation / taxi / limousine service company, this customized service invoice template uses several custom fields, as detailed in the following table.

Customer Value Based Pricingc6006

Special Customer Pricing

"Customer Value Based Pricing" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 19.

...(121) Thirdly, the link between the cells on the invoice form and the fields in the backend database should be established. This link is created by using names. For example, if a field is named CustType in the backend database, the cell name should be "oknCustType", where "okn" is the prefix which is always the same for all the custom fields used by Excel Invoice Manager, and "CustType" is the database field name. That is, on loading customer information, Excel Invoice Manager writes the value of the field CustType to the cell named oknCustType on the invoice form, and on saving an invoice, the value of the oknCustType cell is saved to the field named CustType in the Invoice Header database table.

Lumber Company Invoicecm007

Lumber Company Invoice

"Lumber Company Invoice" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 13.

...(34) The first drop-down list shows freight details. The data source of this list is located on $AE$19:$AE$24, featuring items like "PBT Transport", "Northern Southland Tspt", "Summerland Transport", "Seaton Couriers", "NZ Couriers" and "Waikaka Freight".

...(24) Download the sample template for free to see how it works for you if you have the need to invoicing for your lumber business.

Green Gradient Service Invoicec2037

Green Gradient Service Invoice

"Green Gradient Service Invoice Template" was found to be relative to Jewelry Accounting With Billing Software with the score grade of 10.

...(59) This format design is based on c2004 service invoice template with payment advice. Like the original format, it has a " Remit payment to:" section, which is a section of static text -- i.e. the text here must be modified / edited when the template is put into design mode, and it will not change from invoice to invoice.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c7015
Commercial Invoicing Template
Wednesday, December 11, 2013,
16
7
A4
Portrait
Pro-forma
c2007
Web-hosting Invoicing Template
Wednesday, October 23, 2013,
6
2
A4
Portrait
Service
c3009
Contractor Billing Format
Saturday, October 17, 2015,
18
3
A4
Portrait
Service
c4045
Catering Invoice Template
Tuesday, November 10, 2015,
12
4
A4
Portrait
Receipt
c2006
Engineering Invoice Template
Monday, September 15, 2014,
9
2
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c7021
Welder Invoicing Template
Friday, September 26, 2014,
20
7
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c3007
Notary Invoice Template
Thursday, October 2, 2014,
12
3
A4
Portrait
Service
c2036
Musician Invoice Template
Sunday, October 9, 2016,
6
2
A4
Portrait
Service
c4055
Simple Sample - Discount Amount on Sales Report
Sunday, January 31, 2016,
12
4
A4
Portrait
Sales
c4102
Jewelry Receipt Template
Friday, November 11, 2016,
16
4
A4
Portrait
Receipt
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales
c5014
Transportation Invoice
Thursday, March 16, 2017,
16
5
A4
Portrait
Service
c6006
Customer Value Based Pricing
Saturday, March 11, 2017,
20
6
A4
Portrait
Sales
cm007
Lumber Company Invoice
Sunday, July 2, 2017,
12
x
A4
Landscape
Sales
c2037
Green Gradient Service Invoice
Sunday, April 9, 2017,
12
2
A4
Portrait
Service

What Is Hot

Feature Galleries