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 Invoice

"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

Invoicing Layout for Bike Shop

"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

Invoicing Format for HVAC Service

"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 Invoice 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 Invoicing Form

"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 45.

...(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 Template - Discount Amount

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

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

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

...(32) Uniform Invoice Software is able to handle this type of multiple-page invoices. This feature is even implemented since very early versions of Excel Invoice Manager (the former name of Uniform Invoice Software).

...(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 Format" was found to be relative to Microsoft Access Invoice Template with the score grade of 28.

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

...(32) By using Uniform Invoice Software, the automatic numbering feature creates sequential receipt numbers when you save a receipt. This auto-number generator for receipts is based on the Access database connected with template.

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

...(138) Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Sales Invoice with Profit Calculation uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

...(78) The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Sales Invoice with Profit Calculation without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

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

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

Auto Repair Invoicing Sample (2)c5049

Auto Repair Invoicing Sample (2)

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

...(110) If you are running a small business that creates invoices rarely, a free invoicing template helps you draft your invoices and cash receipts in an easy and quick way and the documents created by the templates look professional. If you need more control over your business, such as managing customers, products, invoices and payments, UIS is your choice. InvoicingTemplate.com is providing you with the fully functional trial version. Feel free to download and try the trial version - no license key or registration code is required to run the trial version within the trial period. You or your company need to purchase nothing in order to trial our invoicing software.

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

Consulting Invoice Template (1st Sample of Customization)c4016

Consulting (1st Sample)

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

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

...(43) If you use the Uniform Invoice Software version of Consulting Invoice Template (1st Sample of Customization), note that this invoice template uses custom fields. Custom fields are the fields that are not defined in the default database design, but added by the end-users.

Simple Sales Invoicing Samplec4032

Simple Sales Invoicing Sample

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

...(25) Simple Sales Invoicing Sample is the template designed by InvoicingTemplate.com that helps you create beautiful and professional sales invoices in an easy and quick way.

...(123) If you like the invoices and receipts created by Simple Sales Invoicing Sample, you may find that these Excel shapes and Smart Art objects easily make Simple Sales Invoicing Sample a beautiful business documents. If you like the samples provided by Simple Sales Invoicing Sample, here is how to use Excel shapes or SmartArt objects in your own template. In Microsoft Excel, you can add shapes, such as boxes, circles, and arrows, to your documents, email messages, slide shows, and spreadsheets. To add a shape, click Insert, click Shapes, select a shape, and then click and drag to draw the shape. After you add one or more shapes, you can add text, bullets, numbering, and Quick Styles to them. To add a shape:

 You can add individual shapes to a chart, or add shapes on top of a SmartArt graphic to customize the chart or the graphic.

Simple Sample - Separate City State ZIPc4081

Simple Sample - Separate City State ZIP

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

  1. Backup the template before modifying it.
  2. Open it.
  3. Go to the "Invoice" ribbon tab and click the "Design Mode" button.
  4. Drag your mouse to select 3 custom fields, "oknCustomerCity" (cell address O8), "oknCustomerState" (cell address O9) and "oknCustomerZip" (cell address O10).
  5. Hit DEL key on keyboard to delete the formulas of these 3 cells.
  6. With the 3 cells / fields still selected, right-click on of the selected cell and choose "Format Cells" from the shortcut menu. This opens the "Format Cells" dialog box.
  7. Go to the "Protection" tab. Clear the "Locked" checkbox option.
  8. Click OK to close the "Format Cells" dialog box. This makes the 3 cells editable when the worksheet is protected.
  9. Now click and select the "City, State ZIP" cell in the "Bill To" section (cell address $F$11).
  10. Enter this formula for the cell: = CONCATENATE( TRIM ( oknCustomerCity ) , ", ", TRIM( oknCustomerState ), " ", TRIM ( oknCustomerZIP )). This formula combines the 3 user entered values into one readable and formal "City, State ZIP" value.
  11. Right-click selected cell ($F$11) and choose "Format Cells" from the shortcut menu.
  12. Go to the "Protection" tab.
  13. Check the "Locked" option box.
  14. Click OK to close the "Format Cells" dialog box. This make the cell not editable when the "Invoice" worksheet is protected.
  15. Exit design mode by clicking the "Design Mode" button again on Microsoft Excel ribbon tab.
  16. Save the template by clicking the Save button on Excel quick access toolbar.

Service Invoicing Templatecn003

Service Invoice Form

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

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

...(78) On the top of the invoice form, you can find the fields for invoice number and invoice date. These are required fields that help you to track the invoice and keep your book organized. In the Bill To section, you can add the customer details including name, address, city, state, zip code and phone. A list of itemized services, including description, quantity, unit price and line item total, allow you to enter your services and cost of each.

Invoice Template with Hours and Ratec4031

Billing Format with Hours and Rate

"Invoice Template with Hours and Rate" was found to be relative to Microsoft Access Invoice Template with the score grade of 2.

...(48)Invoice Template with Hours and Rate or Billing Format with Hours and Rate is a service billing format that calculates line totals from hours and hourly rate. Based on c4025 Hourly Service Billing Format, this template offers a different look and feel by applying various Excel formatting options.

...(47) If you use the Uniform Invoice Software edition, setting tax options can be done by clicking the Settings button on the Invoice worksheet, and then go to the Taxes tab. With the freeware edition, you should first unprotect the spreadsheet and then unhide second tax line manually.

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
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
c4031
Invoice Template with Hours and Rate
Friday, October 10, 2014,
6
4
A4
Portrait
Sales

What Is Hot

Feature Galleries