BoostExcel main content



Microsoft Office for Mac includes all the major applications available in its Windows version, including Word and Excel. While for now Invoice Manager for Excel is a Windows desktop invoicing software program based on Excel, our free blank invoicing templates and billing forms use pure-Excel features, which enables you to adapt our invoice formats on your Mac system.

You can download any template here on for free. Most of our templates are Excel ".xlsx" format packaged in a self-extracting Windows ".exe" file. If you choose to use our free Excel invoice templates on Mac, be sure to read the document "create / customize invoice template", which describes the basic design rules to follow when you want to customize our templates. Also refer to Microsoft Excel documents to get more details. Also be noted, due to the large number of users who download and use our templates, we're not able to provide timely technical support to users of our free templates. Our templates and forms are not tested on Mac, so use them at your own risk.

How to make invoice on mac using UIS

This is a frequently asked question - how to I run Invoice Manager for Excel on Mac?

The answer is NO.

Invoice Manager for Excel (or Excel Invoice Manager prior to August 2013) is a COM add-in program runs inside Microsoft Excel application process on Windows. For now it does not run on Mac.

However our templates are pure Excel workbook files that work on Mac. Visit Mac Invoice Templates for more information. Without UIS, a simple template itself does not offer much features, but it is able to format your invoice data in the right way - i.e. it does enable you to make invoice on Mac easily.

If you need a more complete system for invoicing on Mac, there are many programs or online invoicing systems you can try.

For example, you can use Apple Pages to format your document easily, as detailed on the tutorials How do I Make a Template in Apple's "Pages" or Creating an invoice with Apple's Pages. In case the ready-made templates in Pages don't meet accurately your business requirements, visit Learn how to create your own custom invoice in Apple's Pages or How to Create an Apple Pages Template to find out how to create your own template.

Here are our templates closely related to Mac Invoice Template.

Advanced Sample - Macro-Enabled Invoicing Template
Advanced Bill Sample - Macro-Enabled Billing Template

With the Simple Invoice Templates series we demonstrate how to do basic customizations on create and customizing your own bill format for your business, such as how to change fonts, move cells to create a new layout, change formulas to create a new business logic, etc. See this document to find out more information on the rules and guidelines on creating your own invoice template.

Consulting Invoice Template (1st Sample of Customization)
Advanced Sample - Email Is Required Before Saving Invoice
Advanced Format - Email Is Required Before Saving Invoice

The commands are always executed against the active workbook and active worksheet. Since different worksheets could have buttons with the same name, your VBA macro code should make sure the right workbook / worksheet is activated before issuing a command. For example, the "Invoice", "Quote" and "Purchase Order" worksheets in the default template shipped with Invoice Manager installer program all have the button named "oknCmdSave".

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.

Advanced Sample - Print One Invoice in Two Different Formats
Advanced Sample - Vary Print Results with Two Print Buttons

The default "Print" button included many templates here on print the whole "Invoice" worksheet. This in fact prints the Excel range defined by the "Print_Area" name. There are many ways you can customize the print behavior, as shown on the samples at printable invoice templates.

Clothing Store (Manufacturer) Invoice Template with Item Pickup Buttons
Clothing Store (Manufacturer) Invoice Format with Item Pickup Buttons

Without the item picking buttons, like what we implemented with cm003 Clothing Store (Manufacturer) Invoice Template with Size Breakdown, or the standard invoice template shipped with Invoice Manager for Excel, you can use the "on-sheet picker", which appears when you click and select a supported cell. However there are users that prefer the static buttons.

So with sample template, we look at how to add a button that allows you to pick customer.

Proforma invoice format that helps selling across boards
Proforma invoice form that helps selling across boards

This is a pro forma invoice template is a revisited version of c7010 Proforma Invoice Format in Excel. It has exactly the same number of fields and layout as the original one, but added an earth image with planes flying around.

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

Form with Product Category
Template with Product Category

The main purpose of creating this invoice template on is to provide a sample on using custom fields with Invoice Manager for Excel.

Medical Invoice Template (1)
Medical Billing Form (1)

This free template is the first of our serial of medical billing forms. Originally provided on at Medical Invoicing Layout, this template was designed for those hospitals and health care providers who offer medical care for infants, children and adolescents. The other medical billing templates on this serial will offer more variants and formats for you. While the term "medical invoice" is as bare bones as a name can get, medical invoices can actually be a source of confusion if not designed to provide information in a clear and organized manner. A medical invoice can be used at any health care service and assists the health care service provider to maintain health care records of patients. It is used to bill the patient and contains detailed information on the type of treatment or medical service provided to the patients at their time of hospitalization.

Basic Blank Service Billing Format (No-tax, Long Description)
Basic Blank Service Billing Layout (No-tax, Long Description)

A blank PDF invoice template is also available for Basic Blank Service Billing Format (No-tax, Long Description), which you can download free of charge from It is generated by using the "export to PDF format" feature that is built in with Microsoft Excel. If Invoice Manager for Excel is installed on your computer, this template, "Basic Blank Service Billing Format (No-tax, Long Description)" or "Basic Blank Service Billing Layout (No-tax, Long Description)", the "Extract/Email" command could also generate PDF invoice for you, or send electronic invoice in PDF (or Excel spreadsheet format, or image/PNG format) with email. This could be done by a simple clicking of mouse!

Basic Blank Service Invoice Format (Two-taxes)
Basic Blank Service Invoice Style (Two-taxes)

A basic and blank service invoice format could be served for many different types of businesses. While we've already published two layouts in this topic, "c2012 Basic Blank Service Format (No-tax)" and "c2013 Basic Blank Service Invoice Format (One-tax)", this format "Basic Blank Service Invoice Format (Two-taxes)" has two taxes set by default.

Architect Invoicing Sample
Architect Billing Template

Architect Billing Template removes the support for change order by restore the formula of the Excel cell to:

For another engineering service invoicing template here on, please refer to Free Engineering Service Invoicing Template.

Shipping Invoice Template (2)
Freight Invoice Format (2)

Since the paper is now in landscape orientation, we need to hide some rows to make the shipping invoicing layout be printable on a single page.

Basic Blank Service Invoice Format (One-tax)
Basic Blank Service Invoice Format (One-tax)

With "c2012 Basic Blank Service Format (No-tax)", we set up a simple and blank invoicing form for general needs of service businesses. It is suitable for many business types and we've already made the further customizations as less as possible. One required customization for some business owners is that the taxing type. If you prefer to use c2012 and need to charge one tax, install Invoice Manager for Excel and set the tax type on the Settings window. However if you don't have Invoice Manager for Excel installed, settings the tax type requires you to first unprotect the spreadsheet manually, and then unhide those hidden cells on the bottom of the invoicing form.

Mixed Tax Rates (5 Columns)
Mixed Tax Rates (5 Columns)

The next step is to move the new columns added for this template, i.e. "Product Type" and "Applied Tax Rate" to the printable invoicing form.

Basic Blank Service Format (No-tax)
Basic Blank Service Format (No-tax)

Basic Blank Service Format (No-tax), or Basic Blank Service Layout (No-tax), provides a simple yet professional and beautiful invoicing form for general service businesses. It contains no fields for specific service business, has two editable columns, no tax.

Engineering Invoice Template
Engineering Billing Template

On the top-left corner of the engineering invoice form, there is a logo image. The default logo image is a placeholder image which you should replace it with your own.