#poekie-payout-reconciliation

1 messages ยท Page 1 of 1 (latest)

harsh glacier
#

Hey! What field would you normally use to reconcile payments?

granite sundial
#

We're just moving over to this system, so there's not really a good comparison between before/after

#

How do people generally match payouts with invoices or, receipts for that matter?

harsh glacier
#

I guess it depends. For invoices, must people have their own sequential numbering system setup in Stripe that they'd reconcile with their own accounting systems

#

Otherse may use the description field of a Payment Intent

granite sundial
#

But everyone still needs to match the Stripe payouts with the individual invoices, correct? the only way to match this is using the reconciliation report, or am I mistaken?

harsh glacier
#

But everyone still needs to match the Stripe payouts with the individual invoices, correct?
Well, depends on your accounting requirements I guess!

granite sundial
#

Ok, interesting, I can look at that API

#

So my main question is, then: how can Stripe Checkout fill in the Description with invoice numbers, or receipt numbers, so I can match those?

harsh glacier
#

Can you share a specific Payment Intent that you're attempting to reconcile?

#

Trying to understand your integration

granite sundial
#

ok hold on ๐Ÿ™‚

#

pi_3KkyHEBy4su9ppSN1GqB3TQW

#

This payment intent is created by Stripe Checkout, and it has no description. If you then reconcile, it just says: 'subscription created'

#

and here is an example of a one-off purchase. pi_3KkcbiBy4su9ppSN0FWE7WLd. In this case, the receipt number would be helpful

harsh glacier
#

Sorry had to step away

#

Checking now

granite sundial
#

np!

harsh glacier
#

In the case of pi_3KkyHEBy4su9ppSN1GqB3TQW, you can reconcile via the invoice (in_1KkyHDBy4su9ppSNGlkR4ROk). Will be possible to get that data via that API doc I linked before!

granite sundial
#

Ok, yeah. So I don't think it's possible to get CheckOut to do this for me?

#

I'd need the API to create a report with the information I need

harsh glacier
#

So I don't think it's possible to get CheckOut to do this for me?
Do what?

granite sundial
#

to put the receipt number or the invoice number in the Description

#

I understand that I would be able to find the invoice number through the invoice ID, or the receipt number through the charge ID, but that's a lot of manual work unless I automate it in a way that my accountant understands it

harsh glacier
granite sundial
#

To go back to my original intent: I want to create a report where each payout is coupled to either an invoice number or a receipt number, so I can match those things together for our financial department. That's my goal. Stripe offers a reconciliation report that almost does what I want, except for not printing those numbers. I can try to make it to do what I want my populating the Description field with the required info, or I need to take an entirely different rout through the API you mentioned.

#

Is it maybe possible to alter the Payment Intent's Description field during a checkout completed webhook? ๐Ÿค”

granite sundial
#

Thx for the pointers, I guess I have a bit more digging to do. Too bad there's not something that works out of the box!

harsh glacier
#

I will relay your feedback re: description to the Checkout team!