Financing, tax rates, and accounting
Hi There,
I have been attempting to find a way or an app that can help me breakdown each of my payouts by transaction and within each transaction pulling out:
Fx rate.
Shopify fee
Shopify Fee Vat
Insternational Transactiob Fee
International Transaction Fee VAT
The export file in payouts does not suffice for accountancy purposes as it groups the four types of fees above into one field in excel/csv.
I can see the full breakdown in the payouts section within the shopify app but I need this breakdwon in excel format.
Has anyone any experience with this? Have you used a finance app to do this for you?
I spoke with our shopify success manager and was informed this wasn't something offered in Shopify. There must be something out there that can automate this?
I am currently having to manually plug all of this info in, I can't imagine larger busiensses have the capacity to do this so there must be a solution out there!! Please could someone help me.
Thanks, Laura
Hi,
You can see the data that the transaction api provides here Transactions (shopify.dev)
It only gives the fee from your list. Without Shopify providing the data in the api its not possible for us to fetch it
Hi Jordan -
The information in the API is not enough. I need to export or create a file that can account for each fee in a separate column in a csv file.
Below is an example order.
I need the following to sit in a separate column within a csv/excel
Do I take it from what you are saying that this is impossible to do through Shopify or any other app as the API doesn't exist to facilitate exactly what I am asking?
Thanks, Laura
You are correct. The api does not have that data and so developers could not make you a custom app to get the result you want.
It would need to come from Shopify.
The year-end shopping spree is around the corner! Is your online store ready for the ...
By JasonH Nov 10, 2024We recently spoke with Zopi developers @Zopi about how dropshipping businesses can enha...
By JasonH Oct 23, 2024A big shout out to all of the merchants who participated in our AMA with 2H Media: Holi...
By Jacqui Oct 21, 2024