Invoicing/Ticketing System... Another one

devham

Member
Reaction score
10
Location
Canada
Hi Everyone. I know this gets asked a lot but I am curious if anyone has the same issues as our business.

We are a computer business with 5 technicians that does residential support with a store front for sales as well as MSP/On Site service for business customers.

Right now we bill everything from Quicbooks Desktop. This includes invoicing for recurring payment or customers that have an "account" that we bill at the end of the month. For our store front, we have all our parts as an item in Quickbooks that we then scan with a barcode scanner to create a sales receipt. This is how we have been doing it for the last 15 years but I think there is a better way.

For our store ticketing system/CRM we use PC Repair Tracker. This has been customized to our liking and allows us to keep all work orders up to date. When a customer comes to pickup the computer we then create a receipt in Quickbooks with the work order ID and check them out of PCRT. This isn't a big deal, we have all gotten use to this procedure.

Were we fall flat is our billing for "on site" time. Right now we just have an excel spreadsheet that gets updated and then translated to Quickbooks at the end of the month. I know this isn't the best way to do things.

What I am looking for would be a system that would allow us to create tickets and then export and create the invoice in Quicbooks. I am not a fan of using another system to track invoices because if a customer comes to pickup a cable and add it to the "account" I would like it to be all invoiced on one invoice at the end of the month. When keeping track of time for our on site time we need to keep track of hours worked per technician and the mileage. Another sticking point we have found is that we are in Manitoba and must display both PST/GST on the invoices, a lot of other systems that create their own invoices do not allow for this and the work around never get the tax values correct.

Any help or advise would be greatly appreciated. This has been keeping me awake and thinking for a while now.
 
You need both PST and GST put in as separate lines?

Yes. Our invoices must have GST (5%) and PST (8%) on separate lines of the invoice. They are calculated on the whole invoice but must be displayed separately. So if we have a single tax item of 13% this wouldn't work as it would display the total taxes and then when collecting taxes, some items are exempt from taxes if purchased for resale in our province.
 
Yes. Our invoices must have GST (5%) and PST (8%) on separate lines of the invoice. They are calculated on the whole invoice but must be displayed separately. So if we have a single tax item of 13% this wouldn't work as it would display the total taxes and then when collecting taxes, some items are exempt from taxes if purchased for resale in our province.
On top of that, there are some services that are PST-exempt. Couple that with the reporting periods can vary between PST and GST, and it's a bit of a headache. Lot of people really came down hard on HST out in the West, but for a business, HST reduces workload and maintenance a lot... As well as that you guys can reclaim HST; We can only reclaim GST and get PST-exempt on resell-items only.
 
Yeah - that'll be a doozy.

Repairshopr and most other systems can support having different tax rates on different line items, but I haven't found any that will display multiple tax lines in the way that you're asking.

IE : You have have line 1 at PST and line 2 has GST, but the totals will just show "Tax" at the bottom
 
Yeah - that'll be a doozy.

Repairshopr and most other systems can support having different tax rates on different line items, but I haven't found any that will display multiple tax lines in the way that you're asking.

IE : You have have line 1 at PST and line 2 has GST, but the totals will just show "Tax" at the bottom

Do you know of a system that works well for keeping track of on site time to invoice? Right now PCRT and QB is workable for what we do. Keeping track of time is one of the bigger challenges we face.
 
Autotask will do everything that you're asking about.

How does invoicing work in Autotask? Do I have to email/print the invoice from AT or can I print the invoices from Quickbooks and then send a statement to the customer at the end of the month? If the later, can the invoices from Quickbooks display service notes from Autotask?

Just wondering as I did a demo with Autotask, it was pricey but looked good. The presenter wasn't 100% on Quickbooks integration and they wouldn't give me a demo to try with my Quickbooks file.
 
You approve and post work/hours in Autotask, then create invoices. You can then export the invoices directly to QuickBooks.

You need to put in the time to setup and learn Autotask. If you don't, then you will not like it. Same goes for the QuickBooks integration.
 
Repairshopr has a timer in the ticketing system.

I use that with my phone when I go on site so I have a digital record of how long I'm there.
 
How does invoicing work in Autotask? Do I have to email/print the invoice from AT or can I print the invoices from Quickbooks and then send a statement to the customer at the end of the month? If the later, can the invoices from Quickbooks display service notes from Autotask?

Just wondering as I did a demo with Autotask, it was pricey but looked good. The presenter wasn't 100% on Quickbooks integration and they wouldn't give me a demo to try with my Quickbooks file.

Invoices are created in AT. You then sync these to QB. You can print\email the invoices from either AT or QB. Statements are from QB only. If you'e thinking about issuing on the spot invoices using AT then don't. The process is a bit too involved for that.
 
Invoices are created in AT. You then sync these to QB. You can print\email the invoices from either AT or QB. Statements are from QB only. If you'e thinking about issuing on the spot invoices using AT then don't. The process is a bit too involved for that.
Sounds tedious to manage.
 
It can be, tbh, but nothing else I've tested has better integration with any accounts package. It sure beats printing off the invoices and manually entering them into QB. :eek:
#1: Don't get why QuickBooks doesn't offer a proper solution. They USED TO have a POS solution that worked well.
#2: Most businesses around here just do totals and transfer the totals into QB manually daily, weekly or monthly.
#3: I don't get why the whole thing is such brain surgery. MOST businesses need accounting. MOST need some form of POS. MOST would like some modularity to bolt in, for example, a ticket tracking system.
 
So i've started looking at MaNova from Futurestar Systems. Has anyone had the opportunity to use it? Or has anyone looked in to it before? I would be curious as to why or why you didn't go with them.

http://www.futurestarsoftware.com/?q=story/products
I was looking for serialized inventory, which it didn't do when I looked into it. TBH, I can't believe there is no one company who can get the basics right for Canada. There's only a small handful that do serialized, and they're all US-based with no intent to handle Canada taxes. I might have to settle for one like this one without Serialization, and fall back to something else to track S/Ns.
 
Back
Top