How to Enter Tenant Security Deposits Correctly in QuickBooks

How to Enter Tenant Security Deposit Correctly in QuickBooks

Tenant security deposits are not income and as such, they are to be held until tenant is giving up lease or given notice to leave. If at this point there are repairs to be done, the cost of the total repairs will be deducted and the remainder of the deposit returned to the tenant.

Here is how you enter tenant security deposits correctly in QuickBooks:

  • Create an account in your chart of accounts called Tenant Security Deposit, with its type “Other Current Liability”. To do this: a) Select List from the top menu bar, then Chart of Accounts. b) At bottom left, click on the plus sign (in the mac version) or Account then New (in the Windows version – Pro, Premier, Enterprise). Next:
  • Go to Banking, Make Deposits and enter the correct date, the tenant’s name in the “Received From” column, select the liability account you just created in the “From Account” column, and enter the payment type, reference number, memo, and amount of the deposit. Be sure to select the bank account you will deposit the tenant’s security deposit to, at the “Deposit to:” drop down option at top left.
  • Click Save, Save and New or Save and Close.

In QuickBooks Online, a) Go to Transactions in the left menu bar, then select Chart of Accounts then New at top right of screen. Next:

  • Go to the Plus sign at top center of screen, then select Bank Deposit under “Other”
  • Enter the correct date, the tenant’s name in the “Received From” column, select the liability account you just created in the “Account” column, and enter the payment type, reference number, description, and amount of the deposit. Be sure to select the bank account you will deposit the tenant’s security deposit to, at the top left drop down option.
  • Click Save and New or Save and Close at bottom right.

Any question(s), please feel free to browse our Frequently Asked Questions categories or drop Marie a note.

Why are Some Deposits Still in Undeposited Funds Account in QuickBooks and How Do I Fix This?

Why are Some Deposits Still in the Undeposited Funds Account in QuickBooks and How Do I Fix This

In order to use the undeposited funds correctly, it is important to understand how it really works. What are undeposited funds? Think of the Undeposited Funds account as an envelope where you keep checks until you take them to the bank. If you deposit more than one check or payment in a group deposit, you can enter those transactions so that your Bank Register matches your Bank’s monthly statement.

How to Accurately Use the Undeposited Funds Feature in QuickBooks

To use the undeposited funds accurately:

  • When you record each customer payment, choose Group with other undeposited funds instead of Deposit to a Bank account.
  • When you have all the checks entered and you are ready to actually deposit them in your bank, use Bank Deposits which is found under the Plus Sign Icon at the top of QuickBooks Online. In the desktop versions, go to Banking in the menu bar, and select Make Deposits.
  • In the Bank Deposits or Make Deposit screen, click the drop-down to select the bank account you would like to deposit the funds to. This would of course be the bank account that you actually put the money in.
  • Select the appropriate Date, and class or location if you are using them.
  • You will see a Payments section. These payments listed are the ones you recorded and marked to go to undeposited funds. You can now select which of these payments should be included in this deposit to reflect the lumpsum deposit that was actually made to the bank.
  • Click Save.
  • In order for this process to be successful, you must remember to go to the Bank Deposits window (in QuickBooks Online) or the Make Deposit window (in the desktop versions – Pro, Premier), and deposit the monies to the bank register in QuickBooks. Otherwise, they will just sit there, and if someone else is doing the reconciliations at the end on the month, they may actually enter those payments again directly to the bank register without realizing or even knowing that they were already in the Undeposited Funds account.

    As you can see, there are still deposits in your undeposited funds account because the proper procedure was not followed. If the accounts were already reconciled for the period in which the transactions in the undeposited funds account relates, then the entries were entered twice – incorrectly increasing the revenue and may require an amended tax return to be filed if the tax for that period was already done.

    I have explained indepth how to correct this in my articles:

How Important is it to Use the Undeposited Funds Feature in QuickBooks?

The Importance of Using the Undeposited Funds Feature in QuickBooks

The main purpose of the undeposited funds feature in QuickBooks, is to give users the option of receiving customer payments and applying them to their Invoices on the dates received, while having a place to house them until they are ready to be deposited to the actual bank account. This is called “grouping deposits” in QuickBooks to reflect the lumpsum deposit that was made on a particular date. The undeposited funds feature can be a huge time saver, especially when it comes to reconciling bank accounts. You should absolutely use the undeposited funds feature:

  • If you do not deposit each payment received from customers individually. If each deposit is done separately at the bank such as payments received from PayPal, Square, Shopify etc., there is no need to use the undeposited funds feature. If you receive customer payments via check or cash and you combine them to make one deposit into your bank account, then you need to post the individual payments to undeposited funds first. You will later go to Make Deposits and select the customer payments that made up the total deposits that were actually deposited on a specific date. You will need to ensure you change the date for the deposit in the “Make Deposit” window to reflect the date the deposits actually went into the bank. So, you use the undeposited funds when more than one payment is included in a deposit. That way the deposit in QuickBooks matches the deposit on your bank statement which will make it easier when it’s time to reconcile the bank account.
  • If you do not use the undeposited funds, then the amount is recorded directly in the check register. So, if you actually deposited several checks at once, you can imagine what a nightmare it becomes when you try to reconcile the checkbook. It creates lots of extra work – needlessly. If you use undeposited funds, then you “make deposits” that match the deposits you sent to the bank, which makes life much easier!

  • When checks are received and not immediately deposited in the bank. This way, you will know the day the checks arrived and the day they were deposited. Using the undeposited funds feature in this case, will allow you to record the customer payments for the date in which they were received, and thus show accurate customer receivables while at the same time being able to deposit them on the date they were actually deposited. Without using the undeposited funds, it may be difficult to figure out what payments in QuickBooks make up what deposits on the bank statement when it’s time to reconcile the bank account.

When all is said and done, it is better to use the undeposited funds feature for all deposits, than to not use it for any deposits at all – especially deposits of more than one customer payments. You will have a more seamless, less time-consuming reconciliation process which is super important.

How to clear undeposited funds that were entered in error

If “in error” you mean that the transactions were to be sent directly to the bank account register instead of the undeposited funds account, then you can correct this either by: a) locating and editing the individual payments in question and changing the “Deposit to” field to the bank account. Or, b) you can deposit each payment in the “Make Deposit” window to the bank account by checking each one and changing the date to reflect the date it was actually deposited.

If “in error” you mean that the deposits were doubly entered; once directly in the bank via the check register, and again in the undeposited funds account, the cleanest, but also most time-consuming way to clear these items from the undeposited funds account or “Make Deposit” window is to open the corresponding deposits that were made without selecting from undeposited funds, click on the green Payments button, add the payment from undeposited funds, and then delete the incorrect payment that was entered. As long as the total deposit is unchanged, it will not unreconcile the previous reconciliations. However, if there are a lot of transactions in the undeposited funds account, it could take a really long time trying to resolve this. Why can’t I just delete them? You may ask. It is never okay to just delete anything from QuickBooks without knowing what other accounts and transactions may be affected. These customer payments in the undeposited funds account or make deposit window, may have been applied to Invoices. Deleting them will throw the accounts receivables out of balance, leaving the customers owing more in QuickBooks than they actually do in reality.

Bear in mind that most people who bypass undeposited funds use a revenue account to make the deposits, which means the revenue is possibly overstated – if those deposits are again applied to Invoices and are sitting in the undeposited funds account. So if you are trying to correct a period that you have already filed tax returns for, you will need to discuss this with your tax professional. You may need to file an amended tax return.

How to Clear Items from the Make Deposit Window in QuickBooks for a Past Period that Was Already Reconciled

Clearing items from the make deposit window

Since the accounts were reconciled for the period in which the deposits relate, it means that the same revenues were reentered directly to a bank account register without realizing that they were already entered, and are in the “undeposited funds” account waiting to be deposited to the bank from there.

The fix will depend on the number of transactions involved. If not many deposit entries, here is what you do:

 Few Deposits Fix

1) Locate the previous corresponding deposits in the bank account register and make note of their dates.

2) Make sure they are each the same amount as the deposits in the “Make Deposit” window. (You want to keep the deposits in the month they belong so as not to throw off the previous reconciliations).

3) Check to ensure that the dates in the “Make Deposit” window match the dates in the register, or at the very least, are in the same month. (The aim is to remove the entries from the “make Deposit” window without throwing off the previous reconciliations).

4) Now, go ahead and make the deposit(s) from the “Make Deposit” window for each amount(s) that were previously entered in the register, making sure you change the deposit date to reflect the previous deposit in the register as well.

5) Go back to the bank register and delete the previous deposits that were reconciled. (NOTE: Your deposits that you just made from the “Make Deposit” window should be shown either above or below the previous corresponding deposit with the same date).

6) Next, for QuickBooks Mac Pro or QuickBooks Online: checkmark each corresponding deposit that you have just deposited, as reconciled. (With the exception of the switching of the deposits, the previous reconciliations will remain the same, with accurate opening balances for each month). For QuickBooks Windows Pro/Premier: undo the previous reconciliation(s) to the first month affected by the deposits you deleted, and re-reconcile from there onward. All the deposits you entered will be there in the reconcile window for you to check off, and you will be in balance in minutes if you deposited them all accurately. (You can use the “Mark All” feature in the reconcile window by checking the box “Hide transactions after statement end date” and clicking “Mark All”. In most cases, this will reconcile the account for that month and show a $0 difference in the reconcile window. If there is a difference, and it is not obvious what amount(s) is throwing it off, use the “Unmark All” button and reconcile one by one with the statement.)

As you can see, if the deposits in the “Make Deposit” window are a lot – possibly spanning multiple years, the above-mentioned method of clearing the deposits from the “Make Deposit” window would be very time consuming and impractical.

If there are a multitude of deposits here is what you do:

 Too Many Deposits Fix

1) First, you want to check to see if the deposits that were previously entered directly into the bank register that made the accounts reconcile, and the invoice that the payments in the “Make Deposit” window are for, went to the same Income account. So, locate the previous deposits as well as the corresponding Invoice(s) and check to see where they went. (If there is only one Income account, then they most likely went to the same account).

2) Go ahead and make the deposit(s) for each year, using the year end date for each year’s total deposit. (It’s always good practice to make adjustments at the beginning or ending of a period).

3) Next, create a journal entry for each year end with the total deposit amount you just put in for each year.

  • Debit the Income Account associated with the deposit(s)
  • Credit the bank account that the deposits were made to

This will reduce the amount in the bank account as well as the Income account – as it should, and the “Make Deposit” window will now be cleared. When next you go to reconcile, the journal entry amounts for the deposits will be in the reconcile window. Check each on the debit and corresponding credit side to remove them from the reconcile window. This of course will be a zero effect on your current reconciliation.

Because there were transactions left in the undeposited funds, the revenue for the period(s) associated with those deposits were overstated. It is possible that they were already taken care of by the CPA or tax preparer as far as tax filing; however, you will need to bring this to their attention if taxes were already filed for the affected period(s). Although you have already corrected this on the books in QuickBooks, amended returns may need to be filed, to make the correction tax-wise.

Using the “Too Many Deposits Fix” option above will allow your financials to be accurate, but not your books in the sense that the deposits were not broken down in months which will throw monthly reports off. Using the “Few Deposits Fix” option above will allow your books as well as your financials to be accurate on either the cash or accrual basis.