cancel
Showing results for 
Search instead for 
Did you mean: 
tony18
Level 1

What should bank of america credit card look like on the balance sheet?

As you may know Bank of America credit card is setup with two accounts on the bank side. One main account for all cards so each card has their own account. The main account is for the total of cards and finance charges, if any.

In quick books I have a parent account and two subs to cover both of the accounts. Below is an example from the balance sheet. The visa card I only used the card account. The master card I have both accounts setup. Do they look like they are setup right? I don't know if I'm showing double the expense  or I ended with no expense on the master card..

Credit Cards
  
 
Credit Card/visa
-31,511.31
 
Master card parent acct.
-5,150.66
 
Master Card-main account
-23,557.79
 
Master Card-actual card
23,979.54
 
Total Master card parent acct.
-4,728.91
 
Total Credit Cards
$ -36,240.22

 

 
 
 

 

Thanks for your insight.

 

 

 

5 Comments 5
RCV
QuickBooks Team
QuickBooks Team

What should bank of america credit card look like on the balance sheet?

Let me share some information about the Balance Sheet report, tony18.

 

The Balance Sheet report is a financial statement showing your company's assets, liabilities and shareholders' equity at a specific date. Based on the data you've provided, it seems the credit card charges are not yet recorded. You can go to the Credit Card register and record the CC Expense.

 

Here's how:

 

  1. Click Accounting on the left side menu.
  2. Choose Chart of Accounts.
  3. Tick the View register link under the Action column on the credit card account.
  4. Scroll down on the register and hit the Add CC expense drop-down button and select CC Expense.
  5. Enter the details of the expense.
  6. Tap Save when done.

If there are credit card payments you'll need to record, just follow the steps in this article to keep track of your expenses: Record credit card payments.

 

If you encounter discrepancies like balance sheet not matching your register or the correct balance is incorrect, please refer to this article to troubleshoot the issue: FAQ: Basic troubleshooting for balance sheets.

 

To learn more about the Balance Sheet report, you can check out these articles:

 

I'm just one post away if you need a hand with reconciling your credit card accounts or any QuickBooks Online related. I'm glad to help.

tony18
Level 1

What should bank of america credit card look like on the balance sheet?

Thank you! I think I'm getting things figured out. All my transaction need to go to the parent account.

 

The only problem is i have 300 hundred transaction left to move over to the parent account. Is there any way to do this in bulk or I have to continue one by one?

Mark_R
QuickBooks Team

What should bank of america credit card look like on the balance sheet?

I'm happy to know that you've figured it out, @tony18.

 

At this time, there isn't an option to move hundred of transactions to the parent account in bulk. As a workaround, you can continue moving them one by one or merging the sub-accounts. Let me guide you through the steps.

 

Before we proceed, please know that merging bank accounts that have reconciliation reports will be deleted from the account that has been merged. However, the reconciliation status (R) will remain on the merged transactions.

 

Also, I suggest saving reconciled reports before merging the accounts to avoid data loss.

 

Here's how to merge accounts:

 

  1. Click the Gear icon, then select Chart to Accounts.
  2. Find and review the parent account.
  3. Go to the sub-account you want to merge, then select Edit from the drop-down under Action column.
  4. Change the Name and Detail Type of the sub-account.
  5. Click Save, then Yes to confirm.

Here's an article you can read for more details: How to merge accounts, customers, and vendors.

 

As always, feel free to visit our QuickBooks Community help website if you need tips and related articles in the future.

 

Please touch base with me here for all of your QuickBooks needs, I'm always happy to help. Have a good one.

tony18
Level 1

What should bank of america credit card look like on the balance sheet?

I moved a bunch of transaction to the parent account. Then I had to re-accept or add each transaction in the banking screen but when I do that it puts the transactions back into the sub account where it was to start with.

 

I can't figure out how to get this straighten out now.

GraceC
QuickBooks Team

What should bank of america credit card look like on the balance sheet?

Hello there, @tony18.

 

You can exclude the transaction so that they will not be added again in the sub-account. Let me show you how.

 

  1. Click the Banking menu from the navigation panel.
  2. Go to the Banking tab, click the account you want to use.
  3. Tap the For Review tab.
  4. Mark the checkbox of the transactions you want to exclude.
  5. From the Batch actions drop-down, choose Exclude Selected.
  6. The items will be moved to the Excluded section.
  7. From the Excluded tab, put a check in the box for the transaction you'd like to permanently delete.
  8. Choose Batch actions, then Delete.
  9. You'll be asked if you're sure. Click Yes to confirm.

Once done, these items are no longer reported as part of your business finances and will not appear in any associated account registers or reports.

 

For more information detailed steps you can check this article: How to exclude expenses from downloaded bank transactions?

 

I've added this article that will give you information on using the adding and matching feature in QBO: Download, match, and categorize your bank transactions in QuickBooks Online.

 

Let me know if you need more help with this. I'm just here to assist you further.

Need to get in touch?

Contact us