Re: Quick Books/ Was Re: Am I charging too much here?
Aug 04, 2003 Last reply: 22 years ago 18 Replies
"
"Keyman
> >>From: "Glen Cooper"
> >
> >>That QuickBooks is a nice little program.
> >
> >What a coincidence. I'm in the process of setting up my
quick books. I'm
>strictly mobile with very little inventory. I get it as I
need it. Anyone
>willing to share a suggested list of accounts they've
found useful and / or
>essential for a mobile locksmith business?
>
> REGULAR customers get their own account...see below
>
> I have 2 special ones... cash TAXABLE...
> they are paying me now, AND they get charged sales tax...
this
assumes I dont need to keep track of the
individual...generic
account for (for me) 90% of things..
>
> cash NON taxable.... car openings, service calls, no
parts...
rest same as above...
you're state must be different than mine ? here, car openings are taxable (work on movable property) unless for resell by a licened reseller. service calls are also taxable 'if' when on a non-taxable job, (except parts, say a house rekey) you are asked to work on movable property.
my2¢
Didn't find your answer? Ask the community — no account required.
-
--Shiva--
labor, IF LISTED SEPARATELY is not taxable.
if i sell a lock, including installation, the whole thing is taxable. but, Lock $19.95 labor $25.00 tax is the lock ONLY...
EACH state has their own quirks... someone said if the internet tax ever does get passed, there would be THOUSANDS of different rates required plus the paying of the taxes to each county/town...
--Shiva-- nuk pu nuk
"
"RC" da "PCDJ
Not here... Labor is not taxable.. everything is broke down in two separate columns.. Good thing about QuickBooks you have the choice right off the bat weather the item is taxable or not via check box... this is how my accounts are.. (maximize your screen MIGHT make it look better)
9:05 AM A-1 Action Services
08/04/03 Account Listing August 4, 2003
Account Description Accnt. #
101 · CASH Total Combined Cash Assets 101
101 · CASH:101A Checking MFCU
101 · CASH:101B Cash on Hand
101 · CASH:101C Savings MFCU
102 · Accounts Receivable A/R
102
103 · Undeposited Funds Cash on hand
103
104 · Inventory Asset Merchandise Inventory 104
105 · Equipment Trailer 2001 Utility/Cargo Trailer 105
200 · Accounts Payable
200
201 · Accounts Payable (Vendors) A/P
201
202 · Credit Card A-1 Business Visa Platinum VISA BUSINESS CARD 202
203 · Credit Card Master Card A/P
203
204 · Credit Card Radio Shack Radio Shack
204
205 · Sales 'Taxes Payable' NC and Carteret Sales Tax 205
210 · Payroll Liabilities
210
206 · Note's Payable Int.Exp. Deducted at year end 206
301 · Owner's Capital Owner's Capital 301
301 · Owner's Capital:302 · Draws Draws
302
301 · Owner's Capital:303 · Investments Investments
303
304 · Retained Earnings Retained Earnings 304
305 · Opening Bal Equity Openning Balance Equity 305
401 · Taxable Sales Merchandise Sales 401
402 · Non Taxable Sales Service and Labor Sales 402
403 · Interest Income Interest Income 403
404 · Returned Check Service Charges Returned Check Service Charge 404
405 · Fees Fees
405
406 · Reimbursed Expenses Reimbursed Expenses 406
407 · Uncategorized Income
407
408 · Services Services
408
501 · Purchases
501
505 · Cost of Goods Sold
505
601 · Advertising Expense
601
602 · Repairs Repairs and Maintenance 602
602 · Repairs:602A · Building Repairs Building Repairs 602A
602 · Repairs:602B · Computer Repairs Computer Repairs 602B
602 · Repairs:602C · Equipment Repairs Equipment Repairs 602C
602 · Repairs:602D · Janitorial Exp Janitorial Expense 602D
603 · Gas & Oil Expense
603
604 · Depreciation Expense Depreciation Expense 604
605 · Amortization Expense Amortization Expense 605
606 · Insurance Insurance 606
606 · Insurance:606A · Liability Insurance Liability Insurance 606A
606 · Insurance:606B · Disability Insurance Disability Insurance 606B
606 · Insurance:606C · Work Comp Workman's Compensation 606C
606 · Insurance:606D · Vehicle Vehicle Insurance 606D
607 · Office Supplies Office Supplies 607
608 · Telephone Telephone 608
609 · Taxes Taxes 609
609 · Taxes:609A · Federal Federal Taxes 609A
609 · Taxes:609B · Local Local Taxes
609B
609 · Taxes:609C · Property Property Taxes 609C
609 · Taxes:609D · State State Taxes
609D
610 · Interest Expense Interest Expense 610
610 · Interest Expense:610A · Finance Charge Finance Charge 610A
610 · Interest Expense:610B · Loan Interest Loan Interest Expense 610B
610 · Interest Expense:610C · Mortgage Mortgage Interest 610C
611 · Travel & Ent Travel and Entertainment 611
611 · Travel & Ent:611A · Entertainment Entertainment 611A
611 · Travel & Ent:611B · Meals Meals
611B
611 · Travel & Ent:611C · Travel Travel
611C
612 · Bank Service Charges Bank Service Charges 612
613 · Small Tools Expense
613
614 · Shipping and Postage Postage and Delivery 614
615 · Cash Discounts Cash Discounts 615
616 · Contributions Contributions 616
617 · Automobile Expense Automobile Expense 617
618 · Dues and Subscriptions Dues and Subscriptions 618
619 · Equipment Rental Equipment Rental 619
620 · Licenses and Permits Licenses
620
621 · Printing and Reproduction Printing and Reproduction 621
622 · Miscellaneous Miscellaneous 622
623 · Professional Fees Professional Fees 623
623 · Professional Fees:623A · Legal Fees Legal Fees
623A
623 · Professional Fees:623B · Accounting Accounting Fees 623B
624 · Rent Rent
624
625 · Utilities Utilities
625
625 · Utilities:625A · Gas and Electric Gas and Electric 625A
625 · Utilities:625B · Water Water
625B
626 · Payroll Expenses
626
627 · Professional Development Professional Development 627
628 · Recruiting Recruiting
628
629 · Uniform Expense Work Clothes & Uniforms 629
409 · Other Income Other Income
409
699 · Other Expenses Other Expenses 699
2 · Purchase Orders
2
Page 1 btw.. it's set up assets, liabilities, capital, income, purchases and expenses
100, 200, 3..etc.. debit and credit balanced! some of the accounts were set up by quickbooks automatically.. And I always keep a regular ledger and a journal Plus all data backed up daily!
This is how Some of our items are listed
9:15 AM A-1 Action Services
08/04/03Item Listing August 4, 2003
Item Description Type Sales Tax Code
1.Lockout Emergency Lockout Service Service Non Rekeying Rekeying Charges by type Service Non Rekeying:Rekey Auto Rekey Standard Automotive Lock Charge Per Lock/... Service Non Rekeying:Rekey HS Rekey High Security Locks Service Non Rekeying:Rekey Master Master Keying Charge Per Cylinder with key prov... Service Non Rekeying:Rekey Master nokey Master Keying Charge Per Cylinder with no key p... Service Non Rekeying:RekeyStd. Rekey Keying Charge Per Cylinder with key provi... Service Non Rekeying:RekeyStdnokey Rekey Keying Charge Per Cylinder with no existi... Service Non SAFE WORK Safe Category Service Non SAFE WORK:Safe Open Basic Safe Opening Charge Service Non SAFE WORK:SafeCombo Safe Combination Change Service Non SAFE WORK:SafeLabor Safe Technician Labor Rate Service Non SAFE WORK:SafeRepr. (Min) Basic Safe Repair Following Std. Opening Service Non SAFE WORK:SafetyDepBx Safty Deposit Box Openning Service Non ServCall (Min) Service Call, Based on Location Service Non Service Locksmith Service Service Non Service:Basic HDWR In Basic Hardware Installation Fee Service Non Service:DBoltInst Deadbolt Installation Service Non Service:DeciCode Decipher Code for Replacement Keys Service Non Service:Disc Jockey Service Disc Jockey Service 'RC' da 'PCDJ' Service Non Service:Disc Jockey Service:DJ Lighting & Fog DJ Special Effects Lighting and Fog..(Some faci... Service Non Service:Disc Jockey Service:KJ Karaoke Service KJ Karaoke Service Service Non Service:Impressn Impressioning Service Service Non Service:Key Cutting Fee std. Key Cutting Fee std. (when Keys are supplied to... Service Non Service:Key Extraction Std. Broken Key Extraction/Removal of debris...Minim... Service Non Service:Maintenance Maintenance Labor Rate Service Non Service:Non Tax Sale Nontaxable Sales (service/labor related) Service Non Service:StdLabrRt Standard Labor Rate Service Non Service:Training Training for use of equipment and or Software Service Non Service:VatsServ. Decipher V.A.T.S. Pass Code,..(Standard With Ai... Service Non Service:Welding Charg Welding Material Usage Fee/Charge Service Non ABUS ABUS Inventory Part Tax ABUS:Padlock SCH C
83/45-300-OB Padlock SCH C 0 bitted Inventory Part Tax Adams Rite Adams Rite Inventory Part Tax Adams Rite:AD4590 PushLF AD4590 02 Narrow Stile Push/Pull Paddle (Push t... Inventory Part Tax Adams Rite:AD4710 DL Pnc AD4710 Deadlatch Aluminum Door Lock Inventory Part Tax Adams Rite:ARMortDeadLK Adams Rite Mortise DeadLock Inventory Part Tax Alarm Lock Alarm Lock Inventory Part Tax ALLSAFE Inventory Part Tax ALLSAFE:AH-F Housing AH-F Flush Mount Housing Inventory Part Tax ALLSAFE:AS111 Reader AS111 Entry Lock: (reader only) Inventory Part Tax ALLSAFE:ASA-1 Cards Card, Access ASA-1 STD Inventory Part Tax ALLSAFE:CB-1Codeboard Codeboard, CB-1 Sets ProperCode for AS-111 Inventory Part Tax American Lock American Lock Inventory Part Tax American Lock:AM1105DKAA AM1105DKAA American Padlock Duronotic 1 1/2' Bo... Inventory Part Tax American Lock:AM1106B-KA AM1106B-KA American Padlock Blue 1 1/2' Body an... Inventory Part Tax American Lock:AM1205B-KA AM1205B-KA Padlock - Blue Inventory Part Tax American Lock:AM1206DKAA AM1206DKAA American Padlock Duronotic 1 3/4' Bo... Inventory Part Tax American Lock:AM1206DKD AM1206DKD American Padlock Duronotic 1 3/4' Bod... Inventory Part Tax American Lock:AM5102-KD AM5102-KD Padlock 3' Shackle Inventory Part Tax American Lock:AM5200-KA AM5200-KA American Padlock 5200 Series Keyed Alike Inventory Part Tax American Lock:AM5261-KD AM5261-KD American Padlock 5260 Series 2' Solid... Inventory Part Tax American Lock:AM5262-KD AM5260-KD American Padlock 5260 Series 2' Solid... Inventory Part Tax American Lock:AM5360-KD AM5360-KD Padlock 2' wide Shielded shackle Inventory Part Tax Arrow Lock Arrow Lock Inventory Part Tax Arrow Lock:ARM12StrRm Storeroom Lockset 2 3/8 ARM12 TA-111-US26D Inventory Part Tax Arrow Lock:DSeriesICSSSgl ARROW D60 Series Extra Heavy Duty INTERCHANGEAB... Inventory Part Tax Arrow Lock:DSeriesSSSgl23/4 ARROW D Series Extra Heavy Duty Stainless Steel... Inventory Part Tax Arrow Lock:ESeriesSSSgl23/4 ARROW E Series Heavy Duty Stainless Steel Finis... Inventory Part Tax Automotive Automotive Parts and or Supplies Inventory Part Tax Automotive:All Lock All Lock Inventory Part Tax Automotive:All Lock:Automotive L Automotive Lock Inventory Part Tax Automotive:Auto keying Auto Keying Kits Inventory Part Tax Automotive:Briggs & Str. Briggs And Stratton Inventory Part Tax Automotive:Briggs & Str.:Auto Lock Auto Lock Inventory Part Tax Automotive:Strattec Strattec Inventory Part Tax Automotive:Strattec:GM IGN 79-96 GM IGN
79-96 Part # 609530 Chrome Inventory Part Tax Automotive:Strattec:IGN Chrysler 702788 Chrysler Uncoded Ignition Black Inventory Part Tax Baldwin Lock Baldwin Lock Inventory Part Tax Batteries Batteries all types and sizes Inventory Part Tax Cal-Royal Cal Royal
2 3/4 Entry Lock Ball Grade 2 SS Inventory Part Tax Caster Wheel 2' Caster Wheel 2' Inventory Part Tax Chicago Lock Chicago Lock Inventory Part Tax Chicago Lock:CH5001-LP CH5001-LP Chicago Filing Cabinet Lock..Die cast... Inventory Part Tax Chicago Lock:Tubular Swit Chicago LockTubular Switch Inventory Part Tax Chrysler Inventory Part Tax Chrysler:ChysCam Chrysler Cam for Ignition Lock Inventory Part Tax Chrysler:Chyswitchpkg Swich Package for Chrysler Inventory Part Tax CORBIN CORBIN Inventory Part Tax CORBIN:CR409F06-8 CR409F06-8 Spindle, 32 (KNOBXKNOB) 1 3/4 door S... Inventory Part Tax CORBIN:CRML2048KK-626 CRML2048KK-626 Mortise Lock, Knob X Knob Entran... Inventory Part Tax Don-Jo Manuf. Don-Jo Manuf. Inventory Part Tax
hope this helped, didn't want to burn up too much bandwidth for the internet impaired..LOL non-cable guys.. just add them as you go... this way you won't add a bunch of items you'll never use.. RC
"--Shiva--" snipped-for-privacy@abuse.net wrote in message news:bgkl90$jq5$0@63.78.119.209...
"
"Keyman
is
in my state, the 'whole' thing would be taxable. the lock wouldn't become part of real property till 'after' its installed.
internet
different
nuk pu nuk heard that !!
S
Steve Paris
I don't bother to use the 'inventory' part of QB, as being a one man fully mobile business, it is more a pain in the arse than a help, as every bit of stock you use or sell, you have to spend time recording it, and sure as houses, you will forget to record stuff after a busy day, and it just becomes a real hassle. I think one really useful ingredient of QB is the 'CLASS' section. Give every one of your customers a 'CLASS', i.e., 'Private Job, Shop, Factory, office, Government, Realtor, Body Corp, Repo, etc etc. You will then be able to keep track of which 'TYPE' of customer you should be targeting, and where your money is really coming from. Quick Books is GREAT MATE !
-
--Shiva--
you got it.... 95% of mine is businesses, schools, churches... and NOT the public-especially houses...yes I got some old ladies that I unlock the house for... or the car, and get an occasional call otherwise for a car... but around here, all one does is get in hot water in housing problems...so, I dropped them... my bottom line picked up after doing so...
and yes, DO NOT USE INVENTORY... total waste of time....
--Shiva-- nuk pu nuk
G
Glen Cooper
Got finished with the job today plus did two others. The customer was happy. Bought me pizza plus I got a tip. He said he'd call again and tell his friends. Charged as quoted plus twenty more for two strikes. Check cleared. Taxed for parts
Here if the customer gets the key before you get payed you better not leave because the lock becomes real property when it is installed. Learned that the hard way on a job a few years back with 62 Schlage cylinders. Never got paid but you learn every day.
Glen
P
Putyourspamhere
Can you clarify "Here if the customer gets the key before you get payed you better not leave because the lock becomes real property when it is installed."
Is there somehting in the law that puts you at further disadvantage to collect after you leave the premesis? Or do you just really mean get paid before you even hand over the keys in the first place?
S
Steve Paris
Damned if I would have rolled over on that one Glen. Plenty of avenues around to re-coup your money or property. Hope you let every other Locksmith in town know not to deal with that particular scumbag. Always more than one way to skin a cat !
G
Glen Cooper
Here in Texas if you give the home owner the key before you get the money, ( "Let me see the key to check the locks"), and then the home owner goes inside the house and locks the door, if you leave the house to call the police or for any other reason, the police tell you they can't do anything because you left the house.
The law says the locks become 'real property' after they are installed. If you take the locks off the door or damage them, then you go strait to jail. Do not past go and do not collect 200 dollars.
If you have a hot check or a bad credit card and the customers signature you stand a chance of getting the customer for service theft.
I walked into the house like an idiot, rekeyed the locks, gave the customer the key and let him check the locks while I being a moron at the time due to lack of knowledge, went to the truck to get the bill. He locked the door. I left because I didn't have a cell phone to call the police. I got screwed.
G
Glen Cooper
Really didn't have a leg to stand on. No signature, no hot check, no bad credit card number. The only proof I could have shown was the copy of the customers key.
Also here if you manage to get the customer into small claims court and you win, all that means is you have a judgement in your favor saying you won the case. Then you have to collect on that judgement. You can spend more money than the job is worth.
The real lesson I learned is only trust the trust in the 'In God We Trust' on the dollar bill and never the customer no matter how friendly they act.
P
Putyourspamhere
So if I understand you correctly if you make the mistake of turning over the keys but call the police and wait for them to arrive without leaving the premises then they will take action?
Sounds like the best thing is to make sure you hold onto those keys till you get your $$.
Since I asked about the quickbooks thing, I wanted to say thanks for the feedback rather that just fading into the e-world twilightzone. The input made setting up QB much easier. I'm sure I'll cahnage some things as I go, but at least I have a base to start from. None of the templates seemed to fit.
Here, pure service is not taxed, but if any product changes hands (even from the pinning kit, the whole job becomes taxable. About the only thing I don't charge tax on is auto openings.
The direction the thread has taken has also been useful to me. I decided to check on recourses available to me such as the "mechanics lien" and what if any similar protections might help get me paid before the situations arise.
Anyway, Thanks all.
G
Glen Cooper
A mechanics lien will sometimes work wonders in getting paid. However in Texas it is useless on a house that is being 'Homesteaded'. If you work in Texas and take a customer to court for a lien you need to check the customers tax recoreds before giving the customer the summons or you will walk away from court crying under CERTIAN situations. And they can also file a chapter 7 and stop payment on your lien too.
S
Steve Paris
When I originally began using QB I must admit I got a bit frustrated trying to set it up, especially as our country had just introduced a completely new taxation system. I hired the services of a professional QB mobile consultant / trainer to come to me, and set QB up the way I wanted it to work, as well as relevant taxation settings etc. She was only here for about 2 hours, and charged about $120. Money WELL spent, and of corse a claimable business expense. I can now do my entire years 'business and personal' taxation submittal in under 30 seconds. Gotta love that !!.
"
"Keyman
say thanks for the
twilightzone. The input
things as I go, but
seemed to fit.
bit frustrated
introduced a
professional QB
the way I wanted it
was only here for
expense. I can now do
in under 30
there are QB reps here in the states that will come and do the same thing. many accountants also are familiar with QB and can set it up for a particular business. (wish I would have known that years back when I started using QB) :-)
g'day Steve
P
Putyourspamhere
You can file a mechanics lein as you say, however in Texas apparantly there are some sticky issues when you do it with regard to real property. I don't know the ins and outs as I'm not in Texas. The text you quoted above was text I had already quoted from.......Glen???? I think it was.
C
cashcroft
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required
Report Content
You are reporting this content to the moderators. They will look at it
ASAP.