Tuesday, July 7th, 2015 / by ExcelHelp
Going paperless. A modern idea. One that many businesses throw around as a future intention.
What happens when you or your company actually decides to follow through, however?
It might feel overwhelming to turn the idea of a paperless office into a reality. All those filing cabinets that need to be converted to a digital format can seem daunting.
Reciting the benefits over and over can help:
In addition to knowing these benefits, knowing exactly how to implement this visionary idea will decrease the stress of the situation.
Here you will find a quick step-by-step guide on how to use Excel to reap the rewards and say good-bye to paper.
There is a delightful and unique story of a woman who made her viola and violin teaching business paperless, proving that almost any business can take the leap. She wrote about the experience of digitizing her material and claimed she would never go back to paper.
The typical U.S. office worker uses more than 10,000 sheets of paper per year, which is about 2 cases of paper per employee. With an average price of $40 for a case of standard copy paper, this is an $80 annual cost per employee. The main costs of paper documentation fall into copying, delivery, handling, storage, and retrieval of that paper, with copying costs at 33% and distribution costs at 56% – according to a study conducted by California’s Alameda County.
It’s costly; there’s no way around that fact.
Today’s businesses might not be able go completely paperless still, but there are ways to start and ways to definitely stop wasting paper (and money).
If possible, sign up to receive receipts electronically.
If you have paper receipts then invest in a good scanner. Then save each scanned receipt as a PDF in a designated file.
What makes an electronic receipt valid in the eyes of the IRS?
Each receipt must include the vendor’s name and address, transaction date and the amount paid. Also, be sure to note what you bought and its business purpose. Each scanned receipt needs to be clear and easy to comprehend completely.
Excel will help keep all of this information organized so that looking back on business expenses when it gets to tax time will be easy.
Regular, consistent and accurate data will make the IRS happy and will help you create a credible document.
Try making a simple spreadsheet with these columns for receipts:
Here are some categories to keep in mind that relate to taxes:
Your business already has Excel on the computer. It’s time to utilize it.
Using Excel is a simple and FREE way (unlike with a lot of apps) to keep track of receipts, so why not start?
Note: Always back up to a secure external drive, as well. Just in case. Also, save your Excel files as PDFs if you don’t want anyone to be able to alter them once you are finished.
Set up an Excel spreadsheet to track bills.
Categorize the paper or electronic versions of your monthly payments according to how you pay them. For example, if you pay your office utility bills using a pre-authorized debit or automatic withdrawal from your checking account then place that bill in the checking account pile.
If you pay your phone bill using a business credit card, place that bill statement in the business credit card pile.
The main idea is to start by making organized paper piles that will be transferred into your computer.
Next, input your monthly payments into Excel.
Organize the payments by the date they need to be received. And remember to always allow for processing time if being sent using pre-authorized debit.
Excel is able to alert you if a due date is approaching, as well. You just need to add a formula.
Add a column to your worksheet that will be used for the alert. Let’s assume your due date is in column F, you would place the following formula in column G:
This simple formula checks to see if the date in cell F3 is earlier than a week from today. If so then the formula displays “<<<” in the cell.
This can be used to alert you to any date that is either past or within the next week.
You can also use conditional formatting by:
Now you will have two alerts: If the due date is already past, then it shows up as red. If the due date is today or within the next seven days, then it shows up in blue.
Feeling overwhelmed still about the task of going paperless OR just don’t have the time to set up all these spreadsheets? Call on an Excel help expert to get you started.
Look to free Office templates.
What’s great about checking out these templates is that:
Invoices, Weekly Assignment Schedule, and Sales Tracker are a few of the templates available that can reduce paper use in the office.
It’s also a great way to explore how simple spreadsheets can be used for a number of tasks and really to track anything.
Need help from an Excel expert? Find out the six key factors to consider when you need a custom Excel solution.
By using Excel spreadsheets to manage receipts, bills, and other documents, your business will save time and money. There are so many hidden costs in paper, from buying the reams to printing to storing all the documents (also, think of the environmental cost).
While eliminating paper from your business and switching to a completely electronic network can be intimidating, using a program that is already in place on your computer is a great start.
Employees could work on documents together if need be, by sharing the files. If a customer needed information immediately, finding a file from anywhere at anytime would be much simpler.
Even if your business cannot go completely paperless, the benefits of eliminating some paper is worth exploring.
Has your office talked about going paperless? Does using Excel seem like the easiest way to start eliminating paper from your business? Comment below.
I can not recommend ExcelHelp more highly. We had been struggling to complete a critical project and finding them was a lifesaver. Tom was knowledgable, professional, personable, patient and responsive. Look no further for your database programming needs. Thanks Tom and ExcelHelp.com!Randy Hartnell
We anticipate a long business partnership with ExcelHelp and look forward to working with them. I have been nothing but impressed with your firm’s services, your team members tenacity and the overall results. Sometimes you have to travel a bumpy road trying different firms until you find the one that fits.Posted By: Charlene Faber
Chief Operation Officer, Current Builders
I’d like to express my gratitude for the help and cooperation we’ve received from your entire organization during the development of our Modeling Utility. Over the past several weeks we’ve engaged key customers worldwide...We have confidence that this effort will add significant capability and value to the overall success of the program.Business Development Manager
Network Architecture and Strategy
Posted By: Marty M.