Skip to main content
InvoicingTemplate.com main content

Excel Payment Voucher Templatec5052

Payment Voucher Template

"Payment Voucher Template" was found to be relative to Office Invoice Template With Payment Database with the score grade of 98.

  • In Excel 2003 click the Design Mode button on the Control Toolbox toolbar. Tip: If the Control Toolbox toolbar is invisible, click Excel menu View > Toolbars > Control Toolbox.
  • In Excel 2007, Excel 2010 and Excel 2013, click the Design Mode button in the Controls group of the Developer tab.

    TIP: If the Developer tab is not available in Excel 2007, do the following to display it: a) Click Microsoft Office Button, and then click Excel Options; b) In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

    Or in Excel 2010 and Excel 2013 to display the Developer tab: a) Click File > Options > Customize Ribbon; b) In the area on the right, ensure that the box next to Developer is checked; c) When you click OK, the Developer tab will appear in the ribbon.

  • Right click the Logo image, and then select Properties from the menu.
  • Click the Picture property, and then click the "..." button.
  • Browse to the folder containing your icon file. Select and open the icon file.
  • Close the Properties dialog box.
  • Drag the border of the image object to resize it, if needed.

Payment Receipt Templatec5045

Payment Receipt Form

"Payment Receipt Template" was found to be relative to Office Invoice Template With Payment Database with the score grade of 87.

...(12) The blank payment receipt template is formatted as an Excel ".xls" document.

...(102) Although it is easy to create the layout and format of Payment Receipt Template with Microsoft Word or other Microsoft Office programs, or even with some PDF programs like Adobe Acrobat, the support for Excel formulas makes doing automated calculations easy to implement and modify. For example, Payment Receipt Template uses Excel formulas extensively to do calculations whenever possible and necessary, such as the taxes, totals. If you use the Uniform Invoice Software version of Payment Receipt Template, Excel formulas are also used to create the relationship between several fields, such as one field should be the sum of two other fields.

Cash Payment Voucher Templatec5053

Cash Voucher Template

"Cash Payment Voucher Template" was found to be relative to Office Invoice Template With Payment Database with the score grade of 86.

...(248) Naming a cell is easy in Excel, no matter you are using the free edition of Cash Payment Voucher Template or the Uniform Invoice Software edition of Cash Payment Voucher Template, and the process is the same no matter which Excel version you are using - Excel 2003, Excel 2007, Excel 2010 or Excel 2013. To name a cell, after opening Cash Payment Voucher Template firstly make the sheet is not protected, and then click the cell you want to name (or drag your mouse to select the range you want to name), and then enter the name into the name box on the formula bar. Note that Excel does not allow you to reuse an existing name in this way. For example, if a cell has already been named "oknTaxType" in Cash Payment Voucher Template, and you click and select an empty cell then enter the name "oknType" into the name box, Excel activates the cell with the name "oknTaxType" in Cash Payment Voucher Template, instead of naming the empty cell "oknTaxType". To name a new (empty) cell with an existing name, you have to firstly delete the exiting cell name, and then use this name to name the new cell. To delete an existing cell name, in Excel 2003 click Excel menu Insert > Name > Define to open the Define Name dialog box; in Excel 2007, 2010 and 2013, the Name Manager can be launched by going to the formulas ribbon tab, Defined Names group.

Invoice Sample with Partial Payment and Payment Historyc5092

Invoice Sample with Partial Payment and Payment History

"Invoice Format with Partial Payment and Payment History" was found to be relative to Office Invoice Template With Payment Database with the score grade of 83.

...(98) This hidden section, titled with "PAYMENT DETAIL" includes a table with 5 columns - "Date" (cell name "oknPaymentCreatedDate"), "Total" (cell name "oknPaymentAmount"), "Applied" (cell name "oknPaymentTotalApplied", "Type" (cell name "oknPaymentTerm"), and "Notes" (cell name "oknPaymentNotes"). These columns match exactly the fields shown on the "New Payment" or "Edit Payment" window. The "New Payment" window is shown when you save a new invoice by clicking the "Save Invoice" command on the task pane, or by clicking the "Save To DB" command button (There is an option on the "Settings" window that you could use to turn off this feature).

  • Drag your mouse to select row headings of R30, R31, R32 and R33 - 4 rows in total.
  • Right-click one of the selected row heading, choose hide.
  • Select all the cells of the last visible row (in this case, D29:K29).
  • Set a bottom-border for these cells.
  • The "Taxable" checkboxes of the hidden rows are still visible. You can safely delete these checkboxes. To do this, click one of the checkbox that is to be deleted, hit DEL key on keyboard.

Law Firm Invoice Templatec5104

Law Firm Invoice Template

"Law Office Billing Sample " was found to be relative to Office Invoice Template With Payment Database with the score grade of 78.

...(43) This sample invoice provides another option that you can choose for you law firm or small law office. Like other templates available here on InvoicingTemplate.com, The Excel version works with Uniform Invoice Software (UIS), and the PDF version is created by using UIS.

...(38) The "Currency" field is designed this way because we'll create the billing template for law firms and small law office (INR currency) with exactly the same form layout, but in a different a currency (INR - Indian Ruppee).

Service Invoice with Payment Advicec2004

Service Billing Template with Payment Advice

"Service Invoice with Payment Advice" was found to be relative to Office Invoice Template With Payment Database with the score grade of 74.

  1. First you should unprotect the Invoice worksheet. Most templates designed by us here at InvoicingTemplate.com turn on protection to avoid damage to layouts and formulas by mistake. However before you can customize an invoice template, you should firstly unprotect it by clicking the Unprotect command on Excel Review ribbon tab.
  2. Now drag your mouse to select the cell/cells you want to move.
  3. Push your mouse key on the border of the selected area. Drag it to the new location where you want to place the cell/cells.
  4. Once done, protect the Invoice worksheet.

Payment Voucher Template (Golden Shop)c6004

Voucher Template (Golden Shop)

"Voucher Template (Golden Shop)" was found to be relative to Office Invoice Template With Payment Database with the score grade of 70.

...(149) On the bottom of the voucher form, the fields include Discount, Total, Advance Payment, and Balance. This "Discount" field is an amount field, the amount entered into it will be deducted from the Total by Excel formulas. The "Advance Payment" field is also a manually editable field that is indicating the advance payment from the customer, which is deducted from the "Balance" automatically. If you would like to use this template as a cash payment voucher template, move both the Advance and Balance fields out of the printable form, and make the "Advance" field equal to "Total" by using an Excel formula. A general purpose cash voucher template is also available here on InvoicingTemplate.com, which is ready for you to download for free at Cash Voucher Template. If you are not running a golden retail shop you may find our general purpose Excel Payment Voucher Template helpful and useful.

PDF Invoice with PayPal Buttonc5093

PDF Invoice with PayPal Button

"PDF Invoice with PayPal Button" was found to be relative to Office Invoice Template With Payment Database with the score grade of 66.

  • Open your invoicing template as usual.
  • Click the "Add / Update PayPal Button" command on the "Invoice" ribbon tab.
  • Enter your PayPal account email address in the first text box. Note this is the account where your customer will send money to. So double check it to make sure it is correctly.
  • In the "Information sent to PayPal" section, you'll find 3 fields.
    • Item name: This field describes why the customer is paying you. The default value for this field is "Invoice Number: oknInvoiceID", where "oknInvoiceID" will be replaced with real invoice numbers when a PDF invoice is generated. You can include your company / business name here. For example, it could be "ABC Company Invoice Number: oknInvoiceID".
    • Currency: This field should specify the 3-letter currency code to use. The default currency is "USD". It is implemented as a drop-down selection list. Note that UIS does not convert currency automatically. So make sure this choice in this field matches the currency used on your invoices.
    • Amout: By default this field is "oknBalanceDue". This will be the balance of the invoice that is being created. On generating a PDF invoice, UIS replace this with the value of the "oknBalanceDue" cell.
  • Click "Test" to open a browser window to verify what you customers will see when they click he PayPal payment button on your invoices. In this test link, "oknInvoiceID" will be replaced with "INV100", the amount will show "123.00".
  • Click "Add / Update PayPal button" to add the PayPal button to your Excel invoice template.
  • The template is now switched to design mode with the new payment button selected. You can move it to a proper location by dragging and dropping, or resize it by dragging the border of the button image.
  • Once done, switch off design mode by clicking the "Design Mode" button again.
  • Save the template by clicking the Save button on Excel quick access toolbar.

...(10) Here are some important notes about the PayPal payment button.

Simple Sample - Moving Item# Columnc4049

Simple Invoicing Template - Moving Item# Column

"Simple Sample - Moving Item# Column" was found to be relative to Office Invoice Template With Payment Database with the score grade of 64.

  1. Open the invoice template as usual.
  2. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.
  3. Drag your mouse to select the "To create an invoice" section, as well as the short advertisement section "Need a different invoice layout? Visit our invoice template collection" section. Move the entire selected area (N6:R46) several columns right. In this sample, we put this on $R$6.
  4. On the printable form, select the entire "Description" column, including the heading row, ranging from F21 to H33. Click the "Merge and Center" command on the "Home" ribbon tab. This unmerges the selected area.
  5. Now select the entire column "#/Taxable". The range address should be D21:D33. Move the selected area to the new location starting from $O$21.
  6. Now selected the unmerged "Description" column, ranging from F21 to F33. Move the selected area to the new location starting from $D$21.
  7. Select all the cells that will comprise the new column heading of the Description column, ranging from D21 to H21. Click "Merge and Center" command on the "Home" ribbon tab.
  8. Select all the cells that will comprise the new oknProductName_1 cell (the top-most product description cell), ranging from D22 to H22. Click "Merge and Center" command on the "Home" ribbon tab.
  9. Repeat the above step for all the other description cells.
  10. The "Merge and Center" command set text alignment to be "Center". We have to set this to "Left". To do this, select all the product description cells (excluding the heading cell), ranging from D22 to H33. Click the "Align Left" button on the "Home" ribbon tab / "Alignment" group.
  11. In Excel 2010 / Excel 2013 / Excel 2016, click File / Print to preview the result of a printed invoice.
  12. Exit print preview mode and go back to normal view. Add up borders and set colors to fine turn the printable invoicing form.
  13. Once finished, exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab.

Form with Product Categoryc5008

Form with Product Category

"Form with Product Category" was found to be relative to Office Invoice Template With Payment Database with the score grade of 51.

...(50) "Product Category" is a standard field defined in the Product database table, but not added to the "Invoice Body" database table. So when you create an invoice with Uniform Invoice Software, the category information is not loaded along with product data, and thus not saved along with other invoice details.

...(79) However the support for custom fields in Uniform Invoice Software makes overcoming this limitation easy and quick. What you need to do is to add the custom field "Product Category" to the invoice body database table, and then name a column of cells where you want to display the category when creating an invoice - in this sample, we don't want to show product category on printed invoices, so the product category column is defined outside the printable area.

Sales Invoicing Templatecn001

Sales Invoicing Template

"Sales Invoicing Template" was found to be relative to Office Invoice Template With Payment Database with the score grade of 49.

...(43) Sales Invoicing Template is a general purpose template that is suitable for many business types. It includes both a "Bill To" and a "Ship To" section. There are also 5 columns on the invoice body, including Product#, Description, Quantity, Price and Line Total.

...(36) On the bottom of the invoice form, Subtotal, Tax 1, Tax 2, Total and Total Due are calculated automatically using Excel formulas. The tax rates and tax names, payments, shipping and handing fee, are all editable.

General Purchase Invoice Template (Consulting, One Tax)c2027

General Purchase Invoice Template (Consulting, One Tax)

"General Purchase Invoice Template (Consulting, One Tax)" was found to be relative to Office Invoice Template With Payment Database with the score grade of 30.

...(89) If you items are always taxable or not taxable, you may find the additional taxable column redundant. If this is the case you can move all the taxable check boxes out of the printable invoice form. To do this, first switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab, and then select one tax box, or select all taxable boxes by push CTRL key on your keyboard and click each box. And then, you can drag the boxes out of the printable area.

Service Bill with Discount Percentage c4005

Service Bill with Discount Percentage

"Service Bill with Discount Percentage " was found to be relative to Office Invoice Template With Payment Database with the score grade of 13.

...(127) The "Lock" property is a very useful feature in Excel. When you protect a worksheet such as Service Bill with Discount Percentage, all cells are locked by default, which means that they cannot be edited. To enable cells to be edited while leaving only some cells locked, you can unlock the cells and then lock only specific cells and ranges before you protect the "Invoice" worksheet of Service Bill with Discount Percentage. To lock a cell or a range of cells, first drag your mouse to select the cell or cells, and then right-click one of the selected cell on the form, choose Format Cells. On the Number tab, check the "Locked" box. To unlock a cell or a range of cells, simply clear the "Locked" box.

General Purchase Invoice Template (Service, One Tax)c2026

General Purchase Billing Template (Service, One Tax)

"General Purchase Billing Template (Service, One Tax)" was found to be relative to Office Invoice Template With Payment Database with the score grade of 9.

...(48) To move out the address section, we first need to put the template into design mode. To do this, simply push down the "Design Mode" button on the "Invoice" ribbon tab. This commands unprotect the sheet and then push down the "Design" button on the "Developer" ribbon tab.

...(79) Once the template is in design mode, drag your mouse to select all the cells that you want to move, then push your mouse key down on the border of the selected area and without releasing the mouse key, drag the selected to its new location. It's that simple! Once finished, you need to click the "Design Mode" button on "Invoice" ribbon tab again to switch it off, so that Uniform Invoice Software returns to its normal functional mode.

Specifications

Template#
Title
Release Date
Lines
Columns
Paper
Orientation
Category
c5052
Excel Payment Voucher Template
Thursday, May 29, 2014,
12
5
A4
Portrait
Receipt
c5045
Payment Receipt Template
Saturday, January 4, 2014,
12
5
A4
Portrait
Receipt
c5053
Cash Payment Voucher Template
Friday, May 30, 2014,
12
5
A4
Portrait
Receipt
c5092
Invoice Sample with Partial Payment and Payment History
Friday, July 29, 2016,
8
5
A4
Portrait
Sales
c5104
Law Firm Invoice Template
Thursday, November 24, 2016,
12
5
A4
Portrait
Service
c2004
Service Invoice with Payment Advice
Thursday, October 31, 2013,
12
2
A4
Portrait
Service
c6004
Payment Voucher Template (Golden Shop)
Wednesday, May 28, 2014,
18
6
A4
Portrait
Receipt
c5093
PDF Invoice with PayPal Button
Wednesday, August 10, 2016,
12
5
A4
Portrait
Sales
c4049
Simple Sample - Moving Item# Column
Sunday, January 24, 2016,
12
4
A4
Portrait
Sales
c5008
Form with Product Category
Sunday, November 10, 2013,
12
5
A4
Portrait
Sales
cn001
Sales Invoicing Template
Friday, October 18, 2013,
12
x
A4
Portrait
Sales
c2027
General Purchase Invoice Template (Consulting, One Tax)
Friday, January 22, 2016,
6
2
A4
Portrait
Receipt
c4005
Service Bill with Discount Percentage
Saturday, May 17, 2014,
12
4
A4
Portrait
Service
c2026
General Purchase Invoice Template (Service, One Tax)
Thursday, January 21, 2016,
6
2
A4
Portrait
Service

What Is Hot

Feature Galleries