How can we help?

Lightspeed’s Help Centre is here to provide support, tips and troubleshooting

Reconciling Payments on Stripe and Lightspeed Ordering

Want to know more about payments? Check out reports on Stripe and Lightspeed Ordering's Venue Manager

Amounts received in your bank account may not not be equal to the total value of orders made on a particular day. This is due to the way Stripe groups payments for payout as explained in Receiving Payments for Orders.

Once you're clear on Stripe's payment processes, you might want to dig deeper to understand the makeup of each payment or find out answers to other questions about the funds received. 

Below you'll find an outline of some reports that can be useful when making reconciliations. 

 


What's In This Guide?

 

Stripe View: Balances

Use this view to answer questions like...

"What funds are being held in my Stripe account and when will they be paid out?"

Here you can quickly identify what funds are on their way to your bank account and an estimation on future payouts. 

mceclip4.png

Not receiving payouts? Please see our guide on Receiving Payments for Customers' Orders.

 

Stripe View: Payouts 

Use this view to answer questions like...

"What are the amounts I should be receiving in my linked bank account?"

  • Go to your Stripe Dashboard.

  • Select "Balances" in the side menu.
  • Select "Payouts".

The amounts shown here will match directly with those received in your bank account. Click "Export" for more detailed data. You can also drill down into each payout to see individual payments and fees applied to each transaction. 

mceclip5.png

Not receiving payouts? Please see our guide on Receiving Payments for Customers' Orders.

 

Lightspeed Ordering's Report: Payments by Day  

Use this report to answer questions like...
"How much have I paid in fees for the past X days/weeks/months?" 

  • Go to your Lightspeed Ordering's Venue Manager
  • Click "Reports" in the toolbar at the top of your screen.
  • Select "Payments By Day" on the side menu.
  • Enter the desired date range and select Group By: Arrival Date.
  • Click "Run Report".

The daily totals in the Payment Due column should correspond with the amounts received in your bank account. If there's a slight discrepancy, it will balance out the following day (this would be due to subtle variations in Stripe's processing times). Scroll down for a description of the columns included.   

 

Lightspeed Ordering's Report: Payments by Order 

Use this report to answer questions like...
"What orders were included in the Stripe payout I just received in my bank account?"

  • Go to your Lightspeed Ordering Venue Manager.
  • Click "Reports" in the toolbar at top of screen.
  • Select "Payments By Order" from the side menu.
  • Enter the desired date range and select Group By: Arrival Date.
  • Click "Run Report". 

This report groups individual orders using Stripe's time zone so that you can understand the makeup of each Stripe payout received in your bank account. Scroll down for a description of the columns included.

 

Lightspeed Ordering's Glossary 

Column Description
Trading Date The day the order was made in your venue's local time
UTC Date The day the order was made in UTC time
Arrival Date The expected arrival date of the payout from Stripe
Order Amount The total value of orders (before discounts)
Discount Amount The total value of discounts on orders
Payment Amount The total amount paid by the customer (after discounts)
Payment Fee Fees applied to orders (These include Lightspeed Ordering fees & any other fees)
Payment Due The payout due for each day. 

 

Exporting Data from Lightspeed Ordering

You can export data from Reports on Lightspeed Ordering's Venue Manager using the small icon in the upper right corner of screen. Click this and then select "Excel" or "CSV".                                             

Screen_Shot_2020-04-22_at_8.00.38_am.png

 

Frequently Asked Questions 

How many businesses use Stripe? 

Millions of businesses from startups to large enterprises use Stripe’s software and APIs to accept payments, send payouts and manage their businesses online.

 

What's Stripe's uptime? 

Stripe's systems operate 99.9%+ of the time. 

 

Was this article helpful?
0 out of 0 found this helpful