“Let them win the QuickBooks Desktop open windows argument, mostly cause it doesn’t matter. Even they know that.” -Clayton Adams III
Less and less do I hear this refrain, because I am somewhat removed from the phones; yet I know the argument still rages on in sales calls. “QuickBooks Desktop just is better at workflow…QuickBooks Online takes me 15 minutes longer to do the same task…I cannot have multiple windows open like I can in QuickBooks Desktop…Reporting sucks vs. QuickBooks Desktop”…and such. The last complaint is mostly in relation to open windows, “…like in QuickBooks Desktop”.
Core reporting is essentially the same between the two platforms, I mean the main 3 reports accountants run: namely the Balance Sheet, P&L and Trial Balance. I know there are a few gaps remaining in terms of extra header lines, footer on every report page, and date range formation flexibility, etc… but mostly, QuickBooks Online is on par with QuickBooks Desktop where it matters. Even feature set-wise, QuickBooks Online is practically a price-level away from QuickBooks Pro.
What really is the continuing negative noise about?
Tis more of a tired, dwindling tune…
Bank feeds in QuickBooks Online are superior to QuickBooks Desktop.
Bank rule function, direct connection, batch accept to register, batch modify, batch undo and delete – these are all online banking features that QuickBooks Desktop either does not have or does in a way that just cannot compare to QuickBooks Online feeds. Add to this the fact that with QuickBooks Online, it can all be done on mobile. Bank feeds in QuickBooks Online are superior to QuickBooks Desktop.
This is what the bank feed feature looks like in QuickBooks Desktop:
This is what the bank feed feature looks like in QuickBooks Online:
If automation of data entry is at the doorstep, then QuickBooks Desktop is a-slipping out through the back. Yet, there are many desktop champions still clinging to this old solution, and it is not because QuickBooks Premier supports sales orders. Heavy inventory and job costing requirements are seldom needed across a firm’s client base – at least not the firms with whom I’m talking to. If this were not the case, then why do so many of their clients use Pro?
Exactly… robust feature set is not the reason for the QuickBooks Online criticism or pushback on sales calls. These diehards just like the way the windows open in QuickBooks Desktop vs QuickBooks Online. It’s ok. It is cool how open windows work in QuickBooks Desktop. Genius. A genius whose impact and effectiveness is waning against a more important story: Automation of data entry and real time results. Who cares about open windows if you no longer need to enter data, or can set up the data to enter with minimal involvement? Uh, that question was rhetorical. Have I mentioned yet that bank feeds in QuickBooks Online are superior to QuickBooks Desktop?
My friend and co-host of The QBO Show, Woody Adams and I have been working out the best way to manage post QuickBooks Desktop to QuickBooks Online Conversion Sales Tax Clean Up.
Yay for you! You’ve made the move from QuickBooks Desktop to QuickBooks Online. All of your reports match, but you’ve noticed some goofy stuff in your Chart of Accounts and Products and Services list, and it all relates to your Sales Tax.
Don’t fret, I’m here to give you the step by step instructions on doing a little bit of Sales Tax clean up in QuickBooks Online after you’ve converted your QuickBooks Desktop file. I mentioned this briefly in my post called StacyK’s Step by Step: QuickBooks Desktop to QuickBooks Online: “After conversion you’ll most likely see multiple sales tax payable accounts on the Chart of Accounts in QuickBooks Online. There will be one account in QuickBooks Online for each Sales Tax Payable account you had in desktop. In addition, QuickBooks Online, by default, will create a Sales Tax Agency Payable account for each sales tax jurisdiction the desktop file had. To clean this up, you’ll need to make the accounts that came from desktop inactive (delete them) and use the new accounts in QuickBooks Online to track sales tax – make sure you make the proper adjustments to zero out the balances in these accounts.”
First thing you’ll notice are some new accounts in your Chart of Accounts. If you’ve recently signed up for a new account, you’ll head to your left nav bar and hit Accounting – this is the most likely situation if you’ve just converted. (For an older QBO account, you’ll want to go to left nav bar and choose Transactions > Chart of Accounts):
There will be one account in QuickBooks Online for each Sales Tax Payable account you had in desktop. In addition, QuickBooks Online, by default, will create a Sales Tax Agency Payable account for each sales tax jurisdiction the desktop file had.
The thing is, you can’t delete/inactivate these accounts just yet. If you try this, you’ll get this message:
Well, FINE. I didn’t really want to anyway. I have other things to do!
Unlike QuickBooks Online, QuickBooks Desktop uses Sales Tax SERVICE ITEMS, and since these new accounts in QBO are connected to those services in our QuickBooks Online account. This means we have to take care of those before we can clean up the chart of Accounts.
Unlike QuickBooks Online, QuickBooks Desktop uses Sales Tax SERVICE ITEMS.
To delete/inactivate these items, you’ll click the Sales tab in your left nav bar, and then the Products and Services tab (for older QBO accounts, hit the Gear Icon then under Lists, choose Products and Services).
I think the easiest way to find the QuickBooks Desktop sales tax service items is to click the Type to sort the list, then scroll until you find the service items you need:
Here are all of our Sales Tax Items, and all we have to do is click the drop down next to Edit and choose Make Inactive for each one:
Now that we have those deleted/inactive, we can go clean up our Chart of Accounts, so let’s head back there.
I generally make the account that came in from QuickBooks Desktop inactive first, but make note of the account number, so that I can add numbers to the accounts that QuickBooks Online created.
Remember, in QuickBooks Online: DELETE = INACTIVE.
Remember, in QuickBooks Online: DELETE = INACTIVE.
Now let’s get rid of those sub accounts with the zero balance. To do this, we have to click the drop down next to Register and choose Edit:
Then we change it from a sub account to a parent account:
Now we make THAT one inactive:
Since I have two of these sub accounts, I’ll do all of this to the other one, but spare you the screen shots.
To clean things up just a bit more, I’ll edit the two Sales Tax Payable accounts that QuickBooks Online needs to track my two sales tax rates and add the account numbers. Now I have a nice clean Chart of Accounts:
The last thing I want to do is make sure that all this clean hasn’t affected my balances, so I need to pull a Balance Sheet in both QuickBooks Desktop (here, I’ve used QuickBooks for Mac) and QuickBooks Online. I want to set the report to Accrual basis and the date range to All:
If the numbers don’t match, please note #5 and especially #6 below, in Woody’s checklist of Post QuickBooks Desktop to QuickBooks Online ConversionSales Tax Clean Up:
Go to products & services list and delete all unwanted service items that are really the sales tax items from QBD.
Make all sub Sales Tax Payable accounts as parent accounts
Delete the sales tax payable accounts
Merge the sales tax agency accounts into the Sales Tax Agency Payable account, if needed
Sales tax center may still be jacked up, so make an adjustment.
Draw line in sand, move on, stop over-analyzing.
Bottom line, the process isn’t too difficult – once you know what to do. However, it can be pretty frustrating if you’ve never done it before, or don’t have someone with whom you can obsess over all of it via email and text, like Woody and I did recently.
NOTE: This feature is a LIMITED RELEASE as of August 5, 2016; not all users will have it.
As a longtime lover of the Group Items available in QuickBooks Desktop, I am ridiculously excited to see that we now have something similar in QuickBooks Online – they’re called Bundles.
Look at that pic. They’re pretty fabulous, aren’t they?
QuickBooks Online Bundles Have Arrived!
I’ve used QBDT Group Items for years to easily track commissions paid to 1099 Contractors (ie: an independent sales rep, or some other non employee vendor), and have long lamented the fact that this wasn’t a feature in QBO.
That’s all changed, and I’ve created a PDF walk through to show how to set this up.
Do you have a remote team? I’ve been advocating the work-at-home lifestyle since my son Arik was born, 7 years ago. At that point, I realized there is no need to go into the office everyday—I can be as productive at home; probably even more so, if I try to avoid all the Law & Order reruns that are on.
Work at home is no longer a trend—a remote team is a proven way for small and large companies to save money while increasing productivity. In fact, according to an article in Remote.co, two-thirds of managers say employees who work remotely increase their overall productivity. The same article cited that remote working policies decrease employee turnover and increase employee engagement.
Remote team members are more engaged.
Increased employee engagement when working from home, how is that possible? A 2012 Harvard Business Review article found that remote team workers are MORE engaged than those who work in the office. According to the article (and me), people work harder to connect when they aren’t in the same location.
Take my home-based bookkeeping practice and consulting firm as an example. I have clients and colleagues all over the country. Even though I’m at home, I’m constantly collaborating with my remote team. We see each other rarely (even the folks that live in the same town as I do), yet we really know one another, our strengths and weaknesses and what’s happening. That’s important because all teams work better when the members take the time to know each other.
I’m here to tell you, you can have great team relationships wherever your team members may be—in the cubicle next to you or working from a Wi-Fi connection on the beach. It just takes a little effort and the right technology.
In it, I’ll cover techniques to engage your remote team and technology to keep it simple. Register now—this webinar may just be what your business needs to improve team communication and collaboration.
PS: If you can’t make the live webinar – please register! I’ll send a link to the recording.
PPS: There are two other opportunities to find out about Ooma Office: Thursday, April 21, we’ll have Ooma VP of Product Dennis Pang as our guest on the QBO Show & Monday, April 25, we’ll be doing a special Q&A with Ooma in our FaceBook group, Between Wall & Main (you’ll need to request access to the group to participate).
StacyK’s QuickBooks Desktop to QuickBooks Online Conversion Checklist
Are you a small business, or an accounting professional that services small businesses that are considering moving from QuickBooks Pro, Premier, Enterprise or even Mac to QuickBooks Online? If so, please keep reading.
First: Is QuickBooks Online the best choice? I’ll be the first one to admit that sometimes – albeit rarely – QuickBooks Online isn’t the best solution (but I do try very hard to see if I can get it to work for anyone). If any of the following are a musthave, you’ll either need to look to the Intuit App Center or workarounds (if available, I’ve indicated as such next to each feature) to assist, or you should stick with QuickBooks desktop:
Progress Invoicing (I have a work around)
Receiving Partial Purchase Orders (I have a work around for this, too)
Integrated Labor Costing
Online Bill Pay (Bill.com can manage this as an option)
Sales Orders
Inventory Assemblies (SOS Inventory is a great option)
Using Letters, i.e.: Collection Letters, Credit Letters, etc.
Things to Consider When Converting
Before converting, you have to make sure that your .QBW file can be converted.
Desktop File Targets – While in your QuickBooks Desktop file, hit the F2 button and check to see how many targets there are in it. If the targets in your file are over 350k, you’ll need to condense it or create a period copy before converting, or only import lists
^ Hit F2 to get Product Information Screen in QuickBooks Desktop
If your file is under the 350k targets, you’re good to go, but you need to make yourself aware of how settings, lists and transactions will be converted. There are things that may not get converted or may get converted in a specific way that may not be expected from someone new to QuickBooks Online.
Important (and Awesome) Recent Updates
I want to start with three recent updates that will make many people with happy, because these have historically been deal breakers for moving to QuickBooks Online.
Memorized Transactions – These now convert to Recurring Transactions in QuickBooks Online!
Multi-Currency – For all US, UK, and CA QuickBooks Online accounts, as of December 18, 2015, you can NOW CONVERT DESKTOP FILES WITH MULTI-CURRENCY. Your home currency will remain the same in QuickBooks Online. This is pretty huge, since prior that, there was no way to convert a desktop file that had the multi-currency preference turned on, even if it was no longer being used. It’s sort of sad how excited this news made me.
NOTE: If multi-currency was turned on by accident in your desktop file and never used, I would recommend not converting, as the preference will automatically be turned on during conversion. Instead, I would recommend starting your new QuickBooks Online subscription, and then enter opening balances as of the start date you’ve chosen via a Journal Entry or use Bay State Consulting’s Transaction Pro Exporter to get the data out of the QBW file and their Transaction Pro Importer to get that data into QuickBooks Online.
Inventory Items – All items convert beautifully – if you are converting from 2015 or newer versions. (They used to come in as one parent item with two sub items: one pointing to the Inventory Asset account and one pointing to Cost of Goods Sold. This meant either a LOT of cleanup work after conversion, starting from scratch with opening balances, or not converting at all.
^ QuickBooks Desktop Inventory item
^ QuickBooks Online Inventory item after conversion
NOTE: QuickBooks Desktop uses the Average Cost method for inventory valuation, while QuickBooks Online uses FIFO (First In First Out). What this means is that the Inventory Asset account balances will not match on each balance sheet, nor will the Cost of Goods Sold account balances on the P&Ls after conversion. Best practice for conversion is to go from 2016, regardless of maintenance release. However, 2012 and newer versions will need to have the latest release updates so the latest conversion enhancements are available. You can tell if your installation has the latest inventory conversion enhancements if you get a popup asking about converting to FIFO. If not, options are to update to the latest release, do some work after you convert or download a trial version to upgrade to a newer version of QuickBooks Desktop.
Highlights of Conversion “Translation”
Accounts – Account numbers and the hierarchy of the Chart of Accounts are all converted. QuickBooks Online uses an additional level of categorizing accounts, called “Detail Type”; accounts that are obvious (ie: Undeposited Funds), the Detail Type will be assigned. For others, the detail type will be assigned a generic label within that account type (ie: Other Miscellaneous Income)
Audit Trail – The desktop Audit Trail does not convert. QuickBooks Online has something (that I think is) better: the Activity Log. While the desktop Audit Trail only shows when transactions are created, modified or deleted, the QuickBooks Online Activity Log will show when users login or logout, edit list items, create/modify/delete transactions. It also shows when 3rd party apps import transactions and even when QuickBooks Online automatically downloads transactions to the Bank Feed. When you convert, each transaction will have a “creation date” that is the date of conversion.
Reporting – while QuickBooks Online does not have as many “canned”, or default reports as QuickBooks desktop, generally those that aren’t can be easily created and memorized. What’s really cool is that any of these reports may be added to a group and the scheduled to be emailed to anyone that needs them on a regular basis automatically.
UPDATE 3/14/16: Budgets – From Intuit: “Budgets now import into QuickBooks Online. In certain cases however, there are some budgets which are not yet supported, and will not be imported. Just check the budgets screen after importing to see if your budgets came over.” If you’re using QuickBooks Online Plus, you’ll be able to create new budgets, and you’ll be able to have multiple budgets per fiscal year – something desktop does not do!
Closing Date Info – while the closing date is converted the password is NOT, so you’ll have to set a new one in QuickBooks Online. There is also no Closing Date exception report… or actual exceptions. Once you convert, any exceptions will not show. QuickBooks Online will begin to track new exceptions, in two ways. If you have reconciled and closed the books, you’ll see changes to cleared transactions in the Bank Reconciliation summary page, in the Changes column:
^ Bank Rec summary page in QuickBooks Online
Regardless of whether the books have been closed, you’ll also be able to view the Voided/Deleted Transactions report, available from the Accountant Toolbox, if logged in as an accountant user:
^ Accountant Toolbox
^ Voided/Deleted Transaction list in QuickBooks Online
Custom Fields on Lists – if the QuickBooks desktop file is using custom fields for customers, vendors, employees or items, these will not convert. QuickBooks Online does have 3 custom fields that can be added to forms such as Invoices or Sales Receipts and 3 separate fields that can be used with Purchase Orders.
Inactive Status – Accounts, customers and vendors that are inactive but have balances will be converted as active list items. If there is no balance, they are converted as inactive – which is also referred to as “deleted” sometimes – in QuickBooks Online. Any employees or items in desktop that are inactive will be converted to active employees or inactive Products & Services in QuickBooks Online, whether there is any balance associated with them.
Customer information – Price Levels, Tax Items, Sales Rep, Customer Type, Credit Limits and Job Status are not converted.
Customer Message List – while the original message will still exist, and you can still add a customer message on transactions, there isn’t a drop down menu to choose from. Each message has to be entered manually on the form.
Employees/Payroll – If you’re using one of Intuit’s desktop payroll solutions, all employee contact information is retained. If you have an active payroll subscription, some additional information will be migrated as well. This includes taxes and payroll items; but not any prior payroll period*. Also, no employee payroll information such as filing status, rates, etc. is converted. Paychecks/liability payments are converted as regular checks. The details on these transactions are not converted, and liability refunds, adjustments, opening balance transactions are converted as Journal Entries. Your desktop payroll subscription will not work with QuickBooks Online. AFTER YOU CONVERT, you may sign up for QuickBooks Online Payroll, Intuit Full Service Payroll or Intuit Online Payroll – each of these has a payroll setup interview that allows you to enter all the info for all employees, company items and any year to date history. If you are already using Intuit Online Payroll, you’ll need to edit your export preferences to connect to the new QuickBooks Online account.
NOTE: If you set up a 401k item with any of these in any Intuit payroll offering, it does not create an actual 401k account, nor will it automatically transfer the funds to any 401k account you already have set up. You will still need to manage all of that outside of the payroll service, as it will only calculate the deductions and show your liabilities.
Reconciliations – all of your reconciled transactions will remain cleared – but no reconciliation reports will convert. One option I’ve heard suggested is for accounting professionals using QuickBooks Online Accountant to upload any previous reconciliation reports to the client’s document folder:
^ Documents in QBOA
Existing Estimates & Purchase Orders – Only QuickBooks Online Plus has the ability to create POs. Estimates are converted to all QuickBooks Online subscriptions, but Purchase Orders only convert to QuickBooks Online Plus. However, the connection between closed Purchase Orders and their corresponding Vendor Bills is lost once the data is converted to QuickBooks Online.
Invoices – all of the invoices will be converted (unless they’re pending) but some information will not convert as you might expect. PO Number will be Custom Field 1, Sales Rep will be Custom Field 2, Subtotals now convert, and Sales Tax will show in the Sales Tax field of each invoice after conversion. Progress Invoice columns won’t convert. (If you need Progress Invoicing, I have a work around for that.)
Statement Charges are available in QuickBooks Online as Delayed Charges, but existing QuickBooks desktop Statement Charges will transfer to QuickBooks Online as Invoices.
Group Items – These do not convert, and QuickBooks Online does not have them at the time of this writing.
Sales Tax – QuickBooks Online supports multiple sales tax rates and you are able to assign different agencies and rates as needed. Any Sales Tax groups that you have in QuickBooks desktop will convert, but as one combined rate.
NOTE: Once you convert to QuickBooks Online, you’ll most likely see multiple sales tax payable accounts on the Chart of Accounts. For each Sales Tax Payable account you had in desktop, there will one in QuickBooks Online. There will also be a Sales Tax Agency Payable account that QuickBooks Online creates by default for each sales tax jurisdiction. You’ll need to make the accounts that came from desktop inactive and use the new accounts to track and manage sales tax in QuickBooks Online. Your sales tax payments must be made through the Sales Tax Center, accessible from the left hand navigation bar:
^ Sales Tax Center in QuickBooks Online
Online Banking – The connections setup in QuickBooks desktop won’t transfer, but it’s easy to reconnect with QuickBooks Online’s Bank Feed. I know I’m not alone in this when I say the QuickBooks Online Bank Feed is superior to the QuickBooks desktop Online Banking. The ability to see all connected accounts at once and deal with 100 transactions at a time makes this process so much more efficient. The fact that you can simply click a tab to see already accepted transactions – and easily fix client mis-postings – is icing on the cake!
Users/Permissions – Existing QuickBooks desktop user logins won’t convert. Once you import into QuickBooks Online, you’ll need to invite each user. Another feature that QuickBooks Online Plus has, that QuickBooks desktop doesn’t is the ability to have as many Time Tracking and/or Report Only users as you need, and these don’t count towards the subscription defined user limit. Great for entities with Board Members that may only need to view reports!
Wrapping Up
This is not a complete list – I picked these to highlight because over the last 11 years of doing conversions, they seem to be the most important ones to desktop users, and the ones that cause the most surprise or confusion. For more details on exactly how everything converts, I would direct you to this support article, this list of import limitations and this survival guide.
One more comment about targets and converting is that when you convert, if your file is over 350k targets, you do have the option of importing lists only or importing your QuickBooks desktop file. Even if you do decide to convert, you can still import list information into QuickBooks Online after the conversion:
^ Import List screen in QuickBooks Online
It is also important to note that once you create a QuickBooks Online company you have 60 days to convert QuickBooks desktop data; and you can do it over and over again during those 60 days. Any existing data will be overwritten, so if you don’t like the way that your conversion worked the first time, you can tweak your QuickBooks desktop data and try again.
What I have always recommended when making the change is to run QuickBooks desktop and QuickBooks Online parallel for the first 30 days (which is free with a new QuickBooks Online subscription), to make sure it’s a good fit. Yes, the time it takes to do the double entry is a bit of a pain, but it’s much less so than just jumping in and finding out a few weeks later that QuickBooks Online really isn’t going work.
Converting from QuickBooks Online to QuickBooks desktop is an entirely different article… which I am never going to write, because I believe everyone should be on QuickBooks Online.
*From Intuit support: “We now support bringing over payroll history (for the prior YTD payroll setup) for about 70% of all importers with DT payroll. If payroll items are mapped correctly, and they are supported by QBOP, we will bring them over unless some mismatch is found. Constantly improving on this too, to enable a higher success rate.” Unfortunately, I have not yet seen this in action when converting clients with desktop payroll.
This is an update to an article that first appeared on the Sleeter blog in 2013.
Special thanks to Woody Adams, Micah Sampson, Matthew Bernier, Le’Darien Diez & Sachin Goregaoker for helping me with this!
Full Disclosure: this is a salesy blog post. I want you to register for StacyKAcademy.com.
And not just so I make money. I want you to do it because I want YOU to make more money, have better clients and a better work/life balance.
We’re just about a month away from even starting the StacyK Academy–webinars and group coaching–and attendees are already making connections and helping each other out.
A few weeks ago, I read this article, and wish it had been written (and that I’d read it, and well, paid attention to it – that’s the most important part, right??) about 11 years ago. You know, right after I started my business.
Specifically the parts about web design, email software and the biggest one: knowledge and learning.
It took me a really, really, really long time to come to terms with the fact that I suck at web design and SEO, that I really do need to send out emails to get people to buy from me (Dude. That totally works! Who knew?). For a long time, I thought I knew what I was doing–HA!.
I think that’s part of being a business owner: often we operate in a vacuum, and think we know what’s best; and that is just not the case. It took me way too long to realize that I should always be asking how other people are doing things, what works, what doesn’t, and taking it back to try out in my practice.
I don’t think my bookkeeping business (Kildal Services) has the perfect practice management systems, but I know it really freaking works. This is why I want you to register for StacyKAcademy.com – to get a different perspective, proven lead generation techniques,to take back to your practice and implement. Or bits and pieces. Whatever works for you.
I want you to sign up because I believe, 100%, that as accounting professionals, we are all valuable resources to each other, wells of information to draw from and to which we can contribute our experiences. With almost 30 million small businesses in the US alone, there’s enough work out there for all of us. With StacyKAcademy, I’m trying to create a community where there’s no judgement and where we’re all working towards the same things: building a business and being happy in work and in our personal lives.
So please, register for StacyKAcademy.com while there’s still some seats left. I want you to do it because this shit WORKS. And we have the numbers at KildalServices.com to prove it.
