cancel
Showing results for 
Search instead for 
Did you mean: 
christyllew
Level 2

How to clear transactions in AR Aging/AP Aging that net to zero.

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?

Archie_B
QuickBooks Team

How to clear transactions in AR Aging/AP Aging that net to zero.

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!

caramel_accounting
Level 1

How to clear transactions in AR Aging/AP Aging that net to zero.

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

Dub1
Level 1

How to clear transactions in AR Aging/AP Aging that net to zero.

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?

Fahim Ehsas
Level 1

How to clear transactions in AR Aging/AP Aging that net to zero.

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? 

Candice C
QuickBooks Team

How to clear transactions in AR Aging/AP Aging that net to zero.

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! 

ldr514
Level 2

How to clear transactions in AR Aging/AP Aging that net to zero.

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.

Emunah_bookkeeper
Level 1

How to clear transactions in AR Aging/AP Aging that net to zero.

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

Emunah_bookkeeper
Level 1

How to clear transactions in AR Aging/AP Aging that net to zero.

I have the same issue.  No outstanding bill to pay.  Want to clear the outstanding journal entries that net to zero.

 

 

ZackE
Moderator

How to clear transactions in AR Aging/AP Aging that net to zero.

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:
 

  1. In the top menu bar, go to Vendors, then Pay Bills.
  2. From your displayed window, find the open bill you want to apply your credit to and tick its box to choose it.
  3. Use the Set Credits button.
  4. On your Credits tab, specify the credit, then click Done.
  5. Select Pay Selected Bills.

 

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:

 

  1. Go to our Find a ProAdvisor page.
  2. Use the City or ZIP search field to specify a location.
  3. Select Find a ProAdvisor.
  4. Browse through your results and find one that works best for the business. You can click on each ProAdvisor's profile to learn more information about them.

 

Once you've found an accountant, they can be contacted through their Send a message form:
 

  1. Use the available text box to introduce yourself. Be sure to include details about which services you're looking for.


     
  2. Enter your appropriate info in the Your nameYour email, and Your phone number (optional) fields.


     
  3. Hit Send message.

 

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!

tamguelfo
Level 1

How to clear transactions in AR Aging/AP Aging that net to zero.

did you every get an answer to this?  I am having the same issue.

Erika_K
QuickBooks Team

How to clear transactions in AR Aging/AP Aging that net to zero.

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: 

 

  1. Locate the Customer menu, choose Receive Payments, and select the customer.
  2. Click in the Payment column for the General Journal which will appear in the table.
  3. Select Discounts & Credits, then you'll see the other General Journal there. Double-check that the Amount to Use is correct.
  4. Choose Done.
  5. Then, hit Save & Close

 

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!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us