Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I think I have followed these directions, however, I still have negative amounts on the A/R Aging originating from the JE i used to reduce the receivable. I did apply the journal entry to the invoice. These negative amounts create incorrect balance on my A/R. Where have I gone wrong?
Hi there, christyllew.
Entering journal entries to repair your books in QuickBooks Desktop (QBDT) isn't recommended since it may cause errors or unwanted problems in your books.
To make sure everything is accurate, I suggest consulting an accounting professional to help you analyze your entries and, if necessary, guide you in entering correct journal entries.
If you don't know where to find one, you can use this link: Find a QuickBooks ProAdvisor
I've also added this article to learn how you can resolve AR and AP balances on the cash basis Balance Sheet.
Let me know if you have other concerns or need further assistance with any QuickBooks-related tasks. I'll be checking your response in this thread. Enjoy your day and take care!
I had a similar issue and found a workaround. However, it may require that the period you are trying to correct is still open. If you have any bill with the vendor, you can try this:
1) unapply a payment applied to the bill. you should now have an open balance on the bill
2) go to the bill, and select "make payment"
3) rather than pick the payment to apply the bill, you should see the debit and credit entries as options. select the offsetting debit and credit entries and make a payment. Effectively you will be applying the debit to the credit. Since it should have net zero impact, your bill should remain open for the amount of the payment you unapplied in step 1
4) go back to the bill, and reapply the payment you unapplied in step 1. if done correctly you will no longer see the journal entries as options
Net impact from these steps should be zero, but you will now see the offsetting journal entries fall off the AP aging report
My JE does not show up as an available credit. Also my original balance was the result of a check we wrote as a loan to the customer, so I have made the JE go to "bad debt" against the receivable, so I don't really expect a credit to exist.
The customer has not been invoiced so maybe that's the issue? However, invoicing the customer will add to his debt, unless there's another way to do this?
Is there any way to clear for multiple jobs like batching? I have huge list of jobs that net to zero is clearing one by one my only option?
Hey there, @Fahim Ehsas.
Thanks for joining in on this thread.
The best route would be to clearing these one by one.
I'll send your feedback to our Product Developers so they can consider this in the near future.
I hope this helps answer your question. Take care!
for AP to clear offsetting JEs with no payment due, select new CHECK. Enter the supplier, date, etc.. The JEs should pop up. Add them. Save. The JE's are cleared.
In my case, the bill has already been paid. So I have a journal entry to accrued expense to move the expense to a prior period, and then a reversing entry in the next period. How do I clear these two entries that net to zero?
Alisa
Thanks for joining the Community and getting involved with this thread, Emunah_bookkeeper.
You can link your journal entries with their associated bills to clear them from A/R and A/P aging reports.
Here's how:
If you've already done this, but your journal entries continue showing on the A/R and A/P aging reports, you'll want to work with an accounting professional to identify why it's still showing on them.
In the event you're in need of one, there's an awesome tool on our website called Find a ProAdvisor. All ProAdvisors listed there are QuickBooks-certified and able to provide helpful insights for driving your business's success.
Here's how it works:
Once you've found an accountant, they can be contacted through their Send a message form:
You'll also be able to find many detailed resources about using QuickBooks in our help article archives.
If there's any additional questions, I'm just a post away. Have an awesome Wednesday!
did you every get an answer to this? I am having the same issue.
I've got you covered, tam. I'm here to help you clear transactions in your AR/AP Aging.
You'll need to link the Journal Entries to a bill or invoice to clear them out. For the AR, you'll need to use Receive Payment.
I'll show you how:
Finally, for AP, use Pay Bills. Here's an article for more info: Pay bills in QuickBooks Desktop.
I'm still ready to provide more information if you have questions or clarifications about clearing transactions in your Aging reports, tam. Comment below if you have one, and I'll be sure to get back to you. Take care!
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