Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello! I have some old transactions (e.g., deposits, journal entries) on my A/P aging detail report. How do I remove those? See the attached screenshot for examples.
Thanks!
Solved! Go to Solution.
When you go to Pay bills, click on 'Filter' and select 'All dates'. QBO defaults to only showing bills from the last 365 days and all of these are older than that. You have 4 transactions that have matching "bills" and credits so they should be able to be cleared against each other:
$113.95
$3.95
$35.00
$18.60
That leaves 2 "bills":
Deposit $24.00 and Journal Entry $220.45 = $244.45
And, 5 credits:
Bill Payment ($227.90), Bill Payment ($77.90), Journal Entry ($135.00), Bill Payment ($37.20), and Vendor Credit ($13.69) = ($491.69)
You will need to look at each one and figure out what account needs to be offset with A/P to clear it. For example, you have a $24.00 deposit that was posted to A/P. If the deposit was reconciled, then you need to determine if you still owe the vendor $24.00. If you don't, then create a $24.00 vendor credit and select the appropriate Category. If you don't know what Category to select, ask the company accountant/CPA if necessary. The Bill payments are caused by overpayments. You reverse those with a bill. The Category is generally an expense account but, again, you need to determine that. After you have entered the offsetting bills and credits, don't forget to clear them against each other by going to Pay bills.
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:
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:
For reference, you can check these articles in tracking bills and expenses in QBO:
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!
@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!
When you go to Pay bills, click on 'Filter' and select 'All dates'. QBO defaults to only showing bills from the last 365 days and all of these are older than that. You have 4 transactions that have matching "bills" and credits so they should be able to be cleared against each other:
$113.95
$3.95
$35.00
$18.60
That leaves 2 "bills":
Deposit $24.00 and Journal Entry $220.45 = $244.45
And, 5 credits:
Bill Payment ($227.90), Bill Payment ($77.90), Journal Entry ($135.00), Bill Payment ($37.20), and Vendor Credit ($13.69) = ($491.69)
You will need to look at each one and figure out what account needs to be offset with A/P to clear it. For example, you have a $24.00 deposit that was posted to A/P. If the deposit was reconciled, then you need to determine if you still owe the vendor $24.00. If you don't, then create a $24.00 vendor credit and select the appropriate Category. If you don't know what Category to select, ask the company accountant/CPA if necessary. The Bill payments are caused by overpayments. You reverse those with a bill. The Category is generally an expense account but, again, you need to determine that. After you have entered the offsetting bills and credits, don't forget to clear them against each other by going to Pay bills.
@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!
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.
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