{"id":1681,"date":"2020-01-27T23:17:26","date_gmt":"2020-01-27T23:17:26","guid":{"rendered":"https:\/\/quickbookexperts.com\/Blog\/?p=1681"},"modified":"2020-01-27T23:17:26","modified_gmt":"2020-01-27T23:17:26","slug":"resolve-data-damage-on-your-company-file","status":"publish","type":"post","link":"https:\/\/quickbookexperts.com\/Blog\/resolve-data-damage-on-your-company-file\/","title":{"rendered":"Resolve data damage on your company file"},"content":{"rendered":"

Learn how to resolve data damage on your company file.<\/p>\n

If you suspect data issues with your company file, the steps in this article can help you resolve minor data problems.<\/p>\n

Step 1: Run the Rebuild Data utility<\/h2>\n

The first thing you will need to do is run the rebuild data utility:<\/p>\n

    \n
  1. Go to the\u00a0File<\/strong>\u00a0menu, then select\u00a0Utilities<\/strong>\u00a0and\u00a0Rebuild Data<\/strong>.<\/li>\n
  2. On the QuickBooks Information window, select\u00a0Ok<\/strong>. Follow the prompts to save a backup. (Note:<\/strong>\u00a0Your computer may display QuickBooks is not responding. However, as long as you can see your mouse cursor move, Rebuild is still ongoing. Wait for it to complete).<\/li>\n
  3. Select\u00a0Ok<\/strong>\u00a0when you see Rebuild has completed.<\/li>\n<\/ol>\n

    Step 2: Run the Verify Data utility<\/h2>\n

    The next thing to do is run the verify data utility:<\/p>\n

      \n
    1. Go to the\u00a0File<\/strong>\u00a0menu, then select\u00a0Utilities<\/strong>\u00a0and\u00a0Verify Data<\/strong>.<\/li>\n
    2. If you see QuickBooks detected no problem with your data, select\u00a0Ok<\/strong>. You may continue using your company file.<\/li>\n
    3. If Verify finds an issue with your data, you will be prompted to\u00a0Rebuild Now<\/strong>\u00a0or\u00a0View Errors<\/strong>. Select\u00a0Close<\/strong>, then perform either of the following:<\/li>\n<\/ol>\n

      Review Last Verify\/Rebuild<\/strong><\/h4>\n
        \n
      1. On the Product Information window, (press\u00a0F2<\/strong>\u00a0or\u00a0CTRL+1<\/strong>\u00a0on your keyboard) select\u00a0Review Last Verify\/Rebuild<\/strong>.<\/li>\n
      2. Find the error in the results screen.<\/li>\n<\/ol>\n

        Review QBWin.log<\/strong><\/h4>\n

        Are you comfortable reviewing the QBWin.log or the QuickBooks.log file? If so follow these steps. If not, contact support for additional help.<\/p>\n

          \n
        1. Find QBWin.log or QuickBooks.log files.\u00a0Note:<\/strong>\u00a0If you are working with a support agent, go to the Tech Help window (press F2, then F3 on your keyboard). Go to the\u00a0Open File<\/strong>\u00a0tab, highlight the log file, then select\u00a0Send log files to Intuit support<\/strong>. This will send the file to a repository that will enable the support agent to view your log files.<\/li>\n
        2. Check the log file.<\/li>\n
        3. Windows:<\/strong>\u00a0Search (press Ctrl+F on your keyboard) for\u00a0Begin Verify<\/strong>, then locate the most recent file (logs are in date order with the latest at the bottom).<\/li>\n
        4. Mac:<\/strong>\u00a0Scroll all the way to the bottom for the most recent Verify information<\/li>\n
        5. Find the line that contains the LVL_ERROR, then search for it in the check\u00a0QuickBooks Learn & Support site. (Note:<\/strong>\u00a0Errors within both the Windows and Mac log files might not be exactly the same but are presented in the same format).<\/li>\n<\/ol>\n

          Additional data damage troubleshooting for Mac<\/h2>\n

          Re-sort lists<\/h2>\n

          Re-sorting the lists\u00a0puts your records back in order. If you have manually changed the order of a list, re-sorting it will undo your changes.<\/p>\n

          Identify problem transactions using reports<\/h2>\n

          Run the Balance Sheet in Cash and Accrual Basis<\/strong><\/p>\n

            \n
          1. Go to\u00a0Reports<\/strong>\u00a0menu, then select\u00a0Company & Financial<\/strong>, then\u00a0Balance Sheet Detail<\/strong><\/li>\n
          2. Under\u00a0Accounting method<\/strong>, then choose either\u00a0Accrual<\/strong>\u00a0or\u00a0Cash<\/strong>\u00a0for the Report Basis. If the total assets does not equal the liability and equity in each report, determine the transaction causing the problem.\u00a0Back up your company file<\/a>, then delete and re-enter the transaction.<\/li>\n<\/ol>\n

            Compare the Account report totals to balances on the Chart of Accounts<\/strong><\/p>\n

              \n
            1. Compare the total in the\u00a0Open Invoices<\/strong>\u00a0report (Reports<\/strong>\u00a0menu,\u00a0Customers & Receivables<\/strong>,\u00a0Open Invoices<\/strong>) to the Accounts Receivable balance on the Chart of Accounts.<\/li>\n
            2. Also, Compare the total in the Unpaid Bills<\/strong>\u00a0report (Reports<\/strong>\u00a0menu,\u00a0Vendors &<\/strong>\u00a0Payables<\/strong>, then\u00a0Unpaid Bills Detail<\/strong>) to the Accounts Payable balance on the Chart of Accounts. If the total does not match the balance, check the transaction causing the problem.\u00a0Back up your company file<\/a>, then delete and re-enter or modify the transaction.<\/li>\n<\/ol>\n

              Check specific accounts<\/h2>\n

              Uncategorized Expenses<\/strong><\/p>\n

              Rebuild will often put out-of-balance transactions in this account as a way to “balance” the transaction. Generally, you should only see voided checks in this account unless you have been using it.<\/p>\n

              Look for transactions other than voided checks (any transactions with amounts that have no item or account associated with them). Delete and re-enter those transactions. Determine what item or account should be on the transaction.<\/p>\n

              Undeposited Funds<\/strong><\/p>\n

                \n
              1. From\u00a0Activities<\/strong>, select\u00a0Make Deposits<\/strong>.<\/li>\n
              2. Select\u00a0All<\/strong>\u00a0(do not record the deposit at this time).<\/li>\n<\/ol>\n

                The deposit total amount should equal the balance showing for Undeposited Funds on the Chart of Accounts. In addition, there should not be any deposits (negative amounts) showing on the deposit.<\/p>\n

                Merge damaged accounts, items or names<\/h2>\n

                Merge damaged accounts<\/strong><\/p>\n

                  \n
                1. Go to the\u00a0Lists<\/strong>\u00a0menu, then select\u00a0Chart of Accounts<\/strong>.<\/li>\n
                2. While holding the\u00a0Control<\/strong>\u00a0key, select the damaged account. Choose\u00a0Edit Account<\/strong>.<\/li>\n
                3. Add an asterisk (*) to the name of the account, then select\u00a0Cancel<\/strong>.<\/li>\n
                4. Hold the\u00a0Control key<\/strong>, then select any account.<\/li>\n
                5. Select\u00a0New Account<\/strong>.<\/li>\n
                6. Choose the appropriate type, then enter the original name of the problem account.<\/li>\n
                7. Select\u00a0Ok<\/strong>.<\/li>\n
                8. Hold the\u00a0Control key<\/strong>, then select the original account. Choose\u00a0Edit Account<\/strong>.<\/li>\n
                9. Remove the asterisk (*) from the account name. Select\u00a0OK<\/strong>.<\/li>\n
                10. Select\u00a0Yes<\/strong>\u00a0to confirm that you want to merge the two accounts.<\/li>\n<\/ol>\n

                  Merge damaged items<\/strong><\/p>\n

                    \n
                  1. Go to the\u00a0Lists<\/strong>\u00a0menu, then choose\u00a0Items<\/strong>.\u00a0(Note:<\/strong>\u00a0Make sure the two items are of the same type).<\/li>\n
                  2. While holding the\u00a0Control<\/strong>\u00a0key, select the damaged item. Choose\u00a0Edit Item<\/strong>.<\/li>\n
                  3. Add an asterisk (*) to the name of the item, then select\u00a0Cancel<\/strong>.<\/li>\n
                  4. Hold the\u00a0Control key<\/strong>, then select any item.<\/li>\n
                  5. Select\u00a0New Item<\/strong>.<\/li>\n
                  6. Choose the appropriate type, then enter the original name of the problem item.<\/li>\n
                  7. Select\u00a0Ok<\/strong>.<\/li>\n
                  8. Hold the\u00a0Control key<\/strong>, then select the original item. Choose\u00a0Edit Item<\/strong>.<\/li>\n
                  9. Remove the asterisk (*) from the item name. Select\u00a0Ok<\/strong>.<\/li>\n
                  10. Select\u00a0Yes<\/strong>\u00a0to confirm that you want to merge the two items.<\/li>\n<\/ol>\n

                    Merge damaged names<\/strong><\/p>\n

                      \n
                    1. Open the corresponding Center (Customer, Vendor, or Employee) for the type of name you are merging. (Note:<\/strong>\u00a0Make sure the two names are of the same type.)<\/li>\n
                    2. While holding the\u00a0Control<\/strong>\u00a0key, select the damaged name. Choose\u00a0Edit<\/strong>.<\/li>\n
                    3. Add an asterisk (*) to the name, then select\u00a0Cancel<\/strong>.<\/li>\n
                    4. Hold the\u00a0Control<\/strong>\u00a0key, then select any name.<\/li>\n
                    5. Select\u00a0New<\/strong>.<\/li>\n
                    6. Choose the appropriate type, then enter the original name.<\/li>\n
                    7. Select\u00a0Ok<\/strong>.<\/li>\n
                    8. Hold the\u00a0Control<\/strong>\u00a0key, then select the original name. Choose\u00a0Edit<\/strong>.<\/li>\n
                    9. Remove the asterisk (*) from the name. Select\u00a0Ok<\/strong>.<\/li>\n
                    10. Select\u00a0Yes<\/strong>\u00a0to confirm that you want to merge the two names.<\/li>\n<\/ol>\n

                      Delete memorized reports or transactions<\/h2>\n

                      Delete Memorized Reports<\/strong><\/p>\n

                        \n
                      1. Go to the\u00a0Reports<\/strong>\u00a0menu, then select\u00a0Report Center<\/strong>.<\/li>\n
                      2. Select the report you want to delete, then select the name once.<\/li>\n
                      3. Select the\u00a0red X<\/strong>, then\u00a0Ok<\/strong>\u00a0to delete the memorized report.<\/li>\n<\/ol>\n

                        Delete Memorized Transactions<\/strong><\/p>\n

                          \n
                        1. Go to the\u00a0List<\/strong>\u00a0menu, then select\u00a0Memorized Transactions<\/strong>.<\/li>\n
                        2. Choose the transaction you want to delete.<\/li>\n
                        3. Go to the\u00a0Edit<\/strong>\u00a0menu, then choose\u00a0Delete Memorized Transaction<\/strong>.<\/li>\n
                        4. Select\u00a0Ok<\/strong>\u00a0to delete the memorized transaction.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

                          Learn how to resolve data damage on your company file. If you suspect data issues with your company file, the steps in this article can help you resolve minor data problems. Step 1: Run the Rebuild Data utility The first thing you will need to do is run the rebuild data utility: Go to the\u00a0File\u00a0menu, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1,6,8,5,4],"tags":[],"class_list":["post-1681","post","type-post","status-publish","format-standard","hentry","category-other-questions","category-quickbooks","category-quickbooks-desktop","category-quickbooks-mac-desktop","category-quickbooks-mobile","category-quickbooks-online"],"_links":{"self":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/posts\/1681","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/comments?post=1681"}],"version-history":[{"count":0,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/posts\/1681\/revisions"}],"wp:attachment":[{"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/media?parent=1681"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/categories?post=1681"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quickbookexperts.com\/Blog\/wp-json\/wp\/v2\/tags?post=1681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}