I’ve done several expense reports for a variety of my clients. Things that are typically included are: flights, checked bag fees, dinner/lunch meetings, hotels, rental cars, Uber, taxi’s, concert tickets, misc purchases, credit card transactions, and much more. So, with all of the receipts that are acquired during a single trip, or on a daily basis, how can one keep up with the loot?
My solution, use mobile apps! There are so many available these days it’s hard not to take advantage of their services. These apps allow you to take a photo of your current receipt and it will automatically log that information into a single spreadsheet. Some will even match your credit card transactions, categorize receipts, track company policies & procedures, etc, etc. Saving you, or your Administrative Consultant valuable time. If you’re consistent, utilizing these apps is a great solution! However, there are some companies that do not offer these easy solutions or busy entrepreneurs that do not want to deal with using apps. That’s okay too! You know how it goes, there is a prefabricated spreadsheet that you must fill out manually, entering every receipt, category, or reason. Then you have to submit it to the correct department, attach receipts blah, blah, blah.
As a virtual Administrative Consultant, my goal is to make things easier for all of my clients. So I’ve come up with 6 simple tips to help this process go smoothly, regardless if you choose to go the app route or not.
6 tips for Managing Expense Reports with ease:
- Take a photo of each paper receipt you receive: Even though the apps work great for this I would still take one extra step, and email those photos to yourself, or your Administrative Consultant. (Pssst- you can even text the photo to your Admin Consultant) Just so you don’t have to worry about losing the paper receipts. It’s better to be safe than sorry, and you won’t need a scanner.
- Use your email to your advantage: You can easily set rules or filters to manage specific incoming emails. For example: If you receive Uber, or Google Apps receipts through email, then you can create a filter to put those emails in a specific folder. That way it keeps your newly received receipts organized, and separate from your inbox.
- Create a folder for each month to house all of your emailed receipts and statements: This is important. You need a place to house all of your receipts, and credit card statements. Even if you’re using an app, you need a point of reference in case of a mistake. I would keep this folder in your preferred cloud storage system, or in a secured area on your computer. Your Administrative Consultant can also do this and share the folder with you, or vice versa.
- Make time to compile the data: Now that you have a folder with all of your receipts and statements in one place, what’s next? Fill out the report as you go! I highly suggest this, because it will save you time in the long run. No one wants to go through a month of receipts all at once.
- Submit your receipts: Companies usually like receipts in one nice PDF document. But, if your photos are in a JPEG format, how does this work? Well, you have some options: you can use a program to convert these for you (sometimes for a small fee), or delegate this task to your Administrative Consultant. I usually have the task of converting these for my clients, it also allows me to double check the entered data as I go.
- Double, and triple check!: Before submitting your monthly expense report, just go through and check everything once again. If you’re using a spreadsheet make sure all of your formulas are correct, showing the right amounts. If using an app, check to make sure all receipts are included in the correct amounts. There is less error when using apps, but sometimes a mistake can be made.
Hope this list helps you to become more efficient and productive when managing expense reports. If you need some additional help, contact me at firstname.lastname@example.org