sales224
Level 2

Cleared journal entry.

I have a journal entry that is cleared  & reconciled against bank, but it keeps showing, "add to expense" If I add it, it is going to throw out my reconciliation report in May.   It would appear if I delete the expense, it will throw out May's reconciliation.  Any help or suggestions would be appreciated.

I do remember getting notice quite a few months ago about a glitch Quickbooks experienced which could throw out some expenses.  

Thank you!

ThomasJosephD
QuickBooks Team

Other Questions

I appreciate you bringing this to my attention and providing details about the glitches that could affect your transactions, sales224.

 

Based on your description and the attached image, the Journal entry (JE) you're referring to appears to be linked to Accounts Payable (A/P).

 

When A/P is impacted, such as with $49.71 credited to it. QuickBooks Online (QBO) may treat the transaction like an open balance payable to the supplier associated with the entry. This is likely why you’re seeing the Add to Expense message appear in the sidebar when creating an expense.

 

Since the JE has been cleared and reconciled against your bank statement, it’s important to handle this carefully to avoid disrupting your May reconciliation report.

 

First, confirm which accounts are affected by this JE. Clicking Open in the sidebar panel will allow you to view the full details of the JE. Look for the affected accounts; if one is A/P and the other is your bank account, this likely indicates a supplier refund tied to this transaction.
Openimg.png

 

Next, review the source of the $49.71 transaction by referring to your bank statement for more details. Then, check for any corresponding open supplier balances or credits using the Supplier Balance Detail report. To do this:

 

  1. Go to Reports in QBO and search for Supplier Balance Detail.
  2. Set the report’s date range to match the timeframe of the $49.71 transaction.
  3. Look for the supplier associated with the JE and confirm if there’s an open balance (e.g., a credit or payment of -$49.71) that matches the amount of the JE.

 

Once the supplier credit or payment is located, you can use the Pay Bills function to link it to the JE and close out the open balance in A/P. Navigate to Pay Bills, find the supplier, and select both the supplier credit/payment and the JE.

 

Applying the credit/payment to the JE will clear the outstanding balance, and the Add to Expense message will no longer appear in the sidebar.

 

If you see a prompt warning that you’re editing a reconciled transaction, don’t worry, this won’t disrupt your reconciliation report. The Pay Bills action will only resolve the payable balance and won’t affect the bank account that is already reconciled.

 

At this stage, it’s also important to check your records for duplicate entries, especially if the JE has an uncleared status. You can use the Transaction List by Supplier report, add the Cleared column to check the status, and confirm if the JE is a duplicate of another entry in your books. If it is a duplicate, you can consider deleting or voiding it to maintain accurate records and avoid future errors.

 

Although these steps should resolve the issue, I recommend consulting your accountant for additional guidance, especially since reconciled transactions require careful handling.

 

Let me know if you have any additional questions or concerns! I’d be happy to help.