Reconciling Payments

In this article, we’ll take a look a how financial reports in Lunchbox Reporting compare to financial reports in Lunchmoney (PARPay).

Table of Contents

To ensure that payment information is accounting properly, compare financial reports between Lunchbox and the Payment Processor; Lunchmony (PARPay). In this article, we’ll take a look at the reports that ensure that Transactions and Deposits are matching between the 2 systems.

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

Step 1: Navigate to the Lunchbox Admin and log in.

Step 2: Navigate to Reporting.

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

Step 4: Select the Date you would like to pull the reports for.

Step 5: Click View to pull to launch the report.

Step 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:

Step 7: For this example, let’s look at Order #224207 for $28.14

To pull Transactions from PARPay, you’ll need the “Transactions” Report.

Step 1: Navigate to the PARPay Portal and log in.

Step 2: Select the Location you want to pull the reports for.

Step 3: Navigate to the Transactions tab.

Step 4: Select the Filter option and select the Date you would like to pull the reports for and click Apply to filter the data.

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

Step 6: For this example, let’s look at Transaction ID #51034432 for $28.14:

On these reports, you can compare partially and fully processed transactions, refunds and make sure the individual order information is calculated correctly.

To match these 2 reports, you can use the following to pinpoint specific transactions:

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

Step 1: Navigate to the Lunchbox Admin and log in.

Step 2: Navigate to Reporting.

Step 3: Select the Location you want to pull the reports for.

Step 4: Select the Date you want to pull the reports for.

Step 5: Click View to pull to launch the report:

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

Step 6: 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.

To pull Transactions from PARPay, you’ll need the “Transactions” Report.

Step 1: Navigate to the PARPay Portal and log in.

Step 2: Select the Location you want to pull the reports for.

Step 3: Navigate to the Deposits tab and find the column labeled “Deposit Date”.

Note: Deposit Date = Gross Deposit Ammount - Accrued Fees - Chargeback Amount

Step 4: Find the Deposit line that is 2 days after the “Captured Date” found in the Lunchbox Report (example: 7/26 Captured Date in Lunchbox would be 7/28 Deposit Date in PARPay)

Step 5: Compare the Grand Total (minus Other Payments) in Lunchbox with the Net Deposit Amt in PARPay taking into consideration the 2-day difference.

To manage Chargebacks in PARPay, use the following instructions:

Step 1: Navigate to the PARPay Portal and log in.

Step 2: Select the Location you want to manage Chargebacks for.

Step 3: Navigate to the Chargebacks tab and find the column labeled “Deposit Date”.

Note: If you are looking for more info regarding this info, you can pull the “Credit Details” Report and find the order using the Transaction Date and Amount.

Step 4: To manage the Chargeback, click on the arrow next to the ID and a side panel will open up where you can add notes, documents, etc. before the “Reply By” Date: