(800) 931-6557
(800) 931-6557
ASP
  • Home
  • Services
    • Accounting
    • Accounting FAQ
  • Recruiting
    • Services
    • Recruiting Team
    • Our Process
    • Recruiting Podcast
    • Top Candidates
    • Recruiting FAQ
  • Openings
  • Locations
    • Oregon >
      • Oregon Accounting
      • Oregon Bookkeeping
      • Oregon Team
    • Washington >
      • Washington Accounting
      • Washington Bookkeeping
      • Washington Team
    • Colorado >
      • Colorado Accounting
      • Colorado Bookkeeping
      • Colorado Team
    • Texas >
      • Texas Accounting
      • Texas Bookkeeping
      • Texas Team
  • About
    • Clients
    • Testimonials
    • Inclusion at ASP
    • Resources
    • Submit Resume
  • Blog
  • Contact
  • Payments
  • Home
  • Services
    • Accounting
    • Accounting FAQ
  • Recruiting
    • Services
    • Recruiting Team
    • Our Process
    • Recruiting Podcast
    • Top Candidates
    • Recruiting FAQ
  • Openings
  • Locations
    • Oregon >
      • Oregon Accounting
      • Oregon Bookkeeping
      • Oregon Team
    • Washington >
      • Washington Accounting
      • Washington Bookkeeping
      • Washington Team
    • Colorado >
      • Colorado Accounting
      • Colorado Bookkeeping
      • Colorado Team
    • Texas >
      • Texas Accounting
      • Texas Bookkeeping
      • Texas Team
  • About
    • Clients
    • Testimonials
    • Inclusion at ASP
    • Resources
    • Submit Resume
  • Blog
  • Contact
  • Payments

​In Pursuit of Profit

Read our expert article below or sign up to get articles sent to your inbox.​

9/24/2019

Comments

How Do I Clean Up Old Transactions in QuickBooks?

 
How Do I Clean Up Old Transactions in QuickBooks?
Maintaining clean financial records is vital during business transitions. When circumstances change, updated books allow business owners to accurately discern the financial health of the business and strategically plan for the future. Securing bank loans, weathering audits, maintaining aggressive business growth, filing insurance claims, and resolving ownership disagreements are all instances when transactions are scrutinized for accuracy and timeliness. 
However, outdated or erroneous transactions can linger, muddling financial records and hiding the true value of the business.

In situations when businesses add employees, expand product/service lines, update billing policies, use new shipping channels, or change the timing of their invoices, financial records can become muddled. While the business may look the same externally, its inner financial shortcomings can undermine operational efficiency.

When the transactions get more complicated or increase in frequency, existing employees’ financial skills and capacity cannot necessarily keep pace. The result is an unorganized ledger that can affect the balance sheet and cash flow statement.

In other scenarios, a business’s future needs may not be fully understood, thwarting planning efforts and creating a case where accounting functions end up falling short of these unforeseen expectations even when executed by more experienced personnel.  

Purging old transactions removes distracting clutter and improves reporting accuracy while increasing financial accountability. The result is improved confidence in decision-making for more sustained growth.

Timing

Maintaining data indefinitely can slow down report generation and ongoing management. Once the required retention window for data has passed, financial transactions should be removed for the sake of good housekeeping. Before performance issues arise, save historical data as an archived copy and then clean up old transactions to make everyday use easier. Get financial accounts in order to prepare for upcoming activities like loan applications or investor funding rounds and what-if scenarios like audits or owner disputes.

The Process

QuickBooks stores the details of each credit and debit transaction, but these can be deleted or voided as needed. The process to do so is fairly straightforward, but many business owners get confused about the operational difference and subsequent business implications.

Deleting a transaction removes it entirely from the platform, and although the Audit Log may still contain some details, it cannot be restored. Voiding a transaction reduces it to a zero-dollar value and removes any associated payments. After the transaction is voided the details are retained within QuickBooks without affecting financial reporting or account balances.

While both are irreversible, deletion should only be used when the transaction was created in error. Otherwise, the transaction should be voided to abide by good accounting practices and keep the associated transactional details for future reference. Unfortunately, estimates, deposits, vendor credits, purchase orders, delayed charges, delayed credits, and bills cannot be voided. Transactions also cannot be voided in bulk, making it a potentially time-consuming process depending on how many need to be voided.  

The Condense Data Tool is a way to address old transactions that streamlines the process for higher volume businesses. Condensing removes all transactions before a certain date and consolidates these older transactions. This tool is helpful for business owners that need to manage outdated transactions at scale.
  • Tip: Before using the Condense Data Tool save and view a copy of the balance sheet and P&L statement to compare the new financial statements to after the tool has run. If the statements do not match, the condense function did not work properly, and a backup restore may be required.

Professional Assistance

Business owners looking for an easy way to clean up their books have several options:
Specialized Software
​

QuickBooks add-ons can be purchased relatively inexpensively to automatically clean up the books by removing financial transactions. However, while these complementary solutions are quick fix, they are not magic. Financially savvy business owners will likely see more of a benefit from this type of supplementary software than their less savvy counterparts because while the program can do the technical work, it cannot discern the logic behind it. Therefore, the onus is still on the business owner to genuinely understand the strategic reasoning and methodology needed to run the software effectively. In some cases, this software can actually cause more harm than good because misapplication can skew financial transactions in a way that negatively affects cash flow.

Internal Specialist

Hiring an internal bookkeeper, accountant, or finance professional is the best way to take control of business transactions and other financial components. However, this solution comes at a steep price. The cost associated with recruiting, screening, hiring, and onboarding a dedicated specialist internally is out of the reach of many small businesses. For most business owners, this process is not only daunting and costly, but also time prohibitive.

Third-Party Expert

​The financial savvy required to run add-on software as well as with the cost and time required to hire internally are motivation enough for some business owners to look externally. Paying a third-party company is a cost-effective way for business owners to get the help they need when they need it. Whether it is an occasional accounting clean up, ongoing financial management, or tax preparation help, an accounting firm can provide the necessary help.
Need help with cleaning up your QuickBooks?  We can help!  Contact us today!
Comments

    SUBSCRIBE:

    DOWNLOAD:

    The Ultimate New Business Formation Checklist

    DOWNLOAD:

    Accountant Evaluation

    Categories:

    All
    Accountant
    Accounting
    Accounting Systems
    Artificial Intelligence
    Audit
    Bank Reconciliation
    Benefits
    Bookkeeper
    Bookkeeping
    Brand
    Budgeting
    Business Analysis
    Business Trends
    Career
    Cash Flow
    Change Management
    Checklist
    Closing The Books
    Colorado
    Community
    Contracts
    Controller
    Depreciation
    Ecommerce
    Economy
    Finance
    Fraud
    Government
    Hack
    Hiring
    HR
    Infographic
    Internal Controls
    IRS
    Laws
    Leadership
    Legal
    Local Economics
    Manuals
    Market Trends
    News
    Nonprofit
    Online Bookkeeping
    Oregon
    Outsource
    Payroll
    Payroll Taxes
    Planning
    Procedures
    QuickBooks
    Record Keeping
    Recruiting
    Recruiting Market Reports
    Remote Workforce
    Reporting
    Restaurants
    Risk
    Sales Tax
    Scam
    Security
    Small Business
    Social Media
    Software
    Startup
    Statistics
    Strategy
    Taxes
    Technology
    Texas
    Time Management
    Washington State

    Archives:

    May 2025
    April 2025
    March 2025
    February 2025
    January 2025
    December 2024
    November 2024
    October 2024
    September 2024
    August 2024
    July 2024
    June 2024
    May 2024
    April 2024
    March 2024
    February 2024
    January 2024
    December 2023
    November 2023
    October 2023
    September 2023
    August 2023
    July 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    December 2022
    November 2022
    October 2022
    September 2022
    August 2022
    July 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    January 2022
    December 2021
    November 2021
    October 2021
    September 2021
    August 2021
    July 2021
    June 2021
    May 2021
    April 2021
    March 2021
    February 2021
    January 2021
    December 2020
    November 2020
    October 2020
    September 2020
    August 2020
    July 2020
    June 2020
    May 2020
    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    March 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    March 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    June 2015
    February 2013
    October 2012
    November 2011
    May 2011



    RSS Feed

Services

Accounting Services
Recruiting Services

​

Company

About
Oregon Team
​Washington Team
Colorado Team
​Texas Team
Clients


Support

Contact
CC
FAQ
​Resources
​Blog
​

ASP

Your resource for accounting & recruiting services. Serving Seattle, Bellevue, Redmond, Kirkland, Portland, Beaverton, Hillsboro, Lake Oswego, Denver, Lakewood, Aurora, Dallas, Frisco, Fort Worth, and more.
Contact us today for a free,
no-obligation consultation:
Toll Free (800) 931-6557
WA (425) 492-1901
OR (503) 473-0122
​CO (720) 572-8211
TX (214) 396-7403

[email protected]
© COPYRIGHT ASP - ALL RIGHTS RESERVED 
 A CFO Selections Company
Privacy Policy
Photos from Pricenfees, Debbieallendale