I have a question for people who do e-commerce or another form of mainly selling products. How do you deal with inventory management? I was re-doing my books for this year and it took a lot of time, this is how i do it in FIFO (first in first out)
I am using a online bookkeeping program whenever i buy stock i add the bought inventory to the invoice like this:
Then at the end of the month i get an invoice from my platform and add the sold products to the invoice:
How i calculate COGS:
Count inventory at the last day of the month and compare the difference with last month - newly bought stock.
Use First in first out to acurately calculate the total cost of inventory sold. The red stripes are the productnames. The x means the batch sold out.
The calculation is automated in excel, this is a small part but you get the idear:
Then at the end of the month the bookkeeping program actualizes the inventory.
It works but i feel like there must be an easier way to do this. Can anyone recommend me a good software or a different way to do all this. Thanks in advance!
I am using a online bookkeeping program whenever i buy stock i add the bought inventory to the invoice like this:
Then at the end of the month i get an invoice from my platform and add the sold products to the invoice:
How i calculate COGS:
Count inventory at the last day of the month and compare the difference with last month - newly bought stock.
Use First in first out to acurately calculate the total cost of inventory sold. The red stripes are the productnames. The x means the batch sold out.
The calculation is automated in excel, this is a small part but you get the idear:
Then at the end of the month the bookkeeping program actualizes the inventory.
It works but i feel like there must be an easier way to do this. Can anyone recommend me a good software or a different way to do all this. Thanks in advance!
Dislike ads? Become a Fastlane member:
Subscribe today and surround yourself with winners and millionaire mentors, not those broke friends who only want to drink beer and play video games. :-)
Access Restricted: Unlock 1,000,000+ Posts
Stop Peeking Through the Keyhole.
Open the Door.
You hit a wall because the best advice isn't free—it's earned. Since 2007, MJ DeMarco has been active here daily (99.9% active rate), building a war room for entrepreneurs who refuse to settle for mediocrity.
- Active Daily: Life-changing content posted dozens of times every day. No dead threads.
- MJ's Inner Circle: Direct access to the author of The Millionaire Fastlane.
- Vetted Network: Connect with founders scaling to 7 and 8 figures.
- Proven Roadmaps: Strategy over motivation. Execution over "hustle porn."
"SCALED TO 6-FIGURE MONTHS"
"Tips and advice here saved me from huge mistakes, others allowed me to scale my business to 6-figure months."— User MitchC
"INSANE QUALITY OF PEOPLE"
"The number of high quality people I've met from this forum has been insane. All of it predicated on building real value."— User Richard Peck
"You are the average of the five people you surround yourself with."
Are you surrounding yourself with success?
