cancel
Showing results for 
Search instead for 
Did you mean: 
ArtyFacts123
Level 3

Entering multiple credit card statements on new QB file and how to get opening balance correct?

Hi there!

I created a new QB company file for a client, and needs to me to enter their credit card statements transactions starting with January 1, 2024.  This credit card is a personal credit card with some business transactions, and I don't have access to the payment source data (ie. their checking account statements, etc.).

 

The first credit card statement given to me has a previous balance and also shows a payment credited as well.  To make this more fun, our office policy when setting up a new QB file is to NOT use Opening Balance Equity for any bank/credit card accounts - but rather to manually enter opening balance as a Journal Entry with Owner Equity as the account. 

 

So I have two questions:

1) What is the best way to record the previous month's payment?  Just enter it as a "credit card payment" and the Account could be "Shareholder Distributions"?  Right now I just have it as "Ask My Accountant".

2) When I try to reconcile this first month, the opening balance says zero - even though the register's balance on 1/1/2024 says the "correct" amount.

 

What's the best way to do this?

 

Thanks for your time!!

1 Comment 1
LeizylM
QuickBooks Team

Entering multiple credit card statements on new QB file and how to get opening balance correct?

Setting up the credit card account and ensuring the opening balance is reflected correctly in QuickBooks Desktop (QBDT) is our top priority,

ArtyFacts123.

 

Since the credit card has a previous balance and a payment credited, how can you record it in QuickBooks:

 

First, we can create a journal entry to record the payment. I'll show you how:

 

  1. Navigate to the Company menu and select Make Journal Entries.
  2. Fill out the fields to create your journal entry. Make sure your debits equal your credits when you're done.
  3. Select Save or Save & Close.

 

To record the transactions with details, we can create a sales receipt or checks for customer payments.

 

When selecting the correct account, I suggest consulting your accountant. They can provide guidance based on your specific business needs and accounting practices.

 

Based on your description, it seems you entered the opening balance during account creation. However, you inadvertently recorded the opening balance equity under the owner's equity account. As a result, your account balance is accurate even though you didn't specifically add the opening balance.

 

I'm always prepared if you have more questions or concerns with your QuickBooks opening balance. Kindly leave a comment below, and I'll promptly lend a hand.

Need to get in touch?

Contact us