Skip to main content

CardPointe - Reconciling Reports

M
Written by Marija Golubovic
Updated over a week ago

Overview

To ensure that payment information is accounted for properly, compare financial reports between Lunchbox and the CardPointe Payment Dashboard. In this article, we’ll take a look at the reports that ensure that Transactions and Deposits are matching between the 2 systems.


Transactions

In the following lines, we'll explain how to grab the transaction report in Admin Dashboard and in CardPointe Dashboard, so that you can cross-reference the data.

Lunchbox Transaction Report

To pull Transactions from Lunchbox, you’ll need the “Credit Card Detail” Report:

  1. Navigate to the Lunchbox Admin and log in.

  2. Navigate to Reporting

  3. Select the Location you would like to pull the reports for

  4. Select the Date(s) you would like to pull the reports for

  5. Click View to launch the report

  6. When the report populates, you’ll be able to see each transaction for the day, broken up by the payment type (Mastercard / Visa, Amex / Discover, Other Payments [i.e., Gift Cards and House Accounts] and displaying:

    1. Guest Name

    2. Order Details Link

    3. Transaction Dates

    4. Transaction Amounts

    5. Payment Info


CardPointe Transactions Report

To pull Transactions from the CardPointe Dashboard, navigate to

  1. Reporting tab

  2. Select the Transaction tab

  3. Select Date(s)

  4. Select Location


  5. When the report populates, you’ll be able to see each transaction for the day, broken up by the payment type (Mastercard / Visa, Amex / Discover, Other Payments [i.e., Gift Cards and House Accounts] and displaying:

    • Guest Name

    • Order Details Link

    • Transaction Dates

    • Transaction Amounts

    • Payment Info

If you need to update one or more of the parameters, make sure to select the Refresh button to get an updated report


Deposits

Lunchbox Deposits Report

You’ll need the same “Credit Card Detail” Report you pulled for Transactions to pull Deposits from Lunchbox. To get there,

  1. Navigate to the Lunchbox Admin and log in.

  2. Navigate to Reporting

  3. Select the Location you would like to pull the reports for

  4. Select the Date(s) you would like to pull the reports for

  5. Click View to launch the report

  6. When the report populates, you’ll be able to see each credit card transaction for the day, displaying:

    • Payment Info

    • Payment Status

    • Transaction ID

    • Transaction Dates

      • You’ll need the “Captured Date” for Deposit reporting

    • Transaction Amounts

  7. For reconciliation purposes, you’re going to need the Grand Total and if there are “Other Payments” (for things such as Gift Cards, Loyalty & House Accounts), subtract that from the Grand Total to calculate the total needed to compare to the Payment Provider.

CardPointe Deposits Report

To find deposit reports, in CardPointe dashboard:

  1. Select the Reporting tab

  2. Select Funding tab

  3. Set the Funding date

  4. Set the Funding location

  5. The report will automatically generate

  6. Additionally, you can choose to export it

Did this answer your question?