[Investigate] Discrepancy between line item amounts and invoice amounts

[fivetran-reneeli]

Is there an existing issue for this?

• I have searched the existing issues

Describe the issue

In our internal Stripe data, we've noticed that not all amounts in the line item table tie up to the amounts in the invoice table, when summed up to the invoice grain. So far it's been identified that it ties to a subscription amount found in the price_plan table.

We should confirm whether this is something buggy with our data, or if this is indeed expected and we should make adjustments in our logic.

Relevant error log or model output

No response

Expected behavior

Invoice line item amounts sum up to the amounts in the invoice table

dbt Project configurations

na

Package versions

na

What database are you using dbt with?

other (mention it in "Additional Context")

dbt Version

na

Additional Context

No response

Are you willing to open a PR to help address this issue?

• Yes.
• Yes, but I will need assistance and will schedule time during our office hours for guidance
• No.