Download

DescriptionSizeDownload

The template works with both the Microsoft Store edition and the desktop edition of the app. Make sure you have installed one of them.

How to use:

  1. Download the EXE package.
  2. Double-click to extract the files into a folder. Make sure you have full access privileges to the folder, such as a subfolder inside “My Documents”.
  3. Open the template.
438 KBDownload

License: Private Use (not for distribution or resale). See our Terms of Use.

Screenshot

screenshot for Basic Service Bill Sample with Deposit

Detail

A large number of businesses ask their clients to deposit a percentage of the total amount as an advance payment. This template helps you create deposit invoices quickly and easily.

The following section describes how this template was created. You can ignore this if your purpose is just to use it.

This template is based on Simple Template: Moving Shipping Address (c5077). Let's see the steps involved to move back the "Total Due" cell and how to add the "Deposit" and "Deposit Payment Method" fields.

  1. First, backup the template and database files.
  2. Open the template.
  3. Click the "Design Mode" button on the ribbon tab.
  4. Click the cell where you want to put the "Deposit" field (In this case, $K$40). Name the cell "oknDeposit".
  5. Click and select the cell to the left of "oknDeposit", i.e., $J$40, and enter the text label "Deposit".
  6. Click the cell at $I$40 and name this cell "oknDepositPaymentMethod".
  7. Enter the label "Deposit Payment Method" for the field "oknDepositPaymentMethod" at $H$40.
  8. Select the name "oknPayments" from the name drop-down list at the left end of the formula bar. Excel selects the cell named "oknPayments" on the spreadsheet for you ($B$39).
  9. With the "oknPayments" ($B$39) cell still selected, drag the border of the selection box to move it into the printable area. In this example, we put the "oknPayments" cell under the "Total" cell at $K$90.
  10. Enter the text "Paid" into the $J$39 cell.
  11. Drag your mouse to select both the text label "Total Due" and its corresponding field at $P$40:$Q$40.
  12. Drag the border of the selected area to move it to the destination location at $J41:$K41.
  13. Modify the formula of the "Total" cell. It should look like this:

    =ROUND(oknSubTotal + oknShippingCost - oknDeposit+ IF(oknTaxType=0,0,IF(oknTaxType=1,oknTax1,oknTax1+oknTax2)),2)
    

    This formula deducts the deposit amount from the total payable amount.

  14. Click "Design Mode" again on the ribbon tab.
  15. Click the "Invoices" button on the ribbon tab.
  16. Click "Custom Fields" on the toolbar.
  17. Click "Add Field".
  18. Define the deposit field as follows:
    • Name: Deposit
    • Type: Decimal
    • Precision: 8
    • Scale: 2
  19. Click "Add Field" again.
  20. Define the payment method field as follows:
    • Name: DepositPaymentMethod
    • Type: Text
    • Size: 50
  21. Close the dialog boxes and return to Excel.
  22. Save the template.

Format and Specification

Template#c5078
Belongs to

Service

Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$3:$K$47
Papaer OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top71.28
Bottom49.68
PriceFree