Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi, I'm having trouble with a Y/E adjusting Journal entry that is sitting in my Pay bills. The entry was made in 2021 to adjust my accounts payable at Y/E to match actual and is not sitting as outstanding in my pay bills. If I clear this entry from pay bills with a created Credit of the same amount It will in essence reverse my adjusting entry and therefore make my accounts payable incorrect again.
I've also tried to create two new journal entries pulling the amount into an expense account and then pay off the adjusting entries in pay bills with the new entries. however this just created two new adjustment entries outstanding in my pay bills.
Is there a way that I can remove a Y/E adjusting entry from pay bills without unbalancing my Accounts payable?
Hello, @AHCSS.
It's great to see a new face within the Community! I can provide some information to help you get the answer you need to remove a Y/E adjusting entry from pay bills without unbalancing your Accounts Payable.
To receive the best answer, I recommend consulting with your accountant. They'll be able to give you the advice you need to take the next steps to resolve this issue.
Keep us updated on how the conversation goes with your accountant. We're always here to lend a helping hand. Take care!
That adjustment must have a vendor name connected to it.
Go to the Open Balance report of that vendor and you should see there what the adjustment was meant to balance out.
There would probably be an unapplied credit against the adjustment.
Then go to Pay Bills, select that adjustment, click Set Credits and the unapplied credit should be available to use.
Select it and save it by clicking Pay Selecting Bills.
Let me know if this helps.
- - - -
About OnTrack:
The only thing in that vendor is that Y/E adjustment. so there is no in and out only the one amount that puts it into accounts payable to make the adjustment. that is what makes it show up in pay bills to begin with. so when I select it in pay bills there are no credits to apply. (Sorry should have mentioned that there are no credits to apply in the OP)
As stated above I've tried putting a credit in and applying it but that affects my accounts payable balance and then the adjustment we made to A/P is useless anyway so there would have been no reason to even put it in to begin with. So i'm in a bit of a pickle.
What I need (If it's possible) is a way to remove the amounts from pay bills but keep my accounts payable the same.
Re: a way to remove the amounts from pay bills but keep my accounts payable the same.
This is obviously conflicting and cannot happen.
If an adjustment was made on a vendor having only this transaction, it was probably done to defer the overall AP balance for later and it would be expected to have the adjustment reversed in the following year.
If it was done by your accountant, all you can do is as @Candice C suggested to consult your accountant.
Do you owe the vendor the amount showing in A/P (Pay bills)? If not, then why was there an adjusting journal entry (AJE) made and assigned to that vendor? If you don't owe the vendor, then your A/P balance is not currently accurate and there shouldn't be an issue to offset that with a credit as suggested by @OnTrack Team. Let me know if I'm missing something.
I am having the same issue except my boss made an accrual entry in June to accrue the expense and then reversed the accrual in August with an exact opposite entry...so an equal debit and credit to AP but it is still showing as OPEN in the vendor file...AP balance is clear but vendor stills say amount in OPEN??? Like said above, any entry made will affect cash or AP again and they are both correct. Why shouldn't a debit and credit to AP in the same amount not just wash out? And he did apply the vendor name in both entries.
The payment was probably not linked to the expense transaction, @Betty.
Thank you for ensuring the transactions are under the correct accounts. It seems that some steps were overlooked that's why there's an open transaction.
There are a few ways to zero out the overdue balance of your vendor. You can use the Pay bill feature or create a check. However, if you're using a JE about the debit credit you've mentioned, you can also link it to the bill. I'll walk you through each process so you can decide which one you'd like to use.
For Pay Bill:
For Check:
I'm adding these articles about paying bills and handling vendor credits for your future reference:
You can run a report with vendor totals to view all the vendor payments. To modify it, refer to this guide: Customize reports in QuickBooks Online.
I hope this response finds you with a smile. I'm always here to provide help and answer any questions that you may have. Wishing you a lovely 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