This article provides instruction and information on the following:

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: How to create the Transaction Report that shows 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
  4. Click F12 Next.
  5. In the Report Settings window, enter the desired report settings.
  6. 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

  7. In the Sorting Options pane, click F12 Run Report

A PDF file of the Comparative Revenue Report appears.

Note: For stores that are set up with the 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

Options

If the tax is unchecked on invoice

Invoice/Quote module

  • To remove tax for the entire transaction, clear the Tax checkbox on the grey line.
  • To remove tax for one item, clear the Tax checkbox on the red line.

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 Tax checkbox.

If the department is non-taxable

File/Setup/Dept tab

If you have admin privileges, select or create a department, and 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

Options

Account is non-taxable

Customers module

Select or create a new customer, and 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 Check screen, and 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 will contain the same number of lines, 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, and 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) will automatically create 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, enter the group ID (integer) in the Excel Report Group column, and then click Save. Do this for all departments in each group.
  5. Click Close.
  6. Close and restart Paladin. 

Back to Top

If you have questions or suggestions about this information, contact support@paladinpos.com.

*Content is subject to change. For the most recent version, visit the Help Portal.
Printed on: 10/05/22