Friday, June 20, 2014
Automatic Bank Feeds in QuickBooks Online
There’s a trend among some users of QBO to consider automatic bank feeds as a way to eliminate reconciling of the accounts. This is wrong, so wrong, and I’d like to tell you why.
1. You can’t trust them. They work well, when they’re working, but too often I see bank activity downloaded into QBO that leaves out transactions.
2. The automatic features in QBO make for simple use, but if you just accept all transactions as they download, there’s the potential for misclassification. For example, QBO will remember what the previous expense was for a vendor, and will fill it in. However, that may not be the correct expense at all.
3. Income downloading is especially tricky if you’re unfamiliar with it. If you issue invoices, you should be receiving payments from the Transactions menu. If you don’t, and QBO downloads those deposits, it won’t have anything to match to. Many times I’ve found that these transactions have ended up as Income, when there’s already an invoice for it. This will quickly double your income, in ways that we don’t want it to double. (We want to double it by increased sales, not by tricking the books.)
4. If you have multiple deposit items on a deposit, such as several checks, QBO will need you to manually match those deposits to the received payments. For example, if you receive large numbers of merchant deposits, QBO will enter those as income if you don’t match them. I will often just exclude the credit card deposits because if everything else is done properly, they’re already accounted for. If they match, even better.
5. If you have many transfers between bank accounts, there’s a high likelihood QBO will be so confused that these will not end up in the right place without intervention. Often these transactions will show up as an Other Asset, or an Uncategorized Expense, and if you have multiple accounts with transfers between them, you must verify the transactions before accepting it into your books.
6. And last of all, you can’t trust them. I know I said this before, but it’s such an important detail. Even with all the technology working in our favor, we need to verify. We need to reconcile. We need to look at what’s showing up, and we need to make sure it’s properly classified. Otherwise, we might as well be entering random numbers.
There’s a reason us accountants do the things we do, and it’s not because we like to fill our time with busywork. It’s because verifying and reconciling are the best methods we have to ensure that every transaction in our books is proper, classified correctly, and is placed where it belongs. It may seem time consuming, but it takes twice as long to fix past errors than it does to get them right the first time. More time = more money, and there’s much to be said for having accurate financials when you need them.
Friday, April 4, 2014
Clearing and Suspense Accounts
Thursday, December 26, 2013
What is the Cloud?
And what does it mean when your business is in the cloud?
We keep hearing about the cloud, as if it’s some sort of amorphous thing that’s hanging out there. I’ve heard people use the term who aren’t exactly sure what it means, but it sounds like something they should know about. Cloud computing encompasses a wide range of services, but I’ve enough to do with focusing on accounting programs, so I’ll stick to that.
If you do your accounting “in the cloud,” your data is somewhere off-site. Where off-site depends on what sort of cloud based solutions you’re using. There are two main categories for accounting:
Hosted solutions: With a hosted solution, you use the same accounting program you use now, except a hosting company keeps the file on its servers, and you access the program through the host. This means you can access your QB file from any computer, and you can share the data file with other users. One of the drawbacks to this method is that you must pay for the hosting, and for a QuickBooks license for each user. Hosting per user per month starts around $50 and up. However, it’s the same program you’re used to using, whether it’s QuickBooks or Peachtree or another software. It works just like your desktop version because it IS the desktop version.
What other drawbacks are there? A plus is that should your servers go down, or your computer system, your data is still safe with the host. But if the Internet goes down, you can’t access it.
Hosting is a good solution if you want the same functionality as you have with your desktop software, and if you have multiple users at multiple locations, or if you just want your data somewhere else.
If you have QuickBooks, you need to use a QuickBooks Authorized Host. There are several that are highly rated, and make sure you do your homework first.
A different solution to hosting a desktop program is moving to an online solution. QuickBooks has QuickBooks Online, which is not at all like working with QuickBooks desktop. The interface is different, and the apps that work with it are different. The marketplace is growing for online accounting solutions, and all providers are improving their software on an ongoing basis. The cost for several users can be less than one hosting license, depending on which program you select. QuickBooks Online has several versions, with the lowest cost one not much more than a check register. Other online accounting programs include Xero, Wave, Monchilla, Less Accounting, and Kashoo (which I’ve heard has been bought by Paychex). I haven’t yet found one that can do as much as QuickBooks Online, but I’m always looking.
An advantage to an online program is that you don’t have to worry about upgrades and keeping your software healthy – it’s all included in the monthly cost. You and multiple users have access from multiple locations, making collaboration easier.
A drawback is that, again, if the Internet goes down, you’re out of luck. There are times when people have not been able to login to QuickBooks Online, so it does happen. My experience has been that it happens infrequently. If you need to process payroll and you’ve waited until the last minute, you may have a problem.
Something else which may be either a drawback or a plus is that the online solutions will automatically download your bank and credit card transactions daily. This is a drawback if you’d rather enter them yourself, and a plus if you’d rather just classify the transactions that come in. Accounts still need to be reconciled monthly however, which I’ve found to be a common misperception. Don’t trust that just because it’s downloading that everything is correct – transactions are missed, things happen, and in accounting we like to reconcile everything to ensure nothing is missing.
Online accounting, whether hosted or an online solution, has benefits and disadvantages, like anything else. It works for me and many of my clients because we can work on the same file at the same time, which reduces my time and therefore their costs.
While QuickBooks desktop still has the most features, and I use it daily, the online solutions are making strides in improving their products. If it’s not right for you now, it may be later, or you may want to keep using your desktop solution. You have the freedom to choose what works best for you.
Tuesday, November 26, 2013
A Cloud Journey
First in a series about Cloud Accounting
I started my business in a haze of excitement and enthusiasm, unprepared but having no choice but to make it work. There was no cloud then, other than the type in the sky. Living in the Pacific Northwest, we had more than a few of those, and personally, I had a few dark clouds as well.
To take care of my clients, I traveled. I drove from one client to the next, often bringing back boxes of statements and receipts to my office, where I would attempt to put them in some kind of order and enter them into my QB Desktop software. Sometimes clients wanted me to work at their office, such as the weird guy out in the country who I eventually fired for inappropriate behavior. Sometimes clients wanted to stand over me and watch what I was doing instead of tending to their own business. After a series of increasingly responsible corporate jobs I found this both insulting and time consuming – I can work so much faster when I’m not being surveilled.
Sometimes clients wanted me in their office, in a separate room, where I would use generous amounts of Red Bull and chocolate to keep myself awake while I tried to figure out why the CPA changed my ending bank balances. (Has anyone else experienced this? CPA’s who change the bank amounts to coincide with their year-end ideas? And then never reversed their entries?)
Not only was this method of working annoying, it was time consuming. Clients weren’t always right around the corner from me, and since I was starting out and needed the money, I took every job that came along, whether it was a good fit or not. So I drove, a lot. I drove into downtown Seattle, where at least the client paid for my parking, and I drove down the 405 to Bellevue at rush hour, and I drove to Gold Bar, which is rather like driving from Earth to Mars.
Sometimes I would pull over to the side of the road and take a nap.
And then I started hearing about online applications that would do everything we could do with the desktop. A NetSuite rep met with me, and wanted me to promote their software. But I didn’t understand how it worked, and I didn’t have time to learn anything new, so I let it pass by.
I kept working like I had been.
Then I became accounting manager for a web-based accounting firm, and I found I never had to go anywhere. Eight hours a day, every day, I sat at my desk and directed activities, opened and closed numerous QB and Peachtree files we hosted, even a few programs I’d never heard of, and hoped never to again. My staff was spread out across the U.S., and so were our clients. We could be anywhere we were needed. Our clients were given scanners so they could easily upload documents, and I was sold.
It wasn’t perfect, partly because I was a manager and glued to my desk for the work day, but it was definitely an improvement. There was no traffic, no wasted time, no watching the cost of gas creep up until I wondered if it was worth it. There was just the work, available at all times.
And there’s one of the problems with working in the cloud: the work is always there, and, if you’re anything like me, sometimes you can’t resist logging in and doing it, even when I should be doing other things, things that would indicate I’m a well-rounded person, and not a workaholic.
I’m not a particularly well-rounded person, but neither am I a workaholic.
NEXT: What is the Cloud?
Thursday, May 30, 2013
QB Tips - Don't Delete Users
QuickBooks allows you to delete users. You have a user, you decide to fire said user, you go in to your QB file and it has an option to delete said user. So you select it.
Why wouldn't you?
You wouldn't because it's a bad idea.
You can't delete accounts that have transactions in them, nor can you delete vendors or customers or employees with transactions.
So why should you be able to delete a user? If the user has transactions, and you delete the user, those transactions will have missing links. When we have missing links, we're in an excellent position to end up with data corruption.
The best solution? Just don't do it. Change their password, and leave them there, with all the transaction history linked to that user.
Thursday, November 1, 2012
Intuit QuickBooks Mobile Changes
Monday, March 5, 2012
Why I don’t want to see Miscellaneous on your P&L
Tuesday, December 6, 2011
Preparing for Year End: Things to Do
Tuesday, November 22, 2011
Preparing for Year End: The 1099 Situation
- Nonemployee compensation (subcontractors), unless they’re incorporated
- Rental income (yes, you must send your landlord a 1099)
- Mileage, nonemployee
- Auto reimbursements, nonemployee
- Attorney fees and gross proceeds (any amount)
- Car expenses, nonemployee
Thursday, May 5, 2011
Meals and Entertainment
Wednesday, January 5, 2011
Making JE's Accrual Instead of Cash
Friday, July 9, 2010
Do You Specialize?
Saturday, June 19, 2010
Starting Your Own Business?
Tuesday, May 4, 2010
Are You Self-Employable?
Then write your own ending.
Friday, February 19, 2010
Where Are You Getting Your Answers?
Friday, January 15, 2010
Setting Your Hourly Rate
This is a subject that’s sure to come up when you started your business, and it’s not one-size-fits-all. Nothing really is, after all, is it? For a service business, setting the right rate is vital, even if it isn’t always easy.
There’s a trick to pricing your services, and that is, it needs to be a price you’re a) happy with, b) that you can earn a living with, and c) one that your customers will pay. If you’re not happy with it, you’ll begrudge your customers the time you give them. If you can’t earn a living with it, what use is it? You might as well give away your services. And if your clients won’t pay it, you’re right back to not being able to earn a living.
Rates will vary based on geographical region, services, ego, experience, qualifications, your clients/customers, and a host of other factors. You may have been told to find out what others charge for the same service. This may work, and it may not. Many of us don’t give out our rates when someone we don’t know calls – you may have also been told not to do that yourself, to talk to the client about what they need before you start discussing rates so you don’t scare them off right away.
A bit of a Catch-22 there.
Also, you really can’t base your rates on what someone else charges. Some time ago, after I’d moved to a new area, I met someone who was doing the same work I was. We had lunch and talked about our rates. Hers were twenty an hour less than mine, and she told me I’d have to reduce my rates in order to get any work in this area. I thanked her for the advice and left my rates right where they were. I wouldn’t have been happy with a lower rate, and I know the value of my work.
Since then, many others have said my rates are just fine, among them CPA’s and clients.
One thing to keep in mind is that there will always be someone cheaper than you. But is this your competition? Only you can decide that. There will also be people charging more. What matters is what you need to earn for your business to be successful.
You may look at salary guides, but that doesn’t tell you what rate to charge. What it does tell you is what the going rate is for that position, if you were an employee. You’re not. You can’t build a business on employee wages. You have to pay your own taxes, provide your own equipment and office space, and you have to provide your own benefits. Of course, there are advantages to businesses to go with an independent contractor instead, which you may need to point out to them. The clients don’t always come to us pre-educated.
A good way to get a starting point for your rate is to think about what you need your annual income to be, net of taxes and expenses. Then add taxes and expenses. This is the part a lot of new business owners neglect to do. That’s the minimum you need to make, right?
Look at how many billable hours you can expect in a week. If you want to work a 40 hour week, you won’t have 40 billable hours. This is a business now, and someone has to do all the work that goes into running a business too.
So how much do you need to make an hour?
Look at your qualifications and experience. Do you think you’re worth that hourly rate? If not, you need to work on your ego (or, to be politically correct, self-esteem), or find out how to be worth it. If you’re think you should make more, charge more. Don’t worry about losing clients over it – the price shoppers will always be less concerned about service and more concerned about financial cost. They’ll spend so much time searching for the cheapest option that their businesses will flounder. And do you want to spend time on a business like that? (There is also truth to the rumor that you get what you pay for.)
Setting your hourly rate is a lot less about what other people are charging than it is about you getting what you need and want to be successful. If you’re good and can give clients the service they crave, you’ll do fine, no matter what your rate is.
Wednesday, January 6, 2010
1099 Season
It’s that time of year again, when questions about 1099’s fly through the air like sparks before an electrical storm. Who sends them? Who receives them? Why? When? How? Here’s a few basics, just to get started with, dealing ONLY with the 1099-MISC:
1099’s are issued by your business to anyone who provides services to you for $600 or more during a calendar year. Unless the provider of services is incorporated. Then you can skip the 1099.
How do you know if they’re incorporated? Prior to paying anyone for services, you should hand them a W-9, or mail it, or email it. The provider of services completes the W-9, and on it they can indicate if they’re a corporation and therefore not subject to receiving a 1099. The W-9 also gives you the all-important tax ID number, without which you cannot file a 1099. This is why we ask for a completed W-9 prior to payment, and, hopefully, prior to receiving services, to avoid the sort of skirmishes wherein one party asks for the information in order to comply with the IRS regulations and the second party refuses to provide it, and they’ve already received their payment. (See below for what to do in that case.)
There are exceptions, of course, this being a federal tax law sort of thing. Lawyers are to receive a 1099 if you pay them anything at all. You can often find their tax ID on their letterhead, in which case, no need for a W-9.
What if materials are included in what you paid to the service provider? You can break those out, by completing the 1099 for only what the service was. However, you’re not required to – if you have all costs posted to the same account in your accounting software and aren’t sure which are materials and which are services, send a 1099 for the entire amount. It’s the provider’s responsibility to deal with that on their own tax return, and it’s rather easily done.
Cash or accrual? CASH. You 1099 someone for the amount you physically paid them during the year. If they billed you another 100 grand but at year end it’s still on your books as a payable, it doesn’t count. That’ll be for next year.
Rents? If you’re paying rents, you’re also required to include rents paid on a 1099. There’s a separate block for rent paid.
When: 1099’s are due out by January 31st, so the sooner the better. The filing for the feds comes later, but you must have the 1099’s out to the recipients by January 31st.
How: There are so many options for how that I’m not sure we can cover them all at once. You can print them from your accounting software. You can order free forms from the IRS, and print them on those, though if you haven’t ordered your free forms by now, you won’t have time. You can buy forms at the office supply store. You can file online with various providers who will mail the forms for you and efile with the feds. This is my favorite, especially if a company only has 1 or 2 1099’s. I use filetaxes.com, but there are other options.
Red forms or not? IRS regs require that the 1099 and the 1096, which is the summary that goes to the IRS with their copies, be printed on their red forms. This is why the forms purchased at the office supply store come with red copies. However, I know people who’ve been printing them on plain paper with black ink straight out of their software for years, with no problems and no complaints from the IRS. Yet another reason why online filing is so great – there’s no need to worry about it.
Why? It’s the IRS. You want I should have an answer for what they do? But the short version is, the IRS wants to be able to check to see if someone’s reported all their income, and one way they do that is by checking 1099’s against the person’s tax return. So in completing 1099’s, you’re helping the government collect on taxes! That should give you a warm fuzzy feeling about doing it. There IS a penalty for not doing them by the way, should they happen to find out you didn’t do it.
Another warning on 1099’s: This year I’ve seen an increase in the number of business owners who refer to service providers as “1099 employees.” There is no such thing. You either have employees, or you have subcontractors. Do not confuse the two. Just saying someone’s a subcontractor so you don’t have to pay payroll taxes doesn’t work either. There are guidelines to follow, and if the IRS finds out you’ve misclassified an employee as a subcontractor, the penalties will be steep – not to mention the back payroll taxes. Not to mention your state – if they catch wind of it, back payroll taxes and penalties will mount up quickly. All it takes is one dissatisfied “1099 employee” to bring up the issue, so please don’t do it.
There’s so much more to 1099’s than I can cover here, so if you have questions about 1099’s, ask one of us who knows. We’re awash in 1099’s and W-2’s right now, and we’re not unfamiliar with the process!
Saturday, January 2, 2010
New Mileage Rates, and More!
In keeping with the IRS mission to confuse as many taxpayers as possible at any given time (sure, they don't tell you this is what it is, but we know the truth), here's a few changes for 2010 you may want to know about:
* Mileage rates. Effective January 1, 2010, the standard mileage rate for business driving is 50 cents a mile, down from the 2009 rate of 55 cents a mile. Taxpayers who drive for medical services or in a job-related move may use a mileage rate of 16.5 cents a mile. That's down from the 2009 rate of 24 cents a mile. The mileage rate for charitable driving is not adjusted annually and remains at 14 cents a mile.
* Health savings accounts. The 2010 limit for deductible contributions to a health savings account (HSA) is set at $3,050 for individuals and $6,150 for family coverage. Individuals who are 55 or older may contribute an additional $1,000.
* The interest rates on tax overpayments and underpayments for the first quarter of 2010 remain the same as they were for the fourth quarter of 2009. The rates are 4% for overpayments and underpayments by individuals. Corporations will pay 4% on underpayments and receive 3% on overpayments. On large corporate underpayments, the interest rate is 6%; the rate paid on large corporate overpayments is 1.5%.
More updates will follow. It's an always changing world out there.
Happy 2010!
Tuesday, December 29, 2009
What Happens When You’re Gone?
Succession planning has typically been the bastion of the big guys, the corporations who ensure that key positions are filled in so the company can keep moving forward, no matter what happens.
That’s all good and well for them, but for those of us who don’t have the wherewithal to have legions of replacements standing at the ready, what do we do? Obviously we intend to have nothing happen to us, but get this: things happen. Unplanned, unprovoked, unwarranted, and unwanted things. You could be run over by a truck, just when you thought life was going along swimmingly well. You could be kidnapped and held for ransom by robber barons who care little what happens to your company in your absence. You could step into a shower one day, slip and hit your head, and be dead within the week. (This happened to someone I knew. Not something one can plan for, is it?)
I don’t mean to be morbid, but here’s the thing: things can happen that we never expected. It’s what makes life so interesting, the possibility that every day wondrous things can happen, but so can horrible things, things that we never anticipated. These things can remove us permanently from our business, or they can remove us only temporarily, or they can fall into the great unknown category: will we return to work? Only time will tell.
And what happens to your business then? Perhaps you don’t care. After all, you won’t be around, so what does it matter? How do your customers and clients feel about that? One of the reasons people go to big companies is to ensure they’re taken care of, even if something should happen to the person handling their account. How can you give your customers the same level of comfort?
If you work with others in your business, either partners or employees, is there enough information so the loss of one of you doesn’t mean the customers will be neglected? Are procedures in writing and does everyone know where they are? If it’s just you running your business, what will happen if you disappear one day?
It’s one thing to plan what will happen to your business if something happens to you. If you’re a sole prop, you are your business, so the business will come to an end. But what about your customers and clients? How will they feel about it? Oh sure, they’ll be sad, of course, but what about THEM? They’re going to wonder what’s going to happen to them, which is a natural response. And what will happen to them? These are the things you should be thinking about now, and the beginning of a new year is a good time to do it.
Some of my colleagues who have their own businesses have reciprocal arrangements. If something happens to me, my husband knows who to contact to take over my client work. I have information on all my clients in a file, or will, as soon as I finish updating it. Here’s the thing: this is not a one-time all-done-never-have-to-think-about-it-again sort of thing. It’s an ongoing process, keeping in mind how you’d like your vendors to take care of you, should anything happen to THEM. Do no less for your own customers, and you’ll rest a lot easier in that hospital bed, which will mean you’ll be able to return to work faster and get back to living your life. If you’ve planned to take care of your customers when you can’t do it yourself, they’ll still be there, waiting for you.
Tuesday, September 29, 2009
QuickBooks 2010 has been released!
New Features in 2010
One that I'm looking forward to is the Client Data Review, which will allow me to easily identify errors and make mass corrections. This is only in the Accountant's version, but it will also allow me to fix and send back files from QB Pro and Premier 2009 to clients easily. This is huge, since I'll be able to fix things from 2009 and send it back to you using the Accountant's Copy. No upgrading necessary from 2009!
A totally new feature in 2010 for Pro, Premier, and Enterprise is the Document Management system which will store documents in the Internet cloud. Know how you collect all those pesky receipts and documents that have to be filed? With 2010, we can scan the documents directly into QB, and attach them to transactions, accounts, vendors, employees, and customers. This keeps your documents as well as your QB file backed up, and will simplify collecting and matching documents to specific transactions.
A TWAIN compliant scanner is required for this, so if you're thinking of getting a new scanner, you'll want to make sure it's TWAIN.
Also in Pro, Premier, and Enterprise will be the ability to copy and paste lists from Excel directly into QB lists. And instead of editing each list entry individually, we'll be able to copy the changes to many.
Do You Need to Upgrade?
I'm often asked if upgrading is necessary, and the answer is certainly not. Depending on the features you use, upgrading is entirely optional. QuickBooks does support only the previous three versions, so this year 2006 was sunsetted, which means payroll subscriptions no longer work, as well as online banking. If, however, you're not using those and want to continue with an older version, go right ahead. I would advise that you make regular backups after every use and keep them in a secure location because if there is a problem, there's nothing Intuit support can do to help you. Next year 2007 will be sunsetted, so if you have a payroll subscription or use online banking, you'll want to upgrade.
However, there are always good deals to be found on the current software, especially if you don't have to run out and buy it on a moment's notice. If you'd like to be notified of these sales, let me know and I'll add you to my email list that I send out when I become aware of them. Sometimes they only last a day.