BoostExcel main content

Create a Receipt Form (Excel Invoice Manager)

What is a receipt template?

This version of the document, "Creating a Receipt Form", was written for Excel Invoice Manager. The program is now upgraded to Invoice Manager for Excel. Click receipt templates to see our new formats.

The template created in this tutorial was revised and published at Payment Receipt Template in the Receipt Template category.

A receipt is an acknowledgement that a specified article or sum of money has been received as an exchange for goods or services. In Excel Invoice Manager, you can easily create a receipt form based on the standard template, by simply displaying all the payment details on the form.

How to format the template

The following tutorial demonstrates the steps required to make the payment details visible on the form.

  1. Copy your invoice template file in Windows Explorer; name the new file "Receipt Form.xls".
  2. Open the template in Excel.
  3. Unprotect the Invoice worksheet. (How?)

    Tip: With Invoice Manager for Excel, you can push down the "Design Mode" on the "Invoice" ribbon tab to unprotect the sheet, switch the sheet to design mode, and show gridlines and row / column headings.

  4. Switch to design mode. (How?)
  5. Display grid lines and row/column headers. ( How?)
  6. Drag your mouse on the row headers to highlight the rows between the "Total Due" row and the last row. Please see the figure below.

    Create receipt form - select rows to unhide

  7. Right-click the highlighted row headers, and then choose Unhide from the menu. The Payment Detail section appears.

    Create receipt form - show payment

  8. Click Excel menu File -> Print Preview to preview the printed result. In Excel 2007, you can preview the printed result by clicking Office button -> Print -> Print Preview. Or in Excel 2010 and later versions, click File -> Print.
  9. Once you finish the designing of the receipt form, hide gridlines and row/column headers.
  10. Exit design mode.
  11. Save the template by clicking Excel menu File -> Save in Excel 2000/XP/2003. In Excel 2007, click Office button -> Save. In Excel 2010 ~ Excl 2016, click File -> Save.

Click one of the following links to download the receipt form created in this tutorial.