urlscan.io logo urlscan.io
SecurityTrails logo

bigredconsulting.com Open in urlscan Pro
104.198.107.10  Public Scan

Back to summary
URL: https://bigredconsulting.com/products/summarize-payroll-data-in-excel-fixed/
Submission: On April 05 via manual from US — Scanned from DE

Form analysis 2 forms found in the DOM

GET https://bigredconsulting.com/

<form method="get" id="searchform" action="https://bigredconsulting.com/">
  <label for="s">Search </label>
  <span class="input"><input type="text" value="" name="s" id="s"></span>
  <button type="submit"><span>Search</span></button>
</form>

POST https://bigred.foxycart.com/cart

<form action="https://bigred.foxycart.com/cart" method="post" accept-charset="utf-8" class="foxyshop_product" id="foxyshop_product_form_5148" rel="5148">
  <input type="hidden" name="price||604267d3b2e8101cd911ef584c1f1da5c08f776a97f2b6f07724fa47402125ef" id="fs_price_5148" value="10.00">
  <input type="hidden" name="x:originalprice" value="10.00" id="originalprice_5148">
  <input type="hidden" name="x:l18n" value="$|.|,|1|0" id="foxyshop_l18n_5148">
  <input type="hidden" name="image||c8d09944233b039369ed8001ccfbf8b1f5bbc3c167931b708792af561892430e" value="https://bigredconsulting.com/assets/exampleReportPrinted_1-150x150.jpg" id="foxyshop_cart_product_image_5148">
  <input type="hidden" name="url||bb17f81464c008e40c0e673532eef02881515bdd3d519ec9b2a93772dae33eeb" value="https://bigredconsulting.com/products/summarize-payroll-data-in-excel-fixed/" id="fs_url_5148">
  <input type="hidden" name="quantity_min||b6f1f76345c7405b0c73ff3749a90dc826d4145e2e7c0a705d1c6c162600719c" value="1" id="fs_quantity_min_5148">
  <input type="hidden" name="quantity_max||64fbb847c7af934904bf3a62eb800ecb3b86817681b0d481d7dc1d391dfd5316" value="10" id="fs_quantity_max_5148">
  <input type="hidden" name="x:quantity_max" value="10" rel="||64fbb847c7af934904bf3a62eb800ecb3b86817681b0d481d7dc1d391dfd5316" id="original_quantity_max_5148">
  <input type="hidden" name="name||c159a974e67582184975feca21983411f6bb92e030aec1d14b26d7576a7acd59" id="fs_name_5148" value="Summarize Payroll Data In Excel - Fixed!">
  <input type="hidden" name="code||a6abd0a4dc98b91b6259ee90ca358cf4b2731577aa7f0b7189974ab5c6385e96" id="fs_code_5148" value="Summarize_Payroll">
  <div class="prodSummary">
    <div class="prodLeft">
      <h1>Summarize Payroll Data In Excel – Fixed!</h1>
      <div class="price">
        <div class="foxyshop_price"><span class="foxyshop_currentprice">$10.00</span></div>
      </div>
      <p>Replace the broken QuickBooks Summarize Payroll Data in Excel feature with a repaired version.</p>
    </div>
    <div class="prodRight">
      <p class="label_buy">Purchase License</p>
      <div class="foxyshop_variations">
        <label class="foxyshop_quantity" for="quantity_5148">Quantity</label>
        <select class="foxyshop_quantity" name="quantity">
          <option value="1||5bda34a61e93195e217d05d5a4c5eb669db707e1112a55284010b9ef3a1ca00c">1</option>
          <option value="2||cec75abb6505b6f4d57aa585d733d34a56366cb16a6b92b3a7474dc8487da2c8">2</option>
          <option value="3||01730bdce88f2038bda9e9cfee02cad20bb1991860a7a77d4564f16171a4201b">3</option>
          <option value="4||ead671d64ef74a7a7626525811485d73472c54a3185e1aa5a00ae3d32ed941f1">4</option>
          <option value="5||43af7b91e4979f4fa67339b9cf13993f76cc73f80c7536401e635211849c7e79">5</option>
          <option value="6||fd57587b863ba113b2976fb61ac77cb385db40b7ced96236fe44e147ed6fecb2">6</option>
          <option value="7||ca38acfcc4eb1cdbbbe03e8c25470793ad8a25101c7dd08d9d6e1c942088b19a">7</option>
          <option value="8||1c3c758c24d06bb93d20b111832f2c4110b46c692a586798893c3fc5dee3b5ae">8</option>
          <option value="9||74da317b1dda272e9cbbb44469c1085fd354459fc262fe5d08bd1f7a74449ccc">9</option>
          <option value="10||3547e5f1364f52886d2575e0734c40aef903659bddb5738cbc4724c0ca3f5e1d">10</option>
        </select>
        <div class="clr"></div>
        <script type="text/javascript" src="https://bigredconsulting.com/wp-content/plugins/foxyshop/js/variation.process.jquery.js" charset="utf-8"></script>
      </div>
      <div class="clear"></div>
      <button type="submit" name="x:productsubmit" id="productsubmit" class="foxyshop_button"><span class="button_text"><i class="fas fa-shopping-cart"></i>&nbsp;&nbsp;Add To Cart</span></button>
      <div class="clear"></div>
    </div>
    <div class="clear"></div>
  </div>
  <div class="content">
    <div class="foxyshop_product_info">
      <h2>Fixed version of the Summarize Payroll Data In Excel workbook template</h2>
      <h3><strong>Background</strong></h3>
      <p>The QuickBooks Summarize Payroll Data in Excel feature’s template workbook shipped with QuickBooks is corrupted.</p>
      <p>When opening it with modern versions of Excel, an error is generated indicating corruption in two of the Pivot Reports included in the file. After updating with payroll data, the State Wage Listing and Quarterly Employee Summary reports do
        not update and instead continue to show sample data because of this corruption.</p>
      <p>As of Jan 2022, customers have waited more than three years for Intuit to fix this issue.</p>
      <p>So, we fixed it by repairing the State Wage Listing and Quarterly Employee Summary reports within the template and have posted the fixed version here for download. The reports a little different than the originals in their formatting, but
        appear to display the same results.</p>
      <p><strong><span style="color: #ff0000;">New!</span></strong> Because QuickBooks 2022 is 64-bit, the connection to QuickBooks had to be updated.&nbsp; As a result, there are now two versions of the repaired template.</p>
      <h3></h3>
      <h3><strong>Download</strong></h3>
      <p><strong>This fixed templates are free to download and use. There is no need to purchase or register.</strong></p>
      <p>However, please consider sending a small $10 thank-you. This will help motivate us to keep the templates up to date and to improve them for modern versions of Excel.</p>
      <p><strong>32-bit version – for QuickBooks version-years up to 2021 and Enterprise 21.0</strong></p>
      <p><a href="//bigredconsulting.com/assets/fixed_QB_Payroll_Link_32-bit-1.0.zip">QB_Payroll_Link_32-bit 1.0</a></p>
      <p><strong>64-bit version – for QuickBooks 2022 and Enterprise 22.0</strong></p>
      <p><a href="//bigredconsulting.com/assets/fixed_QB_Payroll_Link_64-bit-1.0.zip">QB_Payroll_Link_64-bit 1.0</a></p>
      <h3></h3>
      <h3><strong>Instructions</strong></h3>
      <ol>
        <li>Download and open the ZIP file to access the updated template.</li>
        <li>Read the included <strong>Readme First!</strong> file for simple instructions to use the template instead of Intuit’s broken workbook.</li>
      </ol>
      <div>
        <style type="text/css">
          #gallery-1 {
            margin: auto;
          }

          #gallery-1 .gallery-item {
            float: left;
            margin-top: 10px;
            text-align: center;
            width: 33%;
          }

          #gallery-1 img {
            border: 2px solid #cfcfcf;
          }

          #gallery-1 .gallery-caption {
            margin-left: 0;
          }

          /* see gallery_shortcode() in wp-includes/media.php */
        </style>
        <div id="gallery-1" class="gallery galleryid-5148 gallery-columns-3 gallery-size-thumbnail">
          <dl class="gallery-item">
            <dt class="gallery-icon landscape">
              <a href="https://bigredconsulting.com/assets/exampleReportPrinted_1.JPG" class="fancybox image" rel="gallery-0"><img width="150" height="150" src="https://bigredconsulting.com/assets/exampleReportPrinted_1-150x150.jpg" class="attachment-thumbnail size-thumbnail" alt="" loading="lazy" srcset="https://bigredconsulting.com/assets/exampleReportPrinted_1-150x150.jpg 150w, https://bigredconsulting.com/assets/exampleReportPrinted_1-45x45.jpg 45w, https://bigredconsulting.com/assets/exampleReportPrinted_1-230x230.jpg 230w" sizes="(max-width: 150px) 100vw, 150px"></a>
            </dt>
          </dl>
          <br style="clear: both">
        </div>
      </div>
      <div class="clr"></div>
    </div>
  </div>
</form>

Text Content

Skip to content


SEARCH

Search Search
 * Home
   * Contact Us
 * Coupons
 * Products
   * QuickBooks Apps
   * QuickBooks Online Apps
   * Excel Apps
   * Quicken Apps
   * Find Tool by Task
   * Try Before You Buy
 * Services
   * Enterprise to Pro Conversion
   * Consulting Purchase
   * Annual Premium Support Renewal
   * Annual Product Extensions
 * Support
   * Request Support
   * Get Replacement Product Key
   * Get free updates – with fixes and latest features!
   * Support Options
   * Returns
 * FAQ
   * QB 2019+ Special Import Instructions
   * Purchase & Startup Questions
   * Install Troubleshooting
   * How to enter your product keys
   * How To Move To A New Computer
   * Connecting to QuickBooks Troubleshooting
   * Other FAQs
 * Other
   * About
   * Miscellaneous Purchase
   * File Upload

    Cart 0

Big Red Consulting

We specialize in Excel-based add-ins and other productivity tools, both
ready-to-use & custom solutions.


SUBSCRIBE


MAIN MENU

 * QuickBooks Apps
 * QuickBooks Online Apps
 * Excel Apps
 * Quicken Apps
 * Free Trials & Updates





SUMMARIZE PAYROLL DATA IN EXCEL – FIXED!

$10.00

Replace the broken QuickBooks Summarize Payroll Data in Excel feature with a
repaired version.

Purchase License

Quantity 1 2 3 4 5 6 7 8 9 10


  Add To Cart




FIXED VERSION OF THE SUMMARIZE PAYROLL DATA IN EXCEL WORKBOOK TEMPLATE


BACKGROUND

The QuickBooks Summarize Payroll Data in Excel feature’s template workbook
shipped with QuickBooks is corrupted.

When opening it with modern versions of Excel, an error is generated indicating
corruption in two of the Pivot Reports included in the file. After updating with
payroll data, the State Wage Listing and Quarterly Employee Summary reports do
not update and instead continue to show sample data because of this corruption.

As of Jan 2022, customers have waited more than three years for Intuit to fix
this issue.

So, we fixed it by repairing the State Wage Listing and Quarterly Employee
Summary reports within the template and have posted the fixed version here for
download. The reports a little different than the originals in their formatting,
but appear to display the same results.

New! Because QuickBooks 2022 is 64-bit, the connection to QuickBooks had to be
updated.  As a result, there are now two versions of the repaired template.





DOWNLOAD

This fixed templates are free to download and use. There is no need to purchase
or register.

However, please consider sending a small $10 thank-you. This will help motivate
us to keep the templates up to date and to improve them for modern versions of
Excel.

32-bit version – for QuickBooks version-years up to 2021 and Enterprise 21.0

QB_Payroll_Link_32-bit 1.0

64-bit version – for QuickBooks 2022 and Enterprise 22.0

QB_Payroll_Link_64-bit 1.0





INSTRUCTIONS

 1. Download and open the ZIP file to access the updated template.
 2. Read the included Readme First! file for simple instructions to use the
    template instead of Intuit’s broken workbook.







 * RELATED PRODUCTS


 * TIMESHEET LINK
   
   $79.00
   


 * LIST REPORTER
   
   $49.00
   


 * LIST IMPORTER
   
   $59.00
   




SUBSCRIPTION

 * None Required (free)
 * $10 suggested


QUICK FACTS

 * Replace the broken QuickBooks Summarize Payroll Data in Excel feature with a
   repaired version.




© 2022 Big Red Consulting



MS Excel is a registered trademark of Microsoft, Inc. QuickBooks and Quicken are
registered trademarks of Intuit, Inc.