Loading... Please wait...

Auto Body Estimating Solutions: Excel and OpenOffice.org

Auto Body Shop Estimating

Race Club Body Shop Newsletter

Auto Body Shop Estimating



abe-product-default.pngBody shop estimating software tools for smaller auto body shops, collision repair shops, restoration shops, custom body shops and even backyard shops will find this tool extremely helpful.


Body shop estimating software and repair management tools save time, money and let you write, print, manage and profit.parts-look-up-2-large.png

Do more than just print an estimate you filled in on your computer, manage that information, let the sheet do the heavy lifting, print repair orders from the same information, track parts cost, materials and more.

With BSET's (body shop estimating tools), you write an estimate, manage the repair, manage parts and materials cost and profit margin.  Specifically designed for smaller shops with lower volumes who still need the ability to print a computer generated estimate for their customer or the Insurance Company but don't need the added monthly expense of point and click.

* We phased out support for the Microsoft Excel versions.  If you are set on using Excel, see this page for helpWe are moving towards OpenOffice only because it's free.  more.  Files are now called BSET, short for Body Shop Estimating Tools of course.  Updated Screen Shots


Need an estimate now? We can write it for you while you wait.  We still use this estimating tool in our office when writing estimates for clients and custom body shop referral customers.


30-years-certification.pngIt's great as a stepping stone software alternative for auto body shop estimating and management until your shop is ready for the expensive database driven collision estimating programs with high monthly fees.

These body shop estimating software tools are optimized for specific types of body shop or we have a Universal version (BSET v6.0) that covers all shops except rebuilders.



CPU Requirements:  Windows PC running OpenOffice.  For multi computer use, integrates with Dropbox or Google Drive.  Bug fix versions are always free.  Free upgrades to newest version when you Have a Website with WebDesignManageSEO.com or buy continued support or Buy Training Sessions.


Popular Links: How to install with OpenOffice, About these Body Shop Estimating Software Solutions, Why We Developed These Body Shop Estimating Software Solutions.




dropbox-logo2.pngFully compatible with Dropbox

Anywhere you have Internet, you can open the estimating file and work.  Although Internet is not required to use this Body Shop Estimating software solution, you can increase your options of access by using the Internet and Dropbox together.

*Also compatible with Google Drive for cloud storage use and multi computer use.






Download OpenOffice

Our Body Shop Estimating Tools require either OpenOffice or Excel, as we are phasing out Excel, we recommend using OpenOffice.  If you know a little about Excel, you can tweak its use as much as you want.  Click here to download OpenOffice.





Web Design Manage SEO.  Don't Neglect Your Website!

A non existing (Facebook is not a website) or neglected website does more harm than good, what message are you sending your potential new customer if they don't see you have a website or the one you have is not as impressive at it should be.  Websites can be done properly and become a very productive part of your business in an affordable way, we are proof of that.  We have teamed up with www.WebDesignManageSEO.com to provide great value in new websites or updating older websites.




 New BSETv6.0 Links were added for decoding VIN and getting OEM parts pricing.  These resources provide diagrams and part numbers.  Part numbers are accurate when entering VIN.  Diagrams can be zoomed in and screen shot.

Looking up parts and decoding your VIN, adding part numbers and getting parts pricing is even more simple.  All body shops can use this feature.  Although Body Shop Estimating tools can be used without Internet access, parts look up will require it as it is web based.






Add you custom shop to our list for customers.If you have a custom body shop or can accommodate customers who require custom work.  Add your shop info to our list so we can send them to you.  Adding your shop is free, we write the estimate for them, all we ask is 4% of the totals as our referral fee.  Add Your Shop


Learn How to Get it Free by Purchasing an Estimating Tool Plus Website Combo!




Which Body Shop Estimating Alternative version is right for you?



All Our Body Shop Estimating Software Tools (BSET 's) have similar attributes, the variables being: Shop type they are set up for.  *Builders and Re sellers version has dedicated tab for sales.

Get unlimited support and upgrades for only $29.95 the first 30 days and $9.95 a month after 30days and you will always have the lated version and unlimited phone support.



Body Shop Estimating Features:


  •  Write and Print Body Shop Estimates

    Even backyard shops need a way to generate and print an estimate that will be accepted by both the customer and the insurance company. You can hand write and estimate, but customers and insurance companies are 90% less likely to question and estimate when it is printed. Even though the information may be the same.

  •  Manage the Entire Repair Process

    After the estimate is written and the car is dropped off for repairs, you can also manage the entire repair process. Keeping track of expenses, customer payments, parts and materials cost.

  •  Adjust Your Shop Settings

    Adding your shop name, address, phone numbers, email, website and labor rates once and never have to do it again. Rates can be changed for specific customers of you like but not necessary.

  •  Add Customer/Car/Insurance Information

    Add customer information, car information and Insurance company information and it will carry the information from tab to tab during the repair process.

  •  Record Payments

    Record your customer payments and they will automatically be applied to the total and reflect customers balance.

  •  Print Repair Orders

    Repair orders are generated automatically. Simply print and place in the car for reference, labor hours are added so technicians have a point of reference for how long the work should take. You can add notes to the shop or they can write note for the supplement.

  •  Add or Link to Images/Albums

    Using Google Photos or inserting photos from your computer is a great way to reference repair work. Within a few simple steps, you can insert or link to photos.

  •  Generate Supplements

    Always something missed on the original agreed on amount. Creating a supplement is the same using the supplement tab. Parts cost change? It will even adjust for the variation in parts cost.

  •  Check in Parts

    Enter your parts invoices when they come in. It keeps track of how much they cost vs how much you estimated they cost.  Automatically inserting the difference into your supplement.

  •  Check in Materials

    Same as parts, you enter the materials invoice and it will adjust the supplement accordingly.

  •  Totals Page for Itemized Totals

    Totals page accomplish the same goal as the databases, point and clicks. It gives you one page look at the detailed totals and what the charges are for. Mostly for reference, but its there to answer questions about the repair.

  •  Statements for Customers

    Statements help you keep track of payment and give you something printable you can give to your customer.

  •  Profit Tab

    Profit tab shows you how much money you actually made.

  •  Reviews Requests

    Email customer to ask for kind words online after you deliver the car.

  •  Custom Body Shops looking for customers can now add their shop information to A Touch of Custom list of preferred shops.  It's free to add your shop to the list, all they ask is 4% of the total.

View the Video Demo at the bottom of the product page... 


    • 08/15/2018 Unlimited Support and Upgrades:  You can now get unlimited support for 30 days for only $29.95 and free upgrade for $9.95 a month after 30 days.  Always get the latest version with the newest updates and features and enjoy unlimited support for only $9.95 a month.  Get it now!
    • 05/11/2018  User requested: Added parts look up for Aftermarket Parts, Added "Mileage In" and "Mileage Out".  Coming soon?  Hiding parts mark ups (some users don't like customer or Insurance companies seeing their profit margins), it will still calculate it if you choose to, just wont show it on the estimate totals.
    • 04/16/18 Updated Items Added to Current BSETv6.0.  Reference number capability to accommodate PO's or use the last 8 of the VIN, Space to record mileage for those body shops who may have customers (fleet) requiring it, Updated pull down menu items for time saving click to add.
    • 10/26/2016 New Features Slated for BSETv6.0 more  Order v5.0 today and we will send you the upgrade free when it's released.
    • 08/31/2016  We have a new section coming.  It's specifically designed for novice estimate writers, it will help inexperienced or seasoned estimators understand more and learn how to properly write an estimate that customers and insurance companies will pay for.
    • 07/04/2016  Tax on services update has been made.  These estimating tools accommodate the new government regulations for taxes on services.  If your state doesn't require it, use "0" on that line in Shop Settings.
    • 09/30/2014 Credit Card Security (Card Declined?).


Video Demo

 Learn How to Get it Free by Purchasing an Estimating Tool Plus Website Combo!