ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel

How to Organize your filing for your online selling records! Easy, inexpensive tips!

Updated on July 27, 2013

Introduction

After 12 years working in a corporate office where I wore many hats, from secretary to business manager, I've learned many easy tips for organizing office filing. Anyone from yourself to your office staff will have no trouble learning this easy system and maximizing productivity!

When you are working with paperwork, the key to successfully maximizing your productivity is to simplify your organizational structure and filing system.

These are some helpful tips I have found work really well to increasing productivity (ultimately profit) on any internet selling venue you use, even your own website.

Filing space and Storage ~ Determine what works best for you

  • What space do you designate for filing? Is it a basket on your desk, an in-box in a bookcase, or some expandable files? I picked up a two-drawer file cabinet which suits my needs. In the top drawer I keep all of my files. The bottom drawer I keep mailing supplies and office supplies. I have my postage meter on top of the cabinet near my desk for quick weighing while I am typing my listings. I have a second expandable file on top of my desk near my printer for easy access. I keep a file folder labeled "daily sales". When I sell something, I print the item details page and put it in that folder until I can properly file it away in my records. This eliminates misplaced documents in the rushing around of packing and shipping.

Color-coded hanging files.  Your file folders will stand out above the hanging files for easy access to your records.
Color-coded hanging files. Your file folders will stand out above the hanging files for easy access to your records.

Tip! Use color-coded hanging files, file folders, or tabs!

If you sell on multiple venues, change the color of your folders or tabs to coordinate with your venue.

Simple headings, color coded hanging files or tabs, coordinate with your staff to learn a basic and easy filing system to optimize your productivity!
Simple headings, color coded hanging files or tabs, coordinate with your staff to learn a basic and easy filing system to optimize your productivity!

Basics of creating file folder headings

  • Take note of what really matters. What kinds of files do you really need? Which files can be eliminated to streamline your filing system and to de-clutter your filing cabinet? Use these suggested file folder headings to customize your own filing cabinet:
  1. Merchandise Intake Sheet ~ or ~ Merchandise Inventory Sheet. I use these for describing a product before I list one. It helps me visualize what I will type in to the listing format, and mention specific attributes. I note on this sheet what I don't want to forget to mention on the listing. Also, when you sell the item, save the merchandise inventory sheet with your records in case the item is returned or a buyer found a flaw in the item. You can use this sheet to refer back to the item to see if you made a mistake or how you could have described the item more accurately next time. Yes, it's extra time and effort, but it helps visualize the item you are describing and collecting the visual aspect of the item before you list it. Some people find that typing their information directly into a listing platform works better for them, but this extra step helps me sort out how I want to describe the item before I actually type it in the computer.


Sample of my merchandise intake sheet.  Feel free to customize this for your own use!
Sample of my merchandise intake sheet. Feel free to customize this for your own use!

2.

Current listings. I file my merchandise intake sheets in a folder titled Current Listings once the item is listed. When an item sells, I pull my merchandise intake sheet from this folder. So this folder also becomes useful in order to double-check your current listings. You can keep track of what you have listed by going through the folder to make sure what you have listed is really what is showing in your active listings.

3.

Items sold. When I sell an item, I print a confirmation page or item detail sheet (whichever the venue calls it). I take the correlating merchandise intake sheet, staple it to the confirmation page I print after a transaction is complete, and then I put it in this folder. (Tip! I also set up an Excel spreadsheets with information about the sold item to use for tax purposes.) Why go through all of this trouble? It serves several purposes. First, this will help you keep track of sold items. Some people do not like a lot of paper around and rather keep everything on the computer. I personally like to store my records in this fashion to have it on hand quickly when referring back to an item. It also helps to keep track of items that are being returned. Then if you choose to relist a returned item, you can easily refer back to the information in this folder to relist the item without having to start all over again. It also serves to help you decide what merchandise is good for you to sell. If you have no filing system now, this system will help you keep track of what your best sellers are. You can look back in this folder and see what your customers prefer most by item, color, season, etc. You can start visualizing trends easier when you have the information in a folder that you can quickly look back at and determine what will help your business the most in the future! Of course spreadsheets are always great options too!

4.

Business Orders Pending. If you buy from other vendors to resell, or if you buy office products such as shipping supplies from online vendors, this file will help you keep track of those orders that you place. Once the order is placed, print a copy from your computer and put it in the file. I bought some printed file folders with large red and white flowers to keep these records separate from my selling transactions. That way when I look for them in my filing cabinet they stand out by the printed folders.

5.

Business Orders Received. Referring to #4 above, when you receive your shipment and confirm it's all there, put your order confirmation and the packing slip for the items you received in this folder. This will help keep your orders organized for several reasons including taking these expenses as tax deductions ~ and ~ keeping track of what you ordered so you don't have to remember everything or wade through time-consuming emails to find out where you ordered something if you want to re-order it in the future.

Other File Folder Headings

I also use other folder headings such as IRS, Logo, Business checking, manuals for equipment (i.e., cash register, printers, scanners, copiers, postage scales, etc.). You can customize any file folder heading to suit your business needs. These are just some suggestions for streamlining your filing efforts which are time-consuming and can cut in to your business profits.

Simplify your organizational structure

  • Keep your organization consistent. If you use more than one online venue, makes sure you color-code your file folders, the hanging folders, or the tabs to keep everything separate, but use the same headings for each! Use the venue in the title of the file folder headings. As long as you are using the same HEADINGS, everyone can follow and understand this system. It's very simple and easy to use. Keeping the headings simple is the most effective way to home in on filing skills for all staff.
  • Use color-coded hanging files or tabs. I found some really inexpensive hanging files that were actually color coded and hung lower so the heading of the file folders stand out. This will eliminate confusion when searcing for items sold from three or four venues if you have the files color-coded and properly labeled.
  • Train all office staff, including having a checklist handy for new hires. As simple as this sounds, it works. Repetition sticks. People remember how to do something when they have to do it the same way every time and when they are bound by a checklist hanging in their work space.
  • Keep separate files for refunds and sales that qualify for your state taxes.
  1. I keep a red folder labeled "refunds" on my desk. This will help keep track of what items were returned or refunded and how much in refunds I processed through the year. It will also help you figure out if a product you are selling is really worth it. For instance, if you had a lot of returns on a particular novelty item, then it might be time to stop selling that item. (One time I had found a vendor selling seasonal novelty putty. I bought a case to resell in custom themed baskets. To my surprise, even though it was an inexpensive item, customers were complaining about the putty saying it was dried out. After the first few refunds, I was able to pull the listings and take the item out of my baskets and find a different vendor with a different product. It's crucial to keep track of this information, especially if you have a lot of items for sale.)
  2. I keep a blue folder on my desk labeled with the state I live in. My business is registered to collect tax in my state. So any sale I make to a customer in my state, I have to report it and pay the tax on a quarterly tax report. So, come the end of each quarter, I can grab the file quickly and have the information at my finger tips instead of trying to wade through hundreds of records to find out which customers bought from me who live in my state. This will be most important if you live in a state in which you need to pay tax to multiple authorities. In the event you need to pay tax to every state you sell to, you can either have a file labeled for each state ahead of time to keep track of each state sales, or you can create an excel spreadsheet and remember to input the information in to that after every transaction.

I keep an accordion file on my desk near my printer for a quick place to put my sold items detailed sheets during packing and shipping so they don't get lost in the paperwork!
I keep an accordion file on my desk near my printer for a quick place to put my sold items detailed sheets during packing and shipping so they don't get lost in the paperwork!

Conclusion

Whether you are a small seller working alone or a larger seller with employees, the key is to streamline filing to make it as easy and simple as possible for anyone to learn and remember. Starting with the basics, a filing drawer and some labeled file folders will help you have access to filing papers without the back-log of papers strewn around your work area at the threat of being misplaced.

I hope you find these tips useful in maximizing your productivity!

Up next: Organizing your Inventory

Next, I will show you simple and effective ways for organizing your inventory for an online-based business! Stay tuned!

Inexpensive two-drawer file cabinet.  Top drawer contains files.  Bottom drawer contains envelopes and mailing supplies.  I keep my postage meter on top of the cabinet by my desk for quick access to weighing parcels.
Inexpensive two-drawer file cabinet. Top drawer contains files. Bottom drawer contains envelopes and mailing supplies. I keep my postage meter on top of the cabinet by my desk for quick access to weighing parcels.
Color coded hanging files that hang lower to show your file folder headings
Color coded hanging files that hang lower to show your file folder headings
Simplify file folder headings.  If selling on multiple venues, keep title simple such as Items Sold, but add in the venue name and color code by venue.
Simplify file folder headings. If selling on multiple venues, keep title simple such as Items Sold, but add in the venue name and color code by venue.
Desk top accordion file at my finger tips.  I keep this near my printer on my desk to file sale detail sheets until I log them into excel and file them in my filing cabinet.
Desk top accordion file at my finger tips. I keep this near my printer on my desk to file sale detail sheets until I log them into excel and file them in my filing cabinet.
Intake sheet or inventory sheet.  Please feel to use for your own business.  I created this one in Word and keep about 50 printed at a time.
Intake sheet or inventory sheet. Please feel to use for your own business. I created this one in Word and keep about 50 printed at a time.
working

This website uses cookies

As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: https://corp.maven.io/privacy-policy

Show Details
Necessary
HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
LoginThis is necessary to sign in to the HubPages Service.
Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
AkismetThis is used to detect comment spam. (Privacy Policy)
HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
Amazon Web ServicesThis is a cloud services platform that we used to host our service. (Privacy Policy)
CloudflareThis is a cloud CDN service that we use to efficiently deliver files required for our service to operate such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
Features
Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
MavenThis supports the Maven widget and search functionality. (Privacy Policy)
Marketing
Google AdSenseThis is an ad network. (Privacy Policy)
Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
Index ExchangeThis is an ad network. (Privacy Policy)
SovrnThis is an ad network. (Privacy Policy)
Facebook AdsThis is an ad network. (Privacy Policy)
Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
AppNexusThis is an ad network. (Privacy Policy)
OpenxThis is an ad network. (Privacy Policy)
Rubicon ProjectThis is an ad network. (Privacy Policy)
TripleLiftThis is an ad network. (Privacy Policy)
Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisement has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
Statistics
Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)
ClickscoThis is a data management platform studying reader behavior (Privacy Policy)