Statement of Cash Flows With Class Filters A/R Problem

Hi there, scottchs.

Welcome back to QuickBooks Community. I appreciate you for providing detailed information on what you've done to accomplished what you need. I'll share steps to ensure that you're able to run the Statement of Cash Flows report with accurate details.

To ensure that rental payments are included in the report, you'll have to make sure that the summary report basis is assigned to Cash. This way, only the invoices that are paid will show because the entries are associated with payments based on the date of the amounts. Then, filter the report to Transaction Type and choose invoice and payment.

Here's how:

1. Click the Reports menu at the top. Then, choose Company & Financial and select Statement of Cash Flows.
2. Click the Customize Report. 
3. Go to the Filters tab.
4. Choose Transaction Type in the Search Filters field.
5. Choose Multiple Transaction types in the drop-down list and select Invoice and Payment.
6. Hit OK.
7. Click the Classify Cash button located in the upper right corner.
8. Choose the Company Preferences tab. Then, choose the Cash radio button on the Summary Report basis.
9. Click OK.

For additional information on how you can personalize the font and style of the report to show the date that you want to view, you can click this article: Customize reports in QuickBooks Desktop.

Please refer to this article to see different details on how or which reports show only unclassified transactions or showing classes or subclasses: Filter, sort or total reports by Class.

Please don't hesitate to leave a comment below if you have any other questions for QuickBooks. Take care and stay safe.

I think I need to clarify my question. I want to look at the statement of cash flows using a filter for a specific set of classes. This works fine, except that the specific payment transactions do not have a class attached to them. I cannot see anywhere on the "Receive Payments" dialog box that would allow for a class to be assigned. As a result, these payments are not included on the Statement of Cash Flows when I filter for specific classes, because the actual payment itself is presumably "Unclassified". My company is already set on a cash basis.

So in an unfiltered Statement of Cash Flows, the invoices are included in the Net Income line, while open balances are counted against net cash in the Accounts Receivable line below. But when filtered for a class, the invoice for that class will show up in Net Income, but the payment is not classed, so the Accounts Receivable line shows all invoices as unpaid and reduces Net Cash by the total amount of invoices.

If I invoice a tenant in Class:PropertyX for $500 and they pay $400, an unfiltered Statement of Cash Flows shows:

Net Income: $500

Accounts Receivable: -$100

Net Cash: $400

If I filter the same report for Class:PropertyX, I get:

Net Income: $500

Accounts Receivable: -$500

Net Cash: $0

Which makes a Statement of Cash Flows filtered by Class sort of worthless. Am I doing something wrong here, or are Statements of Cash Flows not meant to be filtered by class?

Thanks for getting back on this thread, scottchs.

I'm here to share some insights about how QuickBooks populates the data on your reports.

Once we use the Class filter, QuickBooks will show the transactions (invoices) with assigned classes. Please know that we're unable to show the payments tied to those invoices since the payments don't have classes. We'll have to open each invoice by double-clicking it to view the payments (under the Recent Transaction section).

The Filters option in the Statement of Cash Flows report allows us to limit report data to selected criteria. This is particularly important if we need to personalize the report for your needs. QuickBooks looks at individual transaction lines when building a report. If a line matches the report set, then the line is added to the report.

We can also export the report to an Excel file and manually sort it from there. I'll show you how.

1. Select Reports from the top menu bar.
2. Click Reports located at the top.
3. Select Company & Financial and choose Statement of Cash Flows.
4. Select the Dates, and click the Customize Report button.
5. Click the Filters tab.
6. Type Class in the search box, then select the classes from the drop-down list.
7. Click OK.
8. Click the Excel button, then choose Create New Worksheet.
9. Select Export, then manually customize it outside the program.

To learn more about how reports work in QuickBooks Desktop, you can read this guide.

In case you'll need to personalize and design your reports, you can utilize the Customize feature. Then, memorize them to save their current customization settings.

I'll be glad to help you again if you have more questions about running reports. Feel free to leave them below and I'll get back to you as soon as I can.

Thanks for the answer Charlene! It makes sense that I cannot filter a Statement of Cash Flows by class and get accurate cash flow data if the payments cannot be classed. If this is simply the way QB works, there's not much I can do about that. With that said, it seems like an odd choice from a program design perspective. It would make more sense to me to have a program that matches the classes of payments to the classes of the invoices that those payments are applied to. Maybe in a future release?

Thanks for sharing your thoughts about customizing reports in QuickBooks, @scottchs.

As of now, I’m unable to provide you a specific time frame as to when this feature will be available in QuickBooks Desktop (QBDT). As an alternative, you’ll want to export the report to MS Excel as suggested by my colleague CharleneMae_F above.

Also, to stay current on the latest news and updates about QuickBooks, you can visit our Product Updates page for your reference.

Moreover, I’m adding this link that you can read for guidance in managing your reports efficiently: Understand reports.

In case you have any other concerns or questions about running reports, you can always share them with me. I’ll be around to listen and back you up. Have a good one and always stay safe!