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 Billing Form (2)

If you are interesting in how we at design this Medical Bill Sample based on the original Template (1), here are the main procedures - Unprotect the Invoice worksheet, switch to design mode, display gridlines and row/column headings, set paper orientation using the Page Setup dialog box, resize columns - this is sample medical invoicing format, our main purpose is to enlarge the Description column, hide some rows.

Medical Invoice Template (1)

Medical Billing Form (1)

If you use the Invoice Manager for Excel (namely Uniform Invoice Software) edition of this template, note that an invoice is marked as "paid" if the "Balance Due" cell is zero. By default, a paid invoice is not editable. Contact us for a hidden option if you need to be able to edit paid invoice. This design also implements a new feature, that if you fill in the "card holder name", the invoice will be paid. For this reason, if you run the Statement report, the "payment total" calculation will not work. We recommend you to remove this part from your statement report. This is because the template allows you to enter payment information on the invoice form; there are no separate payment records.

Advanced Sample - Invoiced Total in English Words

Advanced Bill Sample - Invoiced Total in English Words

As of the current implementation, Invoice Manager for Excel (namely Uniform Invoice Software) does not contain a built in function for converting a numeric value into equal English words. Fortunately, Invoice Manager for Excel (namely Uniform Invoice Software) is built upon Excel. Like other Office programs, Microsoft Excel supports VBA (Visual Basic for Application) macros, which you can use to extend the functionalities of Excel itself, including creation of user-defined formulas (functions).

First, to convert an ".xlsx" invoice template into ".xlsm" format, follow steps below.

Simple Invoice Format for Florida

Simple Invoice Form for Florida

This simple invoice template for Florida is designed for businesses who want to try something new. The title word "INVOICE" is applied with lightweight word art to show a cambered effect. It also has an orange blossom background that is known as the state flower of Florida.

Five Price Levels (Sales, Amount, Custom Column)

Form with 5 Price Levels

The color column is a custom field defined both in the Product and Invoice Body database tables, which is the most noticeable difference between this customized invoice template and the original 5 Price Levels (Sales, Amount) invoice template. This means that for each product, you can set its color property, and the color values are filled automatically when you choose products from the database. Like all the other invoice templates in this serials available here on, the full power of the invoice template comes only with the installation of Invoice Manager for Excel (namely Uniform Invoice Software), although the free version of this "Form with 5 Price Levels (Sales, Amount, Custom Column)" invoice template can also help you create professional and beautiful invoices.

Makeup Artist Invoice Template

Makeup Artist Billing Form

Secondly, this template uses a warm color style that differs from most templates here on Invoices and bills are business documents so they must be valid and accurate on the first place. But this template tried something different, and the effect is interesting.

Irish Sales VAT Invoice Template

Irish Sales VAT Invoice Template

As Irish Revenue states: Persons who issue invoices and credit notes, and persons to whom these documents are issued, should ensure that the documents accurately represent the transactions to which they refer. Failure to do so may have serious consequences for all parties concerned...... An accountable person who supplies taxable goods or services (other than construction services supplied under a relevant contract) is obliged to issue a VAT invoice. Value-Added Tax is a tax on consumer spending. It is collected by VAT-registered traders on their supplies of goods and services effected within the State, for consideration, to their customers. Generally, each such trader in the chain of supply from manufacturer through to retailer charges VAT on his or her sales and is entitled to deduct from this amount the VAT paid on his or her purchases. The effect of offsetting VAT on purchases against VAT on sales is to impose the tax on the added value at each stage of production – hence Value-Added Tax. For the final consumer, not being VAT-registered, VAT simply forms part of the purchase price.

With this sample template, the "Discount" custom field is added to the "Invoice Body" database table.

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 Invoice Manager for Excel (namely 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 Forwarding Outstanding Balance

This is a service invoice version of Invoice with Previous Balance (Sales). It differs from the original version by moving all shipping-related fields out of the printable invoice.

Past Due Invoice Template

Past Due Invoice Template

When an invoice is past due, you send a past due letter for collection. If the client has new purchases you can also include the overdue amount / previous balance in the new invoice to show the total amount due. This blank overdue invoice template is printable with A4 paper.

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

Unlocking the line total fields is necessary in order to make the fields editable when the Invoice worksheet of the spreadsheet is protected.

Bill Format for Quilting Service

Bill Format for Quilting Service

The first two custom fields are "Batting Backing Allowance" and "Tag Color", which are all defined as text fields. Most other custom fields above the invoice detail section are defined as decimal values. The values in this section are formatted with two colors - the green values are in Inch, and red values are in Feet. Only the values in the "Quit Size" section are editable (quit width and height), all the other values - Quilt Area, Binding, Batting and Backing, are all calculated automatically using Excel.