OOPS I totally messed up the calculation when it comes to profit margin which is actually calculated by subtracting all your fees (shipping, COG, platform fees) from your sold price and then dividing by your sold amount (x100 to get the percentage). So this is easy to adjust on the formula by just taking the earnings column / Sold Price x 100.
Hello, thanks for the video help. I will be trying to get this started asap. I just have a question. I see you have things listed in the tut by the month of Feb. Can I just have all my items listed and sort my date listed or date sold?
Hey Jasmine, how do you account for the exchange rate with Posh US sales? Your COG will be in CAD but sales and profit will have to be converted. Wondering how you track that if you're not converting funds immediately. Thanks!
Thank you... This was very helpful!
OOPS I totally messed up the calculation when it comes to profit margin which is actually calculated by subtracting all your fees (shipping, COG, platform fees) from your sold price and then dividing by your sold amount (x100 to get the percentage). So this is easy to adjust on the formula by just taking the earnings column / Sold Price x 100.
Thank you! This was so helpful! You can probably make some extra $$ by selling your templates to those who are just getting started.
I'm glad it helped! Hope it was easy to follow. Thanks for the suggestion! I'll consider it if I ever made a more complex one with data analytics 😊
Thank you so much for your generosity. I really needed this as a new thrifter.😊❤
Thank you! So helpful
Hello, thanks for the video help. I will be trying to get this started asap. I just have a question. I see you have things listed in the tut by the month of Feb. Can I just have all my items listed and sort my date listed or date sold?
Yes you can by going to the home tab and sort by oldest to newest and it should organize it by the date
Thank you ❗
Hey Jasmine, how do you account for the exchange rate with Posh US sales? Your COG will be in CAD but sales and profit will have to be converted. Wondering how you track that if you're not converting funds immediately. Thanks!
I usually put the sales price in USD and then a separate column when I actually cash it out for the current exchange rate. Hope that helps!
Everything is a total blur, literally. 😖
Sorry! Did you try the higher resolution?
💖💜💟👍💙👍👍👍💜💕💚👍👍👍👍👍💙❤👍💚👍👍👍💖💜💟👍👍💕💚👍👍💖💖👍👍👍💕💟💙❤👍💚👍👍👍💖💜💟👍💙👍👍👍💜💕💚👍👍👍👍👍💙❤