POSHMARK SPREADSHEETS & BOOKKEEPING | How I keep track of all my sales, inventory, and data

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2024

ความคิดเห็น •

  • @HannahAlonzo
    @HannahAlonzo  3 ปีที่แล้ว +19

    Forgot to add! When entering items into the yellow section for my inventory, I organize them alphabetically! Makes items super easy to find when copying/deleting those rows up into the “sold” category 🥰 You can also add a column for “inventory bin” if you have a number or letter-based inventory storage system!

    • @adnanshahzad2399
      @adnanshahzad2399 3 ปีที่แล้ว +1

      Can you share your personal excel file as a viewer access ?

    • @TheLCJ82
      @TheLCJ82 3 ปีที่แล้ว

      If you did this in excel you can use the filter and search by title (which is set up alphabetically)

    • @MihaelaRo
      @MihaelaRo 3 ปีที่แล้ว

      How do you organize them alphabetically?

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +3

      When I bring him new inventory, I just insert rows manually throughout the inventory section to keep them all alphabetical. But you can also highlight the rows and right click on “sort by A-Z”

    • @dominickpadenou8456
      @dominickpadenou8456 3 ปีที่แล้ว +1

      could you make a how to video plz, because i want to make a column for employees earnings

  • @annaskelly4867
    @annaskelly4867 ปีที่แล้ว +3

    This is sooo helpful! I just talked to my accountant on how to deliver the necessary info to him for my taxes and this is basically what he was asking me for. Thank you SO much!!

  • @amberquibodeaux9340
    @amberquibodeaux9340 2 ปีที่แล้ว +1

    Oh my gosh oh my gosh OH MY GOSH! IVE BEEN SEARCHING FOR A SPREADSHEET OF THIS NATURE WITH INVENTORY, SALES , AND EXPENSES AND AT LAST, FINALLY I FOUND ONE! THANK YOU YOU'RE A LIFE SAVER! After IVE SEARCHED AND SEARCHED AND SEARCHED! Whew, I was getting worried there for a minute that I wouldn't find one. Go Daddy Bookeeping shut down...I just don't understand why people wouldn't include all these three necessities together in their spreadsheets!

  • @abbywebster2725
    @abbywebster2725 3 ปีที่แล้ว +10

    I have not been doing ANY sort of bookkeeping pertaining to my Poshmark sales so this is honestly such a blessing!!

  • @msvandy1
    @msvandy1 3 ปีที่แล้ว +7

    Thanks Hannah. You're the best Poshmark TH-camr out there!

  • @katrinaidstein9756
    @katrinaidstein9756 3 ปีที่แล้ว +8

    I've been looking for a free template that would work for me! I think I've found it and I appreciate you so much for simply giving this to us!

  • @pamelahood1409
    @pamelahood1409 3 ปีที่แล้ว +9

    Thank you so much! I really needed a spreadsheet but it was a little intimidating. You made this so simple for me!! Thanks again for sharing 🤗

  • @aubabig5091
    @aubabig5091 3 ปีที่แล้ว +2

    GREAT JOB! I use spreadsheets ALL The time for my full time work and you did great! I LOVE that you added a graph. That i do not use in my full time job but love that i now have it for my part time posh job :)

  • @Justthefurofus
    @Justthefurofus 2 ปีที่แล้ว

    It made a lot of sense and I was just listening and not actually watching. I like numbers and organized graphs so… I really enjoyed this video! Thanks!!

  • @brucetidwell7715
    @brucetidwell7715 3 ปีที่แล้ว +5

    I'll say this first...Hairy Tornado (Josh) here on YT also interviewed NotYourDadsCPA on his channel last week. Probably a lot is the same but Josh did a Q&A format so it may cover some different details.
    Hannah, as usual...Yes, it was very helpful! And Thank You! I have a spreadsheet but I'm definitely adding colums for Days to sale/ Time/ Strategy and I hope I can import your graph creator. That is awesome! I'm going to look at the other one you mentioned, as well. Having the tax estimate is great.

  • @Alexandra4JC
    @Alexandra4JC ปีที่แล้ว

    This one is the best I've seen yet! The others are so complicated. Thanks!

  • @janickdesruisseaux68
    @janickdesruisseaux68 3 ปีที่แล้ว +8

    Great spreadsheet! For the formula automatic change ; it will do it by itself if you add lines in between the existing lines in the original formula ( exemple instead of adding a line under 16 add it between 14 and 15 and it will be included in your existing formula) 🙂

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +1

      Yes absolutely! Thank you for pointing this out, it completely slipped my mind while filming the video. I usually do insert rows in the middle of the “inventory” section because I organize it alphabetically, but I list my sales chronologically by sell date in the top green section so I add rows to the bottom and always have to update the cell ranges. Thanks you so much!

    • @shawnmariemann
      @shawnmariemann 3 ปีที่แล้ว +1

      @@HannahAlonzo just keep at least one blank row at the bottom of the section and then add your new rows between your last data row and the blank row. Then you can still do by date like you want to. Just always keep one row blank at the bottom.

    • @RivaSueZ
      @RivaSueZ 3 ปีที่แล้ว

      In order to remind yourself to add rows before you use the last row in a section you could simply put "ADD ROWS NOW" in the A column as the last row of the calculated formula for each section, Solds, Inventory or Expenses.

    • @sarah3gee
      @sarah3gee 2 ปีที่แล้ว

      Super late to the party here lol. Their ways work probably better than this but another option you do have is to sum out the column. So the same way you looked at the average, you can also select it all and select the sum button and it will put your total to the right or bottom of whatever you click. So if you’re selecting a horizontal row, the cell in the next column will show your sum or if you’re selecting a column, vertically, the next cell underneath will show your sum. Just click on the “sum” button once everything is selected.

  • @Rdvm-qv2xo
    @Rdvm-qv2xo 2 ปีที่แล้ว

    Hannah! Thank you very much for sharing. I'm a dinosaur and it really helped me. Now I just have to go to help with google sheets and study up on the "function" tool. Thanks again!!

  • @bobbieprado4746
    @bobbieprado4746 3 ปีที่แล้ว +4

    Hello! I've watched all your videos and have been using your spreadsheet since March 2021 when I started reselling. Your videos have helped me tremendously; Thank you so much! Can you please tell me what you do with your spreadsheet when a new year starts. I'm so confused. I downloaded a new spreadsheet for 2022 but what do I do when something that was purchased in 2021 and logged in as an expense in 2021 but sold in 2022? Do I add the sale to my 2022 spreadsheet and not add the what I paid for the item? I'm thinking of I do my expenses will be off since it was accounted for in 2021. Please advise! 🙏

  • @amandajkrieger
    @amandajkrieger 3 ปีที่แล้ว +4

    I'm excited to use this! Thank you for sharing your spreadsheet. :)

  • @KimNguyen-nx5kx
    @KimNguyen-nx5kx 3 ปีที่แล้ว +2

    So glad I found your channel! 💕 this spreadsheet because of its simplicity! Thanks so much for sharing!! I’m not savvy with technology and was in search of an easy spreadsheet to use! I’m a visual person so definitely love the graphs 📈! Subbed to your channel!

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      Thanks for watching Kim! So happy you’re here! 🥰

  • @triciacampbell8687
    @triciacampbell8687 2 ปีที่แล้ว +2

    Thank you for the spreadsheet! Just what I was looking for 😊

  • @bethglenmaddie
    @bethglenmaddie 2 ปีที่แล้ว

    I love this! I am like you, not a clue how to do this stuff but I think this looks awesome! I tried clicking on Jen's link but there's nothing there? Anyway, I will definitely be using your system here, it makes total sense to me, I think you've done a fine job!! As I sell on various platforms I will just do one for each place, no biggie. Give yourself a pat on the back, you did great! Thanks for sharing this!

  • @juliannabooks1593
    @juliannabooks1593 3 ปีที่แล้ว +3

    This is a perfect spreed sheet for me. It’s simple and easy to use. Thank you so much

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      Oh I’m so glad to hear that! It doesn’t have all the bells and whistles but it’s served me well so far 😊

  • @zerluu
    @zerluu 3 ปีที่แล้ว +1

    You made poshmarking so interesting.. Iv never done this you kinda convinced me to do it a d excited for it.

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      That’s so awesome! Thanks for watching!

  • @Andigl100
    @Andigl100 3 ปีที่แล้ว +2

    HI! Thank you for this! super helpful. I do have a question. When you sell in a bundle, lets say you sell two items how do you distribute the earnings and all that within the two lines? Not sure if Im explaining myself correctly... But I appreciate the input thanks.

  • @luceroherrera2051
    @luceroherrera2051 3 ปีที่แล้ว +5

    Thank you so much Hannah! I have learned so much from your videos in a short period of time :)) quick question, do you include the sales tax on the "expenses" items? For example if the poly mailers are $15 is that with tax included or just regular price?

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +3

      Great question! I always include tax

  • @lsacks9196
    @lsacks9196 3 ปีที่แล้ว

    Thank you! This is the best spreadsheet I have seen period.

  • @explorationtogetherness4588
    @explorationtogetherness4588 2 ปีที่แล้ว +1

    Are you planning on putting up an updated spreadsheet for 2022? 🙌

  • @TheLCJ82
    @TheLCJ82 3 ปีที่แล้ว +1

    What about highlighting the cells already there and copy and paste below the last filled line..then delete the copied info. I think that it would default to calculating if you do that

  • @lubaleong9619
    @lubaleong9619 3 ปีที่แล้ว

    Thank you for sharing your method and spreadsheet with us!

  • @annawelker6446
    @annawelker6446 3 ปีที่แล้ว +3

    Thank you for posting such educational posh videos, you are truly my Poshmark idol. I do have a question ... if I offer a lower price to a liker with a discount of shipping and they counter, does my discounted pricing of $4.99 or free still apply to their counteroffer?? Or does the shipping go back up to $7.11??Thank you for providing us with your knowledge, it’s greatly appreciated:)

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +4

      Thanks for watching Anna, I’m happy the videos have been helpful! When they counter back, they lose the shipping discount so they will have to pay their offer + $7.11 shipping 😊

    • @annawelker6446
      @annawelker6446 3 ปีที่แล้ว +1

      @@HannahAlonzo thank you! This was incredibly helpful

  • @nilumifernando3314
    @nilumifernando3314 3 ปีที่แล้ว +1

    Thanks a lot for sharing your Spreadsheet...!!

  • @nanap9061
    @nanap9061 3 ปีที่แล้ว

    For beginners like me, this is sooo helpful 💯🗓. As always I appreciate your honesty😊!!

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      Happy I can help! ❤️

    • @nanap9061
      @nanap9061 3 ปีที่แล้ว

      @@HannahAlonzo but then when I tired it it was a little difficult for me. See my other comment.

  • @cecef824
    @cecef824 2 ปีที่แล้ว +1

    I started using your spreadsheet a few days ago. Should you use the same spreadsheet as you used last year, or do you make a new spreadsheet every year?

  • @nebbypal
    @nebbypal 2 ปีที่แล้ว

    Hello Love Thank you so much for sharing this will help me.😊

  • @TheCozyCrimeCorner
    @TheCozyCrimeCorner 3 ปีที่แล้ว +1

    Hi! So, do you change the listing price in your spreadsheet when you mark down your items in your closet?

  • @helloimjen7
    @helloimjen7 3 ปีที่แล้ว

    Thank you so much Hannah!! You are the besttt! I hope your move is going well but I miss your videos! 😩💕

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      Thanks for watching Jennifer! I am itching to get back to posting too!! Hopefully next week! 🤞🏼🤞🏼🤞🏼

  • @carolbednarek6337
    @carolbednarek6337 2 ปีที่แล้ว +1

    This is just an example. To add a total of items, the formula is =SUM(E6:E17)

  • @lifewith_les
    @lifewith_les 2 ปีที่แล้ว

    I appreciate the spreadsheet, you made my life easier :)

  • @jnl.
    @jnl. หลายเดือนก่อน

    to have your formulas for totals stay the same u could put each chart on a diff tab and put the total row above the itemized rows so that row never changes position.

  • @katiezielinski5422
    @katiezielinski5422 3 ปีที่แล้ว

    Thank you SO much for providing this spreadsheet!! :)

  • @str8apache
    @str8apache 2 ปีที่แล้ว

    Thank you for this video and this spreadsheet.🤗

  • @rnabeel6296
    @rnabeel6296 ปีที่แล้ว

    Thank you for the video❤ but why add Fees when the app shows your earnings next to the Item sold? Also you can see details and then you can see that poshmark took their share?!I'm little confused would love tour help with this please❤

  • @debescobar6624
    @debescobar6624 3 ปีที่แล้ว +1

    Do you just copy the item out of inventory and put it into sold when it is sold?

  • @bluemayyss6116
    @bluemayyss6116 3 ปีที่แล้ว

    Thank you soo much for posting this video , I needed this soo much so easy and simple. Your great thanks

  • @trishastorm9813
    @trishastorm9813 2 ปีที่แล้ว

    Thank you Hannah. Love this spreadsheet ❤️

  • @MarlenaNicholeJ
    @MarlenaNicholeJ 3 ปีที่แล้ว

    You are so organized and awesome 💯

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +1

      Thank you for your sweet comments! You’ve brightened my day 🥰

  • @ME-tp8em
    @ME-tp8em 3 ปีที่แล้ว +1

    Makes so much sense, thank you 🙏🏼

  • @OrionCorner
    @OrionCorner 3 ปีที่แล้ว

    Thank you I appriciate for sharing that's what i needed.

  • @christineking6687
    @christineking6687 2 ปีที่แล้ว

    Hi I copied this spreadsheet. I was signed in with my Google account. Had all my stuff on there. I feel so stupid. I thought I saved it. Went to look for it and it would only show yours. What did I do wrong?
    I figured it out. I t works now. Thank you for sharing this spreadsheet.

  • @TheCozyCrimeCorner
    @TheCozyCrimeCorner 3 ปีที่แล้ว

    This has been really helpful!!! However I have a few questions.
    Do you not include price paid for items, fees, and shipping discounts in your total expenses since they are investments? Or do you not include them because you profited from the sale?
    Also before going to your cpa do you add cost of goods unsold into your expenses?
    Thank you!!

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      Hey there! If I’m understanding your question correctly, I do not count fees or shipping discounts as expenses. I do count the price paid for inventory as an expense. I do not have a CPA but I did include cost of goods unsold in my expenses for 2020. Although you don’t have to! I highly recommend watching the “Reselling Taxes Q&A” live recording on abritishposher’s Instagram account for more detailed tax info!

  • @lorisawyer527
    @lorisawyer527 3 ปีที่แล้ว

    Thank you, thank you. This is just what I needed.

  • @LizGarrisonReaLiZeU
    @LizGarrisonReaLiZeU 3 ปีที่แล้ว

    This is great and I so love your channel but I’m curious if you’ve seen the free Spreadsheets offered by Poshmark under seller tools. It tracks your inventory and your sales seamlessly and tells you if it was bought on an offer or up. There is a slight gap between the souls and the inventory of items that are shipped but haven’t been excepted by the buyer but that can easily be fixed periodically. I love the spirit of you giving away what you have done for free.

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      Thank you for watching and for your kind words! Yes, I’ve seen those and occasionally I’ve downloaded the inventory report to see how long certain items have been listed for. I just didn’t love the layout and I like to have my sales and inventory in one place 😊

  • @ashleylovelace4477
    @ashleylovelace4477 3 ปีที่แล้ว

    What would you do if you donated stale inventory? How would you document that on this spreadsheet?

  • @annbernard502
    @annbernard502 ปีที่แล้ว

    Hannah,, I have an apple Mac and there is no "make a copy" under file? is it called something else?

  • @michelleh4114
    @michelleh4114 2 ปีที่แล้ว

    Ty ty ty helps so much fir a newbie

  • @richsmith4363
    @richsmith4363 3 ปีที่แล้ว

    Thanks for sharing your spread sheet.

  • @jillr759
    @jillr759 3 ปีที่แล้ว

    Hi Hannah, Thank you so much for sharing first of all! Do you color code each month sold? Now that Im entering my inventory I'm wondering how you add a new month for sales? Im a RN and so computer ignorant it humiliating! I was thinking if I could color each month in the sole section how cool would that be. I have NO idea how to do it or an suggestions anyone????? Love all of you for working so hard.

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +2

      I don’t color code by month, but you absolutely could! Just click on the row numbers (far left column on your screen) to highlight the rows you want, then go up the the icon at the top of the spreadsheet that looks like a paint can tipping over. That will allow you to change the color of the rows to whatever you want!

    • @jillr759
      @jillr759 3 ปีที่แล้ว

      @@HannahAlonzo omg I will be so nervous ha ha ha but im serious! Need heart surgery im all yours but color coding hell no! thank you Hannah!

    • @gianniray1
      @gianniray1 3 ปีที่แล้ว +1

      You could also add new tabs at the bottom of the sheet by clicking that plus sign lower left corner and label each tab by month and just copy and paste solds into their month sold to keep things separated.

  • @terripieper7090
    @terripieper7090 2 ปีที่แล้ว

    How do you pay yourself? Is it a flat rate or a percentage?

  • @lisarose6905
    @lisarose6905 3 ปีที่แล้ว +1

    Thank you, this is very helpful!

  • @triciacampbell8687
    @triciacampbell8687 2 ปีที่แล้ว +1

    Hey Hannah, does the link for your spreadsheet still work? When I click "Make a copy" it says "Sorry, unable to open the file at this time. Please check the address and try again" Could you please update the description with a new link? Thanks so much, really appreciate it! I'm subscribed now :)

    • @HannahAlonzo
      @HannahAlonzo  2 ปีที่แล้ว

      Hi! The link should still work! Just tried 3 times from 3 different Google accounts and they all worked for me. Not sure what's going on on your end, sorry about that!

  • @morgan.b.writes
    @morgan.b.writes 2 ปีที่แล้ว

    Is $$ made from Poshmark sales considered taxable income?

  • @HondaImpossible
    @HondaImpossible 3 ปีที่แล้ว

    Thank you so much!! This helps so much! ☺️

  • @melissaw9093
    @melissaw9093 3 ปีที่แล้ว

    Thank you Thank you Thank you!!!!!!!!!

  • @susanluckini8326
    @susanluckini8326 2 ปีที่แล้ว

    I feel really stupid; cannot figure out how to download spreadsheet. I really like yours and I'm not tech savvy at all!

  • @danahickles2177
    @danahickles2177 3 ปีที่แล้ว

    I am still new to Poshmark. I have sold just a few items but I have not been keeping track of anything. Is there a way to capture the information (date listed, date sold, Poshmark fee)?

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว

      Yep! On the Poshmark app you can find that info under “my Posh stats” and “my sales” tabs. To find info about date listed, you can download the “my inventory report” and “my sales report”

  • @elliekaleba8894
    @elliekaleba8894 3 ปีที่แล้ว

    Thank you sooo much. This was so helpful.

  • @JM-yf5rw
    @JM-yf5rw 3 ปีที่แล้ว

    My copy isn’t adding up the totals how can i get help with this?

  • @tasharyanfitmom3655
    @tasharyanfitmom3655 3 ปีที่แล้ว

    Love it! Thank you!

  • @nataliepovse375
    @nataliepovse375 2 ปีที่แล้ว

    Hello! Can I get a copy of your spreadsheet please

  • @valerieg.9242
    @valerieg.9242 3 ปีที่แล้ว +1

    U can use “$” to correct that problem...When I am on the computer I will come back and drop the correct command

    • @MihaelaRo
      @MihaelaRo 3 ปีที่แล้ว

      What do you mean? How you do that please do tell

    • @yesiedavila589
      @yesiedavila589 3 ปีที่แล้ว

      Example: highlight row E or just press E and the row will highlight. Then hit the $ sign. This will covert everything in that row to dollars. Hope I’m explaining it clearly. Good luck!👍🏽

    • @MihaelaRo
      @MihaelaRo 3 ปีที่แล้ว

      @@yesiedavila589 so it doesn’t matter where you adding the rows above or below that will extend it to all the row you inserted. Right? And you still have to sit there under row by row by row until next Christmas no easier ways? LOL

    • @yesiedavila589
      @yesiedavila589 3 ปีที่แล้ว

      @@MihaelaRo yes, the only thing it fixes is the total. Unfortunately, you will still have to add the rows. I automatically added the $ to columns that were going to give me a dollar amount. I also automatically inserted extra rows because I knew it wouldn’t be enough. 😉

  • @nanap9061
    @nanap9061 3 ปีที่แล้ว

    I'm still trying to figure out how to find the " file" button and then "make a copy". I don't see it on my excel sheet

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +2

      This is a Google Sheets document, not an Excel spreadsheet, maybe that’s it? You’ll have to open it in Google Sheets in order to make a copy

    • @nanap9061
      @nanap9061 3 ปีที่แล้ว +1

      Yes! That was the problem! Thx so much, Hannah🙏🏿

    • @HannahAlonzo
      @HannahAlonzo  3 ปีที่แล้ว +1

      Yay! 😊

    • @nanap9061
      @nanap9061 3 ปีที่แล้ว +1

      Omg -this is awesome ❤️‼️❤️

  • @adnanshahzad2399
    @adnanshahzad2399 3 ปีที่แล้ว

    Thank you for the sharing

  • @angelika_munkastrap4634
    @angelika_munkastrap4634 5 หลายเดือนก่อน

    Do you really need to pay taxes on it when you’re making so little per month?

  • @Tetrippyhippie
    @Tetrippyhippie 3 ปีที่แล้ว

    my dad is a software enginer he would know how to fix it if u haven't got it fixed yet I can ask him