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. :-)
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?
