[kdawg22]

Have a bunch of old invoices and bills sitting in the AR & AP. Journal Entries were posted in prior years to correct the YE balance. The current AR aging is over 100 pages long and only 5-10 pages of it is current stuff. All the other pages are old invoices and credits that are still sitting in the AR some going back to 1995! (same thing for AP just not as long)

What would be the easiest way to clean up all the old invoices/credits/bills. I feel like it would take a lot of time to issue credit memos for the old open invoices and then reverse out the previously booked journal entries.

I was thinking it might pay just to wait until 1/1/19 and start a new quickbooks company file and post a JE for the beginning balances.

[Anonymous]

Yeah, I’ve been a QB user for 10 years, and there’s no easy fix. All those invoices and bills have to be manually closed by applying a payment/credit/JE. Your best bet is a new company file, and I’d make copies so you can easily revert if needed.

[Anonymous]

Oh, you could also filter the date range on the aging report to show only current items. And then clean up any outliers that pass through. Kinda hacky but would require the least amount of effort imo.

[Anonymous]

Starting a new file is always an option.

[kdawg22]

That is what i figured I just wanted to make sure I wasn't missing anything and I will make sure to have a backup copy. Thanks for the replies!

[Anonymous]

Again, just editing the aging report to show the correct info would be way less hassle than starting a new company file. Not sure how proficient you are in QB, but there’s a Memorize Reports function that lets you save and recall them in one click.

[Author]

Replies