I need help in fixing unapplied payments expense

Hi,

Yes, it will create an additional expense if you create a bill for the same expense you created with a journal entry.   How did you create the original entries when you said you debited the expense and credit accounts payable?  Did you use a journal entry?

If you used a journal entry then yes you probably see the expense and unapplied payment when you run a cash basis profit & loss statement.

Try running the general ledger report and look at the accounts payable account.  If you see any unpaid a/p then you will probably need to use a journal entry to clear off since you did not enter these expenses as bills.

You should see the accounts payable zero out when you created the journal entry to debit the expense and credit a/p and then you debited the a/p and credited cash.  

Going forward, create bills instead of using journal entries so you can view outstanding bills in your A/P Aging Summary report.  When you pay the bill then use the bill payment feature.  

I’m thrilled to see you taking this exciting step of migrating to QuickBooks Online (QBO) from QuickBooks Desktop (QBDT), Gary. We know change can be overwhelming, but rest assured, we’re here to make the transition as seamless as possible for you.

As you move from QBDT to QBO, it's important to note that not all data gets converted, which could cause certain transactions to show unapplied payments. To understand what data doesn’t migrate, take a look at this article: Learn how features and data move from QuickBooks Desktop to QuickBooks Online.

To resolve the issue about the unapplied payments, I recommend opening the Profit and Loss report and look for the Unapplied Cash Bill Payment Expense section.

From there, select the total amount and take note of the vendor and the amount associated with each bill payment in the list.

Once done, create bills for the unapplied payments. Here's how:

1. In the left menu, click the + New button.
2. Choose Bill.
3. Fill out the details with the same vendor, amount, and date as the bill payment.
4. Select Save and close.

After that, choose Pay Bills from the + New button. If you see bills matching the bill payments in the list, select the checkboxes next to them, then Save.

When done, run your Profit and Loss report. The Unapplied Cash Bill Payment Expense account should now be removed.

Regarding your concern about double-charging the expense account, creating the bill will not charge the expense account twice. The expense was already recorded when you initially debited the expense account and credited accounts payable. Creating the bill will simply match the payment to the bill, clearing the unapplied payment without duplicating the expense.

Furthermore, we have a QuickBooks Live Expert Assisted service that assists users with their downloaded transactions, online banking challenges, and various accounting tasks. Our experts offer insights on best bookkeeping practices and using QuickBooks.

After your move to QuickBooks Online, you can find helpful resources here: Learn what to do after you move from QuickBooks Desktop to QuickBooks Online.

Should you require further assistance at any point, whether during this transition or in the future, I’m always here to help. You can connect with us by leaving a comment below.

Thank you, this contradicts the first reply that said entering a bill will charge the expense. I will do what you recommended with one transaction and I should see if it effects the profit and loss.

I did create the expense with a journal entry. We are a church so I wanted to match expenses to revenues. If we received a donation for a specified ministry I would record the corresponding expense in the same month with a journal entry. What I am doing now is creating an other current liability account instead of accounts payable for the liability.

Just one more question. Do I have to enter an account when creating the bill? I did do a search and the answer confirms what you said, it will not charge the expense account twice. If I have to enter and account do I create a dummy account or charge it to accounts payable instead of the expense.

Yes, Gary. You'll need to select an expense category when creating a bill. I'd be glad to explain further below.

It's necessary to select an expense account under the Category column, as this will be used to track your expense transactions. Conversely, when you make a payment on a bill, the accounts involved shift to your bank account and accounts payable. This difference helps ensure that there are no duplicate expenses.

On the other, to ensure which specific account to choose, I recommend seeking guidance from an accountant who can provide you with tailored advice and insights. If you don't have an accountant, I can help you find one. For more details, please visit this page: Find a QuickBooks ProAdvisor.

When recording corresponding expense transactions, we use journal entries only as a last resort. To avoid unapplied cash bill payment expenses, it's recommended to log your transactions using expense forms.

Moreover, you can close your previous fiscal year and prepare for the new one in QuickBooks: Year-end guide for QuickBooks Online.

If you need anything else or clarification about managing your expense transactions in QuickBooks, you can comment again on this thread. We're always there to assist you.

@garystepic 

"Since we pay our bills as soon as we get them, I have been avoiding using bills."

In the future, you can use an Expense (New > Expense) transaction instead of a journal entry or bill.  The Expense transaction in QBO serves the purpose of recording an expense and paying it at the same time.  QB Desktop doesn't have the Expense transaction.  Also, journal entries are a last resort type of entry because they don't show under the vendor account (unless the journal entry contains an A/P line) like they did in QB Desktop.    

"There are some cases where I would debit the expense and credit accounts payable for some vendors. When making the payment the cash account would get credited and the debit would be to the corresponding payable account. Evidently this causes problems."

I don't think that's what's causing the issue.  Journal entries aren't recognized by QB to post to "Unapplied Cash Bill Payment Expense" (UCBPE).   UCBPE should only show when you run a cash basis P&L and you have entries to A/P that use standard QBO forms (Bill Payments, Deposits, etc.) and the date on those entries precede the bill in which they should be applied/credited.  QB Desktop doesn't have UCBPE so you may have had these entries in QB Desktop, you just didn't see them because QB Desktop ignores those entries on the P&L.  IMO, this is an improvement over QB Desktop.  

A this point, you should be able to click on the UCBPE balance on your P&L and see what transactions are hitting that account.  You can then go through and change the dates on the payments/deposits/checks, etc. so they are dated the same as or later than the bills in which they apply.