Transaction Report – Excel

Up to 31 days of transaction data can be viewed in an Excel spreadsheet with the Transaction Report – Excel report option. If you want to analyze, sort, or filter transaction data, this report is designed for you.

This article provides instruction and information on the following:

• Set up 
• Report values (columns)
• Schedule a Transaction Report – Excel (report preset)

Set up 

To set up the report:

1. In Paladin, on the top ribbon, select the Reports module.
2. In the Report Area pane, select Sales Analysis > What I Need To Know.
3. In the Report List pane, select Transaction Report – Excel.
4. In the Choose Report pane, click F12 Next.
5. In the Transaction Report – Excel window, set your criteria in the Report Settings pane (this is limited to a maximum of 31 days).
6. In the Additional Settings pane, select your criteria. Note: Checking Include customer phone numbers will include the customer’s phone and cell phone in two columns after the Account Name column.

Figure 1: Include customer phone numbers

Figure 2: Phone/Cell Phone columns

Note: To include invoice notes, check Show invoice notes.

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

Back to Top

Report values (columns)

The report includes the following values for every transaction in the maximum 31 day time period that you specify:

• INVOICE ID
• LINE NUMBER
• DATE
• ACCOUNT NUMBER
• ACCOUNT NAME
• PHONE NUMBER (if Include customer phone numbers is checked)
• CELL PHONE (if Include customer phone numbers is checked)
• AUTHORIZED SIGNER
• PROJECT
• MEMO/PO
• TERMINAL
• CASHIER
• SCANNED PARTNUMBER
• PARTNUMBER
• DESCRIPTION
• QTY SOLD
• SOLD PRICE
• TAXABLE
• LINE EXT.
• STATE TAX
• COUNTY TAX
• CITY TAX
• PAYMENT METHOD
• Rewards Type 1
• Rewards #1

Note: The PAYMENT METHOD column reflects the type or types of the method used for payment.

Figure 3: Payment method(s)

Back to Top

Schedule a Transaction Report – Excel (report preset)

To schedule a Transaction Report – Excel, a report preset can be created

To set the report preset:

1. In Paladin, on the top ribbon, select the Reports module.
2. In the Report Area pane, select Sales Analysis > What I need to Know.
3. In the Report List pane, select Transaction Report – Excel
4. On the bottom of ribbon, select F11 Edit Preset.
5. In the Create Report Preset window, in the Report Preset Setting pane, select a Report Preset (there are nine available).
6. In the Additional Settings pane, in the Preset name box, enter a name for the preset.
7. Add a name in the Button name box (note that this is restricted to 14 characters).
8. From the Schedule report list, select from the following options: 

• • None
  • Daily
  • Daily – Exclude Weekends
  •  Weekly – Monday
  • Weekly – Tuesday
  • Weekly – Wednesday
  • Weekly – Thursday
  • Weekly – Friday
  • Weekly – Saturday
  • Monthly

9. Click F12 Next
10. In the Transaction Report – Excel window, enter parameters in the Report Settings pane.
11. In the Additional Settings pane, select from the various checkboxes and radio buttons.
12. In the Sorting Options pane, click F12 Save Preset. 

The report preset will now appear on the bottom ribbon of the Reports window.

Figure 4: Report presets

Back to Top