Skip to main content main content
sharing is caring! we do appreciate your time to let others know us!

Medical Billing Format

Medical Receipt Sample

On the top of the spreadsheet, you'll first notice there is a logo image showing "InvoicingTemplate", which is a place holder of your own logo image. Next to the logo image is your hospital, clinic or home health care business name, slogan, street address, city state and ZIP, phone number, web address and etc. This should all be placed with your own information. On the top-right corner, you'll find the letters "MIDCICAL INVOICE" that are all in upper case, which indicates the type of this business document and usually you don't need to modify it.

Medical Invoice Template (2)

Medical Invoice Template (2)

The original design of the medical invoice layout puts 7 columns on a standard A4 paper with Portrait paper orientation. While the original design works well for many situations, someone may find it provides less space for the Description column. Providing a clear and detailed description for each billed charge is important for a professional hospital bill because it helps patients to understand the bill clearly. For example, a larger Description will allow you to use everyday language to explain the procedure under the "Description" column.

Medical Invoice Template (1)

Medical Billing Form (1)

Although this free template, like all the other templates here on, was created based on the sales invoice template shipped with Uniform Invoice Software - this is necessary to make sure it works with Uniform Invoice Software, being a medical bill means the form contains lots of new fields were added that could not be found on the default template shipped with Uniform Invoice Software, including: Date of service (date field), additional payment fields that are line itemed next to description - Total Fee (editable within invoice), CoPay (editable within invoice), Insurance Reim (editable within invoice), Ins Contract Adjust (editable within invoice), Patient Responsibility (calculated automatically with the this formula: Total fee - CoPay - Insurance Reim - Ins Contract Adjust). Since the medical invoice format is designed for those who offer medical care for infants, children and adolescents, the "Bill To" and "Ship To" fields found on a general invoicing form are utilized a little differently. The "Bill To" would represent the head of household account member (i.e. Dad), while "Ship to" would be the actual patient information - This allows you to easily deal with families with multiple children.

Advanced Invoicing Sample - Invoiced Total in English Words

Advanced Bill Sample - Invoiced Total in English Words

Now the steps to create the "SpellNumber" VBA macro function for the ".xlsm" Excel workbook file. The macro code was copied from Microsoft at How to convert a numeric value into English words in Excel, where you can also find step by step instructions on how the create the spreadsheet file. You can also find a similar implementation at Two best ways to convert numbers to words in Excel, and at Converting Numbers Into Words.

Five Price Levels (Sales, Amount, Custom Column)

Form with 5 Price Levels

This sample of customizing invoice templates is named with the keyword "cosmetic". A new column "Color" was added to meet the requirements of the cosmetic business.

Simple Service Bill with Pleased Customer Image

Simple Service Invoicing Sample with Pleased Customer Image

With new format design, we firstly removed all the icon buttons that are used to quickly locate / pick up specific customer, product, payment term, sales rep. name etc. This is because starting with UIS version 4, our Excel-based billing program provides an easy and handy "on-sheet picker" feature, which shows dynamically a litter button when a supported cell / field is clicked.

Invoicing Format for Bakery and Cake Shop

Invoicing Template for Bakery and Cake Shop

The date and numeric fields (quantity, currency) are formatted with US styles. To change this, when in design mode right-click a cell and then choose "Format Cells", and then from the "Number" tab choose the format you like.

Irish Sales VAT Invoice Template

Irish Sales VAT Billing Form

This VAT invoice template has a similar layout as c6008 VAT Sales Invoice Template - Price Excluding Tax - you can also find a service invoice template here on, at c6014 VAT Service Invoice Template - Price Excluding Tax. The format has customized as per the requirements detailed on Irish Revenue. If you've never produced an invoice before you might be wondering how to go about this and what needs to be on the invoice in order for it to be accepted by your customer and their accounts department. If you're registered for VAT and are therefore charging VAT on your invoices it is especially important that your invoices are properly drawn up and that you keep copies so that you don't incur any penalties from Irish Revenue.

Bill Format with Change Calculation

Invoice Template with Change Calculation

The second cell is titled with "Paid". If you click the cell that allows you to enter the payment amount, you'll notice the cell is named "oknPaymentBeforeChange", which differs from default "oknPayments" cell in the default template shipped with Uniform Invoice Software. This is the only manually editable one in this section, identified with a special background color.

Invoice with Previous Balance (Service)

Invoice with Previous Balance (Service)

Please also refer to the original version to find out implementation details about this invoice template, including how Uniform Invoice Software maps database fields to Excel cells, and how to unlock a cell to make sure Uniform Invoice Software can read/write a cell even when the spreadsheet is protected.

Past Due Invoice Template

Payment Due Invoice Form

This past due invoice template is a revisited version of c5007 Invoice with Previous Balance (Sales), which is a sales invoice template that includes the "Shipping Address" on the printable form. A service invoice version of c5007 is also available here on, at c5027 Invoice with Previous Balance (Service). On our original web site it is C5-007 and named "Invoice Template with Previous Balance". The following description from could help you get a better understanding of this template.

Simple Lightweight Service Invoice

Simple Lightweight Service Billing Format

To make it suitable for your company letterhead paper, the invoicing template includes an empty line on the top of form. Click the "Design Mode" button on the "Invoice" ribbon tab, adjust the height of row $3 (marked with the text "Adjust the height of this row to make it suitable for your company letterhead paper"), click the "Print" button to test the print result. You may have to print several times to make it perfect for your paper design. To see another sample here on printing with letterhead papers, see Simple Invoice Sample - Printing on Letterhead Paper. To see more simple and lightweight invoice designs, visit simple invoice templates here on

Plumbing Service Invoice Template (Landscape)

Plumbing Service Invoice Template (Landscape)

Like most free Excel templates available here on, this plumbing service bill sample (Landscape) has a logo image on the top-left corner. You should replace it with your own image before you can use the template for your own business.

Sample Sales Invoice Template 2

Sample Sales Invoice Form 2

To remove the formulas from the line total cells, first drag your mouse to select all the cells, and then hit DEL key on your keyboard.

Bill Format for Quilting Service

Bill Format for Quilting Service

This sample template designed for quilting service providers has added a number of custom fields added to the form suggested by one of our clients who provides long arm quilting service.