Excel Invoice Template Macro Skip to main content
InvoicingTemplate.com main content
sharing is caring! we do appreciate your time to let others know us!

Invoicing Template with Watermark of New York

Invoicing Template with Watermark of New York

Do you like New York, the state in the northeastern United States? You can even add it to your invoices and bills! This free downloadable invoicing template for Microsoft Excel (".xlsx" format) provides a sample on how to add a watermark of New York.

Invoicing Format for Bakery and Cake Shop

Invoicing Template for Bakery and Cake Shop

There are 8 lines on the detail section, which allow to enter itemized purchase information. Such as Banana Pudding Cupcake, Blueberry Cheesecake Cupcake, Baby Shower Cake A1, Children/Character Cake B2, Cheesecakes - Peanut Butter, Pound Cakes - Lemon with Lemon Glaze, Chocolate Sundae Cupcake - buttercream icing, German Chocolate Cupcake - chocolate buttercream icing topped with German chocolate mixture.

Simple Sample - Moving Taxable Controls

Simple Invoicing Format - Moving Taxable Controls
  1. First of all, back up your template. It is always recommended to back up the template before modifying the layout and format. This way, you could easily return to a working state in case something goes wrong during customization.
  2. Now click to push down the "Design Mode" button on the "Invoice" ribbon tab. This switch the spreadsheet into design mode, showing gridlines and column / row headings, unprotecting the sheet, as well as push down the "Design" button on Excel "Developer" ribbon tab (The "Developer" ribbon tab is not visible by default).
  3. Now push down the CTRL key on your keyboard. Without releasing the CTRL key, click the taxable boxes one by one with your mouse. This select the taxable controls that you click.
  4. Once all the taxable boxes are selected, release the keyboard CTRL key.
  5. Click and drag one of the taxable box. Drop it outside the printable area - in this sample, we put it on $C10. By dragging and dropping one of the selected controls, all the selected controls are moved to the new location.
  6. If you want to delete the controls completely, with all the controls still selected, hit DEL key on your keyboard. If you want to leave them there, skip this step.
  7. You can also modify the formulas of the tax fields to have them ignore the value of the taxable boxes completely. If all your products or items are always taxable, modify the formula of the first tax cell to " =ROUND( IF ( oknTaxType =0 ,0, oknTax1Rate * ( oknSubTotal + IF( oknTaxTotalIncludingShippingCost =0,0, oknShippingCost ))),2)"; and modify the formula of the second tax cell to " =ROUND ( IF( oknTaxType <> 2,0, oknTax2Rate * ( oknSubTotal + IF ( oknTaxTotalIncludingShippingCost = 0,0, oknShippingCost )+IF( oknTax2IsAppliedToTax1= 0 ,0, oknTax1 ))),2) ". If all your products / items are not taxable, simply choose "No-tax" from the "Taxes" page of the Settings dialog box that could be opened by clicking the "Settings" button on the "Invoice" ribbon tab.
  8. Now modify the column heading of the original "#/Taxable" column. To do this, simply replace the text "#/Taxable" with something like "Item#" or simply "#".
  9. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  10. Once done, save the template by clicking the Save button on Excel quick access toolbar.

Excel Quotation Template

Excel Quotation Format with Special Discounting Model

On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.

Excel Payment Voucher Template

Excel Payment Voucher Template

InvoicingTemplate.com also offers the Uniform Invoice Software version of this Excel Payment Voucher Template / receipt template. The Uniform Invoice Software version is also free if you have Uniform Invoice Software installed, and it has exactly the same layout as the freeware edition of the Payment Voucher Template, but with many buttons on it, such as "Clear & New", "Save To DB", "Exact / Email", "Print". Uniform Invoice Software, as the name suggests, is our invoicing software that has the ability to make any invoicing templates available here on InvoicingTemplate.com a complete invoicing program that is able to manage customers, products, invoices and payments. For example, if you click the "Clear & New" button, the payment voucher form is cleared and is ready for you to enter a new payment voucher, with several fields filled with default data - for example, the current date is filled into the "Date" field. If you click "Save To DB", the current voucher is saved to backend database and a voucher# is generated automatically. If you click "Exact / Email", a standard Excel spreadsheet is created and the current voucher is copied to the newly created Excel spreadsheet file, which you can email to your client. You can also create a PDF voucher document using Microsoft Excel.

Work Invoice in Excel

Work Invoice in Excel

The columns are titled with "Hours" and "Hourly Rate". However we didn't change the underlying database field names. So in the underlying database, which could be either Microsoft Access or Microsoft SQL Server, the corresponding fields are still "Quantity" and "Unit Price". Nearly all invoice templates created for hours worked take the same approach. The purpose of this is to simplify database design. Likewise, the field titled with "Work Description" is in face the "Notes" field in the underlying database.

General Quote Template for Excel

General Quote Template for Excel

As an Excel spreadsheet template, we use Excel formulas to calculate subtotal, tax and total. For example, for the subtotal field, the Excel formula assigned to the subtotal field is "=SUM(oknLinetotal_1:oknLinetotal_22)". This is one of the big advantages of using Excel spreadsheet templates. While you can create beautiful and professional forms too using Microsoft Word, Publisher, PowerPoint or even Adobe Photoshop, it is much easier when you need to do some calculations. This ability, combined with custom fields (user-defined fields) supported by Uniform Invoice Software, resulting extremely flexible form designs, as you can see from the samples online here on InvoicingTemplate.com. Or see the PDF quotation sample to find out what it will like when your customer receive the quotation created using UIS.

Job Estimate Template for Excel

Job Estimate Template for Excel

On the top of the blank estimate form you see the service business name. Next to it is the highlighted "ESTIMATE#" and "ESTIMATE DATE" fields. These fields are essentially the "Invoice#" and "Invoice Date" cells that appear on most free invoice templates here on InvoicingTemplate.com.

Donation Receipt Template for Excel

Donation Receipt Format for Excel

While not required, this form includes a "Receipt#" field on the top of the form under the "Date" field. If you have used one of our form designs for invoicing, you may know it is just the "Invoice#" field - we just place a new label "Receipt#" before the cell. So all features Uniform Invoice Software offer for the "Invoice#" field, works for the "Receipt#" field too. For example, the automatic receipt numbering feature, which generates a unique, sequential and unique based on a counter stored in the backend database. You can also retrieve information about an already-saved receipt by type in the receipt number into the "Receipt#" field.

Labor Invoicing Sample

Labor Billing Format for Excel

This printable labor invoice template covers job descriptions, hours, rates and total amounts, as well as the general fields for invoices such as invoice#, invoice date and payment term. It calculates taxes, subtotal, discount and total using Excel formulas.

Generic Sponsorship Invoice Sample

Generic Sponsorship Invoice Sample

This is a general invoice sample, which means the template could be used by many entities like individuals, sport teams, philanthropy organization, music events etc. The template has only one column of the "Description" fields, where you can write down anything you think necessary to be put on the invoice, like any contract, agreement, marketing plan, sponsorship level description. As detailed on How To Get Your Sponsorship Invoices Paid On Time, it is necessary to make everything as clear as possible.

Sales Invoicing Format for Germany

Sales Invoicing Example for Germany

As one of the member countries of the EU (European Union), the rules on German VAT registrations, returns and compliance are based on European Union EU VAT Directives which German has transposed into its VAT Act. This free invoicing sample in Excel and PDF format follows the German VAT compliance rules. It charges MwSt VAT tax at 19% by default.

Print Shop Bill Sample

Print Shop Billing Format

Print Shop Invoice Template could be used by a print shop or mail room for a school district. Compared to the default sales invoicing sample shipped with Uniform Invoice Software, in the Bill To section the "Name" changed to "Department", "Company" changed to "Contact Name", "Address" changed to "Department Code", etc.

Invoice with Date Column

Invoice with Date Column

With Uniform Invoice Software, which you can download and try the fully functional trial version for free, it is much easier to use custom fields. The previous standalone utility program, Database Designer, was no longer available. The feature of the Database Designer program was added to Uniform Invoice Software program itself, and database definition file is no longer required. For example, let's say you want to add the Date column to the Invoice Body database table. You first open the Invoice Edit window of any invoice, and then double-click an invoice item to open the detail window of the invoicing item, and then go to the "Custom Fields" tab. Next, click the Add Field button to open the "Add New Custom Field" window. Specify the name of the field ("DateCompleted" in this example because we want to use this field to detail when the service or job was performed / completed - you cannot name a field with the word "date" because it is a keyword used by the underlying database engine), and then select "Date" from the Type list. The "Default value", "Caption" and "Notes" fields are optional on this window. Note that if you are adding a new field that is Text type, you have to also fill in the Size field; and if you are adding a Decimal field, you have to fill in Precision and Scale too. Once the new field "Date" is added to the Invoice Body database table, all you have to do is to name the field. To do this, simply enter the name of each cell on the column "oknDateCompleted_1", "oknDateCompleted_2", and so on, from top to bottom.

Work Order and Processing Sheet Practical Sample

Work Order and Processing Sheet Practical Sample
Column headingColumn name prefixInside Print_AreaFormulaCustom fields
Product IDoknProductIDYes No
PageoknPrdPageYes Yes
DescriptionoknProductNameYes No
FinishoknPrdFinishYes Yes
QuantityoknQuantityYes No
Unit priceoknPriceYes No
Line totaloknLinetotalYes=ROUND(oknQuantity_?*oknPrice_?,2)No
FabricoknPrdFabricNo Yes
TrimoknPrdTrimNo Yes
TypeoknPrdTypeNo Yes
CategoryoknPrdCategoryNo Yes
FramesoknPrdFramesNo Yes