Live Support
+1-802-778-9005A certificate of Deposit is when a small business deposits an amount of money to a bank. The bank will provide a higher interest rate than a normal savings account in exchange for the small business promising to keep the funds in the bank account for a set amount of time. In accounting, a certificate of Deposit is referred to as an asset, more or less equivalent to cash, so often companies will lump certificates of deposits into cash.
In QuickBooks, recording the Certificate of Deposit is important for maintaining accuracy and efficiency with your bank or credit card transactions. Businesses need to organize their financial records for better decision-making and cash-flow management. This involves a lot of banking transactions, such as deposit slips, which need to be managed carefully to make sure that every Transaction is recorded and matched with the bank statement.
You often deposit multiple payments from different sources at once when you deposit money at the bank. The bank usually records everything as a single record with one total. If you enter the same payments as separate records in QuickBooks desktop, you won’t be able to match how your bank records the Deposit.
In such cases, QuickBooks has a different way for you to combine everything so your records match your real-life bank deposits. Put transactions you want to combine into your Undeposited Funds account and then record a bank deposit to combine them. Here’s how to record and make bank deposits in QuickBooks Desktop.
If you haven’t already, put the transactions you want to combine into the Undeposited Funds account.
Here’s how:
Head to the Edit menu and then choose Preferences.
Select the Payments from the list. Then, hit the Company Preferences tab.
Click and uncheck the Use Undeposited Funds as a default deposit to account checkbox.
Press the OK button.
Now, you can select Undeposited Funds or another account each time you create a sales receipt. Below are the steps to do so:
Choose the Create Sales Receipt option on the Homepage.
Select the customer from the Customer dropdown menu.
Click on Undeposited Funds from the Deposit to dropdown menu.
Fill out the rest of the form.
Press the Save & Close or Save & New tabs.
Tip: Always review the “Deposit to” field so you know where your payments are going.
If your bank records a single payment as its own Deposit, you don’t need to combine it with others on QuickBooks desktop. You can put the payment directly into an account instead and skip Undeposited Funds.
If you have your deposit slip from your bank, you’re ready to record the Deposit in QuickBooks desktop.
Choose Record Deposits/ Make Deposits from the Homepage.
Under the Payments to Deposit window, select the payments you want to combine. Then hit OK.
On the Make Deposits window, click the account you want to put the Deposit into from the Deposit to dropdown.
Check the total Deposit. Make sure the account and selected payments match the deposit slip from your bank. You can use your deposit slip as a reference.
Enter the date you made the Deposit at your bank.
Add a memo as required. Then, press Save & Close once you’re done.
Each bank deposit is a separate record, so make deposits one at a time for each of your deposit slips.
If you want to put your Deposit into multiple bank accounts, adhere to the steps below:
Choose Record Deposits / Make Deposits on the Homepage.
Select the payments you want to combine under the Payments to Deposit window. Then, press OK.
On the Make Deposits window, click the account you want to put the Deposit into from the Deposit to dropdown.
Add a new line in the payment you want to put into a second account.
Choose the second account under the From account dropdown on the second line. Then, type the amount you want to put into the second account as a negative value. You can enter the entire amount or part of it.
In this instance, we received three payments from the same customer. We’re moving the third one to a savings account and the other two to checking.
Hit the Save & Close icons once you’re ready.
Review Past Bank Deposits
To see past deposits and the transactions you combined, follow these steps:
Navigate to the Reports menu and then click on the Report Center.
Choose the Banking section.
Find the Deposit Detail report and then hit the Run icon.
The Report lists all of your recorded bank deposits. You can select individual deposits to get more details.
Delete a Bank Deposit
If ever you need to start over, you can delete a bank deposit. Here are the steps to be followed:
Hover over the Reports menu. Then, click on the Report Center.
Choose the Banking section.
Find the Deposit Detail report and then hit the Run icon.
Search and open the Deposit you want to delete.
You’ll see all the payments included on the Deposit under the Make Deposits window Review them and make sure you need to start over.
Hit right-click in the window and click Delete deposit. Then, Press OK to confirm.
All payments on the Deposit go back to your Undeposited Funds account. You can start over and then make a new deposit.
Record Recurring Deposits
You can make an existing deposit a recurring transaction if you regularly record the same deposits:
Go to the Banking menu and then select Use Register.
Search for and then open an existing deposit.
Hit right-click on the Deposit and then choose Memorize Deposit.
Click Automate Transaction Entry if you want QuickBooks to record the Deposit automatically. Otherwise, press Add to my Reminders List to get a notification to create the Deposit.
Under the How Often dropdown menu, select the frequency (monthly, weekly, daily, etc).
Set the start date for the recurring deposits in the Next Date field. The first recurring Deposit will start on the first day.
Type how many deposits you want QuickBooks to create in the Number Remaining field.
You can set how many days in advance QuickBooks will record the Deposit under the Days In Advance To Enter field. Type 0 if you want to record the Deposit on the day you choose.
Hit the OK tab when you’re done.
QuickBooks will automatically record the Deposit on the date and frequency you’ve selected.
The recorded amount on your checking account is a transfer transaction. While the recorded amount on your credit card is a payment transaction. Let’s see how to categorize the transactions accurately.
Choose Bank Transactions on the Transactions tab.
Click on your Checking account.
Under the For Review tab, select the Transaction that needs to be categorized.
Tickmark the 〇 Record as transfer, and then opt for the account you want the amount to be transferred to in the Transferred to.
Press Confirm to end the transfer categorization process.
On the Transactions tab, select Bank Transactions.
Choose your Credit card account.
Click the amount that needs to be categorized under the For Review tab.
Tick the 〇 Record as Credit card payment, and then choose the accurate credit card account on the Select credit card menu.
Press Confirm at the end.
When you download transactions from your bank, you are required to categorize them so you can go into the right accounts. However, if transactions are syncing without the need for categorization, you’ve likely set up bank rules. These rules automatically categorize transactions for you. Here’s how to undo the transactions.
Navigate to the Banking page and then choose the tile for the bank or credit card account you downloaded the Transaction from.
Locate the Transaction you want to unmatch from the Categorized tab.
Click Undo in the Action column.
On the Transactions tab, select Bank Transactions.
Select the bank account from which the funds are coming.
Find and select the Transaction to open it.
Select Record as a transfer. Then, from the Transferred dropdown, select the account where you transferred the funds.
Click Add.
Choose the bank account where the funds are going.
Hit the For Review tab and locate the Transaction.
Select Match from the Action column so the Transaction matches both accounts.
You are recommended to create a check or expense transaction to record the certificate of Deposit you’ve purchased. Here’s how:
Click the + New button under the left menu. Then, select Check or Expense.
From the Payee dropdown, choose the vendor you got the certificate of Deposit from.
Hit the account used to purchase the certificate in the Bank account (check) or Payment account (expense) dropdown menu.
Select the Category dropdown to pick the certificate of Deposit account for this vendor under the Category details section.
If you don’t have an account for the vendor yet, add an account to your Chart of accounts in QuickBooks Online. For this, do the following:
Add a New Account to your Chart of Accounts
Enter the amount of the certificate.
Press the Save and Close tabs.
Open the Chart of accounts, press NEW, and then choose an asset account, name it on the upper right side, and save. Use this account to create a Certificate of Deposit in QuickBooks. Here’s how:
Hover over Settings and then choose a Chart of Accounts.
Click New. You’ll either see a panel labeled New account or New category depending on your account view.
When you deposit money at the bank, you often deposit multiple payments from different sources at once. The financial institution usually records everything as a single record with one total. If you enter the same payments as separate records in QuickBooks, they may not match how your bank records the Deposit.
In such cases, QuickBooks has a special way for you to combine transactions so your records match your real-life bank deposit. Let’s discuss how to record bank deposits in QuickBooks Online.
If you haven’t already, put invoice payments and sales receipts you want to combine into the Undeposited Funds account. This account holds everything before you record a deposit.
You only have one Undeposited Funds account. Use it to hold all payments you need to combine and group together. You can choose the account in QuickBooks to put the Deposit into when you combine.
Important: QuickBooks Payments automatically processes and moves transactions into your accounts. You can also combine outside payments with these steps.
Transactions you download from your Banks and Credit Cards
QuickBooks automatically downloads all your transactions if you connect your bank or credit card accounts. You don’t need to combine downloaded transactions or use Undeposited Funds since QuickBooks already has the info from your bank. All you need to do is to categorize your downloaded transactions.
Click + New and then choose Receive Payment.
Select the Customer from the Customer dropdown menu. Then, tickmark the checkbox for the invoice you’re receiving payments for.
Choose Undeposited Funds from the Deposit to dropdown menu.
Fill out the rest of the form.
Press Save and send, Save and new, or Save and close.
Click + New and then choose Sales Receipt.
From the Customer dropdown menu, select the customer.
Click on Undeposited Funds under the Deposit To dropdown.
Fill out the rest of the sales receipt.
Press Save and send, Save and new, or Save and close.
Each bank deposit creates a separate record in QuickBooks. You are recommended to make deposits one at a time for each of your deposit slips.
Click + New and then select Bank Deposit.
Choose the account you want to put the money into under the Account dropdown menu.
Tick mark the checkbox for each Transaction you want to combine.
Make sure the total of the selected transactions matches your deposit slip. You can use your deposit slip as a reference.
Press the Save and New or Save and Close tabs.
Some banks add service charges and processing fees. Don’t edit the original transactions in QuickBooks add the fee instead while you’re on the Bank Deposit window:
Navigate to the Add funds to this deposit section.
Type the fee as a line item.
Select who the fee was from (like the bank charging you).
Choose Bank charges from the Account dropdown.
Input the amount fee as a negative number. For example, if the fee was S $ 50, enter –50.
Review the deposit total with the bank fee.
Press the Save and New or Save and close tabs.
Note: If you don’t have a bank charge account, here’s how to create one:
Go to Transactions and select Chart of Accounts.
Select New. In the Account pop-up, select Expenses from the Account Type dropdown menu.
Select Bank charges from the Detail Type dropdown menu.
Enter Name as Bank fees.
Select Save and Close.
Move to Reports.
Under the Sales and Customers section, choose the Deposit Detail report.
The Report lists all your completed bank deposits. You can select individual deposits to get more details.
Have you added a payment by mistake? Not an issue if you want to remove a specific payment from a deposit:
Head to Sales and choose All Sales.
Click View/Edit to find and open the payment you’d like to remove. The status should be Closed.
Unmark the checkbox for the payment you wish to remove.
Press the Save and New or Save and Close buttons.
The payment will go back to the Undeposited Funds account. You can easily add it to another deposit.
If you need to start over and delete a bank deposit, do the following:
Navigate to Transactions and then choose a Chart of accounts.
Find the bank account you put the Deposit into and then click on Account History.
Look for the bank deposit and select it to get more details.
Hit the Delete icon.
Press Yes to confirm.
All payments on the Deposit go back to the Undeposited Funds account. You can start over and create a brand-new deposit.
A certificate of Deposit (CD) is a savings account that holds a fixed amount of money for a fixed period of time, such as six months, one year, or five years, and in exchange, the issuing bank pays interest. When you cash in or redeem your certificate of Deposit, you receive the money you originally invested plus any interest. CDs (certificates of Deposit) are considered to be one of the safest savings options.