Skip to main content
tmwilli
August 3, 2017
Solved

Removing old paid bills from Unpaid bills

  • August 3, 2017
  • 2 replies
  • 0 views

QBs Version: 2016 Desktop

Discovered old bookeeper entered memorized bills for many venders but paid them manual check. Is there a way to remove old (unpaid) bills "en masse"?

 

And, if not in within the prrgram itself, is there a 3rd party tool to do this?

    Best answer by qbteachmt

    "The user can delete or void a single bill as needed"

     

    Can and Should are completely different concepts.

     

    If you filed taxes on the year in question on Accrual Basis, everything is Double-entered and double-reported. If you filed on Cash Basis, but what is entered on Bills hits another balance sheet account, they Still Show, as well, so Checksfor what also is on a bill = Double-data entered. That's why you don't Void or delete a historic period.

     

    Even offseting with Current dates might not the right way to do it. Example: If this is only the previous year or two, your CPA can help you determine if fixing the data for its original date is proper, because your entity will file Amended Returns.

     

    And even if this in not a Tax issue, if that affected, as one example, Inventory, then it is likely someone made correcting or offsetting entries such as Adjusting inventory because, oh, look! We seem to show Twice as much stuff as we ever bought.

     

    Any transaction can be Void or Deleted or Offset. Knowing which is the Right Task to do ineach case, isn't something anyone can answer without being able to see the info and be involved in what else it affects.

     

    Auditors use a term: Material, as in, "Is it a large enough mistake to be Material to the financial reporting as that is, now?"

    2 replies

    lynda11_2
    August 3, 2017

    I would make vendor credit memos dated in the current fiscal period and apply them to clear the old bills.  Make the clearing entry in the current fiscal period too.

    tmwilli
    tmwilliAuthor
    August 3, 2017
    Why would you not just delete the bills? The user can delete or void a single bill as needed. Just wanted to know if QBs desktop has a mass void or delete option like QBO does. Or, if this is not a native feature, is there a 3rd party add-on that will do it.
    lynda11_2
    August 3, 2017

    Because they are from a prior period and you probably have produced a tax return on it. 

    qbteachmt
    qbteachmtAnswer
    August 4, 2017

    "The user can delete or void a single bill as needed"

     

    Can and Should are completely different concepts.

     

    If you filed taxes on the year in question on Accrual Basis, everything is Double-entered and double-reported. If you filed on Cash Basis, but what is entered on Bills hits another balance sheet account, they Still Show, as well, so Checksfor what also is on a bill = Double-data entered. That's why you don't Void or delete a historic period.

     

    Even offseting with Current dates might not the right way to do it. Example: If this is only the previous year or two, your CPA can help you determine if fixing the data for its original date is proper, because your entity will file Amended Returns.

     

    And even if this in not a Tax issue, if that affected, as one example, Inventory, then it is likely someone made correcting or offsetting entries such as Adjusting inventory because, oh, look! We seem to show Twice as much stuff as we ever bought.

     

    Any transaction can be Void or Deleted or Offset. Knowing which is the Right Task to do ineach case, isn't something anyone can answer without being able to see the info and be involved in what else it affects.

     

    Auditors use a term: Material, as in, "Is it a large enough mistake to be Material to the financial reporting as that is, now?"

    tmwilli
    tmwilliAuthor
    August 4, 2017
    Thank you both for your instructions on best practice for deleting QBS transactions. I also am quite familiar with the best practices when using QBs. Been a ProAdvisor for some time now.

    But, my question was a simple one: Is there a way to remove multiple bills from a company file like QBO does? And, neither of you are aware of an option.

    Question answered.

    Thanks for your response on this is matter.
    August 4, 2017

    Hi TmwIllI,

     

    With respect to Lynda and QBTeach who provided great advice, if you are using QuickBooks Desktop Accountant, go to the Accountant menu then click Batch Delete/Void Transactions. I believe that tool started in the 2016 version of QuickBooks Desktop Accountant.  

     

    https://community.intuit.com/articles/1501536-use-the-batch-delete-void-transaction-bdt-utility