Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Stripe Invoices automatically_finalizes_at

Planned
Nicolas Muriel User

Connector name: Stripe

Table name: Invoices

Column to add: automatically_finalizes_at

API documentation link: https://docs.stripe.com/api/invoices/object


 

Additional details: This field is the only way to differentiate a draft pending for finalization from a draft that will remain a draft, then is the only field that can help us to differentiate Bookings (Revenue considered in advanced prior to invoice finalization) than just tests invoices (drafts without future finalized_at).

Without this field, is impossible to differentiate between useful and tests draft invoices.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Sadie Martin Fivetranner

    Hi Nicolas,

    This makes sense as an addition to the Stripe connector. I'll add it to our backlog and prioritize it. Stay tuned here for updates about when it's available.

    Best,

    Sadie Martin

  • Sadie Martin Fivetranner

    Hi Nicolas,

    Following up on this one. While automatically_finalizes_at is still on our backlog, I wanted to share a couple of columns already in your STRIPE.INVOICE table. They may let you separate real draft invoices from test drafts in the meantime:

    - AUTO_ADVANCE: when this is TRUE on a draft invoice, Stripe will finalize it automatically. Those are the same drafts that would have an automatically_finalizes_at value. Drafts with AUTO_ADVANCE = FALSE stay drafts until someone finalizes them manually.
    - LIVEMODE: FALSE for invoices created in Stripe test mode, so you can exclude those entirely.
    - STATUS_TRANSITIONS_FINALIZED_AT: the finalization timestamp, once a draft has actually been finalized.

    For example, to find upcoming bookings:

    SELECT id, customer_id, created, amount_due, auto_advance
    FROM stripe.invoice
    WHERE status = 'draft'
      AND auto_advance = TRUE
      AND livemode = TRUE;

    The main thing this doesn't give you is the exact scheduled finalization time.

    Could you try this and let us know whether it covers your bookings use case? If you need the exact timestamp, for example to forecast when revenue will land, tell us and we'll keep the column request prioritized.

    Best,
    Sadie