Skip to main content
ExcelInvoiceSoftware.com main content

Invoice Software for Excel

We offer custom builds for Uniform Invoice Software. If you need the standard version of Uniform Invoice Software, click the button below.

Download Now

  Share This Page

about Excel Invoice Software

Uniform Invoice Software is able to connect various Excel invoice templates with backend database. This flexibility of supporting various invoice formats sometimes causes the questions such as "How do I setup a custom invoice design as the default invoice template?" Here at ExcelInvoiceSoftware.com we offer custom builds that each contains a custom invoice template as the default invoice template that works with Uniform Invoice Software.

Uniform Invoice Software, formerly named Excel Invoice Manager, combines the power of Excel with the backend database system, making it a unique invoicing program that is easy to use, powerful and flexible.

Flexible

By using Microsoft Excel as its frontend, you can not only design the invoice layout by customizing the fonts, colors, borders and images, but also control how the fields are calculated with Excel formulas. Use our existing invoice templates, or design your own with Excel!

Affordable

The life-time license of the standard edition costs just $59.00, with full feature set available such as management of customers, products, invoices and payments. The subscription plan starting from only $1.99 / month - not even enough for a cup of coffee.

Expandable

Uniform Invoice Software uses Microsoft Excel, but it is not an Excel macro-based program. It is an add-in program that connect Excel invoice templates with database. Using database gives your invoicing system the ability to manage large amount of data.

What Is New

1/2 Page Invoice Template for Excel Invoice Software

Many times you have only 1 or 2 items to bill your clients. In these situations a whole page of paper seems a waste. Here is how we implement a 1/2 page invoice template (half page invoice template).

This simple template sample will be created from c4051 Simple Invoice Template - Discount Amount Field. Like the other tutorials and samples in this simple invoice template serial here on InvoicingTemplate.com, we'll mainly focus on how to do the customization. You can also refer to Customizing Invoice Template for more information on the important techniques involved in the customization of our Excel billing forms. For a quick tutorial movie on creating invoice, visit the tutorial on creating an invoice.

Note that our goal is to not only create an invoice template that is printable on half paper size, but also make sure it work with Uniform Invoice Software, which is our invoicing software system for Windows desktop PCs running Windows XP, Windows Vista, Windows 7, Windows 8 and Windows 10 (Microsoft Office or Excel 2003, Excel 2007, Excel 2010, Excel 2013 or Excel 2016 is also required). Uniform Invoicing Software is an offline desktop invoicing app that does not require an Internet connection to run. By installing Uniform Invoice Software, a simple and pure Excel spreadsheet invoicing template becomes a complete invoicing management system. Uniform Invoice Software is implemented as an Excel COM add-in program, which means we don't use Excel macros to implement those advance features like connection with Access database. So, you don't have to change the security settings of your Office / Excel program in order to run Uniform Invoice Software, and all our templates here on InvoicingTemplate.com are not protected with passwords, which enable you to modify and customize the template to make sure it meets your business requirements exactly. Simply put, with Uniform Invoice Software, no matter you are a sole trader, home business, small business, limited company (ltd), you can generate professional and beautiful invoices and receipts without having to deal with complex accounting and billing systems that are usually expensive and hard to use.

Now let's see how we can customize an existing invoice template, in this case c4051 Simple Invoice Template - Discount Amount Field, so that it can be printed on a half of the set paper size. You may like to see other simple invoice template tutorials that deals with printing of invoices too, such as c4052 Simple Invoice Template - Changing Paper Size and c4053 Simple Invoice Template - Changing Print Orientation. It is also possible on a single page to print two duplicate copies of an invoice, so that for example you can send one copy to the client, and send the another copy to your accountant department for bookkeeping. Also refer to printable Print Shop Invoice Template, where you can find a printable invoice template designed for print shop.

Now let's see the steps involved to create this 1/2 page invoice template.

  1. As always, you need to back up the Excel spreadsheet invoice template (and maybe the database file).
  2. Open the invoice template as usual.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab. This command unprotect the "Invoice" worksheet, show gridlines and row / column headings. If you don't have Uniform Invoice Software installed, do these manually. However it is highly recommended to download and install Uniform Invoice Software. The trial version that works with the trial period (30 days) is fully functional within the trial period. After the trial period, if you want to keep the program, simply buy a license key and unlock it.
  4. Go to Excel ribbon "Page Layout" tab and choose "Size" from the "Page Setup" group. Note the paper size of the current template - in this sample, it is "Letter 8 1/2 inch X 11 inch". A half of it would be "8.5 X 5.5" inch.
  5. Click "Margins" and then "Custom Margins" in the "Page Setup" ribbon command group. This opens Excel "Page Setup" dialog box with the "Margins" tab activated.
  6. From the "Center on page" group, uncheck the "Horizontally" and "Vertically" options. Click OK to close the "Page Setup" dialog box.
  7. Go to Microsoft Excel "View" ribbon tab. Push down the "Page Layout" option on the "Workbook Views" group. This switch the worksheet into page layout view, and the rulers show on the top and left of the worksheet window.
  8. Note that at this time the invoicing form occupy the entire printable area of the paper (which is 8 1/2 inch on width and 11 inch on height). To make sure the billing form could be printed on a half of the paper, we need to make sure the printable invoice form occupy only 5.5 inch (a half of the total height 11 inch).
  9. To do this, we first hide 8 lines on the bottom of the invoice detail section, so that only 4 lines are left. To hide a row, right-click on the row heading and then choose "Hide" from the shortcut menu.
  10. We also adjust the line heights to make sure each line occupies less space on the vertical direction. In the original design, the row height of most lines is 0.25. In this sample, we change this to 0.20. To adjust the height of a row, right-click the heading of a row and choose "Row Height" from the shortcut menu.
  11. In this sample, we also moved several rarely used cells out of the printable form, such as "Country" in the "Bill To" and "Ship To" section. For detailed instructions on how to move cells / fields, visit c5075 Simple Sample - Moving Balance and Payment Cells.
  12. If you are following this tutorial, make sure the last row on the printable area (in this sample, row 40) does not exceed a half of paper (5.5 inch). If it does exceed, hide more rows, and make the visible lines smaller on heights.
  13. If necessary, go to Excel File / Print Preview to check the printing result. Make further modifications and customizations as needed.
  14. Switch back to "Normal" view by pushing down the "Normal" button in the "Workbook Views" group on Excel "View" ribbon tab.
  15. Once done, exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  16. Save the template by clicking the "Save" button on Excel quick access toolbar.

All our templates are offered to you by InvoicingTemplate.com online in Microsoft Excel spreadsheet format, including this 1/2 Page Invoice Template. Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and as a part of Microsoft Office - the other famous Office programs includes Word, PowerPoint and Access. It has been the industry standard for spreadsheets, and thus being an ideal maker and format for creating electronic (paperless) fillable, editable and printable sales orders, purchase orders, estimates, invoices, quotes, letters, brochures, receipts, time sheets, statements and other business forms. Our templates, including 1/2 Page Invoice Template, are also available in blank downloadable PDF format. We are also providing Uniform Invoice Software, which utilizes these templates and offer powerful processing and management features.

 Download Now     Learn More

1/2 Page Bill Format for Excel Invoice Software

1/2 Page Bill Format for Excel Invoice Software

2-Page Invoicing Format for Excel Invoice Software

2-Page Invoicing Format for Excel Invoice Software

What Is Special

2-Page Invoice Template for Excel Invoice Software

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.

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.

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

$group

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.

To see the print result of this template, visit the PDF version.

 Download Now     Learn More

   

Excel Invoice Software - Products of the Week

ExcelInvoiceSoftware.com offers custom builds that each integrates Uniform Invoice Software with a customized Excel invoice template. This is just a way to simplify the applying of custom invoice designs and formats. The invoicing program - Uniform Invoice Software, does not change in any way. Currently we have 237 products hosted here on ExcelInvoiceSoftware.com. The following are the latest 12 additions.


Invoice Template with Credit Card Payment Option for Excel Invoice Software

  •  Size: 3748 KB
  •  Columns: 4
  •  A4 (210 mm x 297 mm)
  •  Portrait

2-Page Invoice Template for Excel Invoice Software

  •  Size: 4727 KB
  •  Columns: 5
  •  Letter (8-1/2 in. x 11 in.)
  •  Portrait

5.5 Inch X 8.5 Inch - 2 Invoices On One Template for Excel Invoice Software

  •  Size: 3232 KB
  •  Columns: 4
  •  Letter (8-1/2 in. x 11 in.)
  •  Portrait

1/2 Page Invoice Template for Excel Invoice Software

  •  Size: 3222 KB
  •  Columns: 4
  •  Letter (8-1/2 in. x 11 in.)
  •  Portrait

Daycare Invoice Template for Excel Invoice Software

  •  Size: 3233 KB
  •  Columns: 5
  •  Letter (8-1/2 in. x 11 in.)
  •  Portrait

Psychologist Invoice Template for Excel Invoice Software

  •  Size: 3262 KB
  •  Columns: 6
  •  A4 (210 mm x 297 mm)
  •  Portrait

Snow Removal Billing Format for Excel Invoice Software

  •  Size: 3274 KB
  •  Columns: 7
  •  A4 (210 mm x 297 mm)
  •  Portrait

Recruitment Agency Invoice Template for Excel Invoice Software

  •  Size: 3260 KB
  •  Columns: 3
  •  A4 (210 mm x 297 mm)
  •  Portrait

Travel Service Bill Format for Excel Invoice Software

  •  Size: 3249 KB
  •  Columns: 2
  •  Letter (8-1/2 in. x 11 in.)
  •  Portrait

Lawn Care Invoice Template for Excel Invoice Software

  •  Size: 3274 KB
  •  Columns: 4
  •  A4 (210 mm x 297 mm)
  •  Portrait

Advertising Agency Invoice Template for Excel Invoice Software

  •  Size: 3264 KB
  •  Columns: 4
  •  A4 (210 mm x 297 mm)
  •  Portrait

Tutoring Invoice Template for Excel Invoice Software

  •  Size: 3760 KB
  •  Columns: 5
  •  A4 (210 mm x 297 mm)
  •  Portrait

   

Excel Invoice Manager

On August 1, 2005 we released the first version of Excel Invoice Manager, an invoicing program that combines the powerful of Excel and database.

Excel Invoice Manager is electronic invoice software and billing software based on Excel templates and an add-in program. By seamlessly integrated with Microsoft Excel and utilizing backend databases, it provides you with a powerful, easy-to-use and highly-customizable invoicing and billing system, saving your time and money.

The name "Excel Invoice Manager" was used till August 4, 2013, and since then Excel Invoice Manager was renamed to Uniform Invoice Software.

Download Now