Bank/Cash Statement

Introduction

Introduction

Introduction

Introduction

This window will be used to do bank reconciliation

Business Example

After completion of the invoice (Customer, Vendor & Expense), Payment & receipts all transactions will be updated in the bank statement window to reconcile it.

Tabs

Tabs

Bank/cash statement header

image-1589791759781.png

Critical Fields:
1. Bank Account: Select Bank account to do the reconciliation
2. Name: This field show you the date & Time you created the document. User can override the content.
3. Statement date: The date when you going to do the reconciliation
4. Account Date: The date will post on the acounting fact
5. Beginning Balance: Amount will show the previous day or previous document closing balance for the same document.

Critical & onetime setup fields:

 1. Organization: This field is used to select the organization

Non-Critical Fields:

 1. Statement difference: This field shown the difference between the begining balance and ending balance.

 2. Ending balance: The sum of Begining balance and the statement difference.

 3. EFT Statement Reference: Electronic fund transfer statement reference

 4. EFT Statement Date: date of fund transfer.

Serial number/Lot number (ASI):

 

Zoom conditions:

 

Validation:

Tabs

Bank/cash statement line

image-1589792488810.png

image-1589792535278.png

 

Critical Fields:

1. Statement Line Date: Transaction date on the bank

2. Account conversion Date: Account posting date.

3. Effective Date: Date when the money is available.

4. Statement amount: Enter the statement amount shown in the bank statement.

5. Transaction amount: Enter the amount done by the transaction.

6. Charge amount: Used to maintain the penality/debt occur the staement.

7. Interest amount: enter the bank interest amount occur in the statement.

Critical & onetime setup fields:

1. Organization: This field is used to select the organization

Non-Critical Fields:

1. Payment: Select the payment/receipt document number as reference.

2. Reference no: Bank reference/transaction number

3. Memo: Maintain the content for the special notes

Serial number/Lot number (ASI):

 

Zoom condition’s

 

Customization

Document and action

Document and action

Validation

Save

1. System will check all mandatory fields.

Delete

1. System will delete the header and line details.

Document action prepare

1. System will check the period details and transaction document mapped.

Document action complete

1. System will complete the document and keep the transaction ready for processing in the bank/cash statement.

2. Once document action is complete, all fields are updated in read-only and accounting entries posted.

Document action void/reverse correct actual

1. the system will reverse the transaction data and generate reversal the document with the opposite accounting sign to zero value for the Bank.

Document action close

1. The system will check whether all the activity for the document is completed and change the Document status to close.
Document and action

Action

Verify:

 

Create lines from:

image-1589792795926.png

 This form will show all payment & receipts transactions to add to the statement line.

Copy from/lines:

Copy lines process helps to copy the statement line from existing bank/cash statement document. 

<custom actions>:

Video