Skip to main content
InvoicingTemplate.com main content

Summary

Microsoft Access is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately (Wikipedia.org). On Windows desktop the database file is stored in ".mdb" or ".accdb" format. However with Office 365, the Access data is stored in a SQL database. Uniform Invoice Software, by default uses local (desktop) Access database. Each invoice template published here on InvoicingTemplate.com comes with an Access database with the template# as the database file name.

Uniform Invoice Software itself uses Excel spreadsheet templates as the front-end. Access database is only used as a data storage. We don't lock the database so if you are a power user who want to customize the invoicing application deeply, you are free to do so on the database level too. For example, you can use Access queries, forms, reports, macros and modules.

Here are our templates closely related to Microsoft Access Invoice Template.

Limousine Service Invoicec4104

Limousine Service Bill

"Limousine Service Bill" was found to be relative to Microsoft Access Invoice Template with the score grade of 95.

...(92) 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.

Bike Shop Invoice Templatec4069

Bike Shop Invoice Template

"Invoicing Layout for Bike Shop" was found to be relative to Microsoft Access Invoice Template with the score grade of 78.

...(38) This bike shop invoice template in Microsoft Excel xlsx format provides a simple invoices generator for bicycle retail shops or warehouses for the bikes, clothing, accessories, chain whip, and parts sold and related services / repair works rendered.

...(67) Like all the other Excel invoicing templates here on InvoicingTemplate.com, this invoicing layout for bike shop works well too with Uniform Invoice Software. By installing Uniform Invoice Software, which is our Excel-based invoicing software app, this simple Excel-formatted invoice template becomes a powerful invoicing software program that is able to manipulate your client, products, invoices / receipts and payments data, saving your time and effort on invoicing.

Invoicing Format for HVAC Servicec4089

A C invoice template

"Invoicing Format for HVAC Service" was found to be relative to Microsoft Access Invoice Template with the score grade of 73.

...(72) This HVAC form design is suitable for creating invoices and bills, service or work orders, or you can also use it as a proposal form. Our Excel invoicing templates are original, editable and have no password set for protection. You can easily unprotect any template by clicking "Unprotect Sheet" command on Microsoft Excel "Review" ribbon tab, or switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.

...(112) Besides the usual replaceable logo image placeholder located on the top-left corner of the form layout, it also introduces a repairman image located on the top-center, which should be a suitable widget for heating, ventilation and air conditioning services. In fact you can add any images to the template by simply clicking the "Pictures" command on Excel "Insert" ribbon tab. To have the newly added image appear on UIS-generated PDF invoices and bills, you should name the image with "oknWidget" prefix. For example, in this template the repairman image is named "oknWidget_repairman". Visit Creating and Customizing Invoice Template for more information. For more samples on templates and images visit Invoice Template Images.

Engineering Estimate Templatecm006

Engineering Estimate Template

"Engineering Estimate Template" was found to be relative to Microsoft Access Invoice Template with the score grade of 68.

...(108) The most significant feature of this service invoice template is that it includes 10 columns, and has complex relationship built between the cells/columns using Excel formulas to make the template meet the requirements of the intent service business. This provides a good example of the flexibility of Excel Invoice Manager (now named "Uniform Invoice Software"), the billing software and invoicing software using Excel invoice template as its frontend, as it is able to apply formulas to create/define/build the relationships between cells and fields, while many other non Excel-based invoice programs allow you to customize just the style or format of the invoice form, such as fonts and colors.

...(20) Here is a brief description of what implemented by this engineering service invoice or estimate template by using Excel formula.

VAT Sales Invoice Template - Price Including Taxc6007

VAT Sales Invoicing Template - Price Including Tax

"VAT Sales Invoice Template - Price Including Tax" was found to be relative to Microsoft Access Invoice Template with the score grade of 67.

...(53) Like many other invoicing templates here on Invoicing Templates, VAT Sales Invoicing Template - Price Including Tax has a default logo image on the top of the invoice form. To replace it with your default logo image, you need to first unprotect the invoice worksheet, and then put the spreadsheet into design mode.

...(16) The gridlines and row/column headings could help a lot when design the layout of the form.

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

Proforma (3rd Sample of Customization)c7013

Proforma (3rd Sample of Customization)

"Proforma Invoicing Form" was found to be relative to Microsoft Access Invoice Template with the score grade of 60.

...(113) The default implementation of the Proforma Invoice Template here on InvoicingTemplate.com has a currency field on the Shipping Details section, which is a manually editable field. In practice the currency usually could be picked up from a limited set. For this reason, it could be implemented as a drop-down list, instead of a manually editable field. The benefit of using a drop-down list here is obvious - it is not only easy to use than a manually editable field, but also avoids typo mistakes. And the best part is that, Microsoft Excel provides direct support for this. Here are the steps to add the currency drop-down list to the pro forma invoice template.

Consulting Invoicing Sample with Consultants Background Picturec4091

Consulting Bill Format with Consultants Background Picture

"Consulting Bill Format with Consultants Background Picture" was found to be relative to Microsoft Access Invoice Template with the score grade of 59.

...(119) The template has one tax set by default which is named "TAX" and the rate is set to 8%. To change the tax name to either "GST" or "VAT", first click the "Settings" button on the "Invoice" worksheet or on Excel ribbon, and then go to the "Taxes" tab, fill in the new tax name ("GST" or "VAT") and rate that are suitable for region. You can also find options for changing to 2 taxes or no-tax and the other taxation rules on the "Taxes" tab. Besides requesting payments and managing account receivables, taxing is also another major purpose of a business invoice. So make sure it is clear and correct. Consult with your local taxing department when necessary.

Spin Button to Add or Subtract Onec4083

Sample Invoice Template with Spin Button

"Sample Invoice Template with Spin Button" was found to be relative to Microsoft Access Invoice Template with the score grade of 55.

...(89) The spin button we'll use here one of the control in the "Form Controls" toolset, which is available in all the major apps in the Microsoft Office product family, like Excel (".xls" or ".xlsx"), Word (".doc" or ".docx"), Visio, Publisher, PowerPoint. Here on InvoicingTemlate.com we've already published samples on using form controls. For example, the "Taxable" checkbox could be either implemented using ActiveX control, or a form control - in the standard invoice template shipped with Uniform Invoice Software setup program, it use checkbox in the form control category.

...(18) Now let's see how we can add the spin buttons to "c4020 Invoice Template with Long Product Description".

Child Care Billing Templatec4007

Child Care Invoicing Form

"Child Care Billing Template" was found to be relative to Microsoft Access Invoice Template with the score grade of 36.

...(45) This child care billing template or babysitting receipt template is a revisited version of the Parenting Service Invoice Template (c4-007) originally published on office-kit.com. Use this free printable Excel format to create and print bills and receipts for your babysitting, day care or childminder services.

...(42) As a parenting service company or organization it is necessary to record detailed child information on their invoices, in additional to those default fields provided by Excel Invoice Manager / Uniform Invoice Software. Here are the custom fields added to the database.

Service Invoice Form with Discount Amountc5011

Service Invoice Form with Discount Amount

"Service Invoice Form with Discount Amount" was found to be relative to Microsoft Access Invoice Template with the score grade of 32.

...(88) Just like a general sales invoice template, this service invoice template includes required fields on the form, including your logo, company name, date of order, buyer's name, description of product, amount due, taxes and anything else you specifically need for your company. However, since this is a service invoice template, we moved out all the fields that are defined for providing shipping information. If you would like a version that includes the shipping fields on the printable invoice, see Sales Invoice Form with Discount Amount here on InvoicingTemplate.com.

2-Page Invoice Templatec5081

2-Page Invoice Template

"2-Page Invoice Template" was found to be relative to Microsoft Access Invoice Template with the score grade of 28.

...(72) All templates here on InvoicingTemplate.com are created from the default template shipped with Uniform Invoice Software setup program. While the format and layout look very different between the templates, most of them are printable on a single page (or even 1/2 page, also see 5.5 X 8.5 - 2 Invoices On One Template). However some businesses requires more lines on each invoice, for example a store or limited company selling auto parts.

...(124) This invoice template is based on the default invoice template shipped with Uniform Invoice Software, which is our desktop invoice software which runs offline (without the requirement of an online Internet connection). This template includes 36 lines on the invoice body section, and is printable with 2 pages of standard 8.5 X 11 inch letter paper. This invoicing format is a "Sales Invoice Template", as it contains the "Shipping Address" section, it also added 3 custom fields on the bottom of the form to calculate labor hours and expense. The template shows only one tax on the bottom of the form - to change this tax option / layout, go to Uniform Invoice Software Settings window / Taxes tab and set your preferences easily.

Security Deposit Receipt Templatec1003

Security Deposit Receipt Format

"Security Deposit Receipt Template" was found to be relative to Microsoft Access Invoice Template with the score grade of 21.

...(100) Since there could be disputes related to house renting, the documents involved in the renting process is very important. If you are a tenant, you want to get a formal receipt after making any payment. If you are a landlord or letting agent, you not only have the responsibility for preparing legal and formal documents - which ensures a good start, your duty also includes keeping the documents well so that they can be shown when needed. By installing Uniform Invoice Software, this pure-Excel spreadsheet format receipt template for security deposit could be a complete management system for your receipts.

Sales Invoice with Profit Calculationc5060

Sales Invoicing Template with Profit Calculation

"Sales Invoice with Profit Calculation" was found to be relative to Microsoft Access Invoice Template with the score grade of 19.

...(38) This sales invoice template produces exactly the same printed invoices as the default sales invoice template that is included in the Uniform Invoice Software installer program. The main difference is that this template support the calculation of profit.

...(38) The magic of adding profit calculation depends on a powerful feature supported by all editions of Uniform Invoice Software - Uniform Invoice Software Standard, Uniform Invoice Software Net and Uniform Invoice Software Enterprise, which is called custom fields.

...(136) In order to calculate the profit, you'll need the cost figure which is either set the Product Edit form, or entered manually according to the agreement or contracts on the invoicing form when you are creating an invoice. The cost is the amount you pay the vendor for each item you purchased, equal to the "price" listed on the orders you send to your vendors. On the other hand, the price is the amount your clients or customers pay you. On the invoices that you'll send to your customers, whether they are printed hard-copy, or as electronic bill in PDF / Excel / HTML format, the cost figures will not be shown to your customers, since this column is placed outside the printable area. It is designed for your own accounting or book keeping purpose only.

Simple Service Invoice Templatec4033

Simple Service Billing Format

"Simple Service Invoice Template" was found to be relative to Microsoft Access Invoice Template with the score grade of 18.

...(41)Simple Service Invoice Template is a service billing format designed under the need to itemize all the service that you offered. And by using this beautiful layout, you will able to collect all the information regarding all services that you performed.

...(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.

...(22) Once you have finished your design work for Simple Service Invoice Template, click the Design Mode button again to exit design mode.

Auto Repair Invoicing Sample (2)c5049

Blank Vehicle Repair Invoice (2)

"Auto Repair Invoicing Sample (2)" was found to be relative to Microsoft Access Invoice Template with the score grade of 12.

...(79) All templates offered here on InvoicingTemplate.com are not protected and are not locked. You don't need a password or special key in order to modify it. For example, if you use the UIS version, you can even create a credit memo template or credit note template based on the sample templates provided here. Remember that professional and beautiful business documents, such as the ones created by this printable form design, do help you collect your money easy and quick.

...(133) Data validation is an Excel feature that you can use to define restrictions on what data can or should be entered in a cell. You can configure data validation to prevent users from entering data that is not valid. If you prefer, you can allow users to enter invalid data but warn them when they try to type it in the cell. You can also provide messages to define what input you expect for the cell, and instructions to help users correct any errors. One thing you may not be aware of is that, most of the templates available here on InvoicingTemplate.com, including this Auto Repair Invoicing Sample (2), as well as the default spreadsheet template shipped with Uniform Invoice Software setup program, are using Data Validation to prevent incorrect data being entered.

Consulting Invoice Template (1st Sample of Customization)c4016

Consulting Invoice Template (1st Sample of Customization)

"Consulting Invoice Template (1st Sample of Customization)" was found to be relative to Microsoft Access Invoice Template with the score grade of 10.

...(242) Moving a cell or a group of cells is easy in Excel. First, you click to select the cell or drag your mouse to select all the cells you want to move. And then, drag the border of the selected area to move it to the new location where you want to place the cell or cells. The moving content will overwrite the content in the target location, so make sure the target range is empty (not used) in Consulting Invoice Template (1st Sample of Customization) before doing the movement. And, if the target location contains merged cells, sometimes the movement fails. So it is also helpful to make sure the target location does not contain merged cell. If the target location Consulting Invoice Template (1st Sample of Customization) is overlapping the original range and the original range contains merged cells, the movement could also fail because you cannot change part of merged cell - if this happens, you need to first move the cells to a temporal location in Consulting Invoice Template (1st Sample of Customization) that are empty (i.e. not used), unmerge cells, and then move the cells from the temporal location to the desired location. If you need to unmerge a cell, first select it and then click the "Merge and Center" command on the Format toolbar in Excel 2003; or click the "Merge and Center" command on the Home ribbon tab in Excel 2007, 2010 and Excel 2013.

Simple Sales Invoicing Samplec4032

Simple Sales Invoicing Format

"Simple Sales Invoicing Sample" was found to be relative to Microsoft Access Invoice Template with the score grade of 8.

...(30) To find more samples on how to create new templates based on this simple template, see Simple Service Bill Format / Simple Service Billing Format, or Simple Consulting Billing Format.

...(53) Note that we've used several illustrations / shapes of Microsoft Excel to archive the beautiful invoicing form, such as the parallelogram with the big word "INVOICE" in it, the "flowchart: terminator" shapes surrounding the "BILL TO" and "SHIP TO" labels, and the circle shape object on the bottom of the sales invoice form.

Simple Sample - Separate City State ZIPc4081

Simple Invoice Template - Separate City State ZIP

"Simple Sample - Separate City State ZIP" was found to be relative to Microsoft Access Invoice Template with the score grade of 6.

...(101) In c4072 Simple Sample - Splitting City State ZIP, we demonstrates how to use Excel formulas to split a field value of user-entered "City, State ZIP" into 3 fields, and then store them in 3 database fields. The drawback of that solution is that it relies on the format of the user-entered values - for example, a United States style format like "La Jolla, California 92092-0100". A more stable solution is to let the end-user enter these 3 values, "City", "State" and "Zip" into 3 different cells, so that it will no longer rely on Excel formulas to do the separation.

...(30) We'll take the sample invoice template crated in c4072 Simple Sample - Splitting City State ZIP as the base template, and then implement separate fields for "City", "State" and "Zip".

Service Invoicing Templatecn003

Service Invoice Form

"Service Invoice Form" was found to be relative to Microsoft Access Invoice Template with the score grade of 2.

...(38) This free service invoice template differs from the general sales invoice template in that the service billing form does not contain shipping information. If you don't sell and deliver products then this template might be interesting for you.

...(56) You can also use this template as a sample, and do further customizations using various tools provided by Excel. For example, you can easily change the fonts, colors, borders, patterns and number formats using the Format Cells dialog box that can be opened by right-clicking a cell and then choose Format Cells from the shortcut menu.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c4104
Limousine Service Invoice
Sunday, March 19, 2017,
5
4
A4
Portrait
Service
c4069
Bike Shop Invoice Template
Tuesday, May 10, 2016,
12
4
A4
Portrait
Sales
c4089
Invoicing Format for HVAC Service
Thursday, October 20, 2016,
18
4
A4
Portrait
Service
cm006
Engineering Estimate Template
Sunday, March 12, 2017,
12
x
A4
Portrait
Service
c6007
VAT Sales Invoice Template - Price Including Tax
Monday, May 26, 2014,
18
6
A4
Portrait
Sales
c7013
Proforma (3rd Sample of Customization)
Saturday, November 23, 2013,
20
7
A4
Portrait
Pro-forma
c4091
Consulting Invoicing Sample with Consultants Background Picture
Tuesday, October 25, 2016,
16
4
A4
Portrait
Consulting
c4083
Spin Button to Add or Subtract One
Friday, August 12, 2016,
6
4
A4
Portrait
Sales
c4105
Service Invoice with Horizontal Logo
Sunday, March 19, 2017,
12
4
A4
Portrait
Service
c4007
Child Care Billing Template
Monday, March 13, 2017,
12
4
A4
Portrait
Service
c5011
Service Invoice Form with Discount Amount
Tuesday, November 19, 2013,
8
5
A4
Portrait
Service
c5081
2-Page Invoice Template
Wednesday, March 2, 2016,
36
5
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c1003
Security Deposit Receipt Template
Sunday, August 14, 2016,
8
1
A4
Portrait
Receipt
c5060
Sales Invoice with Profit Calculation
Saturday, September 20, 2014,
12
5
A4
Portrait
Sales
c4033
Simple Service Invoice Template
Wednesday, November 12, 2014,
6
4
A4
Portrait
Service
c5049
Auto Repair Invoicing Sample (2)
Saturday, January 18, 2014,
12
5
A4
Portrait
Service
c4016
Consulting Invoice Template (1st Sample of Customization)
Wednesday, December 4, 2013,
16
4
A4
Portrait
Consulting
c4032
Simple Sales Invoicing Sample
Saturday, October 11, 2014,
6
4
A4
Portrait
Sales
c4081
Simple Sample - Separate City State ZIP
Tuesday, July 26, 2016,
12
4
A4
Portrait
Sales
cn003
Service Invoicing Template
Saturday, October 19, 2013,
12
x
A4
Portrait
Service

What Is Hot

Feature Galleries