jaked - unpaid invoices | Stripe Developers | Page 1

swift hullBOT Mar 7, 2023, 4:47 PM

#

true scroll Mar 7, 2023, 4:48 PM

#

Good question, are you asking about how to identify such customers, how to mark their invoices as unpaid, or both?

#

jaked - unpaid invoices

fiery comet Mar 7, 2023, 4:49 PM

#

Both I suppose. I was thinking maybe I start by listing all invoices with due dates of say lt 1yr ago

#

As that would have to be cancelled users b/c we only have 3 attempts to pay an invoice... so no invoice due over a yr ago would be tied to a valid customer anymore

#

I think.. lol

#

Hrmmm... Just tried to search invoices and got a 500 back from Stripe API

#

https://dashboard.stripe.com/logs/req_yoZe3fvbuN1PqV?t=1678208335

Stripe Login | Sign in to the Stripe Dashboard

Sign in to the Stripe Dashboard to manage business payments and operations in your account. Manage payments and refunds, respond to disputes and more.

#

It looks like the due_date is actually null on these old invoices which are open

#

I also see the attempt_count so I could look for attempt_count = 3, next_payment_attempt = null, status = open, due_date = null

#

Ok well crap.. cant do that b/c those are unsupported

#

I guess I'll use Sigma to write a report.. then use all the invoice ids from that via the api to mark uncollectible

true scroll Mar 7, 2023, 5:16 PM

#

Apologies for the delay, bouncing between a few threads but should be quicker going forward.

Yeah the attempt count would probably be the more straightforward way to find these invoices but you are right that you will probably have to use Sigma. Otherwise you could do this with the API but you'd have to filter through all of your invoices over a certain time

That 500 should be a transient error, if you try again is it still happening?

#

Can you actually tell me a bit more about your subscriptions and retry setup? Are these all monthly subscriptions and are you using smart retries or a specific schedule?

fiery comet Mar 7, 2023, 5:17 PM

#

Yeah I got it a few time.. if I didn't supply a status property in the search

#

Yeah they are all monthly subscriptions..on 3rd failed attempt for payment we cancel the subscription. But the invoice stays open. Or it did until we recently changed the setting that says to mark it as uncollectible.

true scroll Mar 7, 2023, 5:30 PM

#

Gotcha, yeah I think that retry count is probably your best bet.

#

I do see that your schedule retries once after 3 days and again 7 days after the initial failure. So you may even be able to look at any still open invoice that from a week before you changed these settings right?

fiery comet Mar 7, 2023, 6:05 PM

#

Do uncollectible invoices get removed from Rev Recognition reports? I just looked in our 1-30 day aging report and an invoice is in there that is already marked as uncollectible? Do those reports lag a bit/

#jaked - unpaid invoices