e-magine Software - 20-20 Worksheet Templates
Want to print a customized selection of furniture for your client in a professional looking and easy to use report? 20-20 Worksheet Templates will make it easy! A report template presents 20-20 Worksheet information in a polished layout for printing.

Below are Report Examples and Templates to get you started.

For assistance with these 20-20 Worksheet Templates, email Kimball Office eTools Support or call 812.481.6116 or 800-482-1818

Click here to view Frequently Asked Questions and Answers for 20-20 Work Sheet Templates.


20-20 Worksheet Report Examples
Click on a report name below to view the report example and coordinating data locations for the information.

List Price Report - Includes List Pricing
Sell Price Report - Includes Net Selling Price (Does NOT include the Sell Discount Percentage)
List/Sell Price Report - Includes List and Net Selling Price, and Sell Discount Percentage
List/Purchase/Sell Report - Includes List, Net Purchase and Net Selling Prices w/ Sell Discount and Margin
Item Report - No pricing included
Purchase Order Report - Includes Purchase Price and Discount Percentage.


20-20 Worksheet Template Downloads


To utilize the templates using 20-20 Worksheet in e-magine, Giza or CAP software, follow these simple steps:

  1. Click on a template name below and select “Save” to store the template on your computer into the My Documents\CAP\UserReports folder (the template MUST be saved into this location)
  2. When in 20-20 Worksheet, use the Reports pull down menu and left click on “Manage Report Designs”
  3. Select the desired report previously saved in My Documents\CAP\UserReports
  4. The report will populate with the information you have entered into the worksheet data fields
  5. Wow your customer!!


List Price Template Downloads – Includes List Pricing

Sell Price Report – Includes Net Selling Price (Does NOT include the Sell Discount Percentage)

List/Sell Price Report – Includes List and Net Selling Price, and Sell Discount Percentage

List/Purchase/Sell Report – Includes List, Net Purchase and Net Selling Prices w/ Sell Discount and Margin Percentages

Item Report – No pricing included

Purchase Order Report – Includes Purchase Price and Discount Percentage.


Which report template should be used?

No Header: Use the “No Header” format when No Client information has been entered yet.
Report Title, logo and worksheet title (if entered) will still be displayed.

No Areas: For orders without tagged line items, a “No Areas” report should be used.
Sub-totals are not needed and will not print on the report.

No Options: Only Models and Quantities are shown (Options are not displayed).
Option upcharge pricing if it occurs, such as fabric grade pricing, will be included in the line item pricing.

© 2012 Kimball Office All Rights Reserved | Privacy Policy