Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
leigh2
Level 1

excluding accounts from the P&L

I hope someone can help.   Our company credit card has one account but 4 cards for different consultants under that one card.  When I set up quickbooks (and was a complete newbie to it) I needed to figure out how I could have the transactions be downloaded from the bank to reconcile.   A QB expert said the only way to do that was to set it up that all cards are shown but to have a separate account for all of them otherwise I would not be able to reconcile each account to the bank statement.  I have used this method ever since.  Trouble is that the profit and loss are of course showing ALL the transactions from the cards whether they are in the reconciliation or not so I have lots of duplications.  What can I do to rectify this and have my QB account be a true representation of the transactions and payments of my credit card?

thanks!

5 Comments 5
MariaSoledadG
QuickBooks Team

excluding accounts from the P&L

Thanks for reaching out to us. May I know how did you set up the bank account for these 4 consultants? Was it set up as as sub accounts, Leigh2?

 

The most common practice for setting up a bank or credit card account with multiple associated cards is to create a parent account, and then set up each individual card as a subaccount under it. 

 

Before connecting to online banking, it's important to understand how your bank sends the downloaded transactions. If all transactions are download into one account, connect only the parent account. If the transactions download to the individual accounts, connect the subaccounts and not the parent account. 

 

When it's time to reconcile, you'll need to reconcile the parent account, as all transactions in the subaccounts roll up into it. In relation to this, when running a report , focus on the parent credit card account rather than individual sub-account. This will give you an accurate summary that avoids double-counting. 

 

To give you more information about multiple bank and credit accounts setup, check this our for your reference: About bank or credit card subaccount setup.

 

If you wish to streamline or automate transactions in your Banking page or even when running reports, feel free to connect with our QuickBooks Live Expert Assisted team. They can help you save time and simplify the process.

 

Fill me in if you have any concerns or questions about your credit card account setup or when running reports, I'm always around to assist you. 

Rainflurry
Level 15

excluding accounts from the P&L

@leigh2 

 

All CC transactions, whether reconciled or not, should show on your P&L.  Are you expecting something different?    

leigh2
Level 1

excluding accounts from the P&L

As I say, QB set it up for me to have an extra CC account where I could reconcile the 4 credit cards that are under one account in our bank.  So that means that the four cards get reconciled in ONE account (that QB created for me) as I cannot reconcile the 4 sub accounts in QB online as I have ONE statement.  Yes I know that the credit card account will be in the P&L but only one of them is actually reconciled so the others are DUPLICATED.  

 

I hope that explains it better and thanks for taking the time to look at the issue.

Warmly

India 

leigh2
Level 1

excluding accounts from the P&L

Thank you Maria.

 

Yes as you say there are 4 sub accounts.  QB helped me to set up one parent account which is the one I reconcile.  The issue I have is that the 4 sub accounts are showing up in my p&L and duplicating the transactions there and inflating the expenses for the company.  I need to somehow stop the sub accounts that I do not (cannot) reconcile as the PARENT account that was set up for me has all the transactions posted in it.

leigh2
Level 1

excluding accounts from the P&L

thanks for your reply.  As Quickbooks agents guided me and set this up to be this way in the first place I feel very reluctant to now have to pay to get this put right.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us