Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowI am having a problem with one of my vendor records. Here are the steps:
My T accounts show that the accounting is correct. There is no open amount on the AP aging. However, the vendor record shows a negative amount paid of 2x the amount and there is $5000 sitting in Unapplied Cash Bill Payment expense a year end even though all transactions were processed by 12/31/18.
Can anyone help me resolve this problem? Thank you!!
Hi @VFAKathy,
The process that you performed to track your vendor bills and credit is correct.
The bank deposit to the vendor has a negative effect because it is a reduction to the expense. This is why the total that shows under the Transaction List calculates differently than the report.
You can open your Expense by Vendor Summary Report to show the actual totals.
Here’s how:
Please feel free to read these articles for further information about unapplied cash payments:
What's Unapplied Cash Payment?
What To Do If You See Unapplied Cash Bill Payment Expense On Your Profit And Loss
Don’t hesitate to post again if you have other concerns. More success to your business!
@VFAKathy
It is strange that the deposit shows as a negative, but the open amount at the top is zero so the accounting is right.
You get an Unapplied Cash Bill Payment Expense on a cash-basis P&L when there is an unapplied Bill Payment as of the P&L date, which is not the case in the screen shot.
Are you referring to a cash-basis P&L at year-end when you say "there is $5000 sitting in Unapplied Cash Bill Payment expense a year end" ?
If so, what do you see when you double-click the amount?
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.