Home | About Us | Contact Us | Seminars | Get Listed | Subscribe | Hotlist | Online CPE



QuickBooks Problems & Solutions

Chapter 20

 

QuickBooks Problem: You receive fatal error messages from QuickBooks, or you notice errors on reports, invoices, bills, etc.  You are missing transactions or items are missing off reports or lists.

Solution: You should run Verify to check for damage whenever QuickBooks appears to be functioning improperly or erroneously. The Verify Data utility detects data damage, and then logs any errors it finds in a file named Qbwin.log. The Qbwin.log file is contiguous, so that every time you verify, rebuild, condense, or update your data, any integrity issues found will be appended to the end of the Qbwin.log file. It is common for the Qbwin.log to become very large. You can identify only current errors in the data file by renaming the Qbwin.log file, located in your QuickBooks directory, to Qbwin.old. QuickBooks will create a new Qbwin.log file to store the results of the utility you ran most recently.  To run the Verify utility:

1.      From the QuickBooks Windows menu, choose Close All.

2.      From the File menu, choose Utilities, and then choose Verify Data.

3.      If the Verify completes with the message QuickBooks detected no problems with your data, your data is clear.

4.      If the Verify completes with the message Your data has lost integrity..., then there is damage in the file, and QuickBooks will display a message with instructions for running the Rebuild Data utility to attempt to repair the damage. The Rebuild Data utility should never be run across a network. Before starting the Rebuild process, the file information from the Product Information window should be noted for future reference (press Ctrl + 1 to open the Product Information window).  If the file is on a network, it should be copied locally before the Rebuild Data utility is run.  You will be prompted to make a backup as part of the Rebuild process.  Make sure that you do not overwrite your existing backup.  The Rebuild Data utility will run as soon as the backup completes, and it should only be run once.  When the Rebuild process has finished, close your company file and then reopen it in order to refresh the lists in the file. Note: It is a good idea to run Verify again after the Rebuild to check for remaining damage.

 

4.      If the Verify run after rebuilding the file indicates that there is still damage, you should consider restoring a recent backup of your company file.  Make sure that you do not overwrite your existing company file.  From the File menu, choose Restore.  Any information entered in the company file since the backup was made will need to be manually reentered after you restore.

 

QuickBooks Problem: QuickBooks run slowly in multi-user mode.


Solution
:
QuickBooks can run slowly in multi-user mode for several reasons as follows:

·        The data file size is too large to be handled efficiently by the system.

·        There are three or more users accessing one module at the same time.

·        A large report is being run (for example, Transaction report) in data files with more than 32,000 targets.

·        The data file is located on a slow computer.

·        The Audit trail is turned on.

·        A Network Interface Card (NIC) is slow or defective.

 

To resolve this issue, try one or more of these measures:

·        Condense the data file.

·        Limit the number of users accessing a module at any one time.

·        Narrow the date range on a large report.

·        Locate the data file on the fastest machine on the network.

·        Turn off the Audit Trail.

·        Upgrade to faster Network Interface Cards, cables, and hubs.

 

QuickBooks Problem:  Trouble backing up a QuickBooks company data file.

Solution:  If you use the built-in QuickBooks backup utility, you need to be in Single-user Mode to use the back up feature. The QuickBooks backup compresses data into a compact file that has the same file name as the company data file, but with the extension .qbb, rather than .qbw.  If you are backing up to a disk that already contains a file with the same name, the following message will appear: The backup file you chose already exists. Do you want to replace it? We recommend that you back up to a different name each time, preserving older back ups permanently in case they are ever needed.

 


 

QuickBooks Problem: Trouble mapping a network drive in Microsoft® Windows® 9x, NT® or Millennium Edition.

Solution: You can only map a folder that is shared. For example: If a user on Computer 1 shares his or her C: drive, you will only be able to map the C: drive, not the subfolders contained within the C: drive. If you do not see the option Map Network Drive when you right-click the folder containing your company file, you will need to move up a level and check the higher-level folder (or the drive itself) for the mapping option. If you do not see the option, please check with your system administrator.

You should not map a network drive if your company file resides on the same computer where you are using QuickBooks – this will cause QuickBooks to operate slower. Instead, open the file from the drive where the data file resides. The default installation location is C:\Program Files\Intuit\QuickBooks. Navigate through the local C: drive and the appropriate folder levels to open your company file. To map a network drive from within QuickBooks:

  • From the QuickBooks File menu, choose Open Company.

  • Select Network Neighborhood from the Look in drop-down list.

  • Double-click the computer where the company file resides.

  • Right-click the folder containing the company file, and select Map Network Drive.

  • Select an unassigned drive letter. Windows defaults to the first available letter, but you can choose any drive letter that is unassigned.

  • Select Reconnect at Logon.

  • Click OK.

  • From the Look in drop-down list, select the drive letter you assigned, and then in the main window, choose your company file name and click Open.

  • When the company file opens, press Ctrl+1 to open the Product Information window. Look at the path provided under Location in the File Information area. The location of your file should be something like:

G:\QuickBooks Pro\[company name].qbw.


 You can also map a network drive within Windows Explorer as follows:

·        Right-click the Microsoft® Windows® Start button, and choose Explore.

·        Scroll down the left side of Windows Explorer to Network Neighborhood.

·        Double-click Network Neighborhood to expand the network view on the right side.

·        Double-click the computer where the company file resides.

·        Right-click the folder containing the company file, and select Map Network Drive.

·        Select an unassigned drive letter. Windows defaults to the first available letter, but you can choose any drive letter that is unassigned.

·        Select Reconnect at Logon.

·        Click OK.

·        Start QuickBooks, and from the File menu, choose Open Company.

·        From the Look in drop-down list, select the drive letter you assigned, and then in the main window, choose your company file name and click Open.

·        When the company file opens, press Ctrl+1 to open the Product Information window. Look at the path provided under Location in the File Information area. The location of your file should be something like:

G:\QuickBooks Pro\[company name].qbw.

 

 

QuickBooks Problem:   You need to rebuild a QuickBooks company data file.

Solution: You should run the Rebuild Data utility if you receive the message that the Verify Data utility has failed, if the Verify Data utility returns a b-check error, or if a QuickBooks Help & Support Knowledge Base article calls for a data rebuild to fix errors. The Rebuild Data utility will attempt to fix damage in a QuickBooks data file. If the file is on a network drive, copy the file locally before attempting to run this utility.  Follow these steps to rebuild the data file:

  • From the QuickBooks Window menu, choose Close All.

  • From the QuickBooks File menu, choose Utilities, and then choose Rebuild Data.

  • Rebuilding requires that you back up your company file. Click OK on the message informing you that a backup must be made.

  • Do not replace your current backup. Instead, use a different 3.5-inch disk (or other media) for this backup, or back up to your hard disk. Click No if you see a message asking if you want to replace the backup file. To avoid overwriting your current file, enter a new name in the Filename field.

  • At the bottom of the Back Up Company File window, click Back Up.

  • The Rebuild Data utility will begin as soon as the backup is complete. Click OK on the message informing you that the rebuild has completed.

  • Close your company data file and then reopen it to refresh the lists in the file:

    • From the File menu, choose Close Company.

    • From the File menu, choose Open Company.

    • Select the company you want to open, and then click Open.

 

QuickBooks Problem: You receive the following message while trying to start QuickBooks, and when no one else is using the company file: “The company file has been opened by another user. Ask that user to switch to multi-user mode so that you can use the company file.” Microsoft® Windows® 98 and Millennium Edition will display the message: "Cannot access this file. Check security privileges over the network drive."

Solution: This situation can occur if the computer you are using has either Microsoft® Windows® 2000 or XP as the operating system – the permissions to the shared folder where the QuickBooks company file resides may be set to Read Only.  The default permissions are Everyone = Read.  To resolve this problem, the share permissions need to be changed to give QuickBooks users "full control" access to the shared folder where the company file resides.

 

QuickBooks Problem: I get the following warning when trying to use or set up online banking: Unable to connect. Try again later. [OL-202].

Solution: This error might appear on three different occasions as follows: 1. When you click Send in the Online Banking Center; 2. When you are attempting to add a financial institution during the online banking setup process; 3. If you are a CheckFree® client (on July 3, 2002, CheckFree issued a new security certificate, and you may need to update your QuickBooks program). If the message occurs when you click Send in the Online Banking Center, it may indicate a server issue, and you should try the procedure again later. However, if you receive the message after repeated tries, or over an extended period, there may be a problem with your network configuration. Make sure that your Internet access is functioning properly outside of QuickBooks, and that the Internet Connection Setup is configured correctly in QuickBooks. Additionally, if you use firewall software, make sure it is configured to allow QuickBooks access to the Internet.

If you receive the message while attempting to add a financial institution during online banking setup, it will be followed by a second message: "Warning: There has been an error which has prevented the retrieval of Financial Institution information. This may have been caused by a network service problem, which will prevent you from using QuickBooks Online Banking features. Please check your network setup and try again." This message should not prevent you from adding the financial institution, nor from using online banking functions, unless you are also signing up for Online Bill Payment. If you are acquiring Online Bill Payment, you may encounter a separate sign-up issue.

QuickBooks Problem: The computer stops responding while running QuickBooks.

Solution: The most probably cause for this problem may be that the computer may be running low on resources. As a short-term fix, either restart your computer or end tasks for specific programs that are not responding. As a long-term fix, either add more memory to the computer, or purchase a new computer.

QuickBooks Problem: QuickBooks users receive the following message for an extended period of time when attempting to perform tasks in QuickBooks: “Waiting for company file”.

Solution: If one computer is running a utility, such as Verify Data, all other computers accessing the same company file in multi-user mode will be locked out until the process has finished.  If the company file is large, or if the file is stored on a computer that has slow or limited resources, the utility may take a long time to complete.  To allow utilities to complete in the shortest time possible, have all users who are not running the utility exit QuickBooks, and then switch to single-user mode on the remaining computer to run the utility.  (From the QuickBooks File menu, choose Switch to Single-user Mode.) When the utility is complete, choose Switch to Multi-user Mode from the File menu and have other users log in again.

QuickBooks Problem:  When you attempt to open a data file that is stored on a network drive, you receive the error message: “This file cannot be accessed.”

 

Solution: Make sure you have security privileges on the network drive.  It could be that the "File and printer sharing for Microsoft Networks" component is installed on Microsoft® Windows® 95 or 98, and the data file is being opened from a shared folder that was set up with read-only access. To resolve this issue, change the shared folder's access type to “Full Control” on the computer that the shared folder is stored on.

 

QuickBooks Problem: You receive the following error message that occurs when restarting the computer: “An error occurred while reconnecting [drive letter] to [folder path].”

 

Solution: This problem is usually caused when you rename the folder where the QuickBooks company data file is stored. To resolve this error, on your desktop, right-click the Network Neighborhood or My Network Places icon and choose Disconnect Network Drive. A list of mapped drives will appear in the Disconnect Network Drive window. Select the drive noted in the error message. Click OK. The next time you start your computer, you should not receive this message.

 

QuickBooks Problem: You receive the following error message while attempting to send online payments: “Unexpected Error: OL 206”

 

Solution: Your financial institution or CheckFree® may be experiencing server difficulties, or your company file may be in an "error recovery" status. Contact your financial institution or CheckFree at (630) 692-3030 to learn if they are experiencing server difficulties, or to have them clear the "error recovery" status from your company file. To find your financial institution's contact number: From the QuickBooks Banking menu, choose Online Banking Center. From the Financial Institution drop-down list, select your financial institution. Click Contact Info.  Call the Customer Service phone number listed in the QuickBooks Information window to confirm the server status.

 

QuickBooks Problem: You receive the following message when attempting to log in to a company data file as Administrator: “The QuickBooks Administrator is editing the user information for user (Admin). You can try to log in as a different user.”

 

Solution: Various situations may cause this message to appear. For example, another user may already be logged in as Administrator (Admin). A temporary image file has not refreshed properly. The User list is damaged. To resolve this issue, use a name other than Admin to log in to the company data file. From the QuickBooks Company menu, choose Set Up Users. If Admin (logged on) appears in the User List window, another user has already logged in as Administrator. The other user must log off before you can log in as Administrator. If Admin (logged on) does not appear in the User List window, click Close. On each workstation, including the one that you are trying to log in from, exit QuickBooks and all other programs that are running. Turn off each workstation by choosing Shut Down from the Microsoft® Windows® Start menu, selecting Shut down from the drop-down list, and then clicking OK.


Important: Do not select Restart from the drop-down list. After all workstations have been turned off, turn them on again. Restart QuickBooks on your workstation and then try to log in as Administrator. If the message persists, try restoring a recent backup copy of your company file (however, you will need to reenter any new information that was entered since the backup was made).

 

QuickBooks Problem: You receive the following runtime errors, which occur after installing QuickBooks:

 

Runtime error -91

Runtime error -2147418105

Runtime error: 429 Active X components cannot create object

Runtime error ID = 1AD

Runtime error ID = 1CE

 

Solution: The possible cause of this problem may be caused by incomplete registration of all QuickBooks files during program installation. To resolve these messages: Restart your computer, and then restart QuickBooks. If the message persists, search for the file reboot.bat, and then double-click the file in the search results. (If the search results contain multiple files named reboot.bat, only double-click the file in the current QuickBooks installation folder.) If the message persists, install QuickBooks over the existing installation. If the issue is still unresolved, uninstall QuickBooks, and then install the program again.

 

QuickBooks Problem: Trouble getting QuickBooks Pro and Enterprise Solutions to use multi-user mode.

 

Solution: When running on a network, QuickBooks Enterprise Solutions will allow up to 10 users to work in the same data file at the same time. When more than one person is using the same company file, the file is in multi-user mode. To set up a multi-user environment, make sure you have your computers connected to the network properly. Install a copy of QuickBooks Enterprise Solutions on each user's computer. Each user must have a unique copy of the same version of QuickBooks with a unique Installation Key Code. Choose a location for the QuickBooks company file. Be sure each user has read/write access and create/delete rights to the directory where the QuickBooks company file is stored. On a peer-to-peer network you may want to put the company file on the computer of the person who uses QuickBooks the most. This allows that person to have the fastest access to the file. On a Client-Server network you will most likely put the company file on the server. Make sure you have the network drives correctly.

 

 

QuickBooks Problem: Lost registration number.

 

Solution: To locate your registration number:  In QuickBooks, press Ctrl+1 to open the Product Information window. Your registration number will be located in the top left corner of the window. To close the Product Information window, click OK.

 

 

QuickBooks Problem: You receive the following message, after downloading a patch from the QuickBooks Update Service? "Insufficient disk space to apply patch" followed by "Unable to apply patch."

 

Solution: This message sequence can occur when your computer has less than 62 megabytes (MB) of hard disk space available. To resolve this message, erase some un-needed files make available approximately 62 MB of hard disk space. In many cases, this is a good indication that a new computer is needed. Once your computer has more hard disk space available, you can attempt the update again.

 

QuickBooks Problem: Why is an Internet browser required for QuickBooks and how do I make sure that I have the right version loaded?

 

Solution: The latest versions of QuickBooks require Microsoft® Internet Explorer (IE) version 6.0 or higher. If you do not have the required version of IE on your computer when you install QuickBooks, it will be installed along with QuickBooks. If you ever need to reinstall IE, you can install it directly from the QuickBooks CD, or you can download and install the latest version from the Microsoft Web site. To install IE from the QuickBooks CD: Insert the QuickBooks CD in the CD-ROM drive. Click Reinstall QuickBooks when the installation starts. (If you are asked if you want to install QuickBooks now, click Yes.) Enter your Installation Key Code and click Next. (The code from the previous installation should be displayed just above the entry field, or you can find the code on the sticker on the back of the CD envelope.) Click Next past the QuickBooks installation location (you will not be reinstalling QuickBooks). Select Custom as the Setup Type and click Next. Clear the QuickBooks checkbox and select Internet Explorer 6.0. Click Next. Follow the onscreen instructions for the remainder of the installation.

 

 

QuickBooks Problem: You receive the following message after choosing the type of business and chart of accounts in the Easy-Step Interview: “Error on line XXX: imported account has a duplicate account number”

 

Solution: If you are in the Sample company and go to the Easy-Step Interview and then choose any type of business, QuickBooks will return the error. Click OK on the error. The chart of accounts selected will be set up correctly. Intuit is aware of this issue, however, there is no resolution at this time.

 

 

QuickBooks Problem: The check numbering sequence used for printing batch checks does not continue in the Write Checks window.

 

Solution: By design, there are two separate numbering sequences used for QuickBooks checks. One sequence is used for printing sequential groups (batches) of checks, whereas a different sequence is used for manually written checks. If you select the To be printed checkbox in the Write Checks window, the check will grouped with others for continuous (batch) printing. When printed, the check will be assigned a number from the sequence used for batch printing. If you do not select the To be printed checkbox, QuickBooks assigns a check number from the numbering sequence used for manually written checks. To correct the check number in the Write Checks window, double-click the incorrect check number in the No. field and then enter the new number (this will not affect the batch numbering sequence). After you save the corrected check, the next assigned check number in the Write Checks window will continue sequentially from the number you entered. Note: You can correct the starting check number for a batch sequence as well (from the QuickBooks File menu, choose Print Forms, choose Checks, and then update the First Check Number field).

 

QuickBooks Problem: I can't see the account numbers for split detail accounts when printing from an account register.

 

Solution: If the Print splits detail checkbox is selected when printing from a register, account numbers will print for single-account transactions, but not for multiple detail accounts. To see account number detail, you can print a Journal report instead of printing from the register. To do this, from the QuickBooks Reports menu, choose Accountant & Taxes, and then choose Journal. Click Modify Report, and in the Columns box, clear the checkmark from Trans #, Type, Debit, and Credit. Also, in the Columns box, select Clr, Amount, and Balance to add these columns. Click the Filters tab. Select Account in the Filter list, and then select the specific account from the drop-down list. Under Include split detail? Select Yes. Select Date in the Filters list, and then enter the appropriate date range. Click OK. Click Print at the top of the report. Memorize the report if you would like to use this setup again. Intuit is aware of this issue, however, there is no resolution at this time.

 

 

QuickBooks Problem: QuickBooks does not consistently check spelling on forms.

 

Solution: If a form is printed from the Print Preview window, QuickBooks does not perform the spelling check, even though the preference to always check spelling may be active. (Preferences are found on the QuickBooks Edit menu.) To ensure that the spelling check will be performed, click Close in the Print Preview window, and then print directly from the form.

 

QuickBooks Problem: I can't see the complete customer notes on my QuickBooks time detail report.

 

Solution: Time detail reports can display 99 characters in the notes column. If the customer notes are longer than 99 characters, then they will not display completely. To see important customer note information on time detail reports, your notes can either be reduced in length, or rearranged to ensure that the most important information appears at the beginning.

 

QuickBooks Problem: When printing a QuickBooks report in Microsoft® Excel, the report header is not automatically centered.

 

Solution: To center the report header in Excel, change the Advanced Printing options:

Run the report in QuickBooks. Click Excel, and then click Advanced. In the Printing options section of the Export Report to Excel window, select Send header to Page Setup in Excel. Click OK. When you print the report, the header will now be centered. Note: Excel features are not available in QuickBooks Basic.

 

 

QuickBooks Problem: Trouble reconciling an account in QuickBooks with its financial statement.

 

Solution: To reconcile a QuickBooks account with its financial statement, from the QuickBooks Banking menu, choose Reconcile. Enter or select the appropriate account in the Account field. Compare your statement’s opening balance with the amount shown in the Beginning Balance field. If you reconcile regularly and the QuickBooks Beginning Balance differs from the beginning balance on your statement, the discrepancy could be caused by clearing a transaction directly in the account register (as opposed to the Reconcile [Account] window), or by changing or deleting a previously reconciled transaction. Enter your statement’s ending balance in the Ending Balance field. Enter any new service charges, finance charges, or interest earned from your statement. Click Continue to open the Reconcile [Account] window. Now you are ready to reconcile individual transactions. When you find a transaction that matches one on the statement, click the checkmark column to clear it. If you click Leave in the Reconcile [Account] window before you are completely finished, QuickBooks does not retain the transactions you marked. You will need to start over at step 1 the next time you reconcile. For each transaction that you clear, verify that it matches one on the statement. If the transaction does not match and the statement is incorrect, please contact your financial institution. If the statement amount is correct, double-click the transaction in QuickBooks to display it.  Correct the error, and then click Save & Close. Click the corrected transaction to clear it.  When you have finished clearing transactions, look at the Difference amount in the bottom right corner of the Reconcile [Account] window. If the amount is 0.00, click Reconcile Now. You have successfully reconciled the account with the statement. If the amount is anything other than 0.00, the account does not balance for the period of time covered by the statement. Choose one of the following options: Start again, making sure that all amounts and transactions have been recorded correctly. Click Reconcile Now, and then click Enter Adjustment to finish the reconciliation for the time being. (QuickBooks will enter an adjustment to your account.) Eventually, however, you should locate and correct the cause of the discrepancy.

 

QuickBooks Problem: The beginning balance is incorrect in the Begin Reconciliation window.

 

Solution: The beginning balance in the Begin Reconciliation window may be incorrect if any of the following have occurred: A transaction was cleared directly in the account register, causing the transaction to be excluded from the beginning balance in the Begin Reconciliation window. To include the transaction in the beginning balance, you must clear it in the Reconcile [Account] window. Unlike QuickBooks 2001 and earlier versions, transactions cleared directly in the register are no longer used to calculate the beginning balance for reconciliation. If you are familiar with the way QuickBooks formerly calculated beginning (opening) balances, the amount may be different than expected. A previously cleared transaction was somehow modified since the last reconciliation. This includes: Voiding or deleting a cleared transaction. Changing the amount of a cleared transaction. 

 

Additionally, there may be data damage in the company data file. If so, and if you are certain that the discrepancy is due only to transactions cleared in the account register, choose one of the following options: Complete the reconciliation with the beginning balance discrepancy. If you ignore the discrepancy in the Begin Reconciliation window and click Continue to proceed to the Reconcile [Account] window, any transactions cleared through the register will appear and will already have checkmarks next to them. Use your bank statement to select all other cleared transactions for the period. Assuming there are no other issues, the reconciliation should balance correctly. Complete the reconciliation of the transactions cleared in the register before reconciling to the bank statement. Because the sum of transactions cleared in the register is causing the variance between the QuickBooks and the bank statement beginning balances, if you complete the reconciliation of these items, you should then be able to reconcile properly to the bank statement. Enter the beginning balance from the bank statement in the Ending Balance field of the Begin Reconciliation window, and then click Continue to proceed to the Reconcile [Account] window. The transactions cleared in the register will already have checkmarks next to them, and the Difference amount in the lower right corner should be 0.00. Click Reconcile Now to finish reconciling these transactions only, and then begin the reconciliation process again. The QuickBooks beginning balance will now match the bank statement beginning balance.

 

If you suspect that any transactions have been altered or deleted, choose one of the following options: Run a reconcile discrepancy report. From the QuickBooks Reports menu, choose Banking, and then choose Reconcile Discrepancy. Select the appropriate account, and then click OK to display a listing of transactions that have changed since the last reconciliation. Run a reconciliation detail report. From the QuickBooks Reports menu, choose Banking, and then choose Reconciliation Detail. Select the appropriate account, select the statement ending date, and then click Display to open a prior reconciliation detail report. Compare this report to reports printed for past reconciliations to look for differences. Locate the discrepancy amount. (This option will work only if the discrepancy was caused by a single transaction.) From the QuickBooks Edit menu, choose Advanced Find. Select Amount in the Filter list, select the equals (=) option, and then enter the discrepancy amount in the field to the right. Click Find. If a transaction is found, determine whether it is the transaction causing the discrepancy, and correct it as needed. Note: If the transaction was previously reconciled but is now uncleared, correct the status through the account register by clicking in the checkmark column, and then clicking Record to save the change. If the transaction has been marked cleared but has not been reconciled, see the solutions above regarding how to handle transactions cleared in a register.

 

Run an account QuickReport: Use this report to determine if transactions have an incorrect cleared status. From the QuickBooks Lists menu, choose Chart of Accounts.  Select the account you want to reconcile.  Click the Reports button at the bottom of the list, and then choose QuickReport. Click Modify Report, and then click the Display tab.  Select Clr in the Columns list. Click the Filters tab. In the Filter list, select Cleared. To the right of the Filter list, select either Yes (to filter for cleared transactions) or No (to filter for uncleared transactions), and then click OK to return to the report. Look at recent transactions. If you see transactions incorrectly cleared or uncleared, update them in the account register by clicking in the checkmark column, and then clicking Record to save the change. (See the solutions above regarding how to handle transactions cleared in a register.)

 

Run an audit trail report: This report can help identify transactions that have been deleted, changed, or added since the last reconciliation. A close examination of this report can often help locate a problem, however, if the audit trail feature has not been active, you will not be able to see changes or deletions that occurred while the audit trail was inactive. To activate the audit trail feature: From the QuickBooks Edit menu, choose Preferences. Click the Accounting icon on the left. Click the Company Preferences tab.  Select the Use audit trail option, and then click OK. To run the report, from the QuickBooks Reports menu, choose Accountant & Taxes, and then choose Audit Trail. You may need to adjust the report dates to see modifications for the appropriate time period. If the options listed above do not resolve the issue and you suspect damage, use the QuickBooks Verify Data and Rebuild Data utilities to detect and repair the damage.

 

QuickBooks Problem: Transactions are missing from the Match Transactions window after I download a bank statement.

 

Solution: There are various reasons why transactions might be missing from the Match Transactions window after downloading a bank statement. The transactions may not have reached the Intuit server yet. Your financial institution uploads transactions to the server once a day, and until transactions are on the server, they cannot be downloaded. Historical or older information may not have been sent with your statement. Financial institutions decide how far back historical information goes, and they will send you a confirmation letter indicating how old your first downloaded statement transactions will be. Additionally, the server will not hold statement information older than three months.

The Show Matched checkbox in the Match Transactions window may have been cleared. This prevents matched transactions from showing on the QuickStatement.

 

If you find transactions missing from the Match Transactions window, choose the appropriate solution below:

 

If the only missing transactions are from within two business days, try the download again tomorrow, when the transactions may have reached the server. If you would like to contact your financial institution: From the QuickBooks Banking menu, choose Online Banking Center. Select the correct name from the Financial Institution drop-down list. Click the Contact Info button in the upper right corner of the Online Banking Center window.

 

If the only missing transactions are your oldest transactions, in the first statement, try entering the missing transactions manually. All future transactions should download correctly. Make sure the Show Matched checkbox is selected in the Match Transactions window: From the QuickBooks Banking menu, choose Online Banking Center. Click Send (if you have not already done so) to download transactions that have occurred since the last time you downloaded transactions. After the download has completed, select an account from the Items Received From Financial Institution area. Click View to display the QuickStatement in the Match Transactions window. Select the Show Register checkbox if it is not already selected. This will allow QuickBooks to match transactions from your QuickStatement with those in your register. Transactions that have already been reconciled will not be matched. Verify that the Show Matched checkbox is selected in the bottom left corner of the Match Transactions window.

 

 

QuickBooks Problem: You receive the following error, which occurs when attempting to send or delete an online banking transaction? C=43.

 

Solution: C=43 errors indicate possible damage to the data file. To resolve this issue, run the Verify Data utility described earlier. (If data damage is detected, you will then be prompted to rebuild your data file, also described earlier.)

 

QuickBooks Problem: Your computer stops responding when you open a transaction window (such as the Write Checks or Pay Bills window) or edit an online transaction in a register.

 

Solution: A possible cause of this problem could be that your financial institution's information may need to be updated. To update your financial institution's data: From the QuickBooks Banking menu, choose Set Up Online Financial Services, and then choose Online Financial Institutions List. Scroll through the Financial Institutions Directory Web page and select your financial institution. Click the Apply Now button. After the page loads, close the browser using the X in the upper right corner. You do not need to fill out the application. QuickBooks will connect online to receive updated online financial institution information. Once the transmission is complete, you should be able to use online banking functions, as well as open transaction windows, and edit online entries in the register. If the above did not solve the issue, follow the steps below completely and without interruption: From the QuickBooks Banking menu, choose Online Banking Center. Check for any online service notifications or e-mails, view and then delete them.

Select the message and click View. If you want to retain this information, click Print to print the message for your records. Click Close to close the message window. With the same message selected, click Delete. Make sure any transactions in the Match Transaction window are either matched, added to the register or deleted. (For more information on matching transactions, from the QuickBooks Help menu, choose Help Index, and then type matching online transactions.) Send any payments waiting in the Items to Send section. Back up your company file. Disable any accounts that use online banking and/or online bill payment services.  From the Lists menu, choose Chart of Accounts.  Select any accounts that are set up to use online banking. (These accounts have a lightning bolt to the left of the Type column.) Click the Account button and choose Edit. Click the Online Info tab. Record all online account information on this tab.

Clear the Online Account Access and/or Online Payment checkboxes.

You will receive a message "You have just disabled online services for this account. Do you wish to retain the online information associated with this account?" Click No. Repeat Step 6 for any other online bank accounts. Re-enable all online accounts: In the Chart of Accounts window, select the accounts you want to re-enable. Click the Account button and choose Edit. Click the Online Info tab. Reenter all online account information on this tab as recorded in Step 6e. Select the Online Account Access and/or Online Payment checkboxes as appropriate. Click OK to save your changes.

 

QuickBooks Problem: The AutoRecall feature in QuickBooks not automatically filling in information from the last transaction for this name.

 

Solution: AutoRecall memorizes the information on the first transaction recorded for a specific name on a given date. The information from that transaction is used on all subsequent transactions until a new transaction for the same name is recorded on a different date. If a second transaction with different information is entered on the same date, AutoRecall does not store the new information. To resolve this issue, either update your transactions manually, or follow these steps to use AutoRecall to create updated transactions for the same day: Create a new transaction with updated information using a future date. Click Save & New, and then click Previous. Change the date back to today’s date. Click Save & New again.  AutoRecall works with bills, checks, or credit card charges. AutoRecall does not work with purchase orders, invoices, sales receipts, payroll liability checks, or credit memos. In addition, AutoRecall cannot transfer information from one account to another. For example, if you have two checking accounts, you cannot write a check in the first account, and then AutoRecall the check information in the second account.

 

QuickBooks Problem: Trouble setting up custom fields.

 

Solution: Custom fields let you add to the information that QuickBooks tracks about your customers, vendors, and employees and the items that you purchase and sell.  You can add your own custom fields to the windows where you set up customers, vendors, employees, or items. Information you enter into the fields can be just for your use, or it can prefill on certain forms when you enter a name or item on the form.  You can also include data from custom fields in your reports. QuickBooks treats the information you enter into a custom field the same way it treats information entered into any other field. If you memorize a transaction that has a custom field, QuickBooks memorizes what you entered in the field along with the other details of the transaction. If you export a list that contains data in custom fields, QuickBooks exports that data along with the other data from the list. For example, if you want to track your sales by region:  Add a field titled Sales Region to the New/Edit Customer window.  Fill in the sales region for each customer on your Customer:Job list. Add the new Sales Region field to each form. From then on, a customer’s sales region prefills when you enter a sale. You can filter your reports so they show only sales for a particular region.

 

QuickBooks Problem: Trouble setting Outlook or ACT! To work with QuickBooks.

 

Solution: During the synchronization process, each name from your contact manager (Outlook or ACT!) needs to be selected and placed in a QuickBooks list. To assign the contact names to the appropriate lists in QuickBooks: From the QuickBooks Company menu, choose Synchronize Contacts. Follow the instructions in the wizard. Once the synchronization has started, you are prompted you to assign the contact name(s) to the appropriate QuickBooks list. Select the contact name(s) from the list. At the bottom of the window, select the appropriate list in QuickBooks in which to place the contact name(s). (You can select multiple contact names by pressing the Ctrl key on your keyboard as you click each name. Continue to press the Ctrl key until all names have been selected.) Click Apply. This categorizes the contact names so that they will automatically synchronize with the correct QuickBooks list. After all of the names have been categorized, click OK to resume synchronization. When the process is complete, a Synchronization Complete window will appear with an option to view the Sync Log file. You may view the file for information on the results of the synchronization.

 

QuickBooks Problem: Problems memorizing transactions in QuickBooks.

 

Solution: You cannot memorize receipts or deposits of payments, bill payments, paychecks, time records, sales tax payments, or year-to-date (YTD) payroll adjustments. If you are entering the transaction information for future use and do not want to record the transaction now, click Clear to close the transaction window. To memorize a transaction in QuickBooks: Enter the transaction. If the content of certain fields will change each time you recall the transaction, leave those fields blank. For example, your monthly utility bill should be memorized with a blank Amount field. From the QuickBooks Edit menu, choose Memorize. In the Name field of the Memorize Transaction window, enter a name that will help you recognize the transaction in the Memorized Transaction list. In the Detail area of the Memorize Transaction window, indicate how you want the transaction handled. (If you need assistance, press F1 while the Memorize Transaction window is open.)  Click OK to memorize the transaction.

 

QuickBooks Problem: Problems entering journal entries are made in the General Journal Entry window.

 

Solution: This option is available for accountants or users who prefer the traditional system of accounting in which transactions are entered into a general journal. If you are not an accountant, you might use the general journal to transfer amounts from one income or expense account to another, or from one class to another. In order to complete your year-end activities, your accountant may instruct you to record miscellaneous journal entries in QuickBooks. To record a journal entry: From the QuickBooks Banking menu, choose Make Journal Entry. In the General Journal Entry window, change the Date field, if desired. If you number your general journal entries, enter the number in the Entry No. field.  In the detail area, enter distribution lines: In the Account column, enter or select the first account in your transaction. If you are using an A/R (accounts receivable) or A/P (accounts payable) account, the first account in the general journal transaction should be the accounts receivable or accounts payable account. In the Debit (or Credit) column, enter the debit (or credit) amount for the account you selected in the previous step. (Optional) Enter a memo about the amount in the Memo column. The memo appears on reports that include the general journal entry. Enter or select the customer, vendor, employee, or other name associated with the transaction in the Name column (required for A/R or A/P accounts.) (Optional) If you selected an expense account along with a customer or job, you can make the amount billable to the customer. To avoid billing the customer for an expense, click the billable icon to put an X through it. (Optional) Assign a class to the amount. Repeat Steps 4a through 4f to enter distribution lines until the transaction reaches a zero balance (that is, the total in the Debit column equals the total in the Credit column). Click Save & Close to save the journal entry and close the window, or Save & New to save the journal entry and create a new one. 

 

QuickBooks Problem: Understanding and using the opening Bal Equity account.

 

Solution: QuickBooks creates this account the first time you enter an opening balance for a balance sheet account. As you enter the opening balances, QuickBooks records the amounts in the Opening Bal Equity account. This ensures that you have a correct balance sheet for your company, even before you have entered all your company's assets and liabilities. After you have entered all of your opening balances, you may want to move the amount in Opening Bal Equity to your other equity accounts. This is an optional adjustment if you want to identify retained earnings or the equity of several owners.

 

To transfer all or part of the amount:  From the QuickBooks Lists menu, choose Chart of Accounts. Double-click the Opening Bal Equity account to open its register. Enter a transfer transaction: In the Account field, select the equity account that you are transferring the money to from the drop-down list. Enter the amount to transfer in the Decrease column of the register. Click Record, and then repeat steps for any other amounts you want to transfer.

 

 

QuickBooks Problem: Problems handling bounced checks from customers.

 

Solution: When a customer's check has "bounced" (returned to you for insufficient funds), handle it in the following manner: First, create items for tracking bounced checks and their associated charges if these items do not already exist in your company data file. From the QuickBooks Lists menu, choose Item List. Click the Item button and choose New. Select Other Charge from the Type drop-down list and name this item Bad Check or similar. Leave 0.00 in the Amount or % field and select Non from the Tax Code drop-down list. Select your bank account from the Account drop-down list and then click Next.

Repeat steps to create a second item named Bad Check Charge or similar. This is for the service charge you will assess customers for bounced checks when you send them another invoice. Select an income account (such as Returned Check Charges) from the Account drop-down list. If the account does not exist, click the drop-down arrow and choose Add New, and add the new income account. Click