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.

...(22) While we've already published billing templates for shipping service, such as shipping invoice template, this one is built specially for limo services.

...(59) There are also a number of fields for you to write the credit card information, including card type, expiry date, card holder name, card number, and additional details about the order, such as "Over Time", "Rate per hour", "Package". To find alternative ways to show credit information on a billing form, visit Invoice Template with Credit Card Payment Option.

...(52) The 4 columns on the service detail section are "Description", "Hours", "Price" and "Total", where "Total" is calculated automatically from "Hours" and "Price" using Excel formula. While Microsoft Word and even Adobe Photoshop / AI is able to create beautiful invoicing forms too, Microsoft Excel wins when you need to do calculations.

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.

...(129) For a simple example, without Uniform Invoice Software installed, to create a new invoice you have to clear the fields manually, one by one. If Uniform Invoice Software is installed, clearing the template (make the template ready for next new invoice) is as simple as clicking the "Clear & New" command. Without Uniform Invoice Software, you have to number your invoices manually (i.e. assign each invoice a unique, continuous number. This is not as easy as it sounds; with Uniform Invoice Software installed, you don't have worry about these things because invoice numbering is handled by the Excel invoicing app automatically - when you click "Save Invoice" and left the "Invoice#" cell blank, a new invoice number is generated automatically based on the previous number stored in the database.

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.

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

...(28) Looking for engineering estimate and invoice template for your service business? This is just another sample form in Microsoft Excel spreadsheet form that you can download for free.

...(48) It's well known that Microsoft Excel provides powerful features for formatting and presenting data, and that is why so many invoice templates are provided in Excel format. However you may not notice that Excel also provides handy tools to define or build the relationship between cells or fields.

...(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 Invoicing Template - Price Including Tax" was found to be relative to Microsoft Access Invoice Template with the score grade of 67.

...(11) To show gridlines and row/column headers in Excel 2000 - 2003:

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

...(93) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in VAT Sales Invoice Template - Price Including Tax with your own image, follow the steps below:

Proforma (3rd Sample of Customization)c7013

Proforma (3rd Sample of Customization)

"Proforma (3rd Sample of Customization)" was found to be relative to Microsoft Access Invoice Template with the score grade of 60.

...(41)Tip: To delete a drop down list, select the cell with the list. Click the Data tab, and then in the Data Group, click Data Validation. In the Data Validation dialog box, click the Settings tab, and then click Clear All.

...(48)Tip: The width of the drop-down list is determined by the width of the cell that has the data validation. You may need to adjust the width of that cell to prevent truncating the width of valid entries that are wider than the width of the drop-down list.

Consulting Invoicing Sample with Consultants Background Picturec4091

Consulting Bill Format with Consultants Background Picture

"Consulting Invoicing Sample 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.

...(79) Although we categorize the template as consulting invoice template, by nature it is also a service invoice template. So you may like to take a look at our service invoicing forms too if this particular one does not meet your business requirements exactly, for example some samples are designed for charging on the job hours / billable hours and hourly rate. Looking to make a great impression with your clients? Our templates offer you the easy way to go.

Spin Button to Add or Subtract Onec4083

Spin Button to Add or Subtract One

"Spin Button to Add or Subtract One" 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 Invoicing Form" was found to be relative to Microsoft Access Invoice Template with the score grade of 36.

...(101) This invoice template is for the companies or organizations who offer parenting services. As compared to the default/standard invoice template, the "Ship To" section is removed, and a new field, Date Of Birth, is added to the Bill To section, with witch you can record the birth date of a child. There are also a number of custom fields for the other customer-related information, such as Mother's Name, Mother's Profession, Mother's Mobile, etc., are added outside the Print_Area. On the invoice body section, Quantity and Price are moved out of the Print_Area, and two new columns, date and Fee, are added.

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

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

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

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.

...(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 Invoice with Profit Calculation

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

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

Simple Service Invoice Templatec4033

Simple Service Invoice Template

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

...(57) To create this simple service invoice template from c4032 Simple Sales Invoice Template / Simple Sales Billing Format, we move the shipping address section of out the printable invoicing form, which is identified by the "Print_Area" name in the Excel spreadsheet. In order to do this, we first unprotect the Invoice worksheet, and then do the movement.

Auto Repair Invoicing Sample (2)c5049

Auto Repair Invoicing Sample (2)

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

...(127) The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Auto Repair Invoicing Sample (2), all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the "Invoice" worksheet of Auto Repair Invoicing Sample (2). To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

Consulting Invoice Template (1st Sample of Customization)c4016

Consulting Invoice Template (1st Sample of Customization)

"Consulting (1st Sample)" 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.

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

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

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

  1. Open Simple Sales Invoicing Sample. Unprotect spreadsheet.
  2. On the Insert tab, in the Illustrations group, click Shapes.
  3. Click the shape you want, click anywhere in the workbook, and then drag to place the shape.
  4. To create a perfect square or circle (or constrain the dimensions of other shapes), press and hold Shift while you drag.

Simple Sample - Separate City State ZIPc4081

Simple Invoice Template - 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 6.

  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 Invoicing Template

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

...(110) Although the feature set of a simple blank free invoice template is limited if you compared it with a fully featured invoicing software program, the advantage of a billing template is obvious - it is easy to use, and the intuitive interface help you create beautiful and professional invoices without a hard learning curve. If you are not ready for a complete invoicing software, such as Uniform Invoice Software, and don't have enough budget spending on invoice service online, InvoicingTemplate.com offers this blank service billing template could be a great help. If you cannot find the one you like here on InvoicingTemplate.com, feel free to browse Microsoft Service invoice templates.

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