Cash Management Module in ERP

Author Topic: Cash Management Module in ERP  (Read 4120 times)

Offline Badshah Mamun

  • Administrator
  • Hero Member
  • *****
  • Posts: 2002
    • View Profile
    • Daffodil International University
Cash Management Module in ERP
« on: April 26, 2012, 01:27:37 PM »

Cash management module provides information relating to cash flow of the organization, by processing and analyzing all cash and bank transactions, arising out of payment of supplier’s invoices, receipt from sales invoices, stand alone payment and unallocated payment / receipts.

Cash management module also allows analyzing financial transactions for a given period of time and provides information regarding sources of fund and use of fund to ensure liquidity in order to meet payment obligations of the organization.

A typical payment / receipt flow in an organization
   
Payment/Receipt Flow


Integration with other modules


    Accounts payable where from processed purchase invoices are received.
    Accounts receivable wherefrom processed sales invoices are received.
    General Ledger where transactions processed within this module are posted.

Maintaining Master Data:
Some of the master data parameters for cash management modules are

    Maintain payment / receipt method:
This will determine how payments / receipts are processed, for which following parameters are needed to be defined:
        Whether automatic (where invoices or receipts are selected automatically depending upon payment term) or manual payment / Receipt.
        Maximum Amount per Business Partner in a single payment batch.
        Bank Account / Bank Address for making/ receiving payments.
        Output option-whether paper (cheque) or file (Direct debit).
        Composing Options - Where receipt / payment are processed individually (remittance) or combined for a number of invoices.

    The bank relations:
Where details of currency (home currency/ foreign payment), type of bank, whether blocked for payment or receipt, default priority etc. are maintained.
    Linking to General Ledger - Defining of several chart of accounts related to posting of various stages of transactions processing within cash management to General Ledger, such as anticipated payment, anticipated receipts, cheque issued not realized.
    Payment authorization - Maximum amount a user can pay to a supplier or if the user is authorized to make advance payment.

Functionality of Cash Management module


    Supplier Payment - The standard procedure for supplier’s payment is given below. However a variation of this process is followed for payment relating to standing order (where payments are made without an invoice), payment against proforma invoices, stand alone payment etc
        Select and compose invoices for payment
        Print payment advice list
        Modify payment advice
        Reconcile amount as per payment advice and invoice
        Assign bank
        Print cheque or post bank orders in an electronic file.
        Post cash transactions to general ledger

    A flow chart showing supplier payment procedure is given below:
   
    Supplier Payment Procedure
    Receipt of sales invoice amount:
        By Cheque:
            Cheque received from customer (anticipated receipt)
            Cheque sent to bank (cheque anticipated status).
            Cheque paid by bank (bank relation-reconciliation).
        Direct debit: Applicable for customers who have authorized the organization to directly debit their bank accounts.
            Select Invoices for Direct Debits
            Direct Debit Advice
            Compose Direct Debits
            Assign Banks to Direct Debits
            Audit Direct Debits
            Create Direct Debit Orders
            Print Remittance Letters
            Post Direct Debits into general ledger.
    Cash flow Forecast: This functionality provides an insight of the projected liquidity position of the organization at a certain point in the future. While forecasting cash flow the system uses available data regarding I)purchase orders and purchase invoices, ii) sales quotation, sales order and sales invoices iii) standing orders and iv) financial budgets.

Md. Abdullah-Al-Mamun (Badshah)
Senior Assistant Director
Daffodil International University
01811-458850
cmoffice@daffodilvarsity.edu.bd
www.daffodilvarsity.edu.bd

www.fb.com/badshahmamun.ju
www.linkedin.com/in/badshahmamun
www.twitter.com/badshahmamun