Expenses not on reconciliation screen after entering them on the expense tab

Qualityb1 · ‎December 27, 2021

Expenses from the credit card account are always entered in the expense tab however, when I go to reconcile the credit card account, the expenses are not there and I have to upload a .csv file. The bank does not download the expenses to quickbooks online. It only download payments made to the credit card account. After I upload the file and go to reconciling, there are now duplicate expense transactions.

Charies_M · ‎December 27, 2021

I can help you handle duplicate transactions on the reconciliation page, Qualityb1.

There is a possibility that downloaded transactions from the Bank Feed were manually added instead of matching them to existing ones. This can cause duplicate. You can also check this article for your future reference about adding and matching downloaded banking transactions: Add and match downloaded banking transactions.

To fix this, you'll need to delete the Cleared (C) transaction if it is a duplicate of the Reconciled (R) one.

Here's how:

Click Accounting on the left menu and select the Chart of Accounts tab.
Look for the bank account and click View register.
Select the Cleared (C) transfer transaction.
Click Delete and choose Yes to confirm the action.

Feel free to read through this article for the entire process on how to undo reconciliation: How to Unreconcile a Transaction or Undo a Reconciliation.

Another option is to consult your accountant and request to undo the reconciliation. They use a specific tool to batch undo the transactions on your account. If you don't have one, you can use the Find a Pro-Advisor tool to look for an accountant near your area.

In case you'd like to work on reconciling your account, you can visit the following articles:

You may also want to pull up a reconciliation report to have a summary of your beginning and ending balances and lists of cleared and uncleared transactions in QBO.

Reach out to me with whatever questions you may have about reconciling or anything QuickBooks. I’m always here to assist you further.

View solution in original post

Charies_M · ‎December 27, 2021

I can help you handle duplicate transactions on the reconciliation page, Qualityb1.

There is a possibility that downloaded transactions from the Bank Feed were manually added instead of matching them to existing ones. This can cause duplicate. You can also check this article for your future reference about adding and matching downloaded banking transactions: Add and match downloaded banking transactions.

To fix this, you'll need to delete the Cleared (C) transaction if it is a duplicate of the Reconciled (R) one.

Here's how:

Click Accounting on the left menu and select the Chart of Accounts tab.
Look for the bank account and click View register.
Select the Cleared (C) transfer transaction.
Click Delete and choose Yes to confirm the action.

Feel free to read through this article for the entire process on how to undo reconciliation: How to Unreconcile a Transaction or Undo a Reconciliation.

Another option is to consult your accountant and request to undo the reconciliation. They use a specific tool to batch undo the transactions on your account. If you don't have one, you can use the Find a Pro-Advisor tool to look for an accountant near your area.

In case you'd like to work on reconciling your account, you can visit the following articles:

You may also want to pull up a reconciliation report to have a summary of your beginning and ending balances and lists of cleared and uncleared transactions in QBO.

Reach out to me with whatever questions you may have about reconciling or anything QuickBooks. I’m always here to assist you further.

Qualityb1 · ‎December 27, 2021

Should the expenses on the credit card statement be added on the expense tab or upload them?

AileneA · ‎December 27, 2021

I have all the detailed steps in adding expenses, Qualityb1.

Here's how:

Click the New (+) icon to bring up the transaction menu page. Under the category for Vendors, select Expense.
You will now see the Expense Window. Select a Payee for the expense. If it’s a new payee, you can enter their name in the field and click Add.
Next step is to choose the account the money for this expense came from.
Next, enter the Payment date.
After entering the date, enter the Payment method for this expense.
Choose a category for this expense. Under Category, choose the account category from the chart of accounts. If it’s a new category of expense, you can always type in the name of the category in the Account field and click Add new.
To be more detailed with your purchase, you can add more information in the Description.
You can also add notes in the Memo field for additional information. If you need to add more details regarding the expense.
Enter the amount of the expense in the Amount field.
Once you entered all the needed information in the field, Click Save and New to save this expense and start another one, or Save and Close if you’re done creating expenses.

You can also check out our guide on entering, editing, or deleting expenses in QuickBooks Online for your convenience.

Don’t hesitate to leave a message below if you need further assistance with your expense. We’ll be here anytime to help you out. Always take care!

Topics

Training

Community

Resources

Expenses not on reconciliation screen after entering them on the expense tab