Skip to main content
InvoicingTemplate.com main content

Contractor Invoices with Remittance-slipc5106

Contractor Invoices with Remittance Advice Slip

"Contractor Invoices with Remittance-slip" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 81.

...(46) This free contractor invoice template features a remittance slip or remittance-advice-slip on the bottom of the Excel form. The slip is created by mve the total, paid and total due cell down to the bottom, as well as all the information in the "Bill To" section.

...(19) This contractor invoice does not include fields for shipping goods. For more billing samples for contractors, visit contractor invoices.

...(98) The duplicate "Bill To" section is created simply using Excel formula. For example, "Client Name" ($F$39) is filled with the Excel formula "=oknWhoName", where "oknWhoName" is the cell name / range name for a cell inside the "Bill To" section; similarly, "Address" ($F$40) is filled with the Excel formula "=oknWhoAddress", where "oknWhoAddress" is also the name of a cell inside the "Bill To" section. All these fields within the remittance slip section are filled automatically whenever you pick up a client manually, or with the on-sheet picker button, or by entering the client# into the "Customer#" field directly.

Recipient Created Tax Invoices Formc4077

Recipient Created Tax Invoices Form

"Recipient Created Tax Invoices Form" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 73.

...(40) In Australia tax invoices are usually issued by the supplier or seller. However Australian Taxation Office also allows the purchaser or recipient of the goods or services to issue tax invoice for the purchases, knowns as recipient-created tax invoices (RCTI).

...(143) At InvoicingTemplate.com we've already published a serial of Excel invoice templates according to Australian Taxation Office requirements, including ABN Tax Invoice Template, Australian GST Invoice Template and Australian GST Invoice Template (2). Unlike the samples provided by Australian Taxation Office, our invoice templates are provided in both Excel and PDF formats. And of course, the Excel versions works with Uniform Invoice Software, which is our Excel-based invoicing software app that combines the power of Microsoft Excel with the back end databases in either Access or SQL Server format, providing features that could hardly be found or implemented with pure Excel templates. Uniform Invoice Software was originally named Excel Invoice Manager, and the first version was released on August 1, 2005. Our continuous improvements based on the requirements from our users make Uniform Invoice Software an easy to use, powerful and unique invoicing tool.

...(40) On the upper-side of the invoice form you will find two sections "From Recipient" and "To-Supplier", where you, the buyer and the creator of the RCTI invoice, should provide detailed information about both businesses, both including Australian Business Number (ABN).

Bill Sample with Sports Themec4094

Invoicing Template with Sports Theme

"Bill Sample with Sports Theme" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 72.

...(38) Designed for sports shops and stores that sell sports goods, accessories and equipment, or for sports training and education organizations. Download this free billing and invoicing sample in Excel or PDF format that features a translucent sportsman background.

...(67) Like other templates here on InvoicingTemplate.com, this form layout is just one of the sample invoicing templates that demonstrating how the default template comes with Uniform Invoice Software could be customized. While the Customizing Invoice Template document describe the basic rules and principle about customization, you surely need some examples to show the results and details of customization. This is why we built the InvoicingTemplate.com web site.

PDF Invoice with PayPal Buttonc5093

PDF Invoice with PayPal Button

"PDF Invoice with PayPal Button" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 71.

...(38) You can include a PayPal payment button on your PDF invoices to accept online payment via PayPal. In this free sample we demonstrates how to add the PayPal button to the standard invoice template shipped with UIS 4.17.

...(58) Uniform Invoice Software (UIS) is able to generate invoices in Adobe PDF (".pdf"), Microsoft Excel spreadsheet (".xlsx") and image format (".png"), and send the generated electronical invoices to customers via email. Starting from version 4.17, you can even add a PayPal payment button to your PDF invoices. Here are the steps to follow to enable to this feature.

5.5 Inch X 8.5 Inch - 2 Invoices On One Templatec4067

5.5 Inch X 8.5 Inch - 2 Invoices On One Template

"5.5 Inch X 8.5 Inch - 2 Invoices On One Template" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 65.

  1. Backup the template. This gives you an easy way to return to a working state if anything goes wrong during the customization. To do this, simple copy the template (xlsx format) in Windows Explorer.
  2. Open the template as usual.
  3. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon. The "Invoice" ribbon tab was created by UIS. If you cannot find this ribbon tab in your Microsoft Excel, make sure you have UIS installed.
  4. Drag your mouse on the row headings on all the rows that comprise the exiting invoicing form. In this case, we select row 2 to row 39. Note you need to select the row heading to select the entire rows, instead of highlighting any single cells.
  5. Press CTRL + C keywords on your keyboard to copy the selected rows to clipboard.
  6. Right-click to select the row heading of the first row where the duplicate copy will start. In this case, we choose the row 47. Choose "Paste" from the shortcut menu. This create a duplicate copy of the selected invoicing format on the location starting from row 47. The cells inside the duplicate copy have exactly the same format and value as what inside the original format. However the content of the cells in the duplication are all "Values", which means they will not change when the original invoicing form changes - for example, when you are creating a new invoice. We'll fix this by pasting links.
  7. Drag your mouse to select the date and "invoice#" cells in the original invoicing form. Note you need to select the cells that will change its content when you are creating invoices. In this example, K4 (the Invoice# cell), K5 (the invocie date cell). It is not necessary to select those label cells that will not be changed, for example J4 (text "DATE:"), J5 (text "INVOICE#:").
  8. Right-click one of the selected cell and choose "Copy".
  9. Click to select the corresponding cells inside the duplicate area. In this case, we select K49 and K50.
  10. Go to Excel "Home" ribbon tab. Pull down the "Paste" command group, and then choose "Paste Links" from the "Other Paste Options" group. This commands assigns formulas to the cells on the duplicate copy, so that they show the values from the corresponding cells inside the original copy. For example, Excel creates a formula for the K49 cell, as "=K4"; and for the K50 cell, the formula is "=K5".
  11. Repeat the above steps on all the field cells that change their values when you creating an invoice. In this sample, you should execute the "Copy-Paste" process:
    • once for the cells inside the "Bill To" section (target address: F54:F58)
    • once for the cells inside the "Ship To" section (target address: J54:J58)
    • once for the cells under the label "P.O.#" , "Sales Rep. Name", "Ship Date", "Ship Method", "Terms" and "Due Date" (target address: D64:K64)
    • once for all the cells on the "InvBdy" ("Description" column, "Quantity" column, "Unit Price" column, "Line Total" column) (target address: D67:K70)
    • Once for the cells on the summary section, from "Discount (Amount)" to "Total" (target address: I80:K84).
    • Once for the "Notes" field (target address: K82).
  12. Now drag your mouse to select all the cells inside the duplicate form. In this case, it is D47:K84.
  13. Right-click one of the selected cell, choose "Format Cells" from the shortcut menu. On the "Protection" tab, make sure "Lock" is checked. Click OK. This makes the entire duplicate form not manually editable - they will be filled with Excel formulas.
  14. Select both forms. In this case, the cells ranging from D2 to K84.
  15. Go to Excel "Page Layout" ribbon tab, choose "Print Area" and then "Set Print Area" from the "Page Setup" group. This tell Excel what to print when you execute the Print command.
  16. Go to Excel menu "File" and then choose "Print". Make sure the entire print area could be printed on a single page. If not, adjust the lines heights. In this sample, we already make sure the original format occupies only half of the paper size, so there will be no problem to print two duplicate invoices on a single page.
  17. Optional - You can also add a cut-off rule between the two invoicing forms. To do this, go to Excel "Insert" ribbon tab, from the "Illustrations" group choose "Shapes" and then the first line shape on the "Lines" group.
  18. Push down SHIFT key on keyboard and draw the line between the two invoicing forms - in this case, row 46. By pushing down the SHIFT key, you make sure the line will be exactly vertical or horizontal (not an oblique line).
  19. Using the "Drawing Tools / Format" ribbon tab, set the style, color of the cut-off rule. In this sample, we set it to be a gray dash dot line (see screenshots).
  20. In this sample, we also make sure the two copies of invoices will be printed on the center of the paper, by checking the "Center on page: Horizontally, Vertically" options on the "Margins" tab of the "Page Setup" dialog box.
  21. To adjust the space between to duplicate invoices, adjust the height of the empty row (row 46) between to invoicing forms.
  22. Once done, exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  23. Save the template by clicking the "Save" command on Excel quick access toolbar.

Blank Service Invoice with Green Gradient Designc2031

Blank Service Invoice with Green Gradient Design

"Blank Service Invoice with Green Gradient Design" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 49.

  1. Backup your template.
  2. Click the "Design Mode" button on the "Invoice" ribbon tab.
  3. Click a "Taxable" checkbox to select it.
  4. Hit the DEL key on your keyboard to delete the selected checkbox control.
  5. Repeat the above steps to delete other "Taxable" controls.
  6. Exit design mode and save the template.

...(66) As you can see it is fairly easy to customize the template if you are familiar with Microsoft Excel. Just like what we demonstrated in this Blank Service Invoice Format with Green Gradient Design, Microsoft Excel provides abundant tools for you to present your data (i.e. invoices). This, combines with back end database, makes it possible for you to have your very own professional invoicing system.

Advanced Invoicing Sample - Invoiced Total in English Wordsc5102

Advanced Bill Sample - Invoiced Total in English Words

"Advanced Bill Sample - Invoiced Total in English Words" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 35.

...(32) While Excel itself does not have a built formula to convert a numeric value into English words, it is possible to create VBA function and have it work with your invoice template.

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

Restaurant Dining Invoice Template (No Tax)c4040

Restaurant Dining Receipt Format (No Tax)

"Restaurant Dining Receipt Format (No Tax)" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 26.

...(91) (Note that if you have installed the latest version of our invoicing software, Uniform Invoice Software, which is able to upgrade a simple template in Microsoft Excel spreadsheet format into a complete invoicing system, you don't have to replace the logo image manually - you can replace the default logo image by clicking the "Replace Logo Image" button on the ribbon tab in Excel 2007, Excel 2010 and Excel 2013). To replace the default LOGO image in Restaurant Dining Invoice Template (No Tax) with your own image, follow the steps below:

Five Price Levels (Service, Amount)c4013

Form with 5 Price Levels

"Five Price Levels (Service, Amount)" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 25.

...(56) In design mode if you click on the icon button, you will select it - even if you have Uniform Invoice Software installed, the program will not response to your mouse clicks - this is by design. The purpose of this design is to let you select the control and drag it to a new location.

...(51) Once you moved the cells and controls out of the printable area, and done all the other formatting jobs, such as setting colors and background patterns, setting up borders, you need to restore the invoice template to its working state - that is to exit design mode and protect the sheet.

Backorder Invoice Templatec7002

Backorder Invoice Template

"Backorder Invoice Template" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 25.

...(101) The freeware edition of Backorder Invoice Template provides exactly the same form layout and design in Microsoft Excel format as the UIS edition of Backorder Invoice Template. The most noticeable difference, at the first glance, is that the UIS edition of Backorder Invoice Template contains many buttons on it, such as Customers, Products, Invoices and Reports, etc. These buttons calls features and functionalities implemented by UIS. For example, if you click "Save To DB", UIS validates and checks the current document on Backorder Invoice Template, generate a unique invoice number automatically (if necessary), and then save it to the backend database.

Restaurant Dining Invoice Template (VAT)c4039

Restaurant Dining Receipt Format (VAT)

"Restaurant Dining Receipt Format (VAT)" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 18.

...(86) As you can see from Restaurant Dining Invoice Template (VAT), one benefit of using Excel as your invoice creator, as compared to other template formats like Microsoft Word invoice template and PDF invoice template, HTML format or even Photoshop format, is that you can easily apply formulas to do calculations. This means that, once the basic figures are entered on the form, like Quantity and Unit Price, or Hours and Hourly Rate, or Days and Daily Rate, the calculation of totals and taxes is done automatically.

Clothing Store (Manufacturer) Invoice with Size Breakdowncm003

Clothing Store (Manufacturer) Format with Size Breakdown

"Clothing Store (Manufacturer) Format with Size Breakdown" was found to be relative to Microsoft Word Templates For Invoices Kenya with the score grade of 3.

...(88) Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Clothing Store (Manufacturer) Invoice with Size Breakdown.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5106
Contractor Invoices with Remittance-slip
Monday, February 13, 2017,
12
5
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c4077
Recipient Created Tax Invoices Form
Monday, July 4, 2016,
8
4
A4
Portrait
Sales
c4094
Bill Sample with Sports Theme
Friday, October 28, 2016,
12
4
A4
Portrait
Sales
c5093
PDF Invoice with PayPal Button
Wednesday, August 10, 2016,
12
5
A4
Portrait
Sales
c9007
Commercial Invoice Format with Editable Word Art Logo
Wednesday, July 13, 2016,
9
9
A4
Landscape
Pro-forma
c4067
5.5 Inch X 8.5 Inch - 2 Invoices On One Template
Tuesday, March 1, 2016,
4
4
Letter (8-1/2 in. x 11 in.)
Portrait
Sales
c2031
Blank Service Invoice with Green Gradient Design
Thursday, June 30, 2016,
6
2
Letter (8-1/2 in. x 11 in.)
Portrait
Service
c5102
Advanced Invoicing Sample - Invoiced Total in English Words
Sunday, November 20, 2016,
12
5
A4
Portrait
Sales
c4040
Restaurant Dining Invoice Template (No Tax)
Friday, August 28, 2015,
20
4
A4
Portrait
Receipt
c4013
Five Price Levels (Service, Amount)
Tuesday, November 12, 2013,
30
4
A4
Portrait
Service
c7002
Backorder Invoice Template
Monday, May 19, 2014,
12
7
A4
Portrait
Sales
c4039
Restaurant Dining Invoice Template (VAT)
Thursday, August 27, 2015,
20
4
A4
Portrait
Receipt
cm003
Clothing Store (Manufacturer) Invoice with Size Breakdown
Monday, June 27, 2016,
12
x
A4
Portrait
Sales

What Is Hot

Feature Galleries