In a perfect world we'd all have accountants to organize our receipts, paperwork, and spreadsheets, but most of us don't. I refuse if I can do it myself- for now. I love to track every cent I spend for not only my business but my personal life to analyze trends, keep myself accountable, to save and for taxes. Here's how I keep it all organized:
1) Upcycled Manila Envelope(s) to hold business receipts 2) Manila Envelope of Personal Receipts 3) Mini File Organizer 4) Envelopes 5) Small Notebook and Pen 6) Binder Clips
I've seen the same portable organizer at The Dollar Tree, you can try to find one near you for a buck. This is great to carry with you in your purse or car so you organize your receipts properly on-the-go instead of having a receipt pile in your bag or pockets. I carry the little notebook with me to note yard sale/flea market and write down what I pay for finds as I go, the notebook lives in the file folder.
From there I sort my receipts into their respective envelopes within the Manila Envelopes. Yes I'm Old School, I also didn't get a cell phone until I was literally forced to (age: 20) and didn't switch to a smart phone until last year! Above are my personal envelopes. I spend money on more than groceries and a tiny bit of "random" things but the rest of my expenses (cell phone, cable, rent) are scheduled as automated direct-deposits (highly recommend the auto-magical way! So simple, so clean!) so I don't print receipts for those expenses.
These are what my business expense envelopes look like. I write it all in pencil in case I want to use my envelopes for something else later with my cheap self. The business receipts include: supplies, thrifting, southern crossing rent, gas and post office trips (good to keep for tracking numbers, too). I clip them together by month.
Columns: Date (found) | Item (description) | Cost | Estimated Value | Where Found | Condition | Retail (Price) | Date Sold | Profit | Quantity | (Where) Stored | Wholesale | Item # ------>> Am I leaving anything out?
From there I enter the expenses into a spreadsheet. I use Google Documents, it's free and you can share the spreadsheets with partners to edit together if need be. I keep tabs at the bottom to separate types of merchandise for easy-hunting. My personal spending spreadsheet looks much the same, divided at the bottom by type of expense. I highlight in groups by date with different colors for easier scanning, it really helps the eye find things.
Another step people miss- receipts should be scanned. Not merely to have the files digitally but because they fade completely -sometimes within mere months! I've yet to scan mine, when I do I'm going to sort them in digital folders the same way they're stored in my envelopes. You should keep your receipts for 7 years, that's the IRS audit expiration date.
How do you store/organize your receipts or track expenses? Any tips? I do this an antiquated way but I like the process, it keeps my spending tangible to have so much of it "in-hand". Going through all these steps every time I buy anything definitely discourages me from spending more than absolutely necessary, too!
I appreciate all of your posts, but this one... I am loving. :) I am a material / financial analyst by day, volunteer VP of Finance for a non-profit, and small business owner of "The Oakley Office" - which is payroll, bookkeeping, accounting, and consulting for small businesses. Your methods are GREAT!
ReplyDeleteSo many self-employed or small business owners don't keep up with their original costs nor their Inventory (Blows.My.Mind.) but I believe small business is what makes this country so great and I want to help them understand their budgets, their costing structure, and most importantly, their profit.
What does Column L say on your Google Sheets?
-Lana
Never mind about Column L. I reread the post!;)
DeleteNo prob, I know it's not super clear ;D For anyone else reading it says "Stored"- will eventually add the resting place in my home of every single item in my inventory (like "pantry, closet, box #1" etc.) but haven't yet merely because I'm still trying to find the best way to store everything.
DeleteKnowing where it's stored is such a huge help when it comes to shipping stuff out.
Do you calculate your profit from the spreadsheet or from what Etsy/eBay actually deposits?
DeleteI feel the same way about small biz, so passionate about helping people succeed at it which is why I always posts inspiration to get started, help for those working on it, and am working on helpful eBooks next. Most of my artist pals do not track inventory or receipts at all and I can understand why, it slows you now and isn't right-brain friendly. But it's so vital!
DeleteOh, double post, ha. I track by:
Delete1) Writing the daily sales on the calendar day in my planner's calendar (for future reference) and on a large calendar by my desk so I can see the sales as they come and always glance at it to see how I'm doing. I like to hand-write all sales, helps me remember them.
2) I add them up at the end of the month from my calendar.
I don't calculate via spreadsheet formulas. I need to learn how to do that, to be honest, have always been bad at that in excel-type programs. Didn't think to include that in the post, made have to edit with that info. Thanks for asking! Let me know if this is way too old school/bad to do in your pro opinion?
IF/when you calculate by item in the spreadsheet, you will need a new column for fees (i.e. insert a column by G just for fees).
DeleteI am still learning about Etsy... Do they have a download options for your sales? I am thinking of the Square Register & (the long gone) Google Wallet- there is the option to download into Excel from those sites and it is easy to formulate into a pivot table or just to filter out what you need to see.
I don't see anything for that other than the "sold orders" tab but I'll investigate that more when I get back from my kitchen shift. May have to get with you on a step-by-step post or info to help people do this stuff if you're game. :D Definitely agree on a fees column. I'd do one for Etsy and eBay for each item. Need to keep better track of that, it adds up.
DeleteSounds great, I'd love to help!
DeleteThanks Lana! What's the best e-mail to reach you at? That or you can e-mail me at info@thriftcore.com and I'll follow-up later this evening.
DeleteAhhh! How did I miss this post?!
DeleteI came back to this post because I did some more research on etsy. I will email you! I am sooo sorry for the delay.
No problem at all!
DeleteThis comment has been removed by the author.
ReplyDeleteAm starting to track my mileage today. You system looks great.
ReplyDeleteThanks Nancy, yep, that's a big one I started this year. I started last year but didn't keep up with it.
DeleteWent to the post office to drop off packages for ebay and a thrift today and recorded it in a notebook that is now kept in my car. Thanks for the post!
DeleteNo prob. Glad it helped!
DeleteYes, very good system. I suffer from the "artists shouldn't have to worry about money" syndrome and keep most of that info in my head! I know-- not too smart.
ReplyDeleteI didn't track things the first couple of years while I was doing this part time. Super easy to lose track if you don't keep on it.
DeletePinned for later reading - thanks! I just started my business in September and I'm still trying to work out a good system.
ReplyDeleteGlad it helps. I'm writing my indie biz help eBook, I hope you'll check it out when I release it :D
DeleteSo last year, I pretty much put all my receipts in a shoebox. Well, which ever receipts I happened to find. Then my husband pretty much scolded me....So this year, I have been wayyyyyy better and organized. I am putting my monthly receipts, gas, any expenses in an envelope, and I write down on the front the total expenses and my total revenue. Good enough for me. Anything more complex than that, I will hire an accountant. Seriously, I am not good with that sort of stuff....
ReplyDeleteIt is one of those weird things you have to discipline yourself to do, even though it's so simple!
DeleteSince you now have a smart phone, you can download an APP or use your phone's camera to scan/photograph the receipt and email it to your self to download to a file in your email.
ReplyDeleteOh that is awesome, do you know what it's called? Would save me some time for sure.
Deletewe use the home budget app and i love it! it is 5 bucks but totally worth it, and it syncs between mine and my husband's phone. with each expense there is an option to take a photo of the receipt which is awesome and cuts down on paper i have to hold on to! we've been doing so well on our budget since getting that app.
ReplyDeleteOh that sounds awesome- what's it called? I haven't transitioned into aps yet, I love hand-writing everything.
DeleteThis comment has been removed by the author.
ReplyDeletehttp://www.cheapairjordan.us
ReplyDeletemichael jordan shoes
adidas stan smith uk
michael kors outlet
skechers outlet online
longchamp handbags
air jordan retro
longchamp outlet
adidas tubular
cheap rolex watches
canada goose outlet
ReplyDeletegolden state warriors
redskins jerseys
chicago bears jerseys
nike huarache
oakley sunglasses
moncler outlet online
los angeles clippers
dallas cowboys jersey
north face jackets
Click and have a look at this link to find information that will help you manage your family problems.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteHopefully today's fun, very interesting article sekalali to read and may be useful for everything
ReplyDeletePengobatan Untuk Menyembuhkan Penyakit Epilepsi
Cara Mengobati Gagal Jantung Tanpa Operasi
Solusi Yang Tepat Cara Mengobati Dispepsia
Pengobatan Penebalan Dinding Rahim Tanpa Kuret
Cara Mengobati Kista Coklat Tanpa Operasi
very good article and useful once for my admin and pardon me permission to share articles herein may be useful and helpful Cara menyembuhkan thalasemia
ReplyDeletegiven article is very helpful and very useful for my admin, and pardon me permission to share articles here hopefully helped :
ReplyDeleteObat susah kencing
Obat epilepsi
Obat susah kencing
Not all people who work for you qualify as household employees. The IRS provides a guideline to check whether a worker qualifies as a household employee or as an independent contractor. User guide
ReplyDelete
ReplyDeleteAvriq
AVRiQ – Desktop/Laptop Repair
AVRiQ – Network Security
n order to do this, the user has to turn on the sales tax preference, that is, he or she should activate the tax preference. After that, he or she should set the two item code preferences quickbooks tech support number
ReplyDeleteCan't sit tight for another blog by this essayist.
ReplyDeleteonline cpa services
chrome hearts
ReplyDeletebalenciaga triple s
red bottoms
hermes belts for men
ferragamo belt
yeezy boost
Nice And Informative Website. Please Keep Continue Such Kind Of Effort. Contact With Quickbooks Support Phone Number. We Deal In Bookkeeping Services, Company Payroll Services, Cost Accounting, Quickbooks Enterprise, Quickbooks Pos Support, Quickbooks Pro Support And Other Company Related Financial Services. Our Website- Http://www.Accountingexpert.Net Our Toll Free No +1-844-438-3711
ReplyDeleteQuickbooks Support Phone Number +18444383711
nice bLog! its interesting. thank you for sharing....
ReplyDeletejohn faraday
An exceptionally experienced, dynamic and adaptable group at Company Formations 24.7 aides business people to influence their fantasies to work out as expected, by giving far reaching and altered administrations to organization arrangement and registration.רישוי עסקים
ReplyDeleteadidas stan smith women
ReplyDeleteadidas superstar UK
nfl jerseys
lacoste polo
nike flyknit
pandora bracelet
vans outlet
yeezy 500 blush
yeezy shoes
yeezy 500
Nice And Informative information. Please Keep Continue Such Kind Of Effort. Contact With Quickbooks Support Phone Number. We Deal In Bookkeeping Services, Company Payroll Services, Cost Accounting, Quickbooks Enterprise, Quickbooks Pos Support, Quickbooks Pro Support And Other Company Related Financial Services.
ReplyDeleteQuickBooks Error Support
QuickBooks Error Support Number
QuickBooks Error Support Phone Number
Official QuickBooks® India contact us page. Let us guide you to the quickest answer or QuickBooks expert. Contact us by Quickbooks phone number usa.You can also find further details about how to contact our support team. ... on which QuickBooks Online product you use, so it's best to check the support site first. ... is made effective and when you will no longer have access to the service.
ReplyDeleteCall +1-888-621-0339 for Brother Printer Support. Our Brother Printer support phone number is available 24*7 for our callers at Dial Printer Support. Brother Printer Support
ReplyDeleteThere are volumes of accountants who seek after extremely costly promoting projects offered by different organizations and who are tricked by hard to-uphold ensures.CPA San Diego
ReplyDeleteNice Blog
ReplyDeleteQuickBooks Payroll Support Phone Number
This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. candeggina per sbiancare
ReplyDeleteI suppose this info is completely unique.Accounting firms in Toronto
ReplyDeleteIPL LIVE 2019''http://iplliveupdate.com/'',GET THE LIVE UPDATES OF IPL 2019
ReplyDelete
ReplyDeleteLive and exclusive coverage of the 12th edition of the VIVO Indian Premier League 2019. Watch IPL 2019 live stream with live scores IPL Latest News, find Live Scores and all other little and important Gossips of Vivo IPL 2019. catch the exclusive IPL 2019
IPL Live update
IPL 2019 Live Stream
IPL 12 watch Live Stream
IPL 2019 Live Streaming
IPL 12 Live Streaming
IPL Live Streaming match
IPL 12 Live Stream
IPL Today Match
If you really desire to get such type of information, visit this blog quickly.
ReplyDeleteAccountants in Toronto
I have perused your online journal it is exceptionally useful for me. I need to express profound gratitude to you. I have bookmark your site for future redesigns. https://pressurewasherguides.com/pressure-washer-surface-cleaner/
ReplyDeleteANP Metals offers stylish temporary fencing and accessories for installation. marble benchtops melbourne
ReplyDeleteThanks for your posting .
ReplyDeleteKeep posting like this is very helpful For us
I have found something new in this Article.
Solving the QuickBooks Error Code 1722
How to fix QuickBooks Error H101, H202, H303, or H505
Hello, everyone! I really impressed by reading your post. keep it up and make informative posts like these.
ReplyDeleteCreate a QuickBooks Accountant Copy
Payroll Service Key in QuickBooks
Configure firewall while for multi-user mode in QuickBooks
Hello, everyone! I really impressed by reading your post. keep it up and make informative posts like these.
ReplyDeleteUnderstand Firewall And Security Settings For QuickBooks Desktop
appriciate post, if someone have problem in their quickbooks of opening the quickbooks shut down the quickbooks immidiately, then you have an issue quickbooks won't open solution is here.
ReplyDeleteyour article is knowledgable keep it up,quickbooks install diagnostic tool
ReplyDeleteIts a great pleasure reading your article post.Its full of information I am looking for and I love to post a comment that “The content of your post is awesome” Great work.
ReplyDeleteQuickBooks Error 6147
Quickbooks Automatic Backup not Working
QuickBooks Error PS107
QuickBooks Error 6143
QuickBooks Abort Error
congratulations to the winner...best luck for your further responsibilities and jobs.
ReplyDeleteSet up and Use Intuit Account User Management
Fix System Exception Errors in QuickBooks Desktop
Company File Compatibility between QuickBooks Versions
Our company specializes in data migration, email migration, and file format conversion. Recently, we developed the Cigati MBOX Converter Tool to simplifying the way to convert MBOX to DOC Format. Additionally, it can convert MBOX files into PST, JSON, PDF, EML, EMLX, DOCX, etc.
ReplyDelete