Both Excel cells are then locked to prevent accidental modifications to the formula. By using Excel formula, we can easily assign default values (or place holder values) to those fields that must be filled according to Invoice Manager for Excel, but not used in this money receipt template.įor example, after moving the 'Bill To' section out of the printable receipt form, we assign the formula (='PSName001') to the client name of the receipt, and assign the formula (='ps001') to the client# cell. Remember we are using Microsoft Excel that has a unique feature called Excel formula, which does not exists in Microsoft Word. So how we make it possible to save a receipt in Invoice Manager for Excel without manually filling in customer/client information? The secret is simple. If the Customer# is blank when the 'Save To DB' command is being clicked, Invoice Manager for Excel shows a warning message and refuse to save the invoice to database. If you have tried Invoice Manager for Excel, you probably have noticed that the information appear in the 'Bill To' sections are required - especially the Customer# field. The two common sections that appear on almost all free invoice templates available here on, the 'Bill To' and 'Shipping To' sections, are moved out of the printable receipt form. The free receipt template does not include 'Bill To' and 'Ship To' section inside the printable receipt form. The template has a Rate field outside of printable receipt form, with which you can specify the current unit price of gold. Receipt Template for Gold Shop is a free blank receipt template and cash receipt template designed especially for gold shop.

Blank receipts to print free