Re: Quick Books/ Was Re: Am I charging too much here?

Aug 04, 2003 Last reply: 22 years ago 18 Replies



> >>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¢



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

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...

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 !!

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 !

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

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

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?

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 !

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.

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.

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 $$.

here?

<f5ZXa.86605$ snipped-for-privacy@bgtnsc05-news.ops.worldnet.att.net>

message

much here?

<K6IXa.88223$ snipped-for-privacy@bgtnsc04-news.ops.worldnet.att.net>

The customer was

he'd call again and

two strikes. Check

you better not

installed. Learned

cylinders. Never

before you get payed

when it is

disadvantage to

mean get paid before

you get the money,

home owner goes

house to call the

can't do anything

are installed. If

go strait to jail.

customers signature you

gave the customer

at the time due to

locked the door.

police. I got

of turning over the

without leaving the

those keys till you

at least have you're cell phone handy !

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.

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.

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 !!.

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

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.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required