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.

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.

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

"A C invoice template" was found to be relative to Microsoft Access Invoice Template with the score grade of 78.

Download this free printable HVAC invoicing sample in Microsoft Excel format to bill your service of heating, ventilation and air conditioning. A free PDF form is also downloadable.

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

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

... This VAT invoicing template, VAT Sales Invoice Template - Price Including Tax, was originally publish on office-kit.com, at VAT Invoice Template - Price Including Tax, and also our company web site, Uniform Invoice Software, Excel Date Picker - Uniform Software LTD, at VAT Invoice (Price including Tax).

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

... To show/hide gridlines and row/column headers in Excel 2007, Excel 2010 and Excel 2013:

Proforma (3rd Sample of Customization)c7013

Proforma Invoicing Form

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

With the first and second samples on customizing the basic proforma invoice template, we learnt how to unprotect the Invoice worksheet and how to modify Excel color palette to change the color theme of an existing template, as well as how to enter your own company information, including replacing the default InvoicingTemplate.com logo image. This is the 3rd sample on how to create a new design for pro forma invoice template, focused on creating a drop-down list using the data validation feature of Microsoft Excel.

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

This free blank consulting invoicing and billing template in Microsoft Excel format shows 4 consultants in a background picture. The picture is also included in the consultancy PDF invoice sample too.

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

"Spin Button to Add or Subtract One" was found to be relative to Microsoft Access Invoice Template with the score grade of 60.

With this sample invoice template we demonstrates how to spin button, which is one of the Microsoft Forms Controls. The spin button allows you add one or subtract one from a number.

... This customized invoicing format is based on c4020 Invoice Template with Long Product Description, which describes how to reduce the number of lines on the detail section, so that each line can hold longer description text. Just like what you'll see from this example, our free templates are customizable. They are pure-Excel templates with no macro, and no password-protection.

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

Donation Receipt Template for Excelc1004

Donation Receipt Template for Excel

"Donation Receipt Template for Excel" was found to be relative to Microsoft Access Invoice Template with the score grade of 55.

This general donation receipt template in Microsoft Excel spreadsheet format (".xlsx") includes fields for charity / organization name, address, contact information, donor name, several lines of description, an amount field, a handwriting signature field.

... According to IRS Publication 1771, Charitable Contributions Substantiation and Disclosure, charitable donations are tax-deductible for the donor and reportable by the nonprofit organization. A donation receipt must include specific information about the value of the donation and what the donor received in return.

... Secondly, the receipt should include the donor's name, this is necessary in order to be legally valid. Although not required, we've placed the "Phone#", "Mobile#" fields on the top of the section outside the printable area. In case you want to include these information on the PDF donation receipt or printed receipt, you can easily move them into the "Donor" section.

Invoice Template with Credit Card Payment Optionc4068

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

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.

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

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

Bill Format for Catering and Wedding Servicec4092

Invoicing Template for Catering and Wedding Service

"Bill Format for Catering and Wedding Service" was found to be relative to Microsoft Access Invoice Template with the score grade of 36.

Download this free Excel catering bill format to create beautiful and professional invoices and receipts for events such as wedding or celebration. You can also send catering service bills in PDF format with one click of mouse if Uniform Invoice Software installed.

... This template is a variant of c4045 Catering Invoice Template designed by InvoicingTemplate.com. If you compare the original version and this customized one, you'll firstly noticed we've used a new color schema for this bill format, and also there is a garland decoration on the top and bottom of the billing form. Due to addition of these widgets, this template might be a good choice for wedding or celebration events. On the other hand, templates such as c4039 Restaurant Dining Invoice Template (VAT), c7005 Hotel Receipt Template are more suitable for general events / food catering. The background image will also show on the PDF catering and wedding service invoice.

Service Invoice Form with Discount Amountc5011

Service Invoice Form with Discount Amount

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

This template includes a Discount field in the bottom of the form, allowing you to specify the discount in amount. The service invoice template includes no shipping field.

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

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

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.

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

This receipt template could be used for rental / lease security deposit. It contains fields for both landlord and tenant, and also 8 lines description of property and deposit.

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

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

... When running a business you may prefer to know the cost and profit, whether you are selling goods or providing services. The default sales invoice template included in the Uniform Invoice Software installer program does not support this by default (at least at the time when we are preparing this invoice template), which brings many inconvenience for example such as when you are doing marketing plans. This is true even when you are providing service, such as plumbing. The good news is that, adding the support for profit calculation is easy.

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

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

...Simple Service Invoice Template is customized based on Simple Sales Invoice Template / Simple Sales Billing Format. Another invoicing format with similar layout and style is also available here on InvoicingTemplate.com, at Simple Consulting Invoice Template / Simple Consulting Billing Format.

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

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

... There are other sample formats online too, such as Word, HTML or PDF, but Excel is our favorite here at InvoicingTemplate.com. The auto invoicing example given here demonstrating just one advantage of using Microsoft Excel based form designs. By using a drop-down list box instead of a manually editable text field, you can draft an invoice much easy than before.

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

  1. Click and activate the worksheet you want to display gridlines and row/column headers for.
  2. On the Tools menu, click Options, and then click the View tab.
  3. Under Window options, check the Gridlines and Row & Column Headers check boxes.

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.

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

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

Sales Invoicing Format for Germanyc4098

Sales Invoicing Example for Germany

"Sales Invoicing Example for Germany" was found to be relative to Microsoft Access Invoice Template with the score grade of 8.

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

... Foreign companies, or 鈥榥on-resident' traders, providing goods or services in Germany to local businesses or consumers may have to register their business for German VAT. They will then have to follow the German VAT compliance rules, including invoicing and VAT rates, as well as pay over any German VAT due. See "hould you register for German VAT" for more details.

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

... This template has 4 columns on the invoice detail section - Description, Quantity, Unit Price and Amount. Basically this invoicing templates offers the same number of fields / cells on the invoice form as the default template shipped with Uniform Invoice Software. However this template has very different look and feel. This is archived by moving the fields, setting fonts and colors - all tools are provided by Microsoft Excel. Simple Sales Invoicing Template, or Simple Sales Invoicing Form, helps you create professional invoices for your business by simply filling in a blank form. You can also use this simple sales invoicing template as a basic and starting point, customize the layout, look and feel of your invoices to add professionalism to your business. Don't waste time creating manual invoices for goods and services when you can easily use a pre-designed template.

Simple Sample - Separate City State ZIPc4081

Simple Sample - 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 2.

The default invoice template stores "City, State and ZIP" in two separate fields. This customization sample of our simple invoice templates demonstrate how to store it in 3 separate fields using custom fields.

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

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

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
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
c1004
Donation Receipt Template for Excel
Monday, August 22, 2016,
8
1
A4
Portrait
Receipt
c4068
Invoice Template with Credit Card Payment Option
Thursday, March 3, 2016,
12
4
A4
Portrait
Sales
c4092
Bill Format for Catering and Wedding Service
Wednesday, October 26, 2016,
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
c4098
Sales Invoicing Format for Germany
Sunday, November 20, 2016,
12
4
A4
Portrait
Sales
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

What Is Hot

Feature Galleries