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

Credit card balances and Trial balance entries

I am setting up quickbooks for the first time and need to enter the balance owed on several credit cards for the business.  I entered the balance as a bill and coded it accordingly; ie: supplies/ subscriptions / cogs / etc

however, the balance does not show in the credit card register. 

I also need to key in the trial balance amounts but am not sure how to do that.  My quickbooks is connected to ESC software and I need to move these amounts into quickbooks.

Solved
Best answer January 24, 2020

Best Answers
ReymondO
QuickBooks Team

Credit card balances and Trial balance entries

Let me help you record your past transactions in QuickBooks, @mlanclos.

 

If you need to record a large transactions from the past years in QuickBooks Desktop, this will usually takes a lot time to input these files in the system. However, you can lump sum the total amounts for these vendors charges by months, quarters or even years to easily record this payments.

 

Let me show you how:

 

  1. Go to the Vendors menu and click Vendor Center.
  2. Click New Vendor to add new vendor, if you already have the vendor, you can proceed to the next step.
  3. Right-click the vendor's name and select Enter Credit Card Charges.
  4. In the MEMO field, type Lump sum.
  5. Enter the desired information below and click Save and Close.

You'll also want to reconcile your accounts so they will match to your bank and credit card statements in QuickBooks.

 

Let me know if you need more help in recording your transactions in QuickBooks. I'm always here to provide more help.

View solution in original post

6 Comments 6
Emily M
QuickBooks Team

Credit card balances and Trial balance entries

Hi, @mlanclos.

 

Let’s work together and resolve the credit card balance not showing up in the register. You can set up your credit card account in QuickBooks Desktop. Connecting the account to QB keeps tracks of charges and payments that are made for an expense.

 

Here’s how to set up a credit card account:

 

  1. Pick the Settings, then Chart of Accounts.
  2. Choose Account, then click New.
  3. Locate the Credit Card, then hit Continue.
  4. On the Add New Account window:
  5. Type the Credit Card Name. Note: If you are setting up a sub-account, you need to check the Subaccount of. From the drop-down, choose the parent credit card account. 
  6. Select an option under When do you want to start tracking your finances from this account in QuickBooks?
  7. Enter your account's balance.
  8. Select Save Close.

 

Next, you’ll want to enter the credit card charges. This puts the amount you owe in the credit card in the Chart of Accounts.

 

  1. From the Banking menu, go to the Enter Credit Card Charges.
  2. Find the Credit Card drop-down, then choose the appropriate account.
  3. Purchase/Charge should be automatically selected. If you want to record credit or refund you received through the credit card, select the Refund/Credit instead.
  4. Pick the Purchased From drop-down and click the vendor.
  5. Make sure the date is correct.
  6. Go to Expenses or Items tab and enter the expenses/items you want to track.
  7. Push Save and Close.

You may also record a business expense that was paid for by a partner or owner’s funds.

 

  1. Go to the Company menu.
  2. Click on Make General Journal Entries.
  3. (Optional) In the Make General Journal Entries window, change the Date field.
  4. The Entry No. should automatically populate
  5. On the first line, specify the appropriate expense Account for the purchase.
  6. Enter the amount of the purchase in the Debit column.
  7. On the second line, in the Account column, enter the Owner's equity or Partner equity (if the account isn't listed, create the account).
  8. In the Credit column, enter the amount of the purchase.
  9. Select Save and close.

 

Once done, you can now record the reimbursement as a check/expense:

 

  1. Go to Banking at the top menu bar.
  2. Select Write Checks.
  3. Fill in the necessary information and select the Bank/Credit account you are reimbursing from.
  4. Choose Partner's Equity or Owner's Equity under the Account column.
  5. Enter the amount of the reimbursement.
  6. Pick Save and close.

 

Trial Balance reports from a 3rd party software can be imported into QBDT.

Let me guide you on how to import that data:

 

  1. Go to File menu > Utilities > Import > Excel Files.
  2. If you get the Add/Edit Multiple List Entries window, click No.
  3. Follow the wizard in importing files. Select the type of data. QuickBooks opens a formatted excel spreadsheet.

 

 

For additional information about setting up, using, and paying credit card accounts following the link below:

 

https://quickbooks.intuit.com/learn-support/en-us/chart-of-accounts/set-up-use-and-pay-credit-card-a...

 

Here are a couple of articles about the personal and business expense:

 

https://quickbooks.intuit.com/learn-support/en-ca/expenses-suppliers/pay-for-business-expenses-with-...

 

https://quickbooks.intuit.com/learn-support/en-ca/expenses-suppliers/pay-for-personal-expenses-from-...

 

Should you have other questions, let me know. I’m happy to help.

mlanclos
Level 1

Credit card balances and Trial balance entries

There is a large balance on these credit cards being that we have only been paying the minimum amount due each month for the past few years. Do I need to go back and enter all of the vendor charges from years back?

ReymondO
QuickBooks Team

Credit card balances and Trial balance entries

Let me help you record your past transactions in QuickBooks, @mlanclos.

 

If you need to record a large transactions from the past years in QuickBooks Desktop, this will usually takes a lot time to input these files in the system. However, you can lump sum the total amounts for these vendors charges by months, quarters or even years to easily record this payments.

 

Let me show you how:

 

  1. Go to the Vendors menu and click Vendor Center.
  2. Click New Vendor to add new vendor, if you already have the vendor, you can proceed to the next step.
  3. Right-click the vendor's name and select Enter Credit Card Charges.
  4. In the MEMO field, type Lump sum.
  5. Enter the desired information below and click Save and Close.

You'll also want to reconcile your accounts so they will match to your bank and credit card statements in QuickBooks.

 

Let me know if you need more help in recording your transactions in QuickBooks. I'm always here to provide more help.

mlanclos
Level 1

Credit card balances and Trial balance entries

Thank you!  I was told I need to enter the trial balance in a journal entry.  Can you help me with that?

mlanclos
Level 1

Credit card balances and Trial balance entries

I need to enter the trial balance as a journal entry.  Can you help me with that as well please?

Kristine Mae
Moderator

Credit card balances and Trial balance entries

I can help you with entering a journal entry, Mlanclos.

 

Just follow these steps:

  1. Click the Company menu.
  2. Go to Make General Journal Entries.
  3. Fill in the necessary fields.
  4. Click Save & Close.

As always, I suggest conferring with your accountant with the categorization of the trial balance accounts.

 

I'll add the article about creating a journal entry in QuickBooks Desktop for more details. 

 

Tap me if you have more questions. I'll get back to you as soon as I can. 

Need to get in touch?

Contact us