apply bank debit to open cm

We have a client who has rental space, so when someone new moves in they pay a security deposit, and we process a payment against the tenant's credit card.  When the client moves, we issue a CM against the original security deposit and process a refund on the tenant's credit card.  How do I apply the debit that hits the bank to the open CM to close it?

I get that this is essentially just the reverse of the original transaction, but unlike the original (where we receive a payment and then make a deposit in QB), the CM is just open.  I'm thinking we should be able to "apply" the debit to the open CM?  My biz partner is an accounting pro and I'm trying not to trouble her with this as the cash is my responsibility.  Thank you!


Here is the issue: "but unlike the original (where we receive a payment and then make a deposit in QB), the CM is just open."

You make an Other Charge type item linked to Liability and use that on a Sales Receipt when they give you the security deposit.

You use it again on the Credit Memo, for the date you want to Apply it, Refund it, or both needs.

This also seems to be an error: "How do I apply the debit that hits the bank to the open CM to close it?"

You are not supposed to use something linked to Bank at this point.

Please see my attachment.

Now your Liability account can be managed by custom Transaction Detail reporting, set to total by Name, so that you can Reconcile it. Only and Always using an Ending Balance of 0, because the left and right sides you will checkmark only the activities for the name that is now at 0.

Make two versions of this report. One is All Transactions. The other is filtered on Cleared Status = No and this is Current Balances Only. And the reporting on that Item also shows balances and activities; or make one item for Security Deposit Received and the other is for Security Deposit Applied/Returned, but they both link to that same Liability account.

This assumes you do not also have a Trust Bank requirement. If you do, things are a bit different for using QB and Trust Banking.

Please see my attachments.

Was this answer helpful? Yes No
1 additional answer

No answers have been posted

More Actions

People come to QuickBooks Learn & Support for help and answers—we want to let them know that we're here to listen and share our knowledge. We do that with the style and format of our responses. Here are five guidelines:

  1. Keep it conversational. When answering questions, write like you speak. Imagine you're explaining something to a trusted friend, using simple, everyday language. Avoid jargon and technical terms when possible. When no other word will do, explain technical terms in plain English.
  2. Be clear and state the answer right up front. Ask yourself what specific information the person really needs and then provide it. Stick to the topic and avoid unnecessary details. Break information down into a numbered or bulleted list and highlight the most important details in bold.
  3. Be concise. Aim for no more than two short sentences in a paragraph, and try to keep paragraphs to two lines. A wall of text can look intimidating and many won't read it, so break it up. It's okay to link to other resources for more details, but avoid giving answers that contain little more than a link.
  4. Be a good listener. When people post very general questions, take a second to try to understand what they're really looking for. Then, provide a response that guides them to the best possible outcome.
  5. Be encouraging and positive. Look for ways to eliminate uncertainty by anticipating people's concerns. Make it apparent that we really like helping them achieve positive outcomes.

Select a file to attach:

Qb community
Looking for advice from other business owners?

Visit our QuickBooks Community site.