Introducing corporate credit cards in QuickBooks

Keywords: Credit card, Reconcile, Payee, Quickbooks

Credit: Intuit- Quickbooks Online  Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

The workflow for corporate credits in QuickBooks is the same as for any bank or credit card, in that you need to:

  • Set up the credit card account in the chart of accounts and connect it to the

Cardholder account.

  • Manage the transactions in the bank feeds.
  • Record payments made to the credit card account to pay down the balance
  • Reconcile the account when the credit card statement comes in

But, there are also some unique aspects to how corporate credit cards work that affect how you set them up and manage them in QuickBooks.

What’s different about working with corporate credit cards?

Corporate credit cards can be issued to multiple employees, with the company setting usage policies and limits for each cardholder.

Usually, one card is designated as the primary card. This may be a card to which only payments to pay down the balance and fees are applied (so no purchase transactions are made on it). Or the primary cardholder (the person who applied for the corporate card) may also use it to make purchases.

Here’s how a setup with three cardholders could look.

How are corporate credit cards set up in QuickBooks?

To set up a corporate credit card account with multiple cardholders in QuickBooks, you need to create a new parent account in the chart of accounts, and then add the individual cardholder accounts (including the primary) as subaccounts.

Next, you connect the subaccounts to the bank feeds from the credit card company. But, you don’t connect the parent account to a bank feed. If you do this, you wouldn’t be able to connect bank feeds to the subaccounts.

Setup: Creating new accounts in the chart of accounts In QuickBooks Online.

The first step to set up a corporate credit card with multiple cardholders, is to create a new parent account in the chart of accounts. To do this, go to the Chart of accounts from the General settings gear, top right of the screen, and select the New button. This opens the New account panel.

Select Credit Card for the Account type and Detail type.

To help you identify this account from the others, give the account a unique name—for example, you could call it Parent—together with the credit card business name (for example, BOA for Bank of America)

You can add a unique reference in the Description field, such as a note that this account is used to group the corporate credit card subaccounts—documenting this account’s place in the process.

Leave the Opening balance and As of fields blank. This parent account will never have a balance-it’s simply there to hold the group of subaccounts together.

Creating the subaccounts

Once the parent account is set up, you can move on to create subaccounts for each of the individual credit cards, starting with the subaccount that will be designated as the primary.

To create the subaccount, select the parent account you set up previously for the Save account under.

Select Credit Card for the Account type and Detail type.

Give the new subaccount a unique name so that you can easily identify it when recording transactions. For example, you could add the last four digits of the cardholder account to the name. As this is the primary subaccount, you may also find it helpful to include Primary in the name.

As with the parent account, you can add a unique reference in the Description field. You may want to identify the person this card is associated with. It’s a good idea to note that it’s the main account that receives payments and whether or not it will be used for credit card charges as well—again, documenting this account’s place in the process.

Leave the Opening balance blank, as before.

Adding the remaining subaccounts

Continue to add the remaining cardholder accounts as subaccounts, giving each one a unique account name and description. It’s a good idea to identify the cardholder and that the card is used for charging, but not payments—once again, documenting the accounts’ place in the process.

When you’re done, each subaccount should show as nested under the parent account in the chart of accounts.

Setup: Connecting the nonprimary subaccounts in QuickBooks Online.

You’re now ready to move onto the second setup task for working with corporate credit cards. This is connecting all the nonprimary subaccounts to the appropriate cardholder accounts to link the bank feeds. Remember, you’re not connecting the primary subaccount yet. To connect the nonprimary subaccounts, follow the standard process for connecting a bank or credit card account to the QuickBooks account. Once connected, each card will have its own tile in the Bank transactions tab and the credit card transactions will come into QuickBooks via the bank feeds, as usual. If you’ve only recently connected the subaccounts, you may need to select Update to get all the transactions to show. You can then manage the bank feed for each nonprimary subaccount in the same way you would for any bank or credit card account.

Setup: Deciding if and how to connect the primary subaccount in QuickBooks Online.

This final setup task is where it gets interesting. Whether you connect the primary subaccount to the credit card company—and which transactions you add from the bank feed—depends on:

  • How payments to the credit card are going to be recorded in QuickBooks, and
  • Whether the primary subaccount credit card is used for recording payments only, or if it’s also used to make purchases.

How are payments to the credit card going to be recorded in QuickBooks?

There are two recommended methods for recording payments, and the method you opt to use determines what you do with payment transactions that come in via the bank feed from the paying bank account.

Method 1

Enter payments manually by creating an expense transaction (from the payment bank account) to split them between the different subaccounts.

Use when

  • This is a good way to record payments if you’re paying off the full credit card statement balance and want to split the payment between subaccounts.

Method 2

Posting payment transactions from the payment bank account to the primary subaccount.

Use when

  • It’s a good technique if you’re not paying off the full balance and/or don’t want to split the payment.

Should you connect the primary subaccount credit card to the bank feeds if you are using Method 1: Entering payments manually by creating an expense transaction?

You should connect it when it’s used for both purchases and payments:

  • Add the purchase transactions—but not the payment transactions—to QuickBooks.
  • You’ll be adding payment transactions manually, so you need to exclude them from being added to QuickBooks Online via the bank feeds. You could do this by creating a rule to automatically exclude payment transactions from being added to the primary subaccount.

You shouldn’t connect it when it’s only used for payments:

  • You’ll be adding payment transactions manually.

Should you connect the primary subaccount credit card to the bank feeds if you are using Method 2: Posting payment transactions from the payment bank account to the primary subaccount?

If you’re using this method, you should connect the primary subaccount to the credit card company—regardless of whether the credit card is used for just payments or both purchases and payments. Transactions will come in automatically via the bank feeds.

QuickBooks will then automatically match the payment transactions to the corresponding transactions from the payment bank account (assuming the payment bank account is already connected to the bank feed).

Decision-making matrix

Here’s a summary of whether you should connect the primary subaccount to the credit card company—and how you should add transactions to the subaccount.

Overview of regular tasks

Now that you’ve seen how to set up corporate credit cards in QuickBooks, let’s get an overview of the regular tasks before you dive into details.

1. Record payments: expense

Depending on how the credit cards have been set up, you may be recording a credit card payment by creating an expense transaction and splitting the payment between the different credit cards. This is the quickest and cleanest method of recording a credit card payment if the full statement balance is paid off.

2. Record payments: primary subaccount

The other way to record payments is to post them to the primary subaccount. Again, this depends on how the cards have been set up. Remember, this method is good if the total credit card statement balance is not paid, or if you want to see the full payment amount on the credit card side—that is, you don’t want to split it.

3. Reconcile the parent account

Once you’ve set up the accounts, added purchase transactions, and recorded payments, when the monthly credit card statement comes in, you only need to reconcile the parent account, because all the balances from the subaccounts roll up into this account.

Regular task: Recording payments using an expense transaction in QuickBooks.

Let’s take a look at the first regular task, which is how to split a payment between the different credit cards using the Expense transaction. This is the quickest way of recording a payment if you’re paying off the full statement balance.

It can also be used for partial payments: you could allocate across accounts by percentage or by paying off all of one card and putting the rest of the payment (if any) on another.

  • Select the credit card company as the Payee.
  • For the Payment account, select the bank account that was used to make the payment.
  • Select each credit card subaccount from the Category dropdown list. Because you gave each subaccount a unique reference in their name, you can easily identify each one.
  • Including a description is optional, but a good idea for clarity.
  • Enter each nonprimary subaccount’s statement balance in the Amount column.

If the primary subaccount has purchase transactions, enter the total amount of the purchases in the Amount column too. However, don’t include any payments.

Things to consider for this method

Payment transactions will now match when they come through the bank feeds from the payment bank account. However, because you split the transaction on the credit card side, you won’t see the full amount of the payment in the primary credit card account.

The advantage of this method is that it splits the payment across the subaccounts, so when you look at the balance sheet, the balance of each subaccount is correct.

But the flip side is that you never see the full payment amount anywhere in the credit card registers and on the reconciliation screen, and you’ll need to manually reconcile the split transaction.

Regular task: Recording payments by posting them to the primary subaccount in QuickBooks.

Let’s move on to look at another of the regular tasks for working with corporate credit cards-posting payments to the primary subaccount. Remember, you would use either this method or the expense transaction method for recording payments to one set of corporate credit cards. For consistency, you shouldn’t use both methods for the same credit card account.

Posting payments to the primary subaccount is good if you’re not paying the total credit card statement balance or if you’d rather see the full payment amount on the credit card side-that is, you want to see the total credit card payment during reconciliation.

Identified as a paired transaction.

To post the payment to the primary subaccount, go to the For review tab of the bank feed from the payment bank account, and look for the payment transaction.

If QuickBooks finds a corresponding payment to the primary credit card subaccount for the same date and amount, it will flag it (for both the payment bank account and the primary subaccount) as Paired to another transaction.

The matching transaction in the bank feed from the primary credit card subaccount will also be flagged as Paired to another transaction.

Record as a credit card payment

To add the transaction as a credit card payment, select View for the transaction in the payment bank account, then select Record as credit card payment.

When you add the payment transaction from the paying bank account, QuickBooks will record the transaction and match it on the credit card side.

An unconnected primary subaccount

If you don’t have the primary subaccount bank feed connected, you can still record the payment to this subaccount, but a paired transaction would not show. Instead, when the payment clears the payment bank account, you would code it to the primary subaccount. You would see the payment when you reconcile the parent credit card account.

It’s important to note, that you don’t have to connect the primary credit card account to the bank feed, because there are times when it’s not possible to do so.

Create a rule to post future payments to the primary subaccount

You could create a rule to post future payments, like the previous example, to the primary subaccount.

Set up the rule as a Money out transaction and only apply it to the paying bank account, not the receiving credit card account.

Set a condition that the Bank text Contains. Then enter a unique identifier from the credit card account bank details so QuickBooks knows that these transactions are payments to the credit card. The unique identifier could include the last 4 digits of the primary credit card.

Select Credit card payment as the Transaction type and select the primary subaccount in the Credit card field. Add the name of the financial institution in the Payee field.

Once you know the rule is working, you could also set it to Auto-add so that neither you nor your customer will even have to look at it. When you’re ready, select Save.

Advantages and disadvantages

There are a few things to consider when posting to the primary subaccount to record payments.

Advantages

This method has a few advantages. First, you can add payments to bank feeds (if posting to the primary subaccount and it’s connected) and these payments will match the statement.

Second, you can record the payment as a credit card payment transaction, ensuring that it’s categorized accurately.

Another advantage is that you can make more than one payment in a statement period. This means that if the credit limit is reached, a payment can be made mid-month and more charges can then be added to the card. Also, it means that if you have multiple bank accounts, you can make payments from more than one account each month.

Finally, if the primary account isn’t connected, you can have payments recorded automatically.

Disadvantages

A disadvantage of this method is that you have to create a journal entry to zero out the credit card liability across all the subaccounts (which you’ll look at next). This is because the payment is posted to the primary subaccount.

But note that you will want to do this—some will let the balances remain on the primary and subaccounts, knowing that the parent shows the total credit card balance correctly.

To correct or zero out the subaccount balances, you need to transfer the balance from the nonprimary subaccounts to the primary subaccount via journal entry. But again, this is something that you will not want to do, as the overall parent account balance is correct.

If you did not want to allocate the payment across subaccounts, you can zero out the subaccount balances each month, and the balance for the whole credit card (if one remains at month end) sits in the primary. But again, the overall parent account balance remains unchanged and correct.

Regular task: Reconciling the parent account in QuickBooks Online.

The final regular task is to reconcile the parent account.

You only need to reconcile the parent account and not the subaccounts, because all transactions in the subaccounts automatically roll up into the parent.

If you reconcile the subaccounts, any reconciled transactions will disappear from the reconciliation window for the parent account. So if you reconcile one subaccount, you’ll have to reconcile them all. If you have multiple cardholders on a credit card account, reconciling each subaccount individually could be a time-consuming task. By reconciling the parent account, you take care of all the subaccounts in one go.

When doing the reconciliation, keep in mind that charges and interest show as separate purchase transactions. Because the parent is not connected, you have the option to enter the charges manually, but if the primary account is connected through bank feeds, charges and interest will be added through bank feeds—so you don’t need to add them again on the first screen of the reconciliation.

What to look out for when reconciling a parent account.

If you added a split payment (using an expense transaction), you have to manually mark the splits as cleared. The split should total the amount of the payment. You’ll also need to clear a payment manually if you didn’t connect the primary subaccount to bank feeds.

You’ll need to clear any journal entries that you added (they will offset each other).

Because the parent account has no transactions posted to it and is not connected to any bank feeds, it does not show the cleared data column. So you may have to uncheck transactions that have not cleared yet. For example, purchases may have been made at the end of the month that won’t be posted on the account until the following month’s statement.

Correcting the subaccount balances

You should correct the credit card subaccount balances after you reconcile the parent account. You’ll see how to carry out the reconciliation in the next section.

Create a journal entry to transfer the amount of the liability on the statement for each nonprimary subaccount to the primary subaccount. Some statements won’t show the balance of each nonprimary subaccount, just an overall combined balance. Date the journal entry as of the credit card statement date. Debit each nonprimary subaccount for the total amount of their purchases (less any credits). Credit the subaccount with the sum of the liabilities of the nonprimary subaccounts.

Before, the primary would have a negative balance and the other subaccount would have a positive balance. The journal entry puts the total balance of the credit card into the primary subaccount. The credit card account balance will now look like this. Remember, the total balance of the credit card due at any time is the balance of the parent account.

To save time, you could create his journal entry as an unscheduled recurring transaction. Because the total amount of the liability for each subaccount will be different each month, you shouldn’t enter any dollar amount in the Debit and Credit columns. Instead, you could add some guidance in the description field, explaining which items should be debited and which ones should be credited.

Reviewing the subaccount balances

With the accounts set up and reconciled, you’re almost done. The final thing to do is check the account balances and registers to make sure everything is shipshape and ready to go.

First, run a Balance Sheet report as of the credit card statement date. If you split the payment between the subaccounts, the subaccounts will show their respective liability balances as of the statement date (as shown on the first balance sheet).

If you posted the credit card payments to the primary subaccount, then created a journal entry (dated as of the credit card statement date) to correct the subaccount balances, the total liability will show up in the primary subaccount and the nonprimary subaccounts will show a zero balance (as shown on the second balance sheet).

Note that if you had to uncheck transactions at the end of the month that didn’t clear on the current statement, the subaccounts might have balances. Or if a journal entry wasn’t made to put the balance all on the primary, there could be balances on the subaccounts.

Check out our Free Additional Articles