Go Back   Technibble Forums > The Computer Repair Business > Business and Legal Issues

  Technibble Sponsor

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2011, 10:00 PM
DanF DanF is offline
 
Join Date: Mar 2009
Location: Malta (EU)
Posts: 818
DanF is an unknown quantity at this point
Default Manual filing of invoices

Never had any issues, but I felt like discussing this to see if I'm missing something, or maybe it can be done better.

I currently file invoices from my supplier (sometimes from retail stores) in a simple file by date. I do not save any information about these invoices digitally. All I do is keep a simple inventory in a spreadsheet, with these details:

brand, model, price I got it for, date of purchase, invoice number, and months of warranty.

Since my clients database is increasing, I am getting more and more invoices to file. Obviously the disadvantage is that you can't easily search for an invoice manually, just in case you have to RMA a device.

- Do you somewhat link the manual devices to a digital source?

- Lately I had to RMA a power supply. I could easily find the original invoice since I knew approximately the date I got it from the supplier. They didn't even requested the invoice, although I gave them the number. What if I had bought this item multiple times (separate invoices)? How do I know if it's still covered by the supplier's warranty? (since you I don't always sell the items immediately). Do you store any bar codes?

- How do you identify devices sold to clients? Do you list down the item's bar code on the client's invoice (obviously unique, not just the model number)?

I'm not asking because I'm having issues, again, it's something I thought of. Sometimes it helps thinking about bad things that could happen.

Thanks
Reply With Quote
  #2  
Old 08-10-2011, 10:50 AM
K007's Avatar
K007 K007 is offline
 
Join Date: Feb 2009
Posts: 947
K007 is an unknown quantity at this point
Default

Quote:
Originally Posted by DanF View Post
- How do you identify devices sold to clients? Do you list down the item's bar code on the client's invoice (obviously unique, not just the model number)?
Thanks
Sold or used as replacement by serial number.
Most of them have the serial number barcoded.
Serial number goes on the invoice.
Reply With Quote
  #3  
Old 08-10-2011, 11:34 AM
atlanticjim's Avatar
atlanticjim atlanticjim is online now
 
Join Date: Dec 2008
Location: Long Island, New York
Posts: 1,107
atlanticjim is on a distinguished road
Default

I use QuickBooks which allows me to tie individual purchases to my repair records and invoices. I also scan the purchase invoices into quickbooks.
In this way, if I have to find a purchase invoice for an item I used in a repair, I just find the repair invoice, click on the associated part used, pull up that item purchase and then print out a pdf copy of the original purchase invoice.
__________________
Patchogue, New York
Reply With Quote
  #4  
Old 08-10-2011, 02:46 PM
Tony_Scarpelli's Avatar
Tony_Scarpelli Tony_Scarpelli is offline
 
Join Date: Jun 2011
Location: Wichita, Kansas U.S.A.
Posts: 2,134
Tony_Scarpelli has a spectacular aura aboutTony_Scarpelli has a spectacular aura about
Default

Quote:
Originally Posted by DanF View Post
Never had any issues, but I felt like discussing this to see if I'm missing something, or maybe it can be done better.

I currently file invoices from my supplier (sometimes from retail stores) in a simple file by date. I do not save any information about these invoices digitally. All I do is keep a simple inventory in a spreadsheet, with these details:

brand, model, price I got it for, date of purchase, invoice number, and months of warranty.

Since my clients database is increasing, I am getting more and more invoices to file. Obviously the disadvantage is that you can't easily search for an invoice manually, just in case you have to RMA a device.

- Do you somewhat link the manual devices to a digital source?

- Lately I had to RMA a power supply. I could easily find the original invoice since I knew approximately the date I got it from the supplier. They didn't even requested the invoice, although I gave them the number. What if I had bought this item multiple times (separate invoices)? How do I know if it's still covered by the supplier's warranty? (since you I don't always sell the items immediately). Do you store any bar codes?

- How do you identify devices sold to clients? Do you list down the item's bar code on the client's invoice (obviously unique, not just the model number)?

I'm not asking because I'm having issues, again, it's something I thought of. Sometimes it helps thinking about bad things that could happen.

Thanks
There are better ways but what we did was this:

Every receipt of inventory, we put a label on it with the date of invoice and vendor. 06/19/11DH That would be June 19 this year from DH.

The customer brings the part in, it must have our label on it to be under warranty.

The customer is required to bring in their invoice from us, which saves us a great deal of time and seeing if it is within the 12 month or 90 day warranty period.

So we can check that invoice first to see if it is within the period, then we can check the purchase date on our added sticker if they don't bring in the invoice. I guess we demand the invoice to cover us if we cannot find our paper work or their sticker wears off is unreadable or is removed. Usually we can handle their requests.

We use NEBS with a manila hard copy which is our permanent record. That gets filed in larger folders for that client alphabetically.

Go to your dentists office and you will see a 5'x6' metal shelf which holds thousands of folders for clients and invoices for each job/service within each folder all filed alphabetical. This could be a good system for you.

BTW- using the stickers to trace back to the vendors invoice gives us the information we need to rma the product. It has the date, invoice #, brand and serial numbers on expensive items and brand on the other items like power supplies which don't get serial numbers recorded. So I can now process the rma easily.

You soon find with this process that it is easier to check in larger orders a few times a month than many small orders.
Reply With Quote
  #5  
Old 08-10-2011, 02:48 PM
Tony_Scarpelli's Avatar
Tony_Scarpelli Tony_Scarpelli is offline
 
Join Date: Jun 2011
Location: Wichita, Kansas U.S.A.
Posts: 2,134
Tony_Scarpelli has a spectacular aura aboutTony_Scarpelli has a spectacular aura about
Default

Quote:
Originally Posted by atlanticjim View Post
I use QuickBooks which allows me to tie individual purchases to my repair records and invoices. I also scan the purchase invoices into quickbooks.
In this way, if I have to find a purchase invoice for an item I used in a repair, I just find the repair invoice, click on the associated part used, pull up that item purchase and then print out a pdf copy of the original purchase invoice.
Jim I would think this works best with special purchase but if you order 40 power supplies on one PO, it seems messy to connect 40 invoices back to that purchase order or vendors bill.
Reply With Quote
  #6  
Old 08-10-2011, 02:50 PM
Tony_Scarpelli's Avatar
Tony_Scarpelli Tony_Scarpelli is offline
 
Join Date: Jun 2011
Location: Wichita, Kansas U.S.A.
Posts: 2,134
Tony_Scarpelli has a spectacular aura aboutTony_Scarpelli has a spectacular aura about
Default

Quote:
Originally Posted by K007 View Post
Sold or used as replacement by serial number.
Most of them have the serial number barcoded.
Serial number goes on the invoice.
I can see that would be helpful. Our way we put the date/vendor on the label which ties back to the Purchase order which has the serial numbers. If no serial number is listed on the invoice then our vendor doesn't require one, so we don't require it ourselves either.
Reply With Quote
  #7  
Old 08-10-2011, 04:40 PM
K007's Avatar
K007 K007 is offline
 
Join Date: Feb 2009
Posts: 947
K007 is an unknown quantity at this point
Default

Quote:
Originally Posted by Tony_Scarpelli View Post
I can see that would be helpful. Our way we put the date/vendor on the label which ties back to the Purchase order which has the serial numbers. If no serial number is listed on the invoice then our vendor doesn't require one, so we don't require it ourselves either.
You are right, but I do it because that is the customer's proof.
If the item sold is still in warranty you can corroborate the serial number on the invoice with the serial number on the thing the customer brings back.
Reply With Quote
  #8  
Old 08-10-2011, 07:37 PM
4ycr's Avatar
4ycr 4ycr is offline
 
Join Date: Jun 2010
Location: West Lothian, Scotland
Posts: 1,456
4ycr has a spectacular aura about4ycr has a spectacular aura about
Send a message via Skype™ to 4ycr
Default

I use kashflow for my accounts and this allows me to add invoices from suppliers, I then scan the original one in as well and I can search for what I need.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:02 PM.


Powered by vBulletin®
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Technibble.com is based out of MELBOURNE, AUSTRALIA.