Solved

Sub Account Balance Sheet Report

Forum|Forum|8 years ago
March 20, 2018
26 replies
116 views

New to QB Online. I have my main bank account and sub accounts. I was in 2003 Before and had sub account balance sheet reports for fiscal year. My reports were supposed to be migrated over, but they did not. How do I create the same thing on QBOnline. It does not give me the option in the balance sheet to just choose certain account

QuickBooks Online

Best answer by

Bummer. I was told that they did when I moved from 2003 to online. This is for my church and I want to create a balance sheet for each dept head so they know what they have available for their budget. Can you think of any other report that will give me what I need

Hey Dale (@fishing4dale)

I had another thought. @Rustler, while it may require a bit of manual work initially, would it make sense to create and save customized P&L reports by church department with all the relevant parent and sub-accounts for said department?

A

Anonymous

Hey Dale,

Welcome to the community and QuickBooks Online. Are you interested in running targeted reports for particular accounts or creating reports for only (and all) of your sub-accounts?

For the prior, go into the Accounting Tab and go to your Chart of Accounts. Find the specific sub-account you want to run a report for, click the () and then "Run Report." This limits the report (which is customizable) to just the one account.

For the latter, go back into your Chart of Accounts and click the "Run Report" button on the top right. This brings up an account list and summary of everything in your CoA. To filter for specific sub-accounts, click the "Customize" button at the top, expand the "Filter" section, check the Account box and then scroll through the drop-down menu to toggle the specific accounts you want to include in your report.

QuickBooks Desktop and Online have different workflows, each has its own character, but once you learn them both they're equally easy to navigate. I was the opposite, I started with QuickBooks Online and am now exploring the features of QuickBooks Desktop.

I hope this helps!

J

jwhllc

I spent 7 hours with Help Desk and then they concluded, QB Online is is designed to limit reports to Parent Account only and you cannot display the sub-accounts in P&L and Balance Sheet. I complained that this renders QB Online useless since I can see the Total Account balance from a bank statement. I asked why the Chart of Accounts includes such detailed sub-accounts and allows me to enter the detailed data, but cannot retrieve it. I was referred to leave a request in Feedback to the Engineers. Can anyone help me?

R

RobWKal

All reports in the balance sheet will show an amount as long as they have an activity, RobWKal.

It could be that your bank set up is not ideal, we recommend to use Account type and Detail Type as Cash and Cash Equivalent instead of Other Current assets. This might be the reason why its not showing the amount.

This information will guide you to the report you need RobWKal. If you have follow-up questions, don't hesitate to comment below. We're always here to help.

For some reason my replies do not appear. Not sure why

E

Eazi

hie, i want to run a report with full details of my inventory value at hand including its sub-accounts which i created as inventory: demonstration and inventory: held by agent for sale. how do i go around it with QuickBooks online

M

Mark_R

Moderator

Don't sweat, @Eazi. Running an inventory report in QuickBooks Online (QBO) is easy as 1 2 3.

You can run the Inventory Valuation Detail report to show the QTY on hand and its value, including the sub-accounts (sub-product/service). Here's how:

Sign in to your QBO account.
Click Reports from the left menu.
Search for the Inventory Valuation Detail report.
From there, you'll see the full details of your inventory qty on hand and its value.

Here's an article you can read to learn what reports to use to view your inventory status in QBO: Use reports to see your sales and inventory status.

For your future reference, you might also want to check out these articles to know how to customize and memorize reports in QBO:

Should you need any assistance managing your inventory, I'm available here to help any time!

E

Eazi

hie Quickbooks, some of my customers wanted transact in forex, and i wanted to shift from my home currency to the currency that my customer wanted to use to transact with me. How can i do it so that it will display the required currency in question for that specific customer

Sign up

Login with SSO

Let's get you signed in

Login with SSO