Results 1 to 13 of 13

Scrappers Templates and SpreadSheets

| General - Let's talk business
  1. #1
    Tcgs started this thread.
    Tcgs's Avatar
    SMF Badges of Honor

    Member since
    Nov 2012
    Posts
    181
    Thanks
    47
    Thanked 62 Times in 26 Posts

    Scrappers Templates and SpreadSheets

    Do you use spreadsheets to help your scrap metal business? If so, tell us about them.

    If not try a few spreadsheets / templates for,



    Break Even Analysis
    Monthly/Annual Budgets
    Route Planning
    Sales Planning
    Client Tracking
    Envelopes
    Purchase Orders

    Don't have software? Try Google Docs.
    All the software you need is free.
    Except Quickbooks, which you may not need.
    GREENTRUCK
    "CHANGING THE WAY YOU LOOK AT RECYCLING"

  2. The Following User Says Thank You to Tcgs for This Post:



  3. #2
    Mick's Avatar
    SMF Badges of Honor



    Member since
    Aug 2010
    Location
    Palermo, Me
    Posts
    3,407
    Thanks
    363
    Thanked 3,086 Times in 1,326 Posts
    Quickbooks is all I use to track expenses and income, including monthly and yearly reports. Mine is Quickbooks 2009, which was/is free which I keep as a desktop icon. Not sure if it's still free or not.
    People may laugh at me, but that's ok. I laugh all the way to the bank.

  4. The Following User Says Thank You to Mick for This Post:


  5. #3
    billygoat's Avatar
    SMF Badges of Honor

    Member since
    Feb 2012
    Location
    Rochester, NY
    Posts
    631
    Thanks
    99
    Thanked 491 Times in 250 Posts
    I use an older version of Quicken. Spreadsheets are just too much work to set up and maintain. I was able to get the software for free and since it's an older, outdated version they didn't ask for a fee when I registered it.

  6. The Following User Says Thank You to billygoat for This Post:


  7. #4
    Tcgs started this thread.
    Tcgs's Avatar
    SMF Badges of Honor

    Member since
    Nov 2012
    Posts
    181
    Thanks
    47
    Thanked 62 Times in 26 Posts
    I use some spreadsheets everyday. And the templates are time savers. These spreadsheets are absolutely necessary for my business.

  8. #5
    SMF Badges of Honor


    Member since
    Feb 2013
    Location
    pa
    Posts
    140
    Thanks
    0
    Thanked 106 Times in 57 Posts

    Scrappers Templates and SpreadSheets

    I am super high tech. Hand written ledger with receipts paperclipped inside. Kept in the front of the truck so I can write in it as soon as I exchange money. I do however snap a picture of my receipts since I have no real back up system.

  9. The Following 2 Users say Thank You for This Post by Trot:


  10. #6
    Tcgs started this thread.
    Tcgs's Avatar
    SMF Badges of Honor

    Member since
    Nov 2012
    Posts
    181
    Thanks
    47
    Thanked 62 Times in 26 Posts

  11. #7
    volvoscrapper's Avatar
    SMF Badges of Honor


    Member since
    Aug 2012
    Location
    New Jersey
    Posts
    209
    Thanks
    289
    Thanked 218 Times in 111 Posts
    receipts and cash go in cookie jar, my lovely wife takes it from there.

  12. The Following 2 Users say Thank You for This Post by volvoscrapper:


  13. #8
    TheRecycler's Avatar
    SMF Badges of Honor


    Member since
    Jan 2013
    Location
    Ithaca, NY
    Posts
    618
    Thanks
    31
    Thanked 412 Times in 198 Posts
    Quote Originally Posted by Trot View Post
    I am super high tech. Hand written ledger with receipts paperclipped inside. Kept in the front of the truck so I can write in it as soon as I exchange money. I do however snap a picture of my receipts since I have no real back up system.
    I like your method. It works good for me
    Your Trash-My Cash
    Yours Truly, TheRecycler:
    RecycleReuseItAll@Facebook.com

  14. #9
    supaholaya's Avatar
    SMF Badges of Honor


    Member since
    Mar 2013
    Location
    Philly
    Posts
    39
    Thanks
    0
    Thanked 25 Times in 11 Posts
    They have free expense apps on Android find one that suits your needs

  15. #10
    Calamitous's Avatar
    SMF Badges of Honor


    Member since
    Mar 2013
    Location
    Kansas City
    Posts
    25
    Thanks
    87
    Thanked 11 Times in 10 Posts
    You might want to make a copy of that spreadsheet to share, and strip out some data... it looks like you might have left some personal data in there that anyone can read...

  16. #11
    SMF Badges of Honor

    Member since
    Sep 2011
    Location
    Rochester NY
    Posts
    616
    Thanks
    19
    Thanked 526 Times in 238 Posts
    I build many custom Excel spreadsheets for myself and clients.

    Here is a 12 month projected Income and Expense spread sheet. Will show you, Income, cost of sales and expenses and break them down for you in an easy to read spread sheet. It will also show you the percentage of that income, cost of sale or expense compared to the others.

    If you need more line items simply add another line and copy paste.

    I have included some sample data for you to get the idea.

    You can download this from my dropbox here https://dl.dropboxusercontent.com/u/...statement.xlsx

    This spreadsheet is locked with a password. I will be talking with the admin of this site to see if selling my business spreadsheets would be alright through this site. If not i will offer these myself though PM.

    http://reclaimtech.com/
    We pay you to recycle!

  17. The Following User Says Thank You to drozenski for This Post:


  18. #12
    SMF Badges of Honor

    Member since
    Sep 2022
    Location
    Memphis, TN
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    BUMP!

    I need help please - looking to go from handwritten tickets to a more organized fashion - specifically in a timely fashion for legal reasons (thanks IRS).

  19. #13
    mikeinreco's Avatar
    SMF Badges of Honor


    Member since
    Dec 2011
    Location
    TENNESSEE
    Posts
    4,914
    Thanks
    1,257
    Thanked 4,992 Times in 2,331 Posts
    https://www.iscrapright.com/

    A quick google search and this was at top of the list....I don't endorse or use this company but just google "scrap software" and you should come up with some answers


  20. Similar threads on the Scrap Metal Forum

    1. Replies: 13
      Last Post: 09-16-2013, 02:34 PM
    2. SS scrappers
      By Copper Head in forum A Day in the Life of a Scrapper
      Replies: 4
      Last Post: 06-06-2013, 10:52 AM
    3. Hello Scrappers
      By supaholaya in forum Introduce yourself
      Replies: 0
      Last Post: 03-24-2013, 12:08 PM
    4. New Scrappers!
      By JunkSquad in forum Introduce yourself
      Replies: 10
      Last Post: 12-03-2012, 05:58 AM
    5. Hello all scrappers
      By dbmax in forum Introduce yourself
      Replies: 2
      Last Post: 04-25-2012, 12:38 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

 
Browse the Most Recent Threads
On SMF In THIS CATEGORY.





OR

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

The Scrap Metal Forum

    The Scrap Metal Forum is the #1 scrap metal recycling community in the world. Here we talk about the scrap metal business, making money, where we connect with other scrappers, scrap yards and more.

SMF on Facebook and Twitter

Twitter Facebook