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

Why is my A/R calculating incorrectly on my Statement of Cash Flows?

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!

3 Comments 3
RenjolynC
QuickBooks Team

Why is my A/R calculating incorrectly on my Statement of Cash Flows?

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!

bjd90
Level 1

Why is my A/R calculating incorrectly on my Statement of Cash Flows?

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.

AlexV
QuickBooks Team

Why is my A/R calculating incorrectly on my Statement of Cash Flows?

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.

  1. Go to the Help menu and select QuickBooks Desktop Help.
  2. Click Contact us on the pop-up.
  3. Enter "Statement of Cash Flows" in the question field and click Search.
  4. Choose how to connect with our QuickBooks experts.

 

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!

Need to get in touch?

Contact us