#ashleyyy_api
hoary locustBOT
👋 Welcome to your new thread!
⏲️ We'll be here soon! Typically we respond in a few minutes, but sometimes we might take a bit longer if the server is busy or if you have a particularly tricky question.
⏱️ We close idle threads, which makes them read-only. Once a thread is closed it won't be reopened, but you can always start a new thread if you have another question.
🔗 This thread will always be available, even after it's closed. You can find it again using Discord's search, or you can save this link: https://discord.com/channels/841573134531821608/1488295111854129464
📝 Have more to share? Add more details, code, screenshots, videos, etc. below.
hushed rose
CSV attached, the highlighted ones are unpaid so shouldn't be here
ancient kettle
👋 taking a look here
hushed rose
okay actually I don't know how the version I have on my computer managed to highlight rows when the extension is .csv? I bet slack did something weird that discord isn't doing.
A couple example ones are in_1SvRcpC7hUs4wr8noEqEKAGp, in_1So3bEC7hUs4wr8nSrwR7amu, and in_1SkCrUC7hUs4wr8nfencYdiw
ancient kettle
Appreciate your patience here. So i'm not seeing an available column that would show the invoice status in the report that you could filter off of. Trying to think if there are any creatives solutions here.
hushed rose
Our goal here is to provide the connected account with an easy way to total the VAT they're liable for. I haven't looked at the reporting api carefully, but Is there another report we should be using?
ancient kettle
Our team doesn't have the same level of familiarity with the Reporting API as we do with most of the others, but I'm happy to take a look.
One thought was to use the List Invoices Method, to get a list of Invoice ID's filtered by status https://docs.stripe.com/api/invoices/list, then use that list to cross reference the ID's in the tax report to filter the report down to paid invoices only.
I keep digging to see if there is a more straight forward approach
arctic hornet
Hi there - I'm taking over for mossy, who needs to run
hushed rose
Thanks mossy! Hi palamedes! I think if the only option is to look up the data ourselves we can figure it out. It seems odd that this report would include the unpaid invoices. From the name of it, I'd be expecting it to be a list of transactions, not invoices
arctic hornet
Yeah, exactly
You can tell which results in the report for transaction where the type is Invoice (column type) but you have to use the Invoices API from there to identify the status
hushed rose
okay! That's not really going to scale well but we'll do what we have to 😬. Any chance you can pass this on as a bug or feature request or whatever?
arctic hornet
Yeah for sure. Could you give me just a touch more detail on what the business case is? I understand the information you're looking for, but why is it important?
It helps us prioritize feature requests where there is a real business need
hushed rose
So for EU and UK taxes, our connected accounts are liable for their own remittances. We had been using this report to provide them with a way to track the transactions they would need to file taxes for. It's almost exactly what they need, it's got the currency, the country, the amount of tax, everything. But if it's not an accurate representation of all the taxes that were actually paid, what ends up happening is the total owing is higher than it actually should be and they overpay. And then they come to us wanting compensation.
If we're going to be querying your other API endpoints to check the data in this report, we'd might as well be building our own. Which we don't want to do, we want to focus on adopting other exciting features instead 😄
Anyway, appreciate the help and I love your avatar. Have a great rest of your day