Skip to main content
September 5, 2022
Question

I have Bill Payment transactions that I created back in 2019 that are now showing up when I go to reconcile. How can I clear these out?

  • September 5, 2022
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

September 6, 2022

Look no further, @steve-orlando. I’ll help you clear these out.


The closest reason why your 2019 bill payments show up when you reconcile is that they were accidentally unreconciled or caused by browser issues.


You’ll want to make sure the transactions are marked as Reconciled (R) on your register. This way, payments won't show up on the next succeeding month's reconciliation. I’m glad to show you the steps:

 

  1. Go to the Gear icon and click Chart of accounts.
  2. Select the account where entries are posted, then select View register.
  3. Click the Filter icon to narrow down the results. You can select Bill payments as the Transaction Type.
  4. Locate the entries.
  5. In the Status (Checkmark) column, please ensure they’re reconciled. If not, repeatedly click the box until you'll see the "R.”
  6. Select Save after.


On the other hand, if these bill payments are cleared and happen to display just now when you reconcile your account, we can perform some troubleshooting steps to rectify this.


First, access your QuickBooks Online account in an incognito or private window for testing. Here are the keyboard shortcuts you can use:

 

  • Press keys: Ctrl + Shift + N (Google Chrome browser)
  • Press keys: Ctrl + Shift + P (Mozilla Firefox browser & Microsoft Edge)
  • Press keys: Command + Shift + N (Safari browser)

 

Once logged in, try to reconcile your account and check if the payments are still showing up. If you no longer see them, get back to your regular browser and clear its cache. Doing this helps the program to run better. You can also use other supported browsers as an alternative.

 

I've added this expenses and vendors guide to get more insights about managing all your vendor events. It provides you bookkeeping practices to ensure everything is accounted for and accurate.

 

And if you need tips to customize your accounts, you can also visit this reference: How to organize your chart of accounts. This will allow you to quickly determine your financial health so you can make better arrangements moving forward.

 

 I’ll be here to help if you need further assistance with managing your vendor transactions. Just add them to your reply below. Keep safe always!

September 6, 2022

Thank you Madelyn for reaching out.  I believe I had manually entered the Accounts Payable, Accounts Receivable and Credit Card for these transactions.  The Accounts Payable came from a bill for COGS, the Accounts Receivable were from the transaction for selling the item and the credit card processor (Square).  

 

When I first try Accounts Payable and filter there is no "status' column.  Accounts Receivable only shows one of the transactions having any letter and that is a C.  And then nothing for Credit Card either.  

 

When I look into the A/P register I see 2 transactions for each amount zeroing each other out.

 

I appreciate any help!

 

Steve

JenoP
September 6, 2022

I appreciate the additional details. Allow me to help you remove the transactions in the reconciliation window, Steve.

 

Please note that you can only reconcile bank and credit card accounts in QBO. Because of this the Reconcile status columns can only be found in those type of registers.

 

Instead of opening the A/R and A/P accounts , you can go back to the bank register and add the column so you can change the status of the transactions. Here's how:

 

  1. Open your Chart of Accounts and look for the bank or credit card account.
  2. Select View register.
  3. Click the small Gear icon in the upper-right hand corner, then check the box for Reconcile Status

 

Once done, look for a column with a checkmark on its header. Then, manually change the status to R by following the steps in the previous response. 

 

 

You can also take a look at this article for more details: Undo or Remove Transactions From Reconciliations in QuickBooks Online.

 

Let me know if you're able to clear the transactions on the reconciliation page. The Community is always here if you need anything else.