Nettla adds metadata to every payment it sends to Stripe. When you export payments from Stripe, each field appears as an extra column on the right of the CSV file.
Fields on booking and one-off payments
bookingId – the booking in Nettla.
bookingType – the type of booking, for example a court booking or an activity.
paymentId – the payment in Nettla.
customerId – the player in Nettla.
clubId – the club the payment belongs to. Use it to split income per club if several clubs share one Stripe account.
sessionId – the checkout in Nettla.
receiptDescription – the description shown on the receipt.
pointsUsed – how much was paid with a club wallet, in whole currency units (rounded).
bookingDates – the date or dates the session takes place, in your club's time zone.
lineItems – what was bought (see below).
What's in lineItems
A list with one entry per item bought. Each entry has:
name – the product name.
quantity.
unitPrice.
discountAmount – any discount code amount (the code's name isn't included).
taxRate – the tax rate % for that item.
Additional items appear as their own entries. For a pay your part lead booker, lineItems is updated to the final amount when the payment is charged.
Fields on membership payments
membershipId, paymentId, customerId, clubId, sessionId and lineItems.
Fields on guest payments
Payments made without logging in also include userEmail, userName and isGuestPayment.
Good to know
The Stripe Description shows the type of purchase followed by the receipt description.
The IDs help you match Stripe payments with data from integrations such as Mixpanel, BigQuery or Google Sheets.