Understanding your Transaction report

When you export your Transaction Report, you will receive a spreadsheet file that can be opened in either Excel or Google Sheets. Each column represents a specific piece of information recorded during customer activity. This guide explains what every column means so you can confidently read and analyse your data.

A) ID

The internal system ID used to identify the account associated with the transaction.

B) Date_Add

The date the account was first associated with your business.

C)Date Edit 

Duplicate of Date_Add or a related timestamp depending on your setup. Represents the most recent association date.

D)Transaction Type

The category of transaction recorded, for example, purchase, refund, earn, redeem, or adjustment.

E) Loyalty Type

Indicates what type of loyalty activity took place (e.g., points earned, points redeemed, reward issued).

F) Business ID

The internal ID of the business where the transaction occurred.

G) Branch ID

The internal ID of the specific branch (location) tied to the transaction.

H) Group ID

Identifies the business group or organisation a branch or business belongs to (if applicable).

I) Employee ID

The internal ID of the employee associated with the transaction.

J) POS Employee

The employee recorded by the POS system at the time of the transaction (may differ from internal employee ID).

K) Customer ID

The internal ID used to identify the customer who completed the transaction.

L) Refunded

Indicates whether the transaction has been refunded.

M) Voided

Shows whether the transaction was voided in the POS system.

N) Terminal ID

Identifies the terminal or till where the transaction was processed.

O) Smartpoints

The number of points awarded or adjusted during the transaction.

P) Customer Amount

The amount of money the customer spent in that transaction (usually before loyalty is applied).

Q) Unique Identifier

A system-generated unique value used to track or reference the transaction across systems.

R) Order ID

The POS order number associated with the transaction.

S) Reward Given

Indicates whether a reward was triggered or issued as part of the transaction.

T) User ID

The internal ID of the user profile (often refers to the account holder in your system).

U) User First Name

The first name of the user/account holder.

V) User Last Name

The last name of the user/account holder.

W) Nickname

Any nickname the customer has set on their account.

X) Phone Number

The phone number registered to the customer/account.

Y) Card Internal ID

The system ID for the loyalty card 
Z) Account ID

The ID of the customer’s account within your loyalty platform.

AA) Employee ID

A second employee ID field, may appear if the data source records multiple employee references 

AB) Employee User ID

The user profile ID associated with the employee in your system.

AC) Employee ID

Another employee identifier used for reporting 

AD) Employee First Name

The first name of the employee linked to this transaction.

AE) Employee Last Name

The last name of the employee linked to this transaction.

AF) Business Branch ID

Another branch identifier used when multiple systems feed into the same report.

AG) Business Branch Name

The name of the branch where the transaction occurred.

AH) Merchant ID

The merchant’s ID within the platform.

AI) Merchant Name

The name of the merchant associated with the transaction.

AJ) Merchant Business Loyalty ID

A unique identifier linking the merchant to its loyalty program configuration or business loyalty setup.