cancel
Showing results for 
Search instead for 
Did you mean: 
EL34
Level 4

How to reconcile after condensing company file?

I condensed a 13 year old company file at the end of 2019

I now have December 2019 bank statement in hand

But I cannot reconcile because all the transactions are gone because of the consensing

How can I reconcile December 2019?

8 Comments 8
Emily M
QuickBooks Team

How to reconcile after condensing company file?

Hello, @EL34.

 

It’s my priority that you’re able to reconcile your account. You’ll need to review the Reconciliation Discrepancy account for inappropriate adjustments. 

 

Let me guide you on how to fix the issues with reconciling: 

 

Step 1:

Review your opening and beginning balances.

 

Step 2:

Look for changed, deleted or added transactions.

Run a Reconciliation Discrepancy Report; this report shows any transactions that were changed since your last reconciliation.

 

  1. Go to the Reports menu. Hover over Banking and find Reconciliation Discrepancy.
  2. Select the account you're reconciling and then choose OK.
  3. Review the report. Look for any discrepancies.
  4. Edit the transaction as needed.

 

Step 3:

Look for reconciliation adjustments.

 

Here’s a helpful article about issues when you’re reconciling in QuickBooks Desktop:

 

https://quickbooks.intuit.com/learn-support/en-us/bank-transactions/fix-issues-when-you-re-reconcili...

 

If you have any further questions, let me know. I’m here to help anytime.

EL34
Level 4

How to reconcile after condensing company file?

That report is empty for December 2019
Did you take into account that the company dat file was condensed at the end of December 2019?

In the reconcile Checking window, there are no transactions to reconcile previous to 01/01/2020

 

report1.png

 

Emily M
QuickBooks Team

How to reconcile after condensing company file?

Thank you for reaching back out, @EL34.

 

It’s helpful that you provided a screenshot. There are a few options to get those transactions back. 

 

 

Here’s how:

  1. Click Reports.
  2. Choose the Accountant and Taxes.
  3. Find Voided/Deleted Transaction detail
  4. Zero in on the date of the deleted transaction and the re-enter the transaction. 

 

 

You may also Restore a backup copy of your QuickBooks file and locate the transaction. 

Then you can re-enter those details into your live QuickBooks file.

 

Note: Be extremely careful that you don’t restore your backup copy over top of your live data file. 

 

 

Please let me know if you have any questions or concerns.

EL34
Level 4

How to reconcile after condensing company file?

here is a screen shot of the Reconcile Checking account
All the transactions previous to 01/01/2020 are gone because the company file was condensed

report2.png


EL34
Level 4

How to reconcile after condensing company file?

I don't think you understand what is going on here.
There are no transactions previous to 01/01/2020 because the company file was condensed

I can't reconcile my checking account for the month of December 2019

report2.png

David-212915
QuickBooks Team

How to reconcile after condensing company file?

Hello again, @EL34.

 

Since the Condense Data utility converts transactions into a journal entry, the items from December will not appear in the Reconcile window. As my colleague mentioned earlier, you may want to consider restoring a back-up copy.

 

Alternatively, there's also the option of using a journal entry to make a reconcile adjustment for December. Should you be unsure about the creation of an adjustment, I recommend contacting your accountant for guidance.

 

I'm just a post away if I can be of additional assistance. Take care.

EL34
Level 4

How to reconcile after condensing company file?

I can't restore a backup copy

I have had 100's of transactions since 01/01/2020

None of this was mentioned in the Quickbooks guide to condensing a company file
This is only one of the problems
The average pricing on items was totally screwed up also after the condense


RenjolynC
QuickBooks Team

How to reconcile after condensing company file?

 I'd like to direct you to reach out to our Customer Care Support, EL34.

 

We will check your setup to see why you can't restore a backup copy of your company file. As well as investigate where the transactions are for 2020 after your file was condensed. Please check out our support hours and contact us at a time convenient to you.

  1. Click Help located at the top.
  2. Choose QuickBooks Desktop Help.
  3. Enter a brief description of your issue and click Continue.
  4. You can choose Message an Agent or Talk to a Specialist.

 

Feel free to reach back out. I'm only a post away if you have other questions or concerns. Thanks. 

Need to get in touch?

Contact us