cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Created with Sketch. Join our Small Business Relief Initiative. Support a GoFundMe today.
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

It throws of the in Quickbooks balance on each account.  Since the payment sent transaction from the checking account matches the payment received transaction in the main user credit card, it reduces the In Quickbooks balance by that full amount.  Problem is all the other users associated with that credit card, don't get reduced to $0 and the main user goes negative by that amount.

Is this a limitation of QBO and will I have to make a journal account entry to zero those numbers out each month?
16 Comments
Highlighted
QuickBooks Team

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

You can create an adjusting entry to adjust the reconciliation, @perhub

 

If the difference after reconciling is a negative number. You can resolve it by creating a check transaction without a check number. This will reduce your bank account and your Opening Balance Equity account by that amount.

 

Here’s how to create a check:

  1. Go to the Create icon ⨁ and select Check.
  2. Choose the Bank Account where you’re having some discrepancy.
  3. Add the amount and make sure not to indicate a check number.
  4. Select Save and close once you’re done.

But, if it’s a positive number, then you'll just have to create a deposit transaction. This will increase your bank account and your Opening Balance Equity account by that amount. Follow the steps below:

 

  1. Go to the Accounting menu and select Chart of Accounts.
  2. Locate the account register that you’re having, then select View register from the Actions column.
  3. From the Add transaction ▼ drop-down menu, select Deposit.
  4. Fill in the necessary fields and complete the form.
  5. Click Save once you’re done.

 

These adjustments affect only your Balance Sheet, not your Profit & Loss. See this article for detailed guidance: How to adjust a reconciliation

 

I'm always here if you need further help or assistance. Stay in touch by leaving a post below. I'm always here. Have a wonderful day!

Highlighted
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Hi Mary,

 

It may have been some confusion on what I am asking.  When I have a credit card payment. I see a transaction on my bank account and the main credit card account.  However, Since Chase has each cardholder on each account, required to download each transaction, each of those needs to be reconciled. As you can see from the picture, You match the payment from the Checking Account to the Credit card (K Jr) that has the corresponding payment received.  There you accept the match.  However, in this example, the payment was $424.20, but K Jr card only had $395.44 spent that month, and Kathleen card had $38.75. When you match, K Jr goes negative -$28.76 in Quickbooks and Kathleen stays at $38.75.  If it did it correctly, K Jr would show $9.99 in Quickbooks due to the one transaction already and match the $9.99 bank balance and Kathleen would be $0.

 

Honestly, we would rather not have all of our cards on that card required as separate accounts and just have one Credit Card show, but that is how it linked it.

Highlighted
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

.....

Highlighted
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Here is what I am trying to do.  You can see QB downloads Chase cards in same account under different accounts if you have more than one cardholder in that account.  This is causing an error reconciling the "In Quickbooks" amount since it only applies it to K Jr card


Credit Card Payment 1.jpg Credit Card Payment 2.jpg Credit Card Payment 3.jpg Credit Card Payment CoA.jpg

Highlighted
QuickBooks Team

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Hi there, perhub,

 

Thank you for providing screenshots. This will help me provide the exact information needed to resolve those transactions from the bank feeds.

 

When accounts to QuickBooks Online, you need to check with your bank how they send the transactions. If your bank downloads to one account, connect only the parent account. If not, then connect sub-accounts if they download them to the individual user's account.

 

For multiple credit cards from Chase, it's recommended to have a parent account. And, set up other users as sub-accounts. Then, only sub-accounts should be connected on your bank feeds. This is for you to easily apply payments and just reconcile the parent account.

 

Since those accounts are already on your bank feeds, you can simply edit the account info and make them a sub-accounts.

 

Let me show you how:

  1. On the bank feeds, let's choose Chase CC: K Jr Chase CC.
  2. Then, click the edit pencil icon.
  3. Select Edit account info.
    editaccountinfo.PNG
  4. On the Account window, mark the Is sub-account box.
  5. Select the parent account from the drop-down list.
    sub-account.PNG
  6. Click Save and Close.
  7. Follow the same steps for other users' account.
  8. After that, you can then match downloaded payments.

To learn more about creating sub-accounts to break down income and expenses, check this out: Organize your accounts into parent accounts and subaccounts. This article provides detailed steps and instructions to guide you with the process.

 

Keep me posted if you need additional information and I'll get back to you.

Highlighted
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Mary,

 

I have already setup each credit card as a sub account under the Main credit card.

 

The issue I am running into is matching the payment sent from the checking account to the K Jr CC account (since it has the payment received transaction).

 

It matches them, but it throws off the "IN QUICKBOOKS" balance because it is being applied to K Jr and not to the other cards that had transactions done.

 

K Jr CC shows a bank balance that encompeses all the other card holders with that Chase account.  However, they each are required to download the transactions on the account, since they don't show up in K Jr card downloads.  THis is why I created the Main account Chase CC and put all the cards as sub accounts below it.  The bank balance under K Jr card is matching the IN QUICKBOOKS balance for the main Chase CC account I made.

 

The problem is when the payment from the checking account is matched to the payment received showing in K Jr card.  It is throwing off the IN QUICKBOOKS amount.

 

Either there is a way to solve this problem or Quickbooks should just be using one card K Jr, and have all transactions download on there.

Highlighted
Moderator

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Hi, perhub.

 

As referenced by my peer above, you need to know how your bank sends the downloaded transactions. If the transactions download to one account, connect only the parent account. If the transactions download to the individual accounts, connect the sub-accounts and not the parent account. This is to reconcile your account smoothly.

 

You don't need to transfer the transaction to any account connected to the bank feeds. Once your statements are downloaded into QuickBooks Online, you can match it from there.

 

See these articles to get more details about connecting your accounts to Online Banking:

 

In case you want to know some "How do I" steps in QuickBooks Online, you can always visit our Help Articles page for reference. We also have resources available to help you grow and manage your business, all you need to do is visit the QuickBooks Resource Center for more information. 

z.PNG

 

Please get back to me if you have any other QuickBooks questions. I'd be more than willing to lend you a hand. Have a good one.

Highlighted
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

HI Rose,

 

I don't think you are following what I am asking.  I already setup the accounts as sub accounts under a main Chase CC account I made.  Kevin Jr is the main cardholder and the bank balance shows on that card, with all the others showing $0.

 

I am running into issues when I am matching the payment sent from my checking account to the credit card.  It matches it to the payment received in K Jr credit card, but it throws off the IN QUICKBOOKS balance amount on K Jr card and all the other cards that had transactions.

 

That is what I am specifically asking about, not how to setup a main account and sub account.  All the links you have provided don't answer my question.  They are just showing me what I have already done.

 

I am trying to resolve the issue with the IN QUICKBOOKS balance not correctly reflecting due to the fact each cardholder is downloading the transactions.

Highlighted
Moderator

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Hi, perhub.

 

To show this transaction to both accounts, you can record this using the Transfer Funds feature in QuickBooks Online. 

 

Below are the necessary steps to complete the process:

 

  1. Click the Plus icon in the left panel and choose Transfer.

  2. Choose the account that has the payment of $424.20.
  3. Then, choose the second credit card account.
  4. Enter the Amount and hit Save and close.

 

See the following article to get more details about this feature: Transfer funds between accounts.

 

In case you want to know some "How do I" steps in QuickBooks Online, you can always visit our Help Articles page for reference.

 

I'm always here to help if you have any other questions. You have a wonderful day.

Highlighted
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Thanks for that option Rose.  I would need to do the exact opposite from K Jr credit card to transfer $38.75 back to the checking account though.  That appears to accomplish the same thing as just making a journal entry and swapping $38.75 between K Jr CC and Kathleen CC though, but with more steps.

 

If this is the only way to fix the discrepancy, then this is pretty cumbersome for a paid product like this. Honestly, this shouldn't be this complex.  It's better off if the account just downloaded all transactions in one account instead of one for each cardholder.  The way QBO and Chase have this setup just complicates the whole process way more than it should.  I have never seen this on Mint or Personal Capital, and those are free services.

 

As for all the references about transferring funds and linking credit cards.  I have reviewed them, but none of them solve this problem and its why I am on here asking about it.

Highlighted
Moderator

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

I understand, @perhub.

 

Letting us know about this will also show our developers what they need to consider in future product updates. At this time, you can use this option to fix the discrepancy. 

 

I'll be sure to pass along your feedback in my end.

 

In the meantime, you can visit our QuickBooks Blog to know more about our latest happenings. From there, you'll get the recent news, features, and updates about QBO and what our Product Team is working on. 

 

Should you have other questions, do let me know. I'll be here to help. Have a great day!

Highlighted
Level 1

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Following this. 

 

Frustrating on our end as well. 

 

Any progress @IntuitLily ?

 


@IntuitLily wrote:

I understand, @perhub.

 

Letting us know about this will also show our developers what they need to consider in future product updates. At this time, you can use this option to fix the discrepancy. 

 

I'll be sure to pass along your feedback in my end.

 

In the meantime, you can visit our QuickBooks Blog to know more about our latest happenings. From there, you'll get the recent news, features, and updates about QBO and what our Product Team is working on. 

 

Should you have other questions, do let me know. I'll be here to help. Have a great day!


 

Highlighted
QuickBooks Team

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

Good day, @evmo.

 

At this time, the site offers the most commonly used features. We haven't updated any features as of the moment, and there will be a notification that will be sent out if there’s an update.

 

To keep up with what’s new in QuickBooks, check out our blog page by clicking this link here (https://quickbooks.intuit.com/blog/).

 

Let us know if you have any other concerns. We'll be around to help. Take care.

 

 

Highlighted
Level 2

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

@perhub I feel your pain as well.  How are you handling this since posting your question?

Highlighted
Level 1

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

I've been reconciling the sub-cards individually, and generating a "bill" when prompted at the end of the reconciliation.  Make sure the payee of this bill is the master credit card account.  Due date is the due date of the credit card payment.  

Then use bill pay to pay all of the cards on one check/bill payment. 

 

Highlighted
Level 1

How do you correctly reconcile a credit card payment when you have multiple users on CC and payment just goes to match the main user with the payment transaction?

I've been reconciling the sub credit cards individually, and choosing to enter a "bill" at the end of the reconciliations.

Make sure the Bill payee is the master credit card Vendor.

Then use "Bill Pay" to pay all of the credit card sub accounts at once on the due date of the master card.

I still struggle with credits on the account.  Our bank has an automatic draw against the card, but they take the balance less any new credits on the account.  I am struggling to handle that cleanly.

Need to get in touch?

Contact us