Skip to main content
S
solocaptan
March 4, 2023
Question

Already previoulsy reconciled transaction showing

  • March 4, 2023
  • 1 reply
  • 0 views

Hi all,

 

Hoping to connect with somebody that might have encounter similar error we are encounter and hopefully find a solution, before I am embarked with calling QB and spend hours on the phone with someone that might know less than I do from QB. Unfortunately, we have always had issues with bank reconciliation with QB.

Our problem is in the bank reconciliation screen appears a few transaction from previous years. Specifically employees checks done manually via a Payroll YTD adjustment due to some problem with the checks on QB. I can't remember why it has this adjustments. Probably an issue with Payroll. We used Quickbooks payroll.

Now the problem is the beginning balance is correct on the account, reason why discrepancy report is 0 and can not do a mini reconciliation to fix this because the beginning balance is correct. I am very disappointment with QB Enterprise, don't know why they don't have a feature like online that you could marked it as reconciled and be done. It should be as Quick books Online. I have the most expensive QB out there and some things are better ONLINE does not make any sense.

 

I would appreciate any help I can get.

 

1 reply

C
ChristineJoieR
March 4, 2023

There might be possible data damage happening, @solocaptan. I'll help you fix beginning balances issues in QuickBooks Desktop.

 

The Starting Balance is zero or inaccurate when you start the reconciliation process and choose an account to reconcile. It results in one of the following:

 

  • The account balance setup is incorrect.
  • Transactions previously cleared and reconciled were destroyed or altered.
  • You changed the file from a different QuickBooks version.
  • Possible loss of data.

 

You can re-create the opening balance if it's your first time reconciling the account. Then, make a journal entry to correct the beginning balance. Make a note in your journal. On the Begin Reconciliation window, enter the precise date.

 

  1. Go to Company, and then select Make General Journal Entries.
  2. Change the date to the correct statement date of your beginning balance.
  3. Select the account you want from the Account drop-down.
  4. Enter the opening balance in the Debit column.
  5. Select Opening Balance Equity and then select Save.

 

 Reconcile to correct the Beginning Balance

 

  1. Go to Banking, and then select Reconcile.
  2. Select the account you want from the Account drop-down.
  3. Enter the statement date and ending balance that matches your Journal Entry.
  4. Select Continue.
  5. In Deposits and Other Credits, select the Journal Entry.
  6. Note: The amount shown for the Difference should now be zero.
  7. Select Reconcile Now.

 

You can also run a Reconciliation Discrepancy to see a list of changed transactions since your last reconciliation. Use this report to identify the transaction(s) causing the issue.

 

You run the Audit Trail report for a specific transaction. You can customize and filter the data to locate the invoices.

Here's how:

 

  1. Click Reports at the top menu bar and choose Account & Taxes.
  2. Select Audit Trail.
  3. On the report screen, click Customize Report.
  4. Go to the Filter tab and search for the Transaction type.
  5. Choose Invoice and hit OK.

 

This article can guide you in generating reports in your QBDT to show the details you need: Customize reports in QuickBooks Desktop.

 

You can contact us again if you have any more queries or worries. I'd be happy to assist you and find a quick solution. Enjoy your day.

S
solocaptanAuthor
March 4, 2023

Christine,

 

Thanks for the reply. First problem, no data damage. Is checked regularly with file doctor and when doing backup. no conversion of any kind.

This account was reconciled reason why beginning balance is correct. Moreover discrepancy reports shown 0.

No solution here.

This is a problem with QB should not have beginning balance correct so this transactions could be marked as reconciled.

C
ChristieAnn 11
March 4, 2023

I appreciate you for coming back to the thread and adding extra clarifications about your concern, solocaptan. I'll be sharing the possible cause of why there are reconciled entries that keep appearing in your reconciliation and how you can fix it by following the steps below.

 

Since the beginning balance is correct and discrepancy reports show 0 but the reconciliation screen still shows entries from previous years, it could be there's a duplicate transaction on your books. That said, you can delete the following transactions and make sure they are not linked to the other data to avoid errors in your bank transactions. 

 

Here's how to delete entry:

 

  1. Go to the Lists menu at the top to get to the Chart of Accounts.
  2. Select the account where the transactions are posted to open the register. 
  3. Right-click on the transaction, then choose Delete.

 

If you're using the accountant version, you can check out this article to see steps on how to perform the process by bulk: Batch delete or void transactions in QuickBooks Desktop Accountant Edition.

 

Lastly, you may refer to this article to view different guidelines that can help fix any reconciliation issues: Learn the reconcile workflow in QuickBooks.

 

Please add a comment below if you require further assistance with reconciling your account. I'm always determined to find a solution, solocaptan. Have a nice day!

Terms & ConditionsAccessibility statement