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.

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

Invoicing Format for HVAC Service

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

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

...(86) This is a service invoice template, featuring a "Bill To" section and a "Service Location" section that allow you to enter different billing address and the location to perform the HVAC service. In the detail section, there are two parts, just like the parts and labor invoice form. The parts and labor could have different tax rates. On the bottom of the form, the "TOTAL AMOUNT PAYABLE" field calculates the grand total from both the parts and labor sections using a simple Excel formula like this:

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

...(87) As the name implies, the price on this template including tax, so that the total, which is calculated by "Price * Quantity", includes the VAT amount. The VAT amount column inside the printable invoicing form is calculated with the formula "Total (VAT) - Total (Net), where the "Total (Net)" is calculated with a formula like "Total including VAT / (1 + VAT Rate)" if the item that is being invoiced is taxable; or the "Total (Net)" equals to "Total (VAT)" if the current item is not taxable.

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.

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

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

Consulting Invoicing Sample with Consultants Background Picturec4091

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

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

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

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

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

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

Donation Receipt Template for Excelc1004

Donation Receipt Template for Excel

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

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

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

...(15) The receipt must also declare whether the donor received goods in return for the donation.

Invoice Template with Credit Card Payment Optionc4068

Billing Format with Credit Card Payment Option

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

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

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.

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

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

...(29) The itemized section allows the caterer to list each invoiced item in detail, such as "Equipment and set鈥恥p/Pick鈥恥p Fee", "includes, plates, utensils, cups", "beverage dispensers and serving utensils" etc.

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.

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

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

2-Page Invoice Templatec5081

2-Page Invoice Template

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

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

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

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

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

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

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

...(70) Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

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

Auto Repair Invoicing Sample (2)c5049

Blank Vehicle Repair Invoice (2)

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

...(194) Creating the drop-down list is in fact easy and quick in Excel. First, you must have the list of valid entries prepared. To create a list of valid entries for the drop-down list for Auto Repair Invoicing Sample (2), type the entries in a single column or row without blank cells. Now select the cell where you want the drop-down list added for Auto Repair Invoicing Sample (2). On the Data tab, in the Data Tools group, click Data Validation. In the Data Validation dialog box, click the Settings tab. 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; 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. Close the dialog box to have Excel creates the drop-down list for Auto Repair Invoicing Sample (2).

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.

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

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

Sales Invoicing Format for Germanyc4098

Sales Invoicing Example for Germany

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

...(146) Here on InvoicingTemplate.com we've already have a category of templates for VAT invoicing at VAT Invoice Templates, which lists the Excel forms that could be used to invoicing German-based clients, this template differs from the others in that all the text labels are translated into German. As detailed at 2016 European Union VAT rates, the standard Germany VAT rates is 19% for most goods and services, although a reduced rate could be applied for some foodstuffs; water supplies; medical equipment for disabled persons; some public transport; books; newspapers and periodicals; admission to cultural events; writers and composers; agricultural supplies; hotel accommodation; admission to sports events; social services; medical and dental care. This sample template set the default rate to 19%, and assuming all items on the form are taxable. In case you need to change the tax rate with Uniform Invoice Software, follow the steps below.

...(21) This template shows no currency symbols. If you want to show the EURO symbols with certain cells, follow the steps below.

...(16) For a service bill format edition of this template, visit c4099 Service Billing Template for Germany.

Gemäß § 19 UStG enthält der ausgewiesene Betrag keine Umsatzsteuer.

Simple Sales Invoicing Samplec4032

Simple Sales Invoicing Format

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

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

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

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

  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.

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