Question

Statement of Cash Flows With Class Filters A/R Problem

5 replies
41 views

I run a rental business and utilize two primary classes - Projects and Rental Operations - which in turn have a number of subclasses to reflect major capital projects in the former and regular rental operations in the latter.

When I run a cash flow report, I tried to use filters -> class -> Select Multiple to select Rental Operations with all of its subclasses. The problem I am having is that this report give me an inaccurate A/R number. The report includes all rental invoices, each of which is tagged with a class, but none of the payments, which apparently do not have a class tag. So the report essentially shows all my invoices as unpaid.

Any idea how to fix this so that the rental payments are included in this report with this filter on?

QuickBooks Desktop

C

ChristieAnn 11

Level 9

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:

Click the Reports menu at the top. Then, choose Company & Financial and select Statement of Cash Flows.
Click the Customize Report.
Go to the Filters tab.
Choose Transaction Type in the Search Filters field.
Choose Multiple Transaction types in the drop-down list and select Invoice and Payment.
Hit OK.
Click the Classify Cash button located in the upper right corner.
Choose the Company Preferences tab. Then, choose the Cash radio button on the Summary Report basis.
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.

S

scottchsAuthor

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?

C

CharleneMaeF

QuickBooks Team

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.

Select Reports from the top menu bar.
Click Reports located at the top.
Select Company & Financial and choose Statement of Cash Flows.
Select the Dates, and click the Customize Report button.
Click the Filters tab.
Type Class in the search box, then select the classes from the drop-down list.
Click OK.
Click the Excel button, then choose Create New Worksheet.
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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO