How do I clear up old stuff on my A/P aging detail?

Hello there, @wreade78.

I'll ensure to provide information on how you can clear old bills in your Accounts Payable aging detail report in QuickBooks effectively.

Based on the screenshot provided, it seems that you've already created offsetting entries on your report. We can clear your accounts payable by linking those entries to the outstanding transactions and the existing credits. Also, you can take advantage of the Pay Bills feature. See this article for guidance: Enter and manage bills and bill payments in QuickBooks Online.

For future reference tracking your expenses in QBO, you can check out these articles:

• Enter and manage expenses in QuickBooks Online
• Expenses and vendors in QuickBooks

Tag me in the comment below if you have additional queries in managing expenses and other QuickBooks concerns. I'm always here to help you.

@GebelAlainaM Thanks for your message! Unfortunately, I don't understand.

Can you give me specific instructions of what I need to do? For example, how do I clear the deposit dated 12/2/2019 from the the A/P aging detail report?

Thanks!

Hello there, @wreade78.

I'd be glad to help you clear your old transactions from your Accounts Payable aging detail report in QuickBooks Online (QBO).

I can see that you have offsetting journal entries on your report. To resolve this and clear your accounts payable, you can record a bill payment or an expense and then link the outstanding transaction with the existing credit.

Here's how:

1. Go to the +New icon.
2. Click on Expense or Pay Bills.
3. For Pay Bills
   1. Set your Payment account, then enter the date and other details.
   2. Locate the pending transaction, then apply the existing credit.
   3. Save the transaction and ensure that the Total Payment Amount is zero (0.00).
4. For Expense
   1. Select the vendor name under Payee.
   2. Add the debit and credit transactions from the Add to Expense section.
   3. Review the details, then click on Save and Close.

For reference, you can check these articles in tracking bills and expenses in QBO:

• Enter and manage bills and bill payments in QuickBooks Online
• Enter and manage expenses in QuickBooks Online

Aside from that, you can run through the resources from these articles for more resources while managing your other vendor entries in the future: Expenses and vendors.

Please let me know if you have any further questions or need additional help with recording a bill payment. I'm always here to assist you. Have a great day!

@wreade78 

 @GebelAlainaM  and @Clark_B can't possibly tell from your screenshot that there are offsetting entries.  There may be, but there's not enough info on your screenshot to know that. 

If you have positive and negative amounts with the same vendor, you can clear them by going to pay bills and applying the "credits" to the "bills". 

It would help a lot if you could include the amounts of the entries from your screenshot.  You clear bill payments by having a bill to apply them to.  You generally clear the deposits by creating a credit memo or a journal entry that debits A/P.  It's not possible to tell from your screenshot how to clear the journal entries because it depends on whether the A/P amount is positive or negative.  Positive amounts require a reduction in A/P (bill payment or journal entry that debits A/P, and other ways) and negative A/P amounts require an increase in A/P (bill, journal entry that credits A/P, and other ways).  If you can provide more info (details of each entry), I can try and assist further.       

@Rainflurry Thanks for your message. Here's a screenshot showing more info. Note: None of these are appearing in my "pay bills." Thanks!

@Rainflurry Thanks for the info!

I "paid" the four "bills" that are deposits in that report by applying the vendor credits in that report using the pay bills feature. Those deposits are no longer appearing on my A/P aging detail report but the vendor credits are still there. Why do you think that is?

@Rainflurry Never mind. I figured it out. When I used the pay bills feature, there were other credits for the vendor that were being applied before the vendor credits you see in this report. I had to create a bill that handled all the vendor credits. All those transactions are now gone. Thanks for your help!

@wreade78 

Happy to help.  Glad it worked.  

Hello Rainflurry,

Thank you for sharing your input to help address the issue. We love to see members supporting one another! Have a great day.