This video is amazing. It reminded me to include sub-totals into my spreadsheet and gave me a few useful tips which have made it a lot easier to see what costs me the most. Thanks heaps for filming this back when I was in primary school, It's having a lasting positive impact on unsure people like me
Thank you for your step by step guide on how to use the spreadsheet as I am totally number illiterate! Starting out in business is a struggle for me with knowing the easy way to price up my products to enable me to make a profit and not a loss, Catherine
thank you very much for this video, i feel like i pro after watching it. i have saved it for future use cos knowing me i'll forget how i did it the first time round
I have a similar spreadsheet that I have been using for years. I am trying to update it to work out a "Floor" price for selling items that includes a 10% profit margin and also the selling fees between various marketplaces, ranging from 10-14%. I can't get my head around that formula. Any suggestions?
@@BookkeepingMaster It's more complex than that. Selling fees vary depending on the sell price. So the amount needs to be worked backwards not forwards. I'll keep trying to find the answer. Thanks for responding.
Quick question. How can I determine how much I'm spending to make and sell a T-shirt. Like the price of the vinyl, how much vinyl I'm actually using to make the shirt ( how much it costs per inch) and the cost of the actual shirt itself. Don't want to short change myself. Thanks so much. New subbie here.
Hi I hv been selected to a admin job. But they asked me to do accounts. I really dont knw anyting abt account. But my friend said if I see sm videos I cn catch it. do u thk is it possible? If so wht I hv to do nw? Plz help me.
This spreadsheet is incorrect as ebay and paypal fees come from your selling price including postage, not cost price ex postage. They always take their percentage from retail incl post.
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](http://i.ytimg.com/vi/msQoTuCsKJ4/mqdefault.jpg)
![โอ้เธอช่าง... - บี้เดอะสกา ft. ต๋อง เทวัญ (Prod. by ป๋าเพชร) [Official MV]](http://i.ytimg.com/vi/zbWhiLFmVL0/mqdefault.jpg)
![MV วิถีชีวิตใต้ - ผา อัยย๊ะ [Official MV HD]](http://i.ytimg.com/vi/nODlkOUu9B0/mqdefault.jpg)
This video is amazing. It reminded me to include sub-totals into my spreadsheet and gave me a few useful tips which have made it a lot easier to see what costs me the most. Thanks heaps for filming this back when I was in primary school, It's having a lasting positive impact on unsure people like me
Thanks for the great comment
Thank you for your step by step guide on how to use the spreadsheet as I am totally number illiterate!
Starting out in business is a struggle for me with knowing the easy way to price up my products to enable me to make a profit and not a loss,
Catherine
Glad it was helpful! Thanks for taking the time to comment.
Thank you- this video has given me reassurance that I was on the right track with my costing spreadsheet. Thank you for filming this!
Glad it was helpful! Thanks for watching.
This is exactly what I have been looking for, thank you so much this is perfect and very well explained.
Thanks for watching.
thank you very much for this video, i feel like i pro after watching it. i have saved it for future use cos knowing me i'll forget how i did it the first time round
Super helpful video! Thank you so much!
Your kind words are much appreciated. Thanks for watching
thank you this is very helpful. ♥from Philippines
Thank you so much
I have a similar spreadsheet that I have been using for years. I am trying to update it to work out a "Floor" price for selling items that includes a 10% profit margin and also the selling fees between various marketplaces, ranging from 10-14%. I can't get my head around that formula. Any suggestions?
=thecellwithcostprice*0.10
Does this help at all?
@@BookkeepingMaster It's more complex than that. Selling fees vary depending on the sell price. So the amount needs to be worked backwards not forwards. I'll keep trying to find the answer. Thanks for responding.
Quick question. How can I determine how much I'm spending to make and sell a T-shirt. Like the price of the vinyl, how much vinyl I'm actually using to make the shirt ( how much it costs per inch) and the cost of the actual shirt itself. Don't want to short change myself. Thanks so much. New subbie here.
calculate how much the material in bulk cost then divide that by what your using per item. Then subtract from your selling price.
Thank you, really helpful and exactly what I wanted!
+John Brett No problem. Please check out my website for more free videos.
Exactly what I needed! Cheers!
No problem. Thanks for watching.
Thank you. So helpful!
So glad! Thanks for watching
Great video, thank you. I was wondering why you merged the cells in the beginning of the video.
Just habit. You can adjust the size of the cells instead. Thanks for watching.
How do you workout a selling price based on a desired profit?
Work backward. Start with the profit you wish to make, add all expenses, you will then have the selling price. Thanks for watching.
Thank you very much
No problem. Thanks for taking the time to comment.
Hi I hv been selected to a admin job. But they asked me to do accounts. I really dont knw anyting abt account. But my friend said if I see sm videos I cn catch it. do u thk is it possible? If so wht I hv to do nw? Plz help me.
This spreadsheet is incorrect as ebay and paypal fees come from your selling price including postage, not cost price ex postage. They always take their percentage from retail incl post.
Its not incorrect if you're not charging the customer for shipping. But you are correct if you are charging the customer a separate shipping fee.
can we have the template?
I may have one saved on my desktop. Send me an email and I will see what I have got - info@bpfs-online.com
I emailed you and haven’t heard anything back. I could send you a donation for the file.