cancel
Showing results for 
Search instead for 
Did you mean: 
ccrownoble
Level 1

Reconciliation issues - Deleted transactions were recreated and marked "R" but are still showing as deleted

We had a bank account set up for a loan, but it was decided to create a long term liabilities account instead and unsync the bank account. This cause some issues with reconciliation for the checking account where several transactions were taking place from the loan to the checking. I recreated all of the transactions from 2020 using the new long term liability chart of accounts. I manually clicked "R" on those transactions however only some of them show up in the "we can help you fix it" as reconciled in register. 19 of them are still showing up as Deleted. I don't know if perhaps recreating these transactions with the new account number is causing issues or how to resolve this so we can get our reconciliation back on track. I found one solution to go back in and reconcile the deleted transactions that were re-entered, but since my beginning balance is off, nothing is letting me close out so now I have April open but can't get it to zero. 

 

Any help is greatly appreciated as we are trying to close out 2020. 

3 Comments 3
katherinejoyceO
QuickBooks Team

Reconciliation issues - Deleted transactions were recreated and marked "R" but are still showing as deleted

Hi there, @ccrownoble.

 

Thanks for visiting the Community today. I'm here to help ensure you're able to reconcile your account with QuickBooks. 

 

You're right, recreating those deleted transactions with the new account number has caused this issue. I'd suggest you recreate the transactions under the same account where it was previously reconciled.

 

Then, mark the transactions in both registers as reconciled since they were originally reconciled before. This step will fix the beginning balances of those accounts when you reconcile. Here's how:

 

  1. After recreating the transaction, click Accounting on the left menu.
  2. Go to the Chart of Accounts tab.
  3. Click View register and look for the recreated transaction.
  4. Under the Reconcile () column, click on the blank field to mark the transactions as reconciled (R).
  5. Click Save and select Yes to confirm the action.

 

 

Here are some articles that can guide you more on how to resolve reconciliation discrepancies: 

 

 

For future reference, read through this article to know more about closing your books in QuickBooks Online

 

Feel free to message again if you have additional concerns about reconciliation. I'm always around here to attend to your needs. 

 

pennymisale
Level 2

Reconciliation issues - Deleted transactions were recreated and marked "R" but are still showing as deleted

Thank you, that account has been made inactive. Is there any other way to resolve this since we want those transactions under a different account? Could we use that account number, but change that account where it was prior reconciled to a long term liability instead of a "bank" account? 

katherinejoyceO
QuickBooks Team

Reconciliation issues - Deleted transactions were recreated and marked "R" but are still showing as deleted

Thanks for coming back for more support, @pennymisale. In this case, you'll need to enter the transactions by creating a journal entry. This is to let you move the transactions between accounts and force your books to balance. 

 

Here's how: 

 

  1. Go to the+ New menu, then select Journal entry.
  2. On the first line, select an account from the Account field. Depending on if you need to debit or credit the account, enter the amount in the correct column.
  3. On the second line, select the other account you're moving money to or from. Depending on if you entered a debit or credit on the first line, enter the same amount in the opposite column.
  4. Check the amounts - you should have the same amount in the Credit column on one line and the Debit column on the other. to make sure that the accounts are in balance.
  5. Enter information in the memo section so you know why you made the journal entry, then select Save and close.

 

For proper posting of your transactions, I highly recommend consulting your accountant. This is to make sure that your books are accurate. If you can't find one, you'll want to find an expert through this link: https://quickbooks.intuit.com/find-an-accountant/

 

Feel free to message again if you have follow-up questions about this issue. I'd be delighted to get back and help you further. 

 

 

 

Need to get in touch?

Contact us