Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Simple Sample - Total Quantity on Sales Report

Simple Sample - Total Quantity on Sales Report (c4103)

c4103 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-sample-total-quantity-on-sales-report-uis.xlsx.

Simple Sample - Total Quantity on Sales Report (UIS Edition)

Simple Sample - Total Quantity on Sales Report - UIS edition

Download

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

You are safe to download the resources. We've added our digital signatures to the files.

DescriptionSizeDownload

Without database file. How to download and use

96 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

297 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.81 MBDownload

Detail

In most business situations the quantity numbers on an invoice are not addable - for example, if you are invoicing for both goods sold and service rendered. But there are cases where you want to add up quantities on an invoice and show the sum on the sales report.

Since our templates are built upon Microsoft Excel, it is easy to add up several numbers to get the sum. Uniform Invoice Software, which is our invoicing program based on Microsoft Excel, supports this type of customizations without problem. As you can see, we've published hundreds free invoicing templates here on InvoicingTemplate.com, in both Microsoft Excel and PDF format. Uniform Invoice Software supports all the Excel invoice templates here and all the PDF invoices on here are generated with Uniform Invoice Software.

In this sample template, we take c4062 Simple Tax Invoice Sample with Tax Rate List as the base template (i.e. the starting point of our customization). See how to create your invoice template for more information on the general rules to adhere and the basic technique details.

Simple Tax Invoice Sample with Tax Rate List (c4062), which is featured on our simple invoices gallery, is a bill sample where we added a drop down list to the form to let you choose USA state name. The template updates tax rate automatically according to the state name you choose.

In this sample form design, we add a custom field to calculate / store the total quantity on an invoice, and then add this information to the sales report.

  1. First, make sure you have created a backup copy of the template.
  2. Open the template / spreadsheet file.
  3. Click "Invoices" on the "Invoice" ribbon tab.
  4. Click "Custom Fields" on the toolbar to open the "Custom Field Manager" dialog box.
  5. Make sure "Database Table" is showing "Invoice Header".
  6. Click "Add Field" to open the "Add New Custom Field" dialog box.
  7. Enter: Field Name - TotalQuantity; Type - Decimal; Precision - 10; Scale - 2.
  8. Click "OK" to create the new "TotalQuantity" field.
  9. Close all dialog boxes and return to Excel form.
  10. Switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon. This allows you to modify the invoice design.
  11. Click the cell where you want to place the quantity total. In this sample, we choose $I$34 - i.e. the cell below the "Quantity" column.
  12. Enter the formula to calculate the sum of all quantities:
    =sum(oknQuantity_1:oknQuantity_12)
  13. On the formula bar, click to activate the name box located at the left-end, enter the cell name "oknTotalQuantity". Note this name must be the combination of the prefix "okn" and the database field name "TotalQuantity". This name creates the map between the Excel cell and the backend Access database field to store the value when you save an invoice.

Next, we add this field to the sales report.

  1. First click and activate the "Sales Report" worksheet.
  2. Click the cell with the text "Balance Due".
  3. Click "Format Painter" on Microsoft Excel "Home" ribbon tab.
  4. Click the cell next to "Balance Due" - i.e. $R$11. This copies the format of the "Balance Due" cell to $R$11 to make it looks like a report heading.
  5. In the name box of the formula bar enter the cell name "oknRsTotalQuantity".
  6. Enter the label of this column, "Total Quantity".
  7. Click and activate the "Invoice" worksheet.
  8. Click "Design Mode" on "Invoice" ribbon to exit design mode.
  9. Save the template.

Now the invoice form calculates total quantity for each invoice, and when you create new sales reports, the total quantity of each invoice is retrieved and shown you too. For more template samples in this series visit simple invoice templates.

Like other form designs here on InvoicingTemplate.com, Simple Format - Total Quantity on Sales Report 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.

Format and Specification

Template#c4103
NameSimple Sample - Total Quantity on Sales Report
CategorySales Invoice Template
Release DateWednesday, November 23, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$46
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35