How to Record Certificate of Deposit in QuickBooks Desktop and Online?

There are many stages involved in maintaining a Certificate of Deposit (CD) in QuickBooks to make sure your investment is appropriately reflected in your financial records. Banks provide certificates of deposit (CDs), a sort of time deposit with a set duration and typically a fixed interest rate. Accurate accounting records and effective account reconciliation are facilitated by appropriately recording and monitoring a CD. This is a thorough tutorial on how to record Certificate of Deposit into QuickBooks.

About Certificate of Deposit

A time deposit known as a Certificate of Deposit is made by depositing a large amount of money with a financial institution for a predetermined period of time, which can be anything from a few months to many years. The organization gives interest at a set rate in exchange, which is typically more than what is given by traditional savings accounts. This is a thorough explanation of what a CD is and how it functions:

Important Elements

1. Fixed Term:

A CD’s duration can vary greatly, ranging from a few weeks to ten years. In order to receive the guaranteed interest rate, the depositor consents to keep the funds in the account for the duration of the period.

2. Minimum Payment:

A few hundred to several thousand dollars is the minimum deposit required for most CDs, depending on the banking institution and the particular CD product.

3. Unchanged Interest Rate:

A fixed interest rate on certificates of deposit (CDs) is greater than on most money market or savings accounts. Predictable returns are provided by the rate being locked in for the term.

4. Safe Deposits:

The Federal Deposit Insurance Corporation (FDIC) insures CDs provided by banks in the United States up to the maximum amount allowed by law ($250,000 per depositor, each insured bank, for each account ownership type). Likewise, credit union CDs are similarly limited and guaranteed by the National Credit Union Administration (NCUA).

How Certificates of Deposit Operate?

  1. Deposit: At a financial institution, you make a certain amount of money transfers into a CD account.
  2. Term: For a predetermined amount of time, the institution promises to pay you interest at a given rate.
  3. Interest Accrual: Depending on the conditions of the CD, interest is usually paid either at maturity or on a recurring basis. Interest accumulates during the life of the CD.
  4. Maturity: You will get your initial investment back along with the interest that has accumulated at the conclusion of the period. After that, you have the option of taking the money out or investing it in another CD.

How to Record Certificate of Deposits in QuickBooks (Desktop and Online)

Setting up a Certificate of Deposit (CD) account, documenting the initial deposit, monitoring interest revenue, and overseeing the CD’s maturity or redemption are all part of registering a CD in QuickBooks. The processes for QuickBooks Desktop and QuickBooks Online differ somewhat. This manual applies to both versions:

Record Certificate of Deposits in QuickBooks Desktop

1. Create a Fresh CD Account

Open Chart of Accounts

Establish a New Account

  • After choosing “Account,” click “New.
  • Select “Bank” as the kind of account. In terms of how they are treated financially, certificates of deposit (CDs) are comparable to savings accounts.

Enter Your Account Information.

  • Call the account something like “Certificate of Deposit – [Bank Name].
  • Enter the account number and any other pertinent information.
  • To “Save & Close,” click.

2. Record the Original Deposit

Make a Deposit

  • On the “Banking” tab, select “Deposits.
  • Click “Cancel” if the “Payments to Deposit” window shows up.

Choose the CD Account.

  • From the “Deposit To” dropdown box, select the CD account that you created.

Put Deposit Information Here

  • Enter the first deposit amount.
  • If necessary, provide a notation (such as “Initial deposit for CD“).
  • To “Save & Close,” click.

3. Track Interest Earnings

Deposit Money to Earn Interest

  • On the “Banking” tab, select “Deposits.
  • From the “Deposit To” dropdown menu, choose the CD account.

Enter Your Interest Information

  • Enter the interest that was earned.
  • For “Interest Income,” choose or establish an income account.
  • If desired, provide a notation (e.g., “Interest earned on CD“).
  • To “Save & Close,” click.

4. Note CD Redemption or Maturity

Deposit Money

  • Head over to the “Banking” tab and choose “Deposits.
  • Select the CD account using the “Deposit To” dropdown menu.

Enter the Amount of Maturity

  • Include principle and interest in the total amount received.
  • Include a memorandum, such as “Maturity of CD – [Bank Name]“.
  • To “Save & Close,” click on it.

5. Reconcile the CD Account

Balance the Account

  • Click on the “Banking” menu and choose “Reconcile“.
  • Reconcile the CD account with your bank statement by following the instructions.

Record Certificate of Deposits in QuickBooks Online

The certificate of deposit you have acquired may be recorded in QuickBooks Online by creating a check or expenditure transaction. Allow me to explain how:

  1. Click the + New button in the left menu.
  2. Pick either Expense or Check.
  3. Choose the vendor from whom you obtained the certificate of deposit from the Payee dropdown menu.
  4. Choose the account that was used to buy the certificate from the dropdown menu under Bank account (check) or Payment account (expense).
  5. To choose the certificate of deposit account for this vendor, click the Category option in the Category information section.
  6. Enter the certificate’s amount.
  7. Choose Close and save.

Conclusion

Financial institutions provide low-risk, interest-bearing certificates of deposit (CDs), which are perfect for people looking for assured returns on their money and who can commit to the account for a predetermined amount of time. In QuickBooks Desktop and Online, documenting a Certificate of Deposit entails creating the account, logging the first deposit, monitoring interest earnings, and overseeing the CD’s maturity or redemption. Although the procedures in the two versions differ significantly, they both adhere to the same broad guidelines to guarantee correct financial records and efficient account administration.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-800-596-0806 or chat with experts.


Frequently Asked Questions

Can I use QuickBooks to Track more than one CD?

Yes, you may monitor numerous CDs in your Chart of Accounts by creating distinct accounts for each CD. To set up and record transactions for every CD account, use the same procedures.

What if the CD Interest Rate Changes before Maturity?

You might need to make necessary adjustments to the interest income entries if the CD’s interest rate changes (variable rate CDs, for example). Make sure you promptly update the CD account with any new rates or modifications.

How do I deal with Fines for Early Withdrawal?

If you have to take money out sooner than expected and pay a penalty:

Keep track of the fine as a cost. If one doesn’t already exist, you can establish an expense account called “CD Early Withdrawal Penalty.

What if I Need to Eeinvest the CD proceeds?

If you roll over the CD or reinvest the proceeds into a new CD:

  • Create a new CD account for the new CD.
  • Record the rollover as a deposit in the new CD account.
  • Adjust or close the old CD account if necessary.
  • After deducting the penalty, deposit the remaining funds and update the balance of the CD account.
close btn

Get Your Case Study

Call Now+1-800-596-0806
Top