Customer Deposit: Difference between revisions

Latest revision as of 07:37, 26 May 2021

Menu: Customer | Customer Deposit...

Introduction

Deposits are the advance payments made or received for future services and goods to be invoiced. With accrual basis accounting, a prepayment for work that a corporation is obligated to perform becomes a liability.
It might be refund or forfeited in partial or full balance of deposit received.

Generally, the double entry will be:-

Account Description	DR	CR
Bank Account	500.00
Prepayment from Customers		500.00

At General Ledger, Maintain GL Account must have a deposit account named "PREPAYMENT FROM CUSTOMERS" under Current Liabilities.

Customer Deposit - Entry

1. Click on New button.

2. Select the Customer Code. You direct key-in and search by either customer code or name.

3. You may select other deposit account to be credited in Deposit Acc.

4. You may select the bank / cash account to be deposit (to be debited) in Received In.

5. Enter the deposit amount into Paid Amount.

6. Below is the example of the entry created:

7. Double entry will be:-

GL Account	Description	DR	CR
310-001	Maybank	6,000.00
PREPAYMENT	Prepayment from Customers		6,000.00

Customer Payment Off Set with Deposit

Menu: Customer | Customer Payment...

1. Create NEW or EDIT the customer payment.

2. From Deposit will display a total deposit for a customer selected.

3. Click to the arrow key down to select a deposit to offset with customer payment (to knock-off the outstanding invoices).

4. Deposit no (official receipt no) selected and enter paid amount to be off-set. Received in will be auto set.

5. Click SAVE to post. Double entry will be:-

GL Account	Description	DR	CR
PREPAYMENT	Prepayment from Customers	3,000.00
300-A0002	Customer Account		3,000.00

HINTS:
Deposit balance will shown 0.00 in customer payment if no deposit balance to be off-set.

Customer Deposit Refund

1. To make refund for deposit. Access to Customer | Customer Deposit...

2. Click on ADD button. See the screenshot below.

3. Select Deposit Refund.

4. Enter the Deposit Refund amount and payment method to be pay back to customer.

5. Click Ok to save it.

6. Deposit refund will be added to off-set with deposit unapplied amount.

Double entry will be:-

GL Account	Description	DR	CR
PREPAYMENT	Prepayment from Customers	2,000.00
310-001	Maybank		2,000.00

Customer Deposit Forfeit

1. To forfeit the deposit balance (unapplied amount). Access to Customer | Customer Deposit...

2. Click on ADD button. See the screenshot below.

3. Select Deposit Forfeit.

4. Enter the Deposit Forfeit amount and select an account to be credit (eg. gain from deposit forfeit).

5. Click Ok to save it.

6. Deposit forfeit will be added to off-set with deposit unapplied amount.

Double entry will be:-

GL Account	Description	DR	CR
PREPAYMENT	Prepayment from Customers	1,000.00
590-000	Gain from deposit forfeit		1,000.00

NOTE:
Document number for deposit forfeit will be follow to original customer deposit no.

@@ Line 3: / Line 3: @@
 ==Introduction==
 * '''Deposits''' are the advance payments made or received for future services and goods to be invoiced. With accrual basis accounting, a prepayment for work that a corporation is obligated to perform becomes a liability.
+* It might be refund or forfeited in partial or full balance of deposit received.
 * Generally, the double entry will be:-
@@ Line 40: / Line 41: @@
 ''Menu: Customer | Customer Payment...''
 :1. Create '''NEW''' or '''EDIT''' the customer payment.
-:2. '''Deposit balance''' (total deposit from each customer) will be displayed after a customer has selected.
+:2. '''From Deposit''' will display a total deposit for a customer selected.
-::[[File:Customer Deposit-02.jpg |640px]]
+::[[File:Customer Deposit-02.jpg |420px]]
 <br />
 :3. Click to the '''arrow key down''' to select a deposit to offset with customer payment (to knock-off the outstanding invoices).
 ::[[File: Customer Deposit-03.jpg |640px]]
 <br />
-:4. Deposit no (official receipt no) will selected to offset with customer payment. '''Received in''' will be auto set.
+:4. Deposit no (official receipt no) selected and enter paid amount to be off-set. '''Received in''' will be auto set.
 ::[[File: Customer Deposit-04.jpg |640px]]
 <br />
@@ Line 54: / Line 55: @@
 ! style="text-align:left;"| GL Account !! style="text-align:left;"| Description !! style="text-align:right;"| DR !! style="text-align:right;"| CR
 |-
-| PREPAYMENT || Prepayment from Customers || style="text-align:right;"| 6,000.00 || style="text-align:right;"|
+| PREPAYMENT || Prepayment from Customers || style="text-align:right;"| 3,000.00 || style="text-align:right;"|
 |-
-| 300-A0002 || Customer Account || style="text-align:right;"| || style="text-align:right;"| 6,000.00
+| 300-A0002 || Customer Account || style="text-align:right;"| || style="text-align:right;"| 3,000.00
 |}<br />
   '''HINTS:'''
-  No deposit balance from the customer if the deposit balance shown 0.00 in customer payment.
+  Deposit balance will shown 0.00 in customer payment if no deposit balance to be off-set.
-  [[File: Customer Deposit-05.jpg |400px]]
+  [[File: Customer Deposit-05.jpg |420px]]
-==Customer Invoice - Attachment==
+==Customer Deposit Refund==
-* It is very useful to attach any supporting documents to an invoice.
+:1. To make refund for deposit. Access to Customer | Customer Deposit...
-* In future, you able to retrieve and refer the attachment file easily.
+:2. Click on ADD button. See the screenshot below.
-::[[File:Customer Invoice-Attachment.jpg|640px]]
+::[[File: Customer Deposit-08.jpg |640px]]
+<br />
+:3. Select '''Deposit Refund'''.
+::[[File: Customer Deposit-09.jpg |640px]]
+<br />
+:4. Enter the '''Deposit Refund''' amount and payment method to be pay back to customer.
+::[[File: Customer Deposit-10.jpg |540px]]
+<br />
+:5. Click '''Ok''' to save it.
+:6. Deposit refund will be added to off-set with deposit unapplied amount.
+::[[File: Customer Deposit-11.jpg |700px]]
 <br />
+:Double entry will be:-
+::{| class="wikitable"
+|-
+! style="text-align:left;"| GL Account !! style="text-align:left;"| Description !! style="text-align:right;"| DR !! style="text-align:right;"| CR
+|-
+| PREPAYMENT || Prepayment from Customers || style="text-align:right;"| 2,000.00 || style="text-align:right;"|
+|-
+| 310-001 || Maybank || style="text-align:right;"| || style="text-align:right;"| 2,000.00
+|}<br />
-:1. You have to point to the attachment section.<br />
+==Customer Deposit Forfeit==
-:2. Click on ( + ) button to insert the filename path.<br />
+:1. To forfeit the deposit balance (unapplied amount). Access to Customer | Customer Deposit...
-:3. See the sample screenshot below.<br />
+:2. Click on ADD button. See the screenshot below.
-::[[File:Customer Invoice-Attachment2.jpg|640px]]
+:3. Select '''Deposit Forfeit'''.
+::[[File: Customer Deposit-17.jpg |640px]]
+<br />
+:4. Enter the '''Deposit Forfeit''' amount and select an account to be credit (eg. gain from deposit forfeit).
+::[[File: Customer Deposit-18.jpg |540px]]
 <br />
+:5. Click '''Ok''' to save it.
+:6. Deposit forfeit will be added to off-set with deposit unapplied amount.
+::[[File: Customer Deposit-19.jpg |640px]]
+<br />
+:Double entry will be:-
+::{| class="wikitable"
+|-
+! style="text-align:left;"| GL Account !! style="text-align:left;"| Description !! style="text-align:right;"| DR !! style="text-align:right;"| CR
+|-
+| PREPAYMENT || Prepayment from Customers || style="text-align:right;"| 1,000.00 || style="text-align:right;"|
+|-
+| 590-000 || Gain from deposit forfeit || style="text-align:right;"| || style="text-align:right;"| 1,000.00
+|}<br />
-==Customer Deposit Refund==
+ '''NOTE:'''
+ Document number for deposit forfeit will be follow to original customer deposit no.
+==See also==
-==Customer Deposit Forfeit==
+* [https://wiki.sql.com.my/wiki/account4:Contents SQL Accounting]
+* [[Customer Payment]]