Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your time to let others know us!

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.

Online Invoicing Sample

c5121
Sample Invoice Template for Online Invoicing

The "Net" edition of Uniform Invoice Software supports sharing data via local area network, but it is not able to connect to online data sources (i.e. data that accessible via Internet).

Limousine Service Invoice

c4104
Limousine Service Bill

If you are providing limo services you know it is ideal to detail service details on invoice / bill and receipt. While a general service invoice template could help you create invoices, a professionally designed template specific to your limo service shows that you care for your business, and it even helps collect payment more easily and quickly as the bill itself shows what service you have offered, how the account receivable is calculated, and when the service is rendered. More samples on this topic could be found at Business Invoice Template.

Bike Shop Invoice Template

c4069
Bike Shop Invoice Template

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 Service

c4089
A C invoice template

This HVAC form design is suitable for creating invoices and bills, service or work orders, or you can also use it as a proposal form. Our Excel invoicing templates are original, editable and have no password set for protection. You can easily unprotect any template by clicking "Unprotect Sheet" command on Microsoft Excel "Review" ribbon tab, or switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.

Engineering Estimate Template

cm006
Engineering Estimate Template

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.

VAT Sales Invoice Template - Price Including Tax

c6007
VAT Sales Invoicing Template - Price Including Tax

Like many other invoicing templates here on Invoicing Templates, VAT Sales Invoicing Template - Price Including Tax has a default logo image on the top of the invoice form. To replace it with your default logo image, you need to first unprotect the invoice worksheet, and then put the spreadsheet into design mode.

Proforma (3rd Sample of Customization)

c7013
Proforma Invoicing Form
  • 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 Picture

c4091
Consulting Invoicing Sample with Consultants Background Picture

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.

Child Care Billing Template

c4007
Child Care Invoicing Form

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 Amount

c5011
Service Invoice Template - Discount Amount

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 Template

c5081
2-Page Invoicing Format

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 Template

c1003
Security Deposit Receipt Format

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.

Sales Invoice with Profit Calculation

c5060
Sales Invoicing Template with Profit Calculation

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.

Simple Service Invoice Template

c4033
Simple Service Invoice Template

Note that the "InvoicingTemplates" logo on the top of the invoice form is a placeholder, which you should replace with your own logo image. In order to do that, the invoice spreadsheet has to be switched to design mode.

Auto Repair Invoicing Sample (2)

c5049
Blank Vehicle Repair Invoice (2)

If you are interesting in the Uniform Invoice Software (UIS) version of our templates, don't worry - adding the drop-down list to the Excel spreadsheet will not break UIS. UIS welcomes any customizations and designs you could make with Microsoft Excel, as long as you adhere to the guidance described in the "Creating and Customizing Invoice Template" document included in UIS. This customized format, like all the other templates available here on InvoicingTemplate.com, are just examples of how to customize the default sales invoicing sample shipped with UIS - a generic format that is suitable for many business types. So to speak, InvoicingTemplate.com offers not only general invoice online, but also special formats that are suitable for different business types. Invoices are the important part in business and trading, so make sure your forms meet your business requirements.

Consulting Invoice Template (1st Sample of Customization)

c4016
Consulting Invoice Template (1st Sample of Customization)

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 Sample

c4032
Simple Sales Invoicing Format

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.

Simple Sample - Separate City State ZIP

c4081
Simple Invoice Template - Separate City State 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.

Service Invoicing Template

cn003
Service Invoicing Template

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.

Invoice Template with Hours and Rate

c4031
Billing Format with Hours and Rate

The basic Hourly Service Billing Sample, which is created from the default template included in Uniform Invoice Software, uses the same color schema as the original template. The original template works just fine, as both a free template, or when used with Uniform Invoice Software as the front-end of a complete billing and invoicing system, some one might say that the original design is not attractive enough and is just a general design. Fortunately, Microsoft Excel offers comprehensive tools that you could use to customize the layout of the template.