Security Deposits - Customer & Supplier

Hello,

I am stuck with an issue here regarding the security deposit amount we collect from customers and also the security deposits we make to suppliers.

I have read through the guides and it suggests what i was already doing which is not suitable for me.

The situation is like we collect a security deposit amount from our customers and sometimes we have to make a security deposit to our suppliers. This security deposit does not have anything to do with the Accounts payable or Accounts receivable as this amount is not adjusted against the invoices made or received. It stays as a deposit as long as there is business with the customer or supplier. It will only be adjusted when the business is terminated.

I had created a sub-account named Deposits under Assets to receive and spend the deposit amount. But the problem i encounter is:

  1. The deposit amount do not show up in the customer or supplier statements under reports. The statement under reports should show the deposit amount as a separate account.

  2. There is no option to set the starting balance of a customer or supplier under a particular account, in my case “Deposits”.

Any help regarding this will be very helpful. TIA

1 Like

You are trying to have your cake and eat it, too. You say you do not want the deposits to show in Accounts receivable/payable. But you want them to show on statements. However, statements are records of the customer/supplier subaccount under Accounts receivable/payable.

I can think of several alternatives that might work for you:

  1. Create duplicate customers/suppliers, labeled for deposits. These new subaccounts will contribute to Accounts receivable/payable. But they will be separate from the regular accounts involving invoices and payments. And you could produce separate statements.

  2. Make Customer deposits a custom control account under Liabilities, made up of customers. (These are not assets, because you owe the money to the customers.) Make Supplier deposits a custom control account under Assets, made up of suppliers. (These are assets, because you are owed money.)

  3. Use special accounts.

My favorite would be #2, because you already have the customers and suppliers defined. But recognize that deposits entered that way will not appear on statements. Others may think of different approaches.

Suppose i choose to try this method I still have to create duplicate customers and suppliers. Because a customer or supplier can have only one control account which is default to Accounts receivable or Accounts payable.

1 Like

@Tut your #2 also requires your #1 - duplicate account.
Main account under “Accounts receivable/payable” and duplicate account under custom control account.

You are right. I forgot about needing to specify the control account for a customer/supplier. My apologies.

I guess the choice, then comes down to whether you want the deposit to show in a separate account or be part of Accounts receivable/payable. The first choice seems better from the Balance Sheet perspective. The second choice lets the deposit show on a statement.

I wonder why this is not a feature available in Manager. Most business take security deposits or whenever there is a need of investment to meet specific needs of customer or supplier. And in most cases this is not a single transaction which would further complicate things. In my opinion i think this should be included in a single statement which shows all transactions because that would bring clarity and assurance for the customer or supplier that the deposit is there. It would also help easily cross-check with the statement received from the supplier or customer than to have two statements.

It would have been really useful if there was an option to link multiple control accounts to customers and suppliers.

1 Like

You can put the deposits into a separate (duplicate) customer account which is also allocated to a Custom Control Account made up of customers located under BS Liabilities and still get statements as long as you select “transactions” as the statement type

Yes, and the accounting should recorded it as such, which is not as an accounts receivable transaction.

I think this is the only option possible at present.

I was hoping to be able to show both under the same statement of transactions for a customer or supplier. That way all the transactions would be dated and tracked easily.
Creating duplicate customer or supplier is ok. But its more tedious when we have to document everything as a hard copy. In our case we file the hard copies of quarterly statements for every record. Also our government rules states that we should maintain all records of atleast 6 financial years. so if we have to maintain two records for a single customer you can very well understand the difficulty when we need to cross-check any old transaction.

1 Like
  1. Why and 2) why not print as a pdf file and store on a USB stick. Then print a hard copy “if” ever required. As long as you can reproduce a hard copy, then maintaining an actual hard copy is excessive.

This is a requirement of most governments, though the number of years may vary.
As Manager is endless, even after ten years all records are still reproducible, this maintaining of records should never be an issue.

No I don’t understand, for either customer record just create and print a statement for the whole ten years if ever required, besides the “deposit” customer record would be fairly static.

USB’s stored off site is probably more reliable then paper being destroyed in the event of an office fire.

Manager is constantly evolving. So it is doubtful the document template we use today will be possible to reproduce in another two years. Moreover, our tax system is changing and I am sure there will be more changes. So nothing is a guarantee. :slightly_smiling_face:

What i tried to explain is that the monthly or quarterly statement of a supplier or customer is exchanged to verify whether the records match. And their transactions are dated which includes the credit, debit and deposits. So checking the transactions with two separate statements, one for credit debit and one for deposits, will cause a bit confusion with the balance.

Also, suppose i have duplicate customers or suppliers as you suggested, how will the available balance in Deposits be adjusted against the outstanding balance at the end of a business?

1 Like

A Custom Field for Customers named " Amount of Security Deposit" will show on Customer Statements.

Of course the information would have to be entered once for each customer, and it would appear as a footnote on the Customer Statement.

The amount would still have to be recorded on the balance sheet. A date or reference number could be included in the Custom Field to help locate the original balance sheet entry, which may have been recorded years before.

There does not seem to be any elegant solution to this.

Users who starting using Manager 4 years ago can still reproduce their first transactions today.
Because the template changes the data hasn’t, the data will be reproduced in accordance with the template of the day.

True but changes in tax systems doesn’t affect data - countries like Australia / New Zealand have gone from non GST to GST, but all those transactions prior to GST remain unaffected.

To accept your argument means that the 6 year requirement for recording keeping dissipates because the tax system has changed - but that is not the case.

But if one customer account only has deposit transactions where is the confusion.

Via a Journal entry - similar to the transfer of balances when you have both a Supplier / Customer relationship with the same business.

I suggest that you stop finding obstacles for obstacles which don’t exist. Businesses such as Real Estates in receiving rental bonds (security deposits) have been dealing with these types of situations for decades if not centuries and they aren’t having your difficulties.