Index
Getting started
Overview Adding locations Adding users Notification settings Profile page photos Updating your profile Search rankings
Payments
Overview Payment terms Invoices Setting up Stripe ACH payments in Stripe Tracking payments in Stripe Reconciling payouts in Stripe Setting up Payoneer Payment requests
Quoting
Overview Browsing opportunities Direct requests Declining opportunities Submitting a quote Modifying specs Packaging development requests Quoting international freight Tracking quotes Sharing a quote Messaging customers Customer Pricing List
Orders
Overview Accepting orders Sending proofs Adding production timeline Fulfilling orders Closing orders Canceling orders
On this page
Index > Payments

Reconciling payouts in Stripe

Lumi works with Stripe to provide convenient ways to reconcile payments and payouts.

Stripe issues lump sum payouts once per day. The payments included in each payout can be reconciled using the following workflow. Learn more about Stripe payments in our related guide: Tracking payments in Stripe.

Payment metadata in Stripe

Lumi automatically adds metadata to payments in Stripe so you can easily reconcile them with the right customers, invoices, and orders in your system.

You can find payment metadata by going to a payment in your Stripe dashboard and scrolling down to the section titled "Metadata". Payment metadata is also available as CSV columns in Stripe's payout reconciliation report (more on this below).

FieldDescription
clientNameDisplay name for the customer. Note this name can be edited by the customer in Lumi, but the Stripe metadata will always reflect the customer name at the time of the payment.
clientIdUnique Lumi identifier for the customer. Not editable.
invoiceNumbersUnique display number for Lumi invoices (comma separated)
invoiceIdsUnique Lumi invoice identifiers (comma separated). Matches the ID in the URL of an invoice in your Lumi dashboard e.g. /billing/{invoiceId}
orderNumbersUnique display number for Lumi orders (comma separated)
orderIdsUnique Lumi order identifiers (comma separated). Matches the ID in the URL of a purchase order in your Lumi dashboard e.g. /orders/{orderId}

Exporting and scheduling a payout reconciliation report

Stripe offers convenient reporting functionality so you can export a CSV of transactions in itemized or summary form. You can also schedule the report to be automatically sent daily, weekly or monthly.

  1. From your Stripe Dashboard go to Reports in the main navigation
  2. Choose Payout reconciliation
  3. From here you can use the date filters to create a one time report, or Schedule a report.

One time report

For a one-time report, choose the date range and preferred time zone for your export, then scroll down to "Payout reconciliation" and click Download. For "Columns" make sure to select "All" or use "Custom" to include the fields you want (we recommend including all the payment metadata fields).

Scheduled report

Click the Schedule button and follow the same recommendations as above. The report will be sent to your email address. If you want to send to a different email address, you will need to add them as a user in Stripe.

Looking up a Stripe payment in Lumi

If you know the invoice or order number, you can quickly access Stripe payments from your Lumi Dashboard:

  1. Go to your Billing view and click an invoice
  2. On the invoice go to the Payments tab
  3. The last column of the table has a link to Open in Stripe which will help you access details about the payment, and which payout it is a part of

You can also access invoices from the Orders view by going to the Invoices tab on any order.

Keep reading

← Tracking payments in Stripe
How to track payouts for your records.
Setting up Payoneer →
How to receive payments for suppliers outside of the US.