T-Shirt Forums banner

screen printing Quote sheet or software

45K views 32 replies 25 participants last post by  BidGuru 
#1 ·
Well we don't have huge massive volumes yet for custom shirts but it's getting better.

My problem is we can't afford the $4000 quote software that's available.

Just curious what you use to quote your orders and how you came up with it.

I've been trying to find an excel template with the formulas in it, but no luck.

We want to be consistent every time when we do.

Any thoughts from the experienced?
 
#8 ·
Price Perfect is pretty basic and as far as I know has no support (if you play with it you should be able to figure it out pretty well). Can't really expect a whole lot of support when it's free.

If you need something that is a little more advanced and also comes with full support but still on the less expensive side, try Screen Print Embroidery Promotional Products Software
T-boss has a free trial that you can download to see if it's what you need. This is the program that I use for my business. I've only been using it a short time but I really like it. It's easy to use, set up takes a little time but you'll have that with any program. They have a manual that you can download off the site, online support, phone support and a video tutorial.
 
#10 ·
There are only a few programs developed for true screen printing quoting. Tquoter and PriceIt are two of the top program. The other I've seen is T-Boss. Have not seen good marks for this one though. If you think T-quoter is overpriced, I cant wait to hear what you say about PriceIt. PriceIt is used by a majority of shops that I talk to. It is probably the highest rated program although we use Tquoter in my shop. As long as we go by the prices shown, we make money.
 
#21 ·
Here's an Excel spreadsheet that I downloaded from another forum years ago, and on which I based calculators that I've customized for retail sales and for jobs I do for resellers. The only shortcomings are that it doesn't have options for more than 2 printing positions, so if you're doing front, back, and a sleeve, you'll have to make some accommodation for the third position. I usually do it by adding a color to the second print position, then tack on something for the extra trip down the dryer.
You'll have to select cells and read the formulas to change built-in discounts that appear in the first TOTAL row (All Materials and All Labor Charges) that appears just beneath the large black area.
 

Attachments

#24 ·
If it's me you're thanking for a job well done, it's misguided. I didn't create the spreadsheet, just downloaded it from a forgotten contributor on another forum about 6 or 7 years ago who responded to the same requests . . .
It's worked well for me. I do all my bookkeeping in Excel.
 
#25 ·
Recently switched from T-quoter to T-works Manager. Love the interface and the way it sets up pricing. it also allows you to store and track order details. The customer service started out great but has recently took a turn for the worst. Emails and phone calls have gone unanswered for over a month, and I spent the passed couple days recovering my data file. Anyone have any contact info for Joe?
 
#29 · (Edited)
This link seems to not be working! I am desperate for some help calculating T-shirt prices.

Does anyone have this spreadsheet or one like it to share? Or is there currently any low cost software?

I am a small custom print & copy shop, and I do shirts as well, but they are not my only focus so my budget on shirts is only about 15-20 percent of my income. However, recently the local sport shop closed their storefront location so I could pick up lots of work if I could only get my sh** together!

HELP!!!!!???

Regarding post from: tpitman
Senior Member
Certified T-Shirt Junkie
Here's an Excel spreadsheet that I downloaded from another forum years ago, and on which I based calculators that I've customized for retail sales and for jobs I do for resellers. The only shortcomings are that it doesn't have options for more than 2 printing positions, so if you're doing front, back, and a sleeve, you'll have to make some accommodation for the third position. I usually do it by adding a color to the second print position, then tack on something for the extra trip down the dryer.
You'll have to select cells and read the formulas to change built-in discounts that appear in the first TOTAL row (All Materials and All Labor Charges) that appears just beneath the large black area.
Attached Files
Taxable Job Calc.xls (21.0 KB, 477 views)
 
#31 ·
Well we don't have huge massive volumes yet for custom shirts but it's getting better.

My problem is we can't afford the $4000 quote software that's available.

I've been trying to find an excel template with the formulas in it, but no luck.

We want to be consistent every time when we do.

Any thoughts from the experienced?
A lot of small shops or start-up shops try and use spreadsheets for pricing decorated apparel. There are a few reasons for this. They can create something in Excel themselves in an attempt to have some kind of consistency and save time pricing or they may find something someone else has already created with Excel and then try to tweak it to fit their needs. Plus they can usually use a spreadsheet on the cheap or for free.

That said there is several major problems with using a spreadsheet for pricing decorated apparel. The first problem is to create a spreadsheet that would automatically calculate even a small amount of different garment styles with a variety of different decorating methods or locations and calculate quantity breaks, pricing differences between whites, lights and darks, pricing on different sizes or even different styles within the same order would be a daunting task and is doomed to fail from the git-go.

Another problem with using a spreadsheet is that unless you save a copy for each quote/invoice or print out a hard copy you could end up with literally thousands of saved spreadsheets in a few years. You would also not have any good way of instantly pulling a customer's order history.

Spreadsheets or even an accounting program like QuickBooks are fine when used with services or products that do not have the possibility of pricing variations for the same item/style number. They are not any good for pricing custom decorated apparel.

This brings us to programs designed for pricing/quoting custom decorated apparel. These programs range in cost from around $40.00 to over $10,000.00 . The lower priced ones offer basic pricing/quoting/invoicing, customer history, product catalogs, pricing matrixes for different customer types while the higher priced ones will basically allow you to price, track, schedule everything that goes on in your shop. The fancier the program, the harder it is to setup and use.

I would defiantly recommend that you forget spreadsheets as an option and I would also recommend you download trials of as many actual programs for pricing custom decorated apparel as you can find. Play with them and then pick the one that fits your shops needs and budget
 
#33 ·
Hey Folks,
Here is a spreadsheet I created for my screen printing business that you can use for free.
It's very complete and big. It is an Excel spreadsheet, meaning you can mess it up, like any Excel file, but it's very adjustable.

I was using this for years till I got an outside salesperson, that was not an Excel expert.
We went looking for an easier solution to bidding, could find nothing we liked so we created an awesome program that does bids!

Here is the free spreadsheet.
https://www.fastaccuratebids.com/free-screen-printing-spreadsheet/

Make sure you keep a backup copy if you are using it, in case you change something and need to get back to the original.

Good Luck
Steve
 
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.
Top