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?

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!

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

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. 

I did try that before replying however there is no option there.  When I go into chart of accounts, click view register for accounts payable, then click the gear the only option I get under Columns is "Open Balance."  There is "other" but it is only "show in one line" and "paper ledger mode"

Thanks for getting back here, Steve.

The option I shared above is only available for bank or credit card registers. This is the reason why you can't see the Reconcile Status column in the receivable and payable accounts.

To change the status, go to the register of the bank that you're trying to reconcile. Then, look for the transactions and proceed to the Reconcile Status column. 

Let me share these steps again so you can the status back to R:

1. Look for the bank or credit card account in your chart of accounts.
2. Select View register under the Action column..
3. Click the small Gear icon in the upper-right hand corner, then check the box for Reconcile Status. 

Please reply to me again if you're able to remove the old transactions when doing your reconciliation. We'd want to make sure everything is sorted out. 

Can I just delete these Accounts Payable manual entries?  They should already be recorded because there is a COGS associated as well as receiving the proceeds from the customer

Can I delete the transactions I created (remember they are already in other transactions and reconciled) incognito and see if that works?

Thanks for getting back to us, @Steve. I'll outline a couple of handy details to help you out with managing your transactions in QuickBooks Online.

With regards to deleting those Accounts Payable manual entries, we can delete them from your register. Please know that these bills aren't shown when reconciled. To delete those, I'll show you how:

1. Go to the Accounting menu.
2. From the Accounts Payable, click View register.
3. Choose a bill that you'll want to delete.
4. From the Bill window, tick More and choose Delete.
5. Click Yes to confirm.

Then, repeat the process to the other AP entries you'll want to delete.

However, it would be best to seek professional advice from your accountant to ensure the accuracy of your books when deleting transactions. If you're not affiliated with one, you can utilize our Find an Accountant tool to look for one in your area.

Furthermore, I'll be adding these articles for your reference. This will provide you the steps on how to edit and add transactions from the register as well as remove transactions from reconciliations:

• Find, review, and edit transactions in account registers
• Undo or remove transactions from reconciliations in QuickBooks Online
• Add transactions to account registers in QuickBooks Online

Keep me posted if you need more banking help in QuickBooks Online. I'll be glad to help you further. Keep safe always!

When I deleted the first transaction I went to see if there were any changes to the reconciliation.  It is now saying my account is not ready to reconcile because it is off the amount I deleted.  I have attached on of the entries that I am trying to delete.  All these small amount transactions are from a bill from one of my manufacturers

Thanks for checking back with us, @Steve. 

Since you see a message that your account is not ready to reconcile because of the amount you deleted, I recommend consulting with your accounting professional. This way, your accountant can review your books and provide the right steps based on your business needs to get your books in order. 

If you don't have an accountant, don't sweat it. You can find one here in our Resource Center. 

Let me know if you have any questions or concerns. Take care!