In the cash flows reports how can I separate the "cash available at beginning period", into separate classes? right now its under the column "Not Specified"

refugeofhopeinte · ‎July 11, 2024

I use two different classes of funds and expenses. I want to be able to see in my cash flows reports how much funds were available at the beginning of the period and at the end of the period according to class. However even when I filter the report by class all the funds available at beginning of the year are lumped together under "Not specified". I always make sure all income and expenses are classified into each of its proper class.

jeanbiverly_

Thanks for the detailed information, @refugeofhopeinte. I'm pleased to explain why your transactions are categorized under "Not Specified."

When you generate the balance sheet report and organize columns by classes, it may not provide an accurate display. Accounts Receivable and Accounts Payable headers aren't sorted by the assigned class but are categorized under “Not Specified.”

This occurs because their related transactions cannot be split into different locations. To address this, you can divide the transactions based on location or use a journal entry. It's advisable to seek guidance from your accountant to split the transactions.

Unlike by class, filter your balance sheet and profit and loss by location. When you save a location on a transaction, it's linked to the header and detail.

To filter a balance sheet by location:

Navigate to the Reports menu.
Look for and open the Balance Sheet.
Under the Display columns by dropdown, choose Locations.
Select Run report.

For more details, visit this article: Run a balance sheet by class or location in QuickBooks Online.

Here are some articles to help you manage your cash flows effectively:

You can always count on us should you have any other QBO-related concerns. We're readily available to lend a helping hand. Just leave a comment on this thread. Take care, and have a great day!