The printed version.
Basic Service Bill Sample with Deposit (c5078)
c5078 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open
Basic Service Bill Sample with Deposit - IMFE edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you want this design to be set as the default template by the installer program.
Without database file. How to download and use
Download this if you have already installed IMFE, but are looking for additional customized templates.
Large number businesses ask their clients to deposit a percentage of total amount as advance payment. This basic service invoice template with deposit deduction helps you create deposit invoices with easy and quick.
While the default template comes with Invoice Manager for Excel (namely Uniform Invoice Software), which is our Microsoft Excel-based invoicing software program, already support dawn payment and security deposit, this feature is not specially documented (or many users simplify overlook this layout. With Invoice Manager for Excel (namely Uniform Invoice Software), each invoice / receipt can have several payments posted to it. When you click the "Save Invoice" button on the task pane, it not only generates a new invoice# for you automatically, there is also a "New Payment" window appears that allows you to save deposit or advance payment, including payment details like Payment Date, Total Payment, Payment Type, Reference Document#, as well as a fillable "Notes" field where you can fill in any additional information.
With Invoice Manager for Excel (namely Uniform Invoice Software), if an invoice / receipt is overpaid then the overpaid amount becomes "credit" under the customer's account. The credit amount can then be applied to other invoices as payment. We've already published template for creating credit note (credit memo) here on InvoicingTemplate.com, at Free Credit Memo Template, or Service Credit Note Template, or Debit Note Template. If you prefer to take the security deposit or advance payment based on the percentage of the total receipt / invoice amount, such as for car rental / house rental / freelance design work / website development job, here is the template you can try at Advance Payment Invoicing Template.
The default template shipped with Invoice Manager for Excel (namely Uniform Invoice Software) has a simple "Paid" and "Balance Due" or "Amount Due" cells on the bottom of the invoicing form, and the "Paid" field was not manually fillable (this is by design and in purpose). The purpose of this design is to encourage the end-users to use the "New Payment" window to post payments, instead of filling payment amount directly into the invoicing form when creating invoices. One of the advantages of using the "New Payment" window is that you have full and complete details regarding the payment, and the "Payment Report" is able to show only the payment records created using the "New Payment" window.
However one of the disadvantages of using a separate "New Payment" window is that, the options is not so obvious (you need to click the "Save Invoice" button). Sometimes you simply need to enter the payment method and payment amount, according to the agreement between you and the client, but don't really care about the other details about the payment, nor the "Payment Report" either. So in this sample invoice template with deposit, we'll add a new "Deposit" field and the original "Balance Due" cells back into the printable form, the later field was moved out in the sample c5075 Simple Sample - Moving Balance and Payment Cells. This time, we'll create a service invoice template, using the billing format / receipt format created in c5077 Simple Template - Moving Shipping Address as a starting point of the customization. To add a little detail to the deposit payment, we'll create and use another custom field called "Deposit Payment Method", to let you enter payment method information like cash, check, wire transfer or bank transfer etc. For a simple and quick tutorial on how to add / use custom fields (i.e. user-defined fields) in your bill format, visit c4051 Simple Invoice Template - Discount Amount Field.
This template is created as a service invoice template. If your business is less service orientated, but more about selling products to the customers than you may want to take a look at our Sales Invoice Template. All templates on our site, InvoicingTemplate.com, can be downloaded for free. To make your invoicing template a fully featured invoicing software app. While not as powerful and expensive as some accounting software system, Invoice Manager for Excel (namely Uniform Invoice Software) does provide complete features required by a small business for invoicing and management of customers, products, invoices and payments.
Now let's see the detailed steps involved to move back the "Total Due" cell and how to add the "Deposit" and "Deposit Payment Method" fields.
Now you can test the template to see if it works in the way you like. Since an invoice is not just a document of sales but it is essentially an accounting tool. It is utilized by an organization to make communication with the customer who is making a purchase or getting services. Every business has its own requirements regarding invoices. Fortunately, compared to Microsoft Word, or even Adobe Acrobat PDF and Photoshop, or OpenOffice programs, or some online accounting / billing or spreadsheet tools like Google Docs, Microsoft Excel wins in many areas when it comes to customizing a form. This, combined with the backend database, makes Invoice Manager for Excel (namely Uniform Invoice Software) an ideal invoice creator for small businesses. Feel free to download and try it to see how it works for you.
This template "c5078 Basic Service Invoice Sample with Deposit" does not modify the taxing features defined by the based template. So like the origin one, it has two taxes, GST and PST on the bottom of the form. To change this, click the Settings button, and then go to the "Taxes" tab. For a sample on how to add the deposit to the Sales Report, refer to c4055 Simple Invoice Template - Discount Amount on Sales Report. If you would like to create a selectable drop-down list for the newly added payment method field, visit the sample and tutorial at c4062 Simple Tax Invoice Sample with Tax Rate List.
Like other form designs here on InvoicingTemplate.com, Simple Service Invoicing Template with Deposit is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.
|Name||Basic Service Bill Sample with Deposit|
|Category||Service Invoice Template|
|Release Date||Tuesday, February 9, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|