Sunday, April 24, 2011

QuickBooks Online Banking - Can't Delete the QuickStatement?

Are you having trouble deleting the QuickBooks Online Banking QuickStatement? This is an issue for some clients that Intuit is not actively resolving as of this writing. Here are a few tips and suggestions that will hopefully resolve the issue for you.
First, in the QuickStatement make certain that all matchable transactions have been matched. Then, at the main Online Banking Center page, make sure the QuickStatement is highlighted yellow, then click the Delete button in the lower right corner of the screen. If this does not delete the QuickStatement, here are a few options to consider:
1. Press Control--Delete. Instead of simply pressing the Delete button, press Control--Delete. This may do the trick.
2. Newest Release? Make certain you are running the most current release of your software. For 2004 and 2005 versions of QuickBooks, from the File menu, select Update QuickBooks and follow the instructions. For the 2006 version of QuickBooks, from the Help menu, select Update QuickBooks and follow the instructions.
3. Run the Verify Data utility. From the File menu, select Utilities, then select Verify Data. This may find a glitch in the data file causing your QuickStatement to remain undeleted. If one is found, run the Rebuild Data utility. Please refer to QuickBooks' internal help before running the Rebuild Data utility, especially if you are using QuickBooks on a network.
4. Restore a backup. If you made a backup immediately prior to your online banking session, AND the backup did not contain any of the unmatchable transactions, you may restore it. However, any work you did during your online banking session will be lost. You need to weigh whether or not this will be a good approach to solving the problem. And of course, it does not solve the problem if the unmatchable transactions were downloaded before you made the backup.
If none of these methods work, you may either contact Intuit directly, contact your QuickBooks professional who can then contact Intuit on your behalf, or you may try this work-around. Be advised that this work-around somewhat complex. Please read through these instructions carefully and make certain you understand all of them before you begin.
Add, disable, reverse, check, reconcile, re-enable. Using this method, you will add the transactions to the register, disable the account for online access, reverse the entries you added, check your work, reconcile the account, and re-enable the account for online access. Here is how to do it:
  • Add each transaction. Click the Add to Register button to enter them into the register. Open the Account field, and scroll up to create an Other Current Liability account called, "QuickStatement Use Only." Enter all unmatchable transactions using this Other Current Liability account. The QuickStatement must be empty before you proceed; however, do not close the QuickStatement when you are finished entering transactions.
  • Disable Online Access. Go to the Chart of Accounts and locate the account you were just working in. Highlight it, right click it, and select Edit. In the Edit Account screen, select the tab that says Online Info. Uncheck the box that says Online Account Access. Since the QuickStatement is still open, QuickBooks may or may not allow you to disable the account for online access. If it does not: a. Go back and close the QuickStatement. Then try again to disable the account for online access. Hopefully it will let you. b. If it does, great! Proceed as follows.
  • Reverse the entries you just entered. There are at least three ways to do this. Only one is shown here: Go to the Chart of Accounts and locate the Other Current Liability account you just created ("QuickStatement Use Only"). Highlight it, right-click it, then select Use Register. Go through the register, and using today's date, record a new and opposite entry for each entry here. In other words, if an entry appears in the Increase column, record an entry in the Decrease column of the same amount. Or if an entry appears in the Decrease column, record an entry Increase column of the same amount. You are not altering, in any way, the previously entered transactions--you are adding new ones that cancel out the entered transactions. In both instances make sure you use either the bank account or credit card account you used during your online banking session, and that the dollar amount is exactly the same as the entry you are reversing. Go through the register and do this for all entries that appear there.

No comments:

Post a Comment