Saving and Tracking Receipts

      Paper receipts for expenses are a pesky detail that requires attention. September 30, 2010

Here's the paper-trail question: do you file all those pesky receipts by job, by vendor, by category (e.g. tools, supplies, cogs, etc) or date? Or do you use some hybrid of two or more of these? Do you make copies of receipts and store in multiple locations? How do you not lose those zillions of home depot receipts? Thanks for your help. I'm not very good at this.

Forum Responses
(Business and Management Forum)
From contributor G:
The physical receipts I store by job category, whether it is a business expense or a job expense with a title. Then I have a ledger that everything gets printed to. It is organized the same way but by chronological date order.

From contributor Z:
Every invoice that comes into the shop gets scanned, gets a distinctive name and put in the job folder on the computer. I can go to any clientís folder and there will be a separate folder for each vendor with the invoice scanned in. I created a simple excel spreadsheet that has the date, vendor, invoice number, I.T. number (Internal Tracking number that is the same as the name assigned to the scanned invoice) description and cost. I separate the spreadsheet into materials, hardware, labor (plumber, electrician etc.) and misc (truck rental). All the numbers add up on another tab that give the totals and percentage of cost (total and by category). You can create a bar graph or pie chart to get a simple graphic representation of where your money went.

From contributor C:
I am a cabinet maker and not an accountant. I prefer the easiest possible way to get this stuff safely out of the way. My receipts get stored in a single file (actually, it's not a file but more like one of those accordion files). Receipts from January go in the first slot, February the second slot and so on. However, they do not go directly to my file. First they go into a box on my desk that is designated for new receipts. From there I enter them into Quickbooks (I highly recommend using this program) where I can classify them any which way I choose. I tell the program which account I used to pay for the items and which job they were used for and bam- I'm done! All the info is there for my accountant at tax time. I make a copy of my Quickbooks file and e-mail it to him. He does my taxes and it's that easy. Once, the receipts have been entered their only use is to be available in the unlikely event that I get audited by the IRS. So it's off to the accordion file!

From contributor A:
I file my receipts by date and make a note in my job files as to how much was spent on materials for the job and where the purchase was made. I don't always separately order materials per job and a lot of times I use stuff already on hand.

From contributor A:
Itís not only the IRS you are keeping things organized for. We are about to go through a routine state tax audit, where they sent out a letter basically asking for every document created by the business for 3 1/2 years. I hope in practice they will look over the ledgers, ask for exemption certificates, a few other things, and get bored because everything is in order and realize their time is spent better chasing someone else.

From contributor L:
I second the Quickbooks recommendation.

I second the motion to use an accounting software package. Personally I prefer Peachtree over Quickbooks. Talk to your accountant and let them help you decide.

From the original questioner:
I do use Quickbooks, but not for job costing. Credit card transactions are downloaded into Quickbooks so I don't need most of the receipts to do the simple cash-base accounting.

Would you like to add information to this article?
Interested in writing or submitting an article?
Have a question about this article?

Have you reviewed the related Knowledge Base areas below?
  • KnowledgeBase: Knowledge Base

  • KnowledgeBase: Business

  • KnowledgeBase: Business: Estimating/Accounting/Profitability

  • KnowledgeBase: Business: Legal

    Would you like to add information to this article? ... Click Here

    If you have a question regarding a Knowledge Base article, your best chance at uncovering an answer is to search the entire Knowledge Base for related articles or to post your question at the appropriate WOODWEB Forum. Before posting your message, be sure to
    review our Forum Guidelines.

    Questions entered in the Knowledge Base Article comment form will not generate responses! A list of WOODWEB Forums can be found at WOODWEB's Site Map.

    When you post your question at the Forum, be sure to include references to the Knowledge Base article that inspired your question. The more information you provide with your question, the better your chances are of receiving responses.

    Return to beginning of article.

    Refer a Friend || Read This Important Information || Site Map || Privacy Policy || Site User Agreement

    Letters, questions or comments? E-Mail us and let us know what you think. Be sure to review our Frequently Asked Questions page.

    Contact us to discuss advertising or to report problems with this site.

    To report a problem, send an e-mail to our Webmaster

    Copyright © 1996-2019 - WOODWEB ® Inc.
    All rights reserved. No part of this publication may be reproduced in any manner without permission of the Editor.
    Review WOODWEB's Copyright Policy.

    The editors, writers, and staff at WOODWEB try to promote safe practices. What is safe for one woodworker under certain conditions may not be safe for others in different circumstances. Readers should undertake the use of materials and methods discussed at WOODWEB after considerate evaluation, and at their own risk.

    WOODWEB, Inc.
    335 Bedell Road
    Montrose, PA 18801

    Contact WOODWEB

  • WOODWEB - the leading resource for professional woodworkers

      Home » Knowledge Base » Knowledge Base Article