Introduction
This new feature available on version: W1 20.4
User can use Bank Deposit for positing the cash received in bank instead of use Cash Receipt Journal. This alternative way will make it easier to do bank reconciliations as just one single transaction for the total of all the receipts at the same date.
In additional, Bank Deposit can be use for record the deposit received from customer (i.e. customer prepayment) and it use for offset invoice afterward.
Setup Requirement
Following setup is required before creating Bank Deposit
# | Setup |
---|---|
1 | Sales & Receivable Setup - No. series for Bank Deposit Nos. Note: Post Bank Deposit as Lump Sum can be change in Bank Deposit Card |
2 | General Journal Template - assign the default no. series for the journal for Bank Deposit. |
Use Bank Deposit to record the customer payment for settle customer invoice or prepayment
Step | Description | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Go to Bank Deposit then click New to create new Bank Deposit Fill up the information as below:
| ||||||||||||||||||||||||||||||
2 | Continue to enter Bank Deposit Line for another cheque details. | ||||||||||||||||||||||||||||||
3 | If depositing a cash payment for a specific customer invoice, choose the Apply Entries action, and then enter the invoice number in the Applies-to ID field (1) select Apply Entries (2) Set Applies-to ID **Please note, different with cash receipt journal, the total for applied entries will not calculated by system and populate in bank deposit line. | ||||||||||||||||||||||||||||||
4 | Print the Bank Deposit Test Report (optional) (1) Select "Show Applications" for showing the Applied customer invoice for the deposit line. (2) Test Report information 1 - cheque deposit from customer 60000 Blanemark Hifi Shop is use for Prepayment, no existing customer invoice or AR to settle 2 - cheque deposit from customer 20000 Selangorian Ltd is use for settle the customer invoice No. 00-8, the Application is shows in below of the bank deposit line. | ||||||||||||||||||||||||||||||
5 | Post the Bank Deposit |
Case example for receipt prepayment from customer by use Bank Deposit
The case scenario is the customer has no outstanding balance. The customer depositing for prepayment then use the prepayment amount to settle their customer invoice afterward/
1 - Create bank deposit for handle the receipt, once the Bank Deposit for the prepayment is posted, the balance amount to be reflect in Customer Balance
In Customer Ledger Entry, you can see the source code BANKDEPOSIT it identified the deposit is positing via Bank Deposit
- the cheque no. is recorded in Document No. and the Bank Deposit No. is shoes in External Document No. This is different with Cash Receipt Journal if the deposit is positing via Cash Receipt Journal
2 - Sales Invoice #103033 for the customer is posted at 01/31/2024.
3 - Go to Customer Ledger Entries then use Apply Entry function to settle the invoice by use of the prepayment amount. After applied, the invoice to be settle by the prepayment.
*please note, in the case example below, there have 100 prepayment discount, therefor, you will see the remaining amount is 5,100 after settle the invoice for 5,000.