Business Credit Cards (Rollup) on Balance Sheet

Good day, EJ.

If the sub-accounts has zero amounts, you can click on the drop-down list for Show non-zero or active only field and select Non-zero for both Show Rows and Columns. Then, click Run Report. 

However, sub-accounts with balances can't be removed in the Balance Sheet report. However, you can export the report to Excel where you can make more customization. Just click the Export button in the right-hand corner and select Export to Excel.

Let me also share these report-related quick guides for more details: 

• Basic troubleshooting for balance sheets
• Customize reports in QuickBooks Online
• Popular custom reports in QuickBooks Online

Don't hesitate to add a reply or reach out to us again if you need anything else. 

Thank you for the information.  Not what I was hoping for, but I can work with it.

But, this does lead me to a second question regarding a Main Company Card and additional cards that are tied to the main card.  I have each card setup in my bank feeds except the Main Company Card.  I also have a separate account tied to the Main Company Card, but no feed, where the payments are entered.  The results will show the correct balance for the Main Company Card, but it makes it appear that all of the additional cards have outstanding balances.  This does not appear to be a "best practices" approach.  Is there a better way, or is this something that QBO can't do yet?

Thank you

EJ

P.S. - Though a completely separate topic, why would you use Transfer vs Add for a credit card transaction (i.e. payment) in the Business Bank Account.  You can't split a Transfer.  EJ

Hello there, @GolfNut72.

It's my pleasure to provide insights regarding the bank connected to QuickBooks Online. 

There are some banks that either the sub-account or the main account can be connected. When paying the sub-accounts, you’ll have to create a Credit Card Credit to zero the outstanding balance.

Here's how to create a Credit card credit:

1. Click + New on the left menu and then select Credit card credit.
2. Enter the information needed in the form and hit Save and close.

For more details about managing your expenses in QuickBooks Online, here's your guide: How to Record Spending: Transactions, Bills & Payments.

We use the transfer feature in the business bank account, it’s how QuickBooks records the payment to sub-accounts for the balance to be reduced or zeroed.

Also, I'm adding these articles to learn more in handling your bank transactions:

• Assign, categorize, edit, and add your downloaded banking transactions
• Match and categorize bank transactions in QuickBooks Online

If you have other concerns or questions, don't hesitate to reach out to us. We're always here to help.

The issue is that as the Main Credit Card account is reconciled and paid, the balances still show in the sub accounts with an off-set of a negative balance in the main credit card account.  this makes for a rather dirty balance sheet.  I know how to not show accounts so I am looking for some normal process to clear these accounts against each other.

Nice to have you joined this thread, @Lonnie5.

I'll share some insights on how you can seamlessly run your Main Credit Card balance sheet report.

Posting to your sub-accounts will have an effect on your parent account balance. While posting to your parent account has no effect on the sub-accounts.

To isolate this, you'll want to reconcile your credit card sub-accounts to clear those balances. This way, your balance sheet report for your main credit card shows accurate data.

You can follow these steps in reconciling your sub-account:

1. Go to the Accounting menu and select Reconcile.
2. Select your sub-account from the Account drop-down menu.
3. Enter the needed details and click Star reconciling.

You can also check this article for the complete details: Reconcile an account in QuickBooks Online.

Furthermore, I'd also recommend working with your accountant on other ways in handling this issue. This way, we can also ensure the accuracy of your accounts after making some changes.

In case you run into some issues during reconciliation, I got you this resource that can guide you in fixing it: Learn the reconcile workflow in QuickBooks.

I'll be around if you need more help with your reports and accounts. Keep me in the loop by tagging me in your reply. Have a good one!