Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I'm having trouble reconciling the money that my program says that I earned and my cash flow. My A/R was down (see report) and on the report it decreases cash. In reality if A/R is down cash should increase. I've checked two other company files, one of them on the same PC, and they both report my A/R correctly on the SCF report. I guess I'm wondering if the problem is deeper than the report. I'm wondering if I really earned the money that Quickbooks says that I have. The discrepancy is $16,000, so if it's upside down that could translate into another $32,000 profit on my 2020 tax return. I need to get this resolved before I file taxes. Please help!
Hi there, bjd90.
I'd like to share some steps to help you fix the report.
If the other company file has the same data, it's possible that the current one is damaged or corrupted. Before doing anything, let's make sure that your QuickBooks Desktop is updated to the latest release. Then, follow the basic data damage troubleshooting steps in this article: Fix data damage on your QuickBooks Desktop company file.
Once done, go back and run your Statement of Cash Flows report and reconcile the account when you have the correct information. I'm adding this link for the instructions: Reconcile an account in QuickBooks Desktop.
Otherwise, make sure to check the invoices covered in that period are paid. Also, review your bank statement if the transactions matches what you have in QuickBooks.
Please keep me updated on how it goes. I'll be around to help you out again. Take care and stay safe!
I have updated my company file to the latest version, and rebuilt the data of my file using File/Utilities/Rebuild Data. After the rebuild, File/Utilities/Verify Data tells my my data doesn't have any problems. I have tried the Quickbooks Tool Hub. Unfortunately, after downloading the latest version, when I click on Quickbooks Tool Hub/Company File Issues/Run Quickbooks File Doctor, the program starts but always crashes. I'm pretty sure the problem is a company file issue instead of a program issue, as a company file on a different company using the same program on the same PC calculates correctly. All accounts are reconciled through the time period in which I am running the report. All customer payments are applied to their invoices correctly. I'll attach the Statement of Cash Flows from Company #2 so you can see the difference.
Hello 31510369!
Thanks for the reply. Let me share some details on how we can fix this.
When you pull up the Statement of Cash Flows report, make sure to set the correct date. The data that appears will be based on the filters you've set. For the detailed steps on how to get accurate data, check this link: Customize reports in QuickBooks Desktop.
You also want to use other financial reports, like profit and loss. You can use it to compare the data showing on your Statement of Cash Flows. Please check this link: Track your cash flow in QuickBooks Desktop. This will further explain how to get a better understanding of your cash flow.
With regards to the QuickBooksTool Hub that's crashing, you'll want to uninstall and reinstall it. Also, it's recommended to run it on Windows 10, 64-bit.
It'd also be best to seek some help from our Support Team so they can conduct further investigation.
You'll want to visit this page: QBDT Reports. From there, you'll see all articles on how to create and manage reports.
Keep on posting here if you have other concerns. I'll be here!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here