Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I have taken over the operation of my dad's business since his death. I am working on cleaning up the Quickbooks Desktop and need some suggestions on an issue I have. Back on December 31 1999, he ran the Condense Data option (I guess) as I have a group of Journal Entries done with a memo or Transactions created by using the cleanup process.
One example of an issue I have is a piece of equipment that was purchased and financed by my mom, for what ever reason, though this loan was paid back to her, he did not remove it from the books. I need to find a way to zero out this item in the list. I cannot edit the transaction, as I get the warning "This transaction is a result of cleaning up past transactions"
If I do a normal journal entry with a credit and debit for the dollar amount, to the same account, it just washes itself out and still maintains the original balance. The item is listed in the chart of accounts as a long term liability, I just need to figure out a way to zero the dollar amount out. Not sure why it's not, unless he just paid my mother back out of his earnings and did not process payments to her through QB. My mom is listed as a vendor, but as far as I can see I cannot make a journal entry to her, and I would also think that would make her have an outstanding balance due to her.
Please do not suggest that I talk to our CPA, as we don't have one. I just need to know how to zero this thig out.
I'll help you clear the account cdhodgdon.
The option to delete data after condensing your file is unavailable in QuickBooks Desktop. It's the reason you've encountered an error.
After creating the journal entry, let's apply it to the loan payments to clear the amount. Here's how:
For more details about managing loans, please see this article: Manually Track Loans in QuickBooks Desktop.
If the issue persists, I'd recommend contacting our QuickBooks Support Team. They can provide additional solutions to fix this. Here's how:
Additionally, I've added these articles that'll help you ensure your record is accurate:
Please keep us posted if you have additional questions or concerns about linking the journal entry. We want to make sure your books are accurate.
Since I cannot pinpoint the exact date this loan was paid back, can I create a fake bank account and process that item through it and then deactivate the bank account? Looking at this process, I am not making any new journal entries, correct? The main thing is that 99.9% of the items in the books are right and I am just needing to clean up some items so they don't show up on reports when they should not be. Similar to the fact that your girl that handles QB's, when she reconciled the credit cards (all from the same bank, different employees), she only reconciled them from the main credit card account (on the chart of accounts) instead of clearing out each card individually, so on the balance sheet, it still shows that my dad has 5 credit cards with about $500,000 in outstanding balances, LOL.
I'm here to help you clear your credit card account, cdhodgdon.
You have to create a journal entry to resolve the balance before you inactivate the Credit card account. What you can do is create a clearing account to show where the payment is coming from. This way it will be posted as paid off by the owner.
Here's how to set up a clearing account:
Then, create a journal entry using the clearing account. I would also recommend consulting with a professional accountant to help you clear out or handle the amount accordingly to avoid messing up your books.
You can also visit this website: Reconcile Workflow. This provides more details about starting, fixing discrepancies, and completing the reconciliation process.
If there's anything else I can help you with or additional questions about the process of clearing transactions from your accounts, just let me know. I'd be more than happy to assist you further.
I may look at that for the credit card, was not as worried as I believe I really just need to go in and do a reconciliation on each individual card, but I will look into this.
My real question about setting up a clearing account (non-real bank account) was for working to clear the journal entries related to loans that were paid off (not sure why they are still in the file as showing owed), but the journal entires were created during a cleanup process, so I can directly modify them. See my original post and comments.
Ok, so I did your suggestion on clearing the old credit cards out, using a Journal Entry, but now, I have run into another issue. When I did it, the main credit card account now shows a -$778,035.75 for the account. I have attached a screen shot.
I most have missed something, somehow. Good thing is I backed up prior to making changes and I can either restore the backup or just delete the Journal Entries. Not sure what I did wrong or not. Thanks
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here