This article provides instruction and information on the following:

Note: Refer to the following for detailed instruction on how to read a Comparative Revenue report.

How to create a Comparative Revenue report

Note: The Comparative Revenue Report must be run on the same day that you run the Transaction Report with monthly service charges. Refer to: Create a Transaction Report showing monthly service charges

  1. In Paladin, on the top ribbon, select the Reports module.
  2. In the Report Area pane, select Sales Analysis > Revenue.
  3. In the Report List pane, select the report that you want to generate.
    • Today’s Comparative Revenue
    • Yesterday’s Comparative Revenue
    • Period Comparative Revenue
    • Report Revenue from a Promotion
  1. In the Choose Report pane, click F12 Next.
  2. In the Report Settings window, enter the desired report settings.

Note: You can select Export to Excel and/or Exclude Tax from Gross Profit?

  1. In the Additional Settings pane, select one of the following from the Detail by list: 
    • None
    • Department
    • Primary Supplier
    • Location
    • Class 1
    • Class 2
    • Class 3
    • Customer Type
  1. In the Sorting Options pane, click F12 Run Report

A PDF file of report opens.

Important: : If Change is given on a Cash sale, the # OF INV column of the THIS PERIOD pane will show 2. This is expected behavior in Paladin.

Expected discrepancy # OF INV 
Figure 1: Expected discrepancy # OF INV 

Note: For stores that are set up with in-store pickup, in the Revenue Sources table of the report, under Sources, you will see the WEBSTORE line item. The WEBSTORE number represents all items charged to the In-Store Pickup payment type.

Back to Top

Information about the Sales Tax Detail section of the Comparative Revenue Report

Note: The following items will not affect INVOICE NON-TAXED amounts.

Tax row: This Period Exempt Sales includes

For this line item

Go here


If the tax is unchecked on invoice

Invoice/Quote module

  • To remove tax for the entire transaction, clear the Tax checkbox located to the left of Part Number.
  • To remove tax for one item, clear the Tax checkbox on the red line below Tax and to the left of the Part Number box..

If the tax box is unchecked for the item in the Inventory module

Inventory module

To select an item, do one of the following:

1. Enter the part number, use Advanced Lookup, or create a new item. 

2.  In the Pricing tab, in the Pricing Level section, select the item, and then clear the Taxable checkbox.

If the department is non-taxable

File > Setup > Dept tab

If you have admin privileges, select or create a department, then select the taxes that apply to the department.

Instant saving/Dynamic Promotions that are non-taxable


For Ace Rewards clients only: Select any instant savings or dynamic promotions that are not taxed. Examples: Coupons, reward programs.

Note: The following items will affect THIS PERIOD EXEMPT SALES amounts.

Tax row:  INVOICE NON-TAXED:  This Period Exempt Sales includes

For this line item

Go here


Account is non-taxable

Customers module

Select or create a new customer, then press F8 to change the tax- exempt status.

Tax is reset with F8 in checkout screen

Invoice/Quote module

Process the transaction, complete the transaction on the Checkout screen, then press F8 to change the tax.

Service Charges

Customers module

Select all service charges that are tax exempt.

Back to Top

How to set Comparative Revenue report export

This option causes the Comparative Revenue report to export a row for every active department in your store. Every report contains the same number of lines, thus, simplifying using this data in other management or reporting systems.

To enable this feature:

  1. In Paladin, from the main menu, select File > Setup.
  2. Select the Company tab.
  3. In the Report Options pane, check Show Zero Comparative Revenue Departments in Excel Export.
  4. Click Save, then click Close.

Note: This feature is limited to the Excel export output only.

Back to Top

How to set up department groups for the Comparative Revenue report

When you assign department groups. the Comparative Revenue report (Excel version) automatically creates individual worksheets for those specified groups. It is not necessary to assign every department to a group. 

  1. Decide how you want to group your departments. Each group will need an integer group ID. Integers can be simply 1, 2, 3, etc. You do not have to assign every department to a group. 
  2. In Paladin, from the main menu, select File > Setup.
  3. Select the Dept tab.
  4. To assign a department group ID, select the department, then enter the group ID (integer) in the Excel Report Group column. Do this for all departments in each group.
  5. Click Save, then click Close.
  6. Close and restart Paladin. 

Back to Top

If you have questions or suggestions about this information, contact

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 7/17/24