G
GuestUser140
Guest
Hi guys,
We sell used consumer electronics amongst other things.
I like simplicity.
Until now, I've always used two Excel files:
1. A general table with all the stock in it (with serial number, purchase price, date, ...)
Only the columns "sale price", "sale date", "invoice number" and "customer name" are empty and need to be filed out when something is sold.
2. A blank invoice template.
When something is sold, I (or my employee) simply fills out the 4 empty fields in table 1. Takes no time.
Then she copies the line of that specific item from table 1, and pastes it into the invoice.
Print and done.
Variation: save as PDF, upload to cloud, done.
At the end of the month, we do a stock count.
She scans the physical stock and emails me the barcodes. I check in table one whether all the empty fields correspond to a scanned barcode (=whether an item is indeed in stock). I do that manually. (About 100 barcodes which takes 15 min.)
Am I doing too much work? Can it be done more efficient?
Best,
Michael
We sell used consumer electronics amongst other things.
I like simplicity.
Until now, I've always used two Excel files:
1. A general table with all the stock in it (with serial number, purchase price, date, ...)
Only the columns "sale price", "sale date", "invoice number" and "customer name" are empty and need to be filed out when something is sold.
2. A blank invoice template.
When something is sold, I (or my employee) simply fills out the 4 empty fields in table 1. Takes no time.
Then she copies the line of that specific item from table 1, and pastes it into the invoice.
Print and done.
Variation: save as PDF, upload to cloud, done.
At the end of the month, we do a stock count.
She scans the physical stock and emails me the barcodes. I check in table one whether all the empty fields correspond to a scanned barcode (=whether an item is indeed in stock). I do that manually. (About 100 barcodes which takes 15 min.)
Am I doing too much work? Can it be done more efficient?
Best,
Michael
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. :-)
Membership Required: Upgrade to Expose Nearly 1,000,000 Posts
Ready to Unleash the Millionaire Entrepreneur in You?
Become a member of the Fastlane Forum, the private community founded by best-selling author and multi-millionaire entrepreneur MJ DeMarco. Since 2007, MJ DeMarco has poured his heart and soul into the Fastlane Forum, helping entrepreneurs reclaim their time, win their financial freedom, and live their best life.
With more than 39,000 posts packed with insights, strategies, and advice, you’re not just a member—you’re stepping into MJ’s inner-circle, a place where you’ll never be left alone.
Become a member and gain immediate access to...
- Active Community: Ever join a community only to find it DEAD? Not at Fastlane! As you can see from our home page, life-changing content is posted dozens of times daily.
- Exclusive Insights: Direct access to MJ DeMarco’s daily contributions and wisdom.
- Powerful Networking Opportunities: Connect with a diverse group of successful entrepreneurs who can offer mentorship, collaboration, and opportunities.
- Proven Strategies: Learn from the best in the business, with actionable advice and strategies that can accelerate your success.
"You are the average of the five people you surround yourself with the most..."
Who are you surrounding yourself with? Surround yourself with millionaire success. Join Fastlane today!
Join Today
