This guide will be removed on April 29, 2022. Please use our new, easier-to-use Toast technical documentation site. All updated content is on the new site.

Payments data export

The payments data export includes information about the payments applied to checks at your restaurant. The file name of the payments data export is PaymentDetails.csv.

The following table shows details on what the payment data export contains.

Field

Description

Data Type

Location

Restaurant Location

String

Payment Id

Payment ID

Long

Order Id

Order ID

Long

Order #

Order Number

Integer

Paid Date

Timestamp for Order Paid Time

Date (MM/DD/YYYY HH:MM:SS)

Order Date

Timestamp for Order Open Time

Date (MM/DD/YYYY HH:MM:SS)

Check Id

Check ID

Long

Check #

Check number

Integer

Tab Name

Number of Table

Integer

Server

Name of Server who created order

String

Table

Number of Table

String

Dining Area

Name of Dining Area

String

Service

Day Part

String

Dining Option

Dining Options (defined by restaurant)

String

House Acct #

House Account number payment applied to

Integer

Amount

Amount Value

Number (2 decimals)

Tip

Tip Value

Number (2 decimals)

Gratuity

Gratuity Value

Number (2 decimals)

Total

Total Value

Number (2 decimals)

Swiped Card Amount

Swiped Card Amount

Number (2 decimals)

Keyed Card Amount

Keyed Card Amount

Number (2 decimals)

Amount Tendered

Cash Amount Value

Number (2 decimals)

Refunded

Status of Refund

String

Refund Date

Timestamp of Refund Value

Date (MM/DD/YYYY HH:MM:SS)

Refund Amount

Refund Value

Number (2 decimals)

Refund Tip Amount

Refund Tip Amount

Number (2 decimals)

Void User

Employee who voided the transaction

String

Void Approver

Employee who approved the void transaction

String

Void Date

Timestamp of the void transaction

String

Status

CC Processing status

String

Type

Payment type (Credit, Cash, Gift Card)

String

Cash Drawer

Cash Drawer used for payment

String

Card Type

Card Brand

String

Other Type

Other type of payment

String

Email

Email of customer for digital receipt

String

Phone

Phone number of customer for digital receipt

String

Last 4 Card Digits

Last 4 Card Digits of customer card

String

Receipt

Receipt token for digital receipts

String

V/MC/D Fees

CC processing fees for payment

Number (2 decimals)