a condensed customer listing in a journal entry on a accounts receivable line with an open balance of $- 5,543.09, I don't understand the details of what this means!

Hello there, @568SKH. I can share more details about the condensed data process in QuickBooks Desktop (QBDT).

Condensing data will remove transaction detail and list entries. You need to get the backup file to see the previous accounting data. Then, open it in the QBDT application.

If you don't have the QBDT app, you can utilize the trial version. For more information about restoring a backup file in QBDT, check out this article: Restore a backup of your company file.

After restoring the backup file, you can spot those open transactions by running a report. Then, export it and create a journal entry in your QuickBooks Online (QBO) company.

However, if you want to make the new entries to zero in QBO, I recommend speaking to the previous accountant or bookkeeper. They can point out the transactions and discuss further the things to do.

I've included this reference that can be handy in the future: Common custom reports in QuickBooks Online. It will help you track the data you need.

I'm up and ready to help you out again if you have more questions about the process. Take care.

Hello Stephanie,

thank you for pointing me in the right direction.  Of course I have a few more questions.   Also,I understand that  the former bookkeeper and accountant contractor team- yes not a good idea when there is no real Board oversight-quit working for the NP unexpectedly and not on good terms.  They have been very unhelpful in terms of providing insight to previous transactions, etc.  So, I give up on that.

Here are a few  more questions.  DOes it matter that the journal entry remains with that open balance of negative ARS?  I think the answer could be yes because I am trying to reconcile this bank account and I cannot get it to disappear off the beginning balance discrepancy report, even after I have corrected for the issue on that report!  Also, I have no idea as to why they entered a negative AR balance as a credit when it would have made better sense if a positive number was entered as a debit.  If the transaction line had been entered correctly, does this mean that this condensed customer number reflected a sum of all the new invoices that were sent out for the next month?  Can I assume that if I somehow knew which customers' invoices were in this truncation, I could see them in their individual accounts?   Finally, why did it look as though the accounting team went back into the general journal a few times (I can see in the audit trail) to clear the open balance for the APS but never for the AR line? I will stop writing for now.  I am very much appreciating your help.  

I appreciate all the details that you've shared, @568SKH. I’ll make sure to address your concerns one by one to help you figure out these balances.

Regarding the open balance of your journal entries, you’ll need to consult your accountant for the verification. This way, we can ensure you get the best answers as to why there are negative amounts involved.

The sum of the invoices will show depending on how you condense the affected date of those payments or links. 

Additionally, you can also track your invoices or transactions specific to a customer.

Moreover, it is already out of our scope to share some insights about the accounting team who handled your journal. For clarifications, I recommend checking out with them for further assistance.

I’ve added this article about an account you can create to move money from one account to another: Set up a clearing account.

Be sure to get back to me if you have additional questions while working with your journal entries. It would be my pleasure to help. Have a good one!

Hi @MarsStephanieL , we are in a similar situation as @568SKH also caused by a condensing of our company file for the purpose of reducing targets to migrate to QBO. We are continuing to work on QBDT in parallel with our efforts to move to QBO as there are other issues to resolve before we can drop QBDT. In the meanwhile, we also have open balance due to the removal of older transactions. I was reviewing the custom reports suggestion for online here Customer or Vendor payments page:

https://quickbooks.intuit.com/learn-support/en-us/help-article/report-management/common-custom-repor...

and was wondering if there was a similar way to do this for QBDT.

We would want to identify all transactions per Customer made since the date of the condensing. Once done with this, extract these transactions and reapply them to the backup copy made prior to condensing and resume work on that company file. Is this possible with QB?

Thanks,

Henry

Thank you for providing more details on what you've just worked on. I'm here to show how you can do this in a much simpler way, Aventador. 

QuickBooks Online (QBO) offers different reports that cater to your business needs. You can customize them so it would show the information you need most. Once you have the perfect set of filters, you can save and run the same report for your future needs. 

On the other hand, you can use a third-party application in QBO to identify transactions made previously and during the date, you condensed your data. This way, you'll not be going through with the process wherein you extract these transactions and reapply them to the backup copy.

If you're trying to look for an application for QuickBooks Desktop, check out our Intuit Marketplace.

Moreover, here is the list of available reports that you can use and customize in case you specific information. I've added this article for more details: Reports Included In Your QuickBooks Online Subscription.

Please get back to us if you have any concerns about customer listings and journal entries. We're here to get you covered.

Hi @MariaSoledadG ,

Thank you for the reply. Let me just clarify some details. Although we have migrated to QBO, we are not updating our transactions there yet, because we have not migrated our import and export flows using TransactionPro (3rd Party app) to the cloud yet. Currently we continue to use the desktop version of this which is where we are looking to be able to extract transactions made since we migrated (July 20) and restore these transactions back to the backup copy made prior to that migration. We ask if you have any experience using this 3rd party app on the desktop. We have obtained the transactions using a custom report per customer on desktop.

Hi there, @aventador. Thank you for getting back to us and providing more information about your situation.

Regarding third-party apps, we're unable to offer recommendations or support. However, you can check out the Intuit Marketplace, which features various apps that integrate with QuickBooks. There, you'll find app reviews and information about different solutions that may fulfill your requirements for extracting and managing transactions.

Here's how:

1. Head to this link: Intuit Marketplace
2. From the QuickBooks Compatibility section, choose the QuickBooks Desktop version you're using.
3. Type in the clue word of the specific app you're looking for in the Search field and click the magnifying glass to search. 
   

    

Additionally, this article helps you set up your QuickBooks Online (QBO) account, configure preferences, and navigate through the platform's features: QBO Start Up Guide.

If you need further assistance with getting started with QBO, please feel free to ask. We'd be more than happy to help.