Transactions Table

The Transactions Table shows every sale and return from a specified date range. Filter and sort the table, download customer receipts, and export your records to a spreadsheet.

Table of Contents

Using the Transactions Table

From setting a custom date range to retrieving customer receipts, learn the ins and outs of using the Transactions Table.

Access the Transactions Table

By default, the table displays data from 12 am to 11:59 pm for the day it is accessed, but go ahead and select whatever range you would like to see.

  1. Click 'Analytics' and choose 'Transactions'.
  2. Select the calendar button.
  3. Choose a starting and ending date/time and tap 'Retrieve'.

    Or, select one of the preset ranges.

Filter and Sort Results

The Transaction Table’s filtering and sorting capabilities help you sift through the results.

Filter

Use some of the pre-defined filters to narrow down the transactions that display. Type keywords into the “Filter by” field in the upper-left.

Available filters include:
Employee Name (e.g. Jack, Jill, Harry, Sally, etc.)
Type (sale or return)
Item (e.g. House Coffee, Chocolate Chip Cookie, etc.)
Department (e.g. beverage, food, t-shirts, etc.)
Category (e.g. coffee, tea, sandwiches, etc.)
Customer (e.g. first name, last name or email)
Register (e.g. register 1, bar register)
Line Item Type (liability or asset)
Tender (e.g. cash, credit, gift card, etc.)
Or, type “:” to show all filters.

Click the X to remove a filter or Clear All to remove all filters.

Sort Results

Sort transactions to order them by total or date/time.

Click Time or Total to put the table in ascending order (oldest / least first).
Click again to put in descending order (most recent / greatest first).

Details and Receipts

View additional transaction information or even download an old customer receipt.

  1. Click a sale to expand its record.
  2. Select 'Download Receipt'.

Export Transaction Details

Export transactions to a spreadsheet for analysis outside of BackOffice. Exports are available in a few different configurations; continue below to see what is included in each.

Be advised that totals for return transactions appear as negative numbers on each transaction export. Sum a particular column to get the total sales value net of returns.

Choose an export: Transactions, Transaction Tenders, or Transactions by Item

Transactions

This export focuses on general sales and returns. See when a sale/return took place, who rang it up, and the various totals.

Time
Date and time the transaction was completed.

Register Name/Number
Register number the transaction was performed on.

Cashier Name
Name of cashier that processed the transaction.

Operation Type
Type of transaction performed (sale / return).

Customer Name
First and last name of customer, if entered. The default is Walk-In if no customer was selected.

Customer Email
The email address of the customer (if entered at the register).

Gross Amount
Total of transaction before discount or tax is applied.

Discount
Total discount applied to the transaction shown in $0.00 format.

Net Total
Total amount of transaction including discounts, tax, and gratuity.

New Liabilities
Total of new liabilities sold, such as gift cards and gift certificates.

Tax
Total tax applied to the transaction. Tax is based on the rate from your Tax Settings.

Total Due
The amount owed by the customer, after tax, discounts, and liabilities have been applied.

Tips
Any gratuity/tip added at the register if paid by credit card.

Tendered Amount
The amount collected from the customer.

Tender Type
The form of payment (cash, credit, external credit, gift card, etc.)

Card Type
The type of credit/debit (Visa, Discover, Mastercard, etc.) card used for payment.

Last 4 Digits
The last 4 digits of the credit or debit card used as payment.

Cardholder Name
The name on the card used during a credit transaction.

Receipt Number
Receipt number needed to perform returns at the register.

Transaction ID
ID number that identifies the transaction within the ShopKeep database.

Transaction Tenders

This export focuses on specifics of the tender type(s) used. This is handy if you have split-tender sales, need to find a transaction charged to a specific credit card, or want to see how a transaction was paid for.

Time
Date and time the transaction was completed.

Register Name/Number
Register number the transaction was performed on.

Cashier Name
Name of cashier that processed the transaction.

Operation Type
Type of transaction performed (sale / return).

Customer Name
First and last name of customer, if entered. The default is Walk-In if no customer was selected.

Customer Email
The email address of the customer (if entered at the register).

Gross Amount
Total of transaction before discount or tax is applied.

Discount
Total discount applied to the transaction shown in $0.00 format.

Net Total
Total amount of transaction including discounts, tax, and gratuity.

New Liabilities
Total of new liabilities sold, such as gift cards and gift certificates.

Tax
Total tax applied to the transaction. Tax is based on the rate from your Tax Settings.

Total Due
The amount owed by the customer, after tax, discounts, and liabilities have been applied.

Tips
Any gratuity/tip added at the register if paid by credit card.

Tendered Amount
The amount collected from the customer.

Tender Type
The form of payment (cash, credit, external credit, gift card, etc.)

Card Type
The type of credit/debit (Visa, Discover, Mastercard, etc.) card used for payment.

Last 4 Digits
The last 4 digits of the credit or debit card used as payment.

Cardholder Name
The name on the card used during a credit transaction.

Receipt Number
Receipt number needed to perform returns at the register.

Transaction ID
ID number that identifies the transaction within the ShopKeep database.

Transactions by Item

This export focuses on the individual items involved in sales/returns. Not only does it include sale totals, but also item-specific information such as department, description, and cost.

Time
Date and time the transaction was completed.

Register Name/Number
Name of the register that the transaction was performed on.

Cashier Name
Name of cashier that processed the transaction.

Operation Type
Type of transaction performed (sale / return).

Store Code
Unique number auto-generated by ShopKeep for each item. Used for label printing.

Line Item
Name of item as seen on receipts and BackOffice.

Department
General group for inventory.

Category
A subset of Department.

Supplier
Provider of the inventory item. Only appears if entered in BackOffice.

Supplier Code
A re-order code, provided by the supplier, that is associated with the item.

Cost
How much the item costs the business to sell.

Price
What the customer pays at the register.

Quantity
How many of an item was sold/returned in transaction.

Modifiers
If the item has modifiers included, how much the modifiers totaled.

Subtotal
Total item price before tax and discounts. Factors in price, quantity, and modifiers.

Discounts
Total discount applied to the item shown in $0.00 format.

Net Total
The item’s subtotal plus tax and minus discounts.

Tax
Total tax applied to the item. Tax is based on the rate from your Tax Settings.

Total Due
The amount owed by the customer, after tax, discounts, and liabilities have been applied.

Transaction ID
ID number that identifies the transaction within the ShopKeep database.