thinkQuickBooks

helping right brain professionals navigate the left brain world of accounting

Archive for the tag “quickbooks accounting”

Intuit has relaunched the QuickBooks Community forum!

As of yesterday, it’s new and improved! Well, at this point we can say it’s new ūüėČ

https://community.intuit.com/

There are nine ‘topics’ to choose from. The first six topics relate to the US versions of QuickBooks. The last three topics are specifically for QuickBooks Canada, QuickBooks UK, and QuickBooks en Espa√Īol.

If you’re a regular visitor, you’ll notice that the topics have been revised. Intuit is perhaps trying to make the language easier for the majority of users to understand (for example, ‘Customers & Getting Paid’ instead of Accounts Receivable). If you click on the QuickBooks Canada topic, you’ll probably notice that ‘Sales Tax’ is not a subtopic. I noticed this right away and definitely think it should be added back!

It appears Intuit has some kinks to straighten out, and I’m sure they’re working on them. Members don’t seem to have access to their old questions and answers. And referring specifically to the QuickBooks Canada topic, the ‘Unanswered’ questions seem to all be ‘asked about a year ago!’ That said, it’s early in the changeover and it looks like Intuit is gradually adding back content.

Opinions on the new platform aside, the community forum can be a great resource to get pretty much any question you have answered. A lot of QuickBooks gurus hang out and provide answers, generally because they love to serve and help other members with their books. You can also search the database for older questions and answers (a note about searching… right now, you have to type your search into the ‘Have a Question?’ field at the top of the page. You’ll then be taken to the results page, and the field will now be labelled ‘Search.’ Here you can search for another topic). You can also browse tags which you will see on the right hand side of the main page.

I’d love to know what you think of the new forum. And if you have a suggestion, you can contact Intuit directly. Look for the ‘Send us Feedback’ link at the bottom of all forum pages. Embrace the change!

Advertisements

Why is my previous QuickBooks GST/HST ‘File Sales Tax’ journal entry incorrect?

ISSUE: the journal entry that QuickBooks automatically creates when filing sales tax is not entered correctly. The most common problem is missing tax items. You may also see missing information on the memo line, and you may even see the tax items switched around.

This happened to one of my clients this week. He noticed an ‘unassigned tax amount’ when attempting to ‘file sales tax.’¬†He clicked on the amount and it took him back the journal entry that QuickBooks had created for the previous sales tax filing. We then started to uncover some strange errors…

Here’s a screenshot of what a normal FILE SALES TAX journal entry should look like:

Correct JE for File Sales Tax

And here are two screenshots of the incorrect FILE SALES TAX journal entries discovered in¬†my client’s file:

Incorrect JEIncorrect JE #2This is a known issue.¬†QuickBooks senior tech support tells me¬†it’s essentially random. It¬†started with the 2012 R12 update and the 2013 R4 update. It’s considered a critical issue with moderate severity and high impact. The engineers are working on completely removing this issue.¬†

SOLUTION: Go back to the incorrect journal entries that QuickBooks created and manually correct them. Review previous, current, and future tax filings carefully.

My advice until Intuit works on eliminating this potential problem is to keep current with your updates and CHECK YOUR ‘FILE SALE TAX’ WINDOW CAREFULLY BEFORE FILING! Watch out for unassigned tax amounts.¬†If you have any, drill down on¬†the amount.¬†If you end up in a previous ‘File Sales Tax’ journal entry, and you spot something wrong, you’ve likely encountered the ‘File Sales Tax’ bug!¬†You will need to correct the journal entry by entering the correct tax items. If you discover information missing from the memo line, correct that as well. You can refer to previous filings for missing information.

NOTE: these errors carry over to the next sales tax return. If you discover more than just the last “File Sales Tax’ journal entry incorrect, your previous filings with the CRA could have errors.

Other tips for spotting errors in the File Sales Tax window: Manually multiply line 101 by the tax rate in your province for a ballpark figure of what line 103 should be. Drill down on line 103.¬†Look for a¬†balance leading into the period. This will be zero if you have not made changes to your sales after your last filing. Drill down on line 106. Again, look for a balance leading into the quarter. This will also be zero if you haven’t made any changes to your purchases after your last filing.

Be careful when troubleshooting your sales tax, and always make a backup of your file before making any changes.

I’d love to hear from you if you’ve run into this particular bug!

‘Find a Local QuickBooks Expert’ site shutting down in Canada!

This weekend, the ‘Find a Local QuickBooks Expert’ search wizard for Canada will be gone. But it’s only temporary! In September, a new and improved site will be launched. Here’s the announcement:

Find an Expert

I couldn’t be more excited about this development! We are definitely behind our US counterparts in this regard, so this is very welcome news. I’ve been asking about and hoping for a better site for years! Here’s a peek at what the Canadian site looks like now:

7/19/13 UPDATE – FEATURE NOW GONE! I was hoping to add a screen capture of the site today but they took it down a day early! Here’s the link anyways: http://www.intuit.ca/en/intuit/findexpert_index.jsp

And here’s a link to the US site:

http://proadvisor.intuit.com/find-a-proadvisor/search.jsp

The links take you to the welcome pages, not to the search results. The differences when you actually perform a search are astronomical!

Complaints about the Canadian site aside, this is an awesome tool provided by Intuit on both sides of the 49th. I have connected with a few clients because of it, and the long-awaited improvements will be great for Canadian ProAdvisors and clients alike.

Did you sign up for e-statements? Don’t forget to save or print!

So you’ve gone green and signed up for e-statements. Kudos to you! Here’s how going paperless helps the environment, compliments of http://payitgreen.org/

PayitGreen

There’s nothing better than neglecting my own bookkeeping and sitting down to do it a couple times a year. It fulfills my need for a challenge. LOL! (I don’t recommend this, by the way!) This last time, I went to my credit card provider’s website to download the past twelve months of statements into QuickBooks. Except eight of them were gone! Only the most recent four were available to download into QuickBooks. The missing months were easy enough to access in PDF format (they keep seven years for me), but the downloadable files were indeed gone with no way to get them back. That made for a lot of manual data entry for me.

Another of my credit card providers only saves six months, PDF or otherwise. After that, I have to contact them to retrieve the missing statements. This involves an email, a confirmation email, a password and a time limit to fetch them… which I typically miss. I then have to start the entire process of retrieval over again!

Banks and credit card issuers often make only a certain number of statements available online. In many cases, it’s only a few months. If you need to go back farther than that, you may have a few hoops to jump through. You may even be required to pay a fee.

So here’s a reminder. Save those files to your computer every couple months (and if you still prefer to print, no judgement here!).

How do I get rid of the zeros on my Profit & Loss?

Great question! First off, let me explain why these are here. Accounts with no activity during the period will not show up on the P&L. Accounts with activity during the period will show up on the P&L… even if the total balance is zero. If you want to hide those zero balance accounts, here’s what you do:

Open the Profit & Loss report. Click on CUSTOMIZE REPORT in the upper left hand corner. You’ll be on the DISPLAY tab. Now, click on the ADVANCED button to open the Advanced Options window. Under DISPLAY ROWS, select the NON-ZERO radio button. Click okay. Click okay again.

Any accounts with zero balances should now be gone. This is a nice way to ‘tidy up’ your Profit & Loss report when it needs to be distributed. Note: this also works with a Trial Balance report.

QuickBooks Canada 2013 R7 released. Goodbye, Samples of Common Payroll Items…

UPDATE: Apparently the problems plaguing the R7 update in the US could be problems in Canada as well. According to tech support, the R8 update (payroll) will be released by the end of June. It is advised that you wait!

QuickBooks released their 2013 R7 update this week. If you‚Äôve selected the option for automatic updates, you should be prompted to install the update when you open QuickBooks. The other option is to manually install the R7 update. Here’s a link to the instructions as well as the R7 release notes:

How to manually install QuickBooks 2013 updates

The R7 update includes the July 2013 (97th Edition) Tax Table, which you’ll need before processing payroll in July. To confirm you have the correct tax table:

Employees > My Payroll Service > Tax Table Information. From there you can click on the Tax Table Info button for more detailed information.

One important thing I noticed about this release is that they’ve removed the Samples of Common Payroll Items guide from the HELP menu! Rather than a handy chart, they now direct you to the CRA website. I’m not a fan of this change! I loved the¬†Samples of Common Payroll Items guide. However, I’ve been told by the folks at Intuit that this change is permanent.

TIP: before updating your file to R7, copy and paste this guide into Word.

That said, it’s always been a good idea to consult the CRA and Service Canada websites when setting up your payroll items. Look for the T4130 Employers’ Guide – Taxable Benefits and Allowances on the CRA website and information about insurable earnings on the¬† How to Complete the Record of Employment Form on the Service Canada website.

Holy Colour, Batman! QuickBooks 2013 R6 update released in Canada

The R6 update for QuickBooks 2013 is now available for Canadian versions of QuickBooks. If you’ve selected the option for AUTOMATIC UPDATE*, you should be prompted to install the update when you open the program. If not, you can go to HELP > UPDATE QUICKBOOKS > UPDATE NOW and select GET UPDATES. The other option is to manually download the update. Here’s a link to the support page which provides the link, and also, a link to the release notes:

How to manually install QuickBooks 2013 updates

The R6 update introduces the “Company File Colour Scheme” which replaces the “Company Colour Flag” preference. If you use it, it’s suddenly a blast of colour when what you’re used to seeing is a tiny little flag! Orange was okay when it was just a flag, but wow, is it ever bright when it’s the entire title bar! Some of the colours are equally as shocking. I’ve settled on the blue-medium which is fairly easy on the eyes. Here’s where to find it if you don’t have it set: FILE > PREFERENCES > DESKTOP VIEW. Choose the MY PREFERENCES tab and choose a colour under the COMPANY FILE COLOUR SCHEME.

The R6 update also clears up some of the ‘real estate’ issues I was complaining about in an earlier post, along with several other fixes and improvements, many for the Enterprise version. The release notes don’t say anything about the “Fatal Application Exit,” which I continue to get pretty much every day I’m working in QuickBooks. Here’s what Intuit says about the problem:

Error: QBW32.EXE – Aborting Application: QuickBooks is now terminating when working in 2013

I’m still anxiously waiting for the new feature where I have the ability to collapse specific sub-accounts on financial reports to show up in Accountant Edition and Premier and not just Pro!

*NOTE: to set your copy of QuickBooks for AUTOMATIC UPDATE, go to¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬†¬† HELP > UPDATE QUICKBOOKS > OPTIONS and select the YES radio button next to AUTOMATIC UPDATE. You can also choose whether to used a SHARED DOWNLOAD if you’re in a multi-user environment.

Loss of laptop real estate in QuickBooks 2013

If you don’t seem to have a lot of useful ‘real estate’ when working on forms in QuickBooks, your computer resolution could be to blame. I personally find working on my laptop very frustrating because I have so few lines of detail on the bottom of forms. Here’s what Intuit Canada says about the issue:

Missing Buttons on Write Cheques Window

Laptop or not, it seems like I spend a lot of time in 2013 moving, maximizing, collapsing, expanding, resizing, supersizing…you get the picture. One of my biggest complaints about certain windows is the fact they can barely be minimized from the top and bottom. This drives me crazy. You can minimize the sides, but that’s not where the SAVE buttons are at. They’re at the BOTTOM, and I should be able to minimize the window from the top and bottom! And the really weird thing? This seems to act differently at every different computer I sit down at. Tip: holding down the shift key while opening certain windows – for example, ‘Make Deposits’ – does help a bit with downsizing.

One last thing. I love the new feature where I have the ability to collapse specific sub-accounts on the financial reports. But I am completely at a loss why they would add this feature to PRO and not PREMIER. Is this a mistake? Technical support couldn’t give me an answer, and no one has really mentioned it on any of the forums. First time I can remember where a feature in Pro is not available in Premier!

Clever trick to unapply a customer credit in QuickBooks

CUSTOMERS & CREDIT MEMOS:

Open the CREDIT MEMO you wish to unapply, and temporarily change the name of the CUSTOMER:JOB – any name will do. SAVE. This will unapply the credit. Then, change the name on the CREDIT MEMO back to the correct CUSTOMER:JOB. The credit memo is once again fully available and you can apply as you’d like.

It’s official…I’ve been voted CANADA’S SUPERSTAR BOOKKEEPER!

http://www.c2online.ca/Home/BookkeeperSuperstarsCanada.aspx

Thanks for your votes, everyone! This is an incredible honor!

Post Navigation