Skip to main content
F
fishing4dale
March 20, 2018
Solved

Sub Account Balance Sheet Report

  • March 20, 2018
  • 2 replies
  • 0 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

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? 

 

 

 

 

 

 

 

2 replies

A
Anonymous
March 21, 2018

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! 

F
fishing4daleAuthor
March 21, 2018

Actually what I am looking to do is the income and expenses summary report for the last fiscal year. Does that make sense? The P&L gives it for all, but what I want is a separate report for each dept, it shows nothing and just want one distribution acct, it gives me nothing

Rustler
Rustler
March 21, 2018
@fishing4dalewrote:

Actually what I am looking to do is the income and expenses summary report for the last fiscal year. Does that make sense? The P&L gives it for all, but what I want is a separate report for each dept, it shows nothing and just want one distribution acct, it gives me nothing

to have by department reporting, you have to QBO Plus, and in company settings turn on locations and classes, then define them and tag transactions with them.


QBO does not have balance sheet by class or location the way desktop does


Bank accounts should not be used to run a balance sheet or a P&L, they are just a place to hold money.


company>categories and turn on classes/locations
OR
Gear>accounts & Settings
Advanced>categories and turn on classes/locations

class allows you to tag each item line in a transaction
location allows you to tag the entire transaction

E
Eazi
December 14, 2020

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
December 14, 2020

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:

 

  1. Sign in to your QBO account.
  2. Click Reports from the left menu.
  3. Search for the Inventory Valuation Detail report.
  4. 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
    December 28, 2020

    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

     

    Terms & ConditionsAccessibility statement