Skip to main content
InvoicingTemplate.com main content
sharing is caring! we do appreciate your time to let others know us!

Summary

barcode scanner

A barcode scanner or barcode reader scans a barcode and feed the text or number into an accounting / billing / inventory program. A barcode is an easy way to identify a good, used widely in super markets, grocery shops and medical stores etc.

Here is an easy step-by-step tutorial about installing a barcode scanner: How Do You Install a Barcode Scanner?

In Invoice Manager for Excel (namely Uniform Invoice Software), barcodes are usually used in the Product# (or Item#) field:

  • Click to activate one of the Product#/Item# cell where you want to input the barcode.
  • Pull the trigger on the scanner, the text or numbers from the barcode should appear in the active cell.
  • If you have in-cell lookup feature enabled, all related information about the item will be filled into the current bill, including product description, unit price etc.

Billing Software With Support For Barcode Scanner is a sub-topic of Billing Software Excel Free Download . Here are our templates closely related to Billing Software With Support For Barcode Scanner.

Consulting Invoicing Form

c4008
Consulting Billing Template

If you running a consulting business, this simple consulting invoice could be used as a sample or starting point of your own invoices. Being a consultant your most important work includes setting consulting fee rates and making money, but providing a professional and beautiful consulting invoices could help you collect payments easily and quickly.

Contractor Billing Format

c3009
Contractor Invoicing Layout

Contractor Billing Format differs from other templates here in that it itemizes "service" and "expense" in two separate sections on the invoice detail section. Each section has a different tax (including tax name and tax rate) applied.

Catering Invoice Template

c4045
Catering Invoice Template

Catering is the business of providing food service at a remote site or a site such as a hotel, public house (pub), or other location. Catering has evolved to become an artisanal affair. In fact, many other templates here on InvoicingTemplate.com could be used for catering invoicing. For example, Cleaning Service Invoice Template, Free Restaurant Dining Invoice Template (VAT), and Free Restaurant Dining Invoice Template (No Tax). By default, this template has one default logo image put on the top of the form. To replace this default logo image, simply install Invoice Manager for Excel (namely Uniform Invoice Software). Click the "Replace Logo Image" button on the "Invoice" ribbon to replace the default logo image. With Invoice Manager for Excel (namely Uniform Invoice Software) installed, you can also easily customize the taxing options of the form. Click the Settings command on the Excel ribbon, and then go to the Taxes tab.

Engineering Invoice Template

c2006
Engineering Billing Template

On the bottom of the invoicing form, the section starting with the label "Payment" is designed for hand writing - it will not be included in the invoice that you'll send to your customer.

Welder Invoicing Template

c7021
Welder Billing Form

After removing the text and names of the "Type" column, the space of the type column is merged into the Description column, so that the fillable description column could hold more content about the welding or steel fabrication job that have been done.

Notary Invoice Template

c3007
Notary Invoice Template

This implementation of Notary Invoice Template / Notary Billing Template by InvoicingTemplate.com has one tax presented on the bottom of the form, which is named "TAX". If you use the Invoice Manager for Excel (namely Uniform Invoice Software) edition of this free invoice template, you can easily change the tax name and rate, and even the number of taxes appear on the form.

Musician Invoice Template

c2036
Musician Invoice Template

As a service invoice template, this design sample does not include the "Shipping Address" section. It is a basic template that includes only two columns, "description" and "amount".

Agency Billing Template

c3004
Agency Invoice Form

Outside the printable area, the two important columns are Broke Fee and Cost. With the Broke Fee column, you enter the gross revenue you expect, and the Cost column is calculated automatically based on Line Total and Broke Fee. This is done by using a simple Excel formula.

Contractor Invoices with Remittance-slip

c5106
Contractor Invoices with Remittance-slip

This free contractor invoice template features a remittance slip or remittance-advice-slip on the bottom of the Excel form. The slip is created by mve the total, paid and total due cell down to the bottom, as well as all the information in the "Bill To" section.

Sample Service Invoice Template: Using Handwriting Signature

c5039
Service Template with Signature

Sample Service Invoice Template: Using Handwriting Signature is a variant of Sample Sales Invoicing Sample: Using Handwriting Signature. It is the service edition of the original template.

Invoice Template with 4 Pages

c5083
Invoicing Layout with 4 Pages
  1. In Windows Explorer, copy the template file "invoicetemplate4pages-uis.xlsx" to create a backup copy of the template. This ensure that you can easily return to a working state whenever something goes wrong during the following customization of the template.
  2. Open the template as usual by double-clicking it.
  3. Click the "Design" button on the "Invoice" worksheet. Note that you have to install our Excel invoicing software app in order to have Excel show the "Invoice" ribbon tab.
  4. Click to select one "Taxable" checkbox object; or push down CTRL key on your keyboard and then click several "Taxable" controls one by one to select multiple controls.
  5. Release keyboard CTRL key. Hit DEL key on keyboard. This deletes the selected objects.
  6. Repeat the above steps to delete all the other Taxable controls.
  7. The default formula for calculating tax looks like "=ROUND(IF(oknTaxType=0,0, oknTax1Rate * (oknLineTotalTaxable + IF ( oknTaxTotalIncludingShippingCost=0, 0, oknShippingCost ))), 2)", where "oknLineTotalTaxable" is the name of a hidden cell that calculates the taxable amount using Excel's array formula. Here since all the items are taxable, you modify it to be "=ROUND(IF(oknTaxType=0,0, oknTax1Rate * (oknSubtotal + IF ( oknTaxTotalIncludingShippingCost=0, 0, oknShippingCost ))), 2)". If you want to include the labor expenses (implemented as custom fields on the bottom of the invoices, which calculates labor cost from labor hours and labor hourly rate), then change the formula to "=ROUND(IF(oknTaxType=0,0, oknTax1Rate * (oknSubtotal + oknLaborTotal + IF ( oknTaxTotalIncludingShippingCost=0, 0, oknShippingCost ))), 2)".
  8. Once done, exit design mode buy clicking the "Design" button again on the "Invoice" ribbon tab.
  9. Save the template by clicking the "Save" button on Excel quick access toolbar.

Jewelry Receipt Template

c4102
Jewelry Receipt Template

This free Excel template for jewelry store is created based on c4011 Receipt Format for Gold Shop (first sample). As detailed on the Creating and Designing an Invoicing Template document, the Excel spreadsheet template must be created based on the default template shipped with Invoice Manager for Excel (namely Uniform Invoice Software) (UIS) or any variant based on that template. This is because a template that works with UIS should include a number of required fields in order to functional properly, such as the link to backend Microsoft Access or SQL Server database. See Invoicing Software For Jewellery Shop for more samples on this topic.

Canadian Invoice Template with HST

c6020
Canadian Billing Form with HST

Canadian Invoice Template with HST, or Canadian Billing Form with HST, is an invoicing form that implements one tax (HST - Harmonized Sales Tax) . It also includes the "Taxable" checkbox column on the invoice detail section to support for

Clothing Store (Manufacturer) Invoice Template with Item Pickup Buttons

cm004
Clothing Store (Manufacturer) Invoice Template with Item Pickup Buttons

Without the item picking buttons, like what we implemented with cm003 Clothing Store (Manufacturer) Invoice Template with Size Breakdown, or the standard invoice template shipped with Invoice Manager for Excel (namely Uniform Invoice Software), you can use the "on-sheet picker", which appears when you click and select a supported cell. However there are users that prefer the static buttons.

So with sample template, we look at how to add a button that allows you to pick customer.

New Zealand Tax Invoice Template

c4038
New Zealand Tax Invoice Template

According to New Zealand Inland Revenue, for a tax invoice to be valid it must have:

The template has 4 columns on the invoice detail section - Quantity, Description, Unit Price, Line Total. The form includes a shipping address section so that you can fill it if necessary. Like most templates here on InvoicingTemplate.com, the New Zealand Tax Billing Form also includes logo image placeholder, which you can replace with your own logo image.

Sales Invoicing Format for Germany

c4098
Sales Invoicing Example for Germany

The German tax law is very formal and also the VAT invoice requirements are very strictly. The German rules are conform to the obligations of the EU VAT Directive and its VAT invoice requirements. Refer to German VAT invoice requirements and VAT invoicing rules for more information.

For a service bill format edition of this template, visit c4099 Service Billing Template for Germany.

Limousine Service Invoice

c4104
Limousine Service Invoice

If you are providing limo services you know it is ideal to detail service details on invoice / bill and receipt. While a general service invoice template could help you create invoices, a professionally designed template specific to your limo service shows that you care for your business, and it even helps collect payment more easily and quickly as the bill itself shows what service you have offered, how the account receivable is calculated, and when the service is rendered. More samples on this topic could be found at Business Invoice Template.

Plumbing Contractor Invoice Template (Landscape)

c2009
Plumbing Contractor Billing Template (Landscape)

The original version (c2008) Plumbing Contractor Invoice Template contains 2 columns and 12 lines for you to detail the materials used and service performed. Some plumbers needs less lines on the invoice body, but hope each line could be longer to detail the job / work they have been done. That's why InvoicingTemplate.com designed this variant of Plumbing Contractor Invoice Template. With this new design, the layout of the invoicing form is similar to the original one, but we've set paper orientation to be landscape. This is done on the Page Setup dialog box.