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.

Bike Shop Invoice Templatec4069

Invoicing Layout for Bike Shop

"Bike Shop Invoice Template" was found to be relative to Microsoft Access Invoice Template with the score grade of 95.

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

...(86) The "Invoice" ribbon is created by Uniform Invoice Software (UIS) - i.e. you have to install UIS in order to have Excel show the ribbon tab. This ribbon tab provides global commands, that are available to all the worksheets in the Excel spreadsheet template, such as "Customers", "Products", "Invoices", "Reports", "Settings" and "Help"; there are also shortcut to commands that affect the working mode the invoicing form, such as "Hide Task Pane", "Disable On-sheet Picker", "Design Mode", "Replace Logo Image", "Add / Update PayPal Button", etc.

Engineering Estimate Templatecm006

Engineering Estimate Form

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

...(29) The "Ship To" section now has a new title, "SITE ADDRESS", so in this section it is possible to fill in the location where the service to be performed.

...(37) For example, the unit price of your product or service might be determined by many factors that should also be listed on the invoice form, such as customer category (VIP, wholesale, or general customer), measurement unit, etc.

...(38) To implement the features required by the estimate or service invoice template, there are a number of custom fields defined / added to both the underlying database and the front-end Excel template, as detailed in the following table.

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

...(49) A counter partner of this free VAT invoice template is also available here on InvoicingTemplate.com, at VAT Sales Invoice Template - Price Excluding Tax, which defines the price in the way that does not include VAT. Choose any template that suits your business requirements and download it for free.

...(67) The protection of the "Invoice" worksheet in VAT Sales Invoice Template - Price Including Tax prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in VAT Sales Invoice Template - Price Including Tax.

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

  • First choose a column (or row) to place the possible values. This should be an empty (not-used) area outside the printable form. In this example, we choose the range on the right side of the shipping details section. The possible currency types are: US Dollar, Euro, Pound Sterling, Japanese Yen - you could enter more on the column, just make sure there is no blank (empty) cells between valid possible values.
  • Select the cell where you want the drop-down list - in this example, you select the currency field (the cell after the label "currency"). If you are running Excel 2007, Excel 2010 or Excel 2013, on the Data tab, in the Data Tools group, click Data Validation. If you are running Excel 2003, choose Excel menu Tools > Validation.
  • In the Allow box, click List.
  • To specify the location of the list of valid entries, do one of the following:
    • If the list is in the current worksheet, enter a reference to your list in the Source box or click in the Source box and then select your list in the current spreadsheet to populate the reference automatically.
    • If the list is on a different worksheet, enter the name that you defined for your list in the Source box.
  • Make sure that the In-cell dropdown check box is selected.
  • To specify whether the cell can be left blank, select or clear the Ignore blank check box.
  • Optionally, display an input message when the cell is clicked.
  • Specify how you want Excel to respond when invalid data is entered.

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

...(105) This blank consultancy bill format is created based on c4016 Consulting Invoice Template (1st Sample of Customization) in the consulting invoice template category here on InvoicingTemplate.com. The picture / image added as the background is firstly set to 35% opacity, and then have a gradient opacity effect applied using Adobe Photo Shop. The combination of these adjustments to the image makes sure the background is as clear as possible, and meanwhile it does not affect the readability of the foreground text such as the "Invoice#" and "Invoice Date" fields, and the fields in the "Bill To" section. See our bill sample images for more information.

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

...(113) The spin button is used to add one or subtract one from a number. It is suitable for adjustment integral numbers in a small range. If your products are always sold in a whole part and thus don't use the decimal part in the "Quantity" field, a spin button could be applied. For example, in the invoice templates based on hours and rates, where the decimal part could appear on the number of hours, a spin button is not suitable. On the other hand, in a hotel receipt template where the number of guests is always an integral number that changes in a small range, a spin number is suitable for the situation.

Invoice Template with Credit Card Payment Optionc4068

Invoice Template with Credit Card Payment Option

"Invoice Template with Credit Card Payment Option" was found to be relative to Microsoft Access Invoice Template with the score grade of 45.

...(45) This simple billing format in Excel format demonstrates how to add credit card payment options to an existing template, could be used as a payment remittance advice slip (also visit Invoice Template with Remittance Slip). There is also a cardholder signature spot for payment authorization.

...(19) The invoice template implements options for "VISA" and "MASTERCARD", you can add other credit cards in a similar way.

...(157) Note that by default Uniform Invoice Software supports a payment system that allows partial payments. When you click "Save Invoice" command, a new invoice number is generated (the auto numbering features works when the invoice# cell is left blank), and a "New Payment" window appears where you can enter information like payment date, total payment amount, payment type, reference document# and a general purpose "Notes" field. The total payment amount could less than, equals to or greater than the balance due of current invoices. If it is overpaid, the overpaid amount becomes credit under the customer client's account, which you can apply to existing or new invoices in the further; if the paid amount is less than the balance of current invoice, the invoice is keep its status "pending", which is added to the customer's account payable. One of the advantages of this approach is that the payment report is able to show you detailed payment information.

Child Care Billing Templatec4007

Child Care Billing Template

"Child Care Billing Template" 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.

Service Invoice Form with Discount Amountc5011

Service Invoice Template - Discount Amount

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

...(116) If you have Uniform Invoice Software installed, you may notice that the Discount field is added to both the Customer and Invoice Header database table. This means that, the discount can be saved into a client's account, and when you are making a billing invoice, The discount value is loaded / filled automatically along with the other customer information, such as customer name, address, city state and zip, country and email addresses etc. The form then uses formulas to calculate subtotal, taxes, total, total due. If you use the freeware version of this Service Invoice Form with Discount Amount template, won't benefit from connecting with a database because that should be done by Uniform Invoice Software.

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.

...(25) The default template has 12 lines on one page. This sample template shows you a customized invoice layout that has 36 lines on two pages.

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

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

...(109) Although there is only one column in the detail section, Uniform Invoice Software works with this types of templates well. The secret is an option on the "Template" tab of the "Settings" window - "Allow incomplete lines on invoice body". By default, our Excel-based invoicing program applies a group of strict rules to make sure the data integrally of the invoice or receipt that is to be created - for example, each line should at least contain the "Item#" and "Line total" values. By enabling the "Allow incomplete lines on invoice body" option, this rule is disabled, allowing the program to save any data appear on the detail section.

...(67) This deposit receipt template is created based on c1002 House Rent Receipt Template published here on InvoicingTemplate.com. The main adjustment is that, as our users said, there are usually not too much to say on the receipt - so it seems not necessary as the original receipt design puts 16 lines on the detail section. In this new format, we reduce the number of lines to 8.

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.

...(135) You can download the finished billing template, Sales Invoice with Profit Calculation, from the download page, or download the PDF version by clicking the corresponding link at the right-hand of this page. The service version of this template, Service Invoice with Profit Calculation, which does not include the shipping address section, is also provided. We've also created a variant for each of these templates, Sales Invoice with Profit and Taxable Column, which is a sales invoice template includes the profit calculation, and also adds the "Taxable" column to the printable invoice form; and Service Invoice with Profit and Taxable Column, which is the service edition that includes both profit calculation (outside the printable invoicing form), and the taxable column (inside the printable area). All these designs and forms are providing you for free by InvoicingTemplate.com.

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.

...(23) Please download this template for free from the download page. A fillable PDF simple service invoice template is also available here on InvoicingTemplate.com.

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

...(26) Please refer to Uniform Invoice Software documents, which is installed on your local computer once you install the program, for more information on customizing our templates.

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

...(120) So how do we at InvoicingTemplate.com design this customized auto repair billing form based on the previous layout? It is in fact easy if you know Excel a little. Our procedures are as follows: unprotect the Invoice worksheet in the Excel spreadsheet and switch to design mode; select the area where you want to put your car / vehicle model list - in this sample, we choose to place the model list to the right side the printable area, starting from Q16, so that you can easily add new entries to it whenever needed. Once the car models are setup, you can then easily go to the Data ribbon tab, execute the Data Validation command to create the drop-down list.

Consulting Invoice Template (1st Sample of Customization)c4016

Consulting (1st Sample)

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

...(60) By moving the "Machine#" field out of the printable invoice form, the original Consulting Invoicing Template becomes more universal and thus be suitable for more types of constants. The sample consulting invoice template created in this tutorial, like all the other templates here on InvoicingTemplate.com, has a free edition and an edition that should be used with Uniform Invoice Software.

...(42) While designing the layout of an invoice form we mention the word "move a field" or "move a cell" frequently. This is a process to change the location of a field or cell without breaking the predefined relationship between fields and cells.

Simple Sales Invoicing Samplec4032

Simple Sales Invoicing Sample

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

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

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.

...(55) To make the text shown on the printed invoice matches exactly the specification - that is, the "City" name followed by a comma, the "State" name followed by a space, we'll put the editable "city", "state" and "zip" fields outside the printable invoicing form, and use an Excel formula to concatenate what the user entered.

Service Invoicing Templatecn003

Service Invoicing Template

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

...(46) The Service Invoicing Template is the most popular template in its category "Service Invoice Template" here on InvoicingTemplate.com. During the past several years we've built a number of variants based on this service invoicing form but this template is the most downloaded one in its category.

...(36) The service billing form is suitable for service providers, like freelancers, contractors and consultants, solicitors, advisers and many other small businesses. InvoicingTemplate.com offers this template for free, which will give your order invoices a professional look.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
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
c4086
Invoicing Template with Logo
Saturday, August 20, 2016,
6
4
A4
Portrait
Sales
c4068
Invoice Template with Credit Card Payment Option
Thursday, March 3, 2016,
12
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,
12
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