DocumentationDocumentation
  • Main

    • Introduction
    • My Account

      • Change Password
      • Logout
    • Common Topics

      • Accounting
      • Audit trail and Version control
      • Accounts Vs Contracts
      • Branch Operations
      • Concept of Entity
      • Holidays
      • EOC
      • Concept of Events
      • Concept of Input and Authorization
      • Navigation
      • Impact of Unapproved Records
      • Concept of Product
  • Admin

    • Branches

      • EOC Details
      • Maintain
    • Channel banking

      • Mobile app version
      • Role template
      • Target announcement
      • User maintenance
    • Correspondent Bank Management

      • Maintain
    • Entities

      • Announcement
      • Maintain
      • Task forces
    • Notification

      • Settings

        • Maintain
    • Pricing

      • Charges

        • Charge bundle setting
        • Charge schemes
      • Interest

        • Interest bases
        • Interest rate history
        • Interest scheme
      • Settings

        • Charge bundle group
        • Relationship pricing
    • Reports

      • Audit log
      • Cob exception report
      • User log on - log off
    • Secure stationery

      • Card bundle
      • Card maintenance
      • Secure device
      • Series
      • Welcome kit order
    • Settings

      • Security
    • Status

      • Card account status
      • Client account status
      • Loan status
      • Loan application status
      • Factoring status
    • System codes

      • Address details

        • Address Type
        • E-mail types
        • Phone types
        • Regions
        • Zip codes
        • Zones
      • Categories

        • AML category
        • Block category
        • Category types
        • Conversation category
        • Classified data category
        • Employment categories
        • Loan level risk category
        • Offering
        • Risk category
        • Services delivery channel
        • Tax category
      • Currency

        • Currency
        • Currency rate type
        • Rates authorization
      • Custom fields

        • Custom fields
        • Field mappings
      • Documents

        • Diary types
        • Document type
        • Document templates
      • Generic definitions

        • Clearing zone
        • Community
        • Countries
        • Credit rating agency
        • Identification type
        • Branch levels
        • Departments
        • Education
        • Employment type
        • Identification type
        • Insurance plan
        • Invoice formats
        • Languages
        • Locker type
        • Offer condition
        • Organisation type
        • Person role
        • Purpose of loan
        • Reminder formats
        • Sic codes
        • Statement format
        • Till/vault/ATM
      • Interface definition

        • External Product mapping
        • ISO 8583 mapping
        • Maintain
      • Network calendar

        • Maintain
      • Payments

        • Payment methods
        • Payments terms
        • Source of funds
      • Process

        • Auto allocation rules
        • Branch submenus
        • Business rule parameters
        • Link process
        • Process authorization
        • Process help
        • Process mapping
        • Process reasons
        • Stage rule association
    • Tax schemes

      • Maintain
    • Translations

      • Aura-data
      • Aura-label
    • Users

      • Authentication settings
      • Active sessions
      • Designations
      • Maintain
      • Roles
      • Role groups
      • Unapproved records
    • Additional Topics

      • Interest Accrual
  • Retail

    • Accounts

      • Client account

        • Closure
        • Maintain
      • Multi-currency contract

        • Maintain
      • Nostro account

        • Closure
        • Maintain
      • Operations

        • Adhoc Charges
        • Cheque number search
        • Prepaid instrument issue enquiry
      • Term deposit

        • Maintain
        • Premature withdrawal
        • Reversal
    • Loans

      • Change of terms

        • Interest Parameters
        • Payment Terms
        • Settings
        • Invoice Cancellation
      • Charge waiver
      • Disbursement
      • Maintain
      • Product Novation
      • Repayment

        • Full Prepayment
        • Partial Prepayment
        • Payment of Due Amounts
        • Payment of Invoice Amounts
        • Simulation of Payment
      • Restructuring
      • Reversal
      • Loan application

        • Maintain
    • Loan Broker

      • Maintain
    • Payments

      • Gross payment settlement

        • RTGS/SWIFT/TARGET2
      • Net payment settlement

        • Authorization
        • Enquiry
        • Credit transfer
        • Dispatch accounting enquiry
        • Debit order
        • Internal client transfer
      • Standing instructions

        • Maintain
    • Peer-to-peer

      • Loan request

        • Maintain
        • Loan request repayment
      • Placement instruction

        • Maintain
      • Placement plan

        • Maintain
      • Settings

        • Loan request settings
        • Marketplace preferences
        • Placement settings
        • Product
    • Safe deposit locker

      • Agreement
      • Maintain
      • Operation
    • Settings

      • Collection settings
      • Multi-currency settings
      • Payment settings
      • Payment template
      • Product Maintenance
      • Product-Client Account
      • Product-Term Deposit
      • Product-Nostro Account
      • Product-Mortgage and Loan
      • Standing instruction settings
      • Transaction defaults
    • Transaction review

      • Account statement
    • Transaction wizard

      • Cash deposit
      • Cash withdrawal
    • Additional Topics

      • Module Specific EOC Batches
      • Payment Processing
  • Commercial

    • Factoring

      • Contract

        • Maintain
        • Disbursement
        • Repayment
        • Change of terms
      • Operations

        • Adhoc charges
      • Settings

        • Product
  • Treasury

    • Forex

      • Contracts

        • Cancellation
        • Maintain
        • Manual Settlement
      • Settings

        • Product
    • Additional Topics

      • Module Specific EOC Batches
  • Card

    • Cards

      • Maintain card
      • Maintain card account
      • Maintain dispute account
    • Loans

      • Change of terms
      • Disbursement
      • Maintain
      • Repayment
      • Reversal
    • Operations

      • Balance Movement
      • Change of Cycle
      • Manual actions
    • Settings

      • Card account product
      • Card loan product
      • Card product
      • Card provider
      • Merchant category
      • Charge group
      • Cycle group
      • Interest group
      • Message type
    • Transaction review

      • Transaction enquiry
    • Additional Topics

      • Balance classification
      • Overdue Days
      • Interest Liquidation
      • Replenishment
      • Module Specific EOC Batches
      • Reversals
  • CRM

    • Clients

      • Agreement
      • Maintain
      • Marketplace investment preferences
    • Collateral/Limits

      • Collaterals
      • Limits
      • Settings

        • Limit setting
    • Conversations

      • Conversation
    • Due diligence

      • Organization
      • Person
    • Loyalty program

      • Maintain
      • Reward points redemption
      • Settings

        • Product
        • Reward group
    • Organisation

      • Maintain
    • Person

      • Maintain
    • Reports

      • Balance certificate
      • Average account balance
    • Sales

      • Agent
      • Agent User
      • Campaigns
      • Outlet
      • Performance targets
      • Terminal
    • Additional Topics

      • Limit Utilization
      • Module Specific EOC Batches
  • General ledger

    • Collective impairment

      • Maintain
    • General ledger

      • Accounts
      • Chart of accounts
    • Reports

      • Branch Inter-branch reconciliation
      • GL report
      • GL transaction report
      • Inter branch - Due to Due from
      • Journal report
    • Settings

      • Accounting period
      • Currency
      • Journal template
      • Transaction code
      • Related transaction setting
    • Transaction entry

      • Cross currency journal
      • Day journal
      • Station journal
    • Transaction review

      • Statement
      • Transaction enquiry
    • Additional Topics

      • Module Specific EOC Batches
  • Digital assets

    • Escrow covenant
    • Primary issue
  • Paymentgrid

    • Settings

      • Charge rule
      • General ledger
      • Language converter
      • Message configuration
      • Network cutoff time
      • Nostro BIC mapping
      • Nostro route
      • Nostro configuration
      • Product
      • STP configuration
      • Transaction code
    • Operations

      • Bulk dispatch for inward cheques
      • Debit order
      • Direct Debit
      • Free format message
      • Gross settlement
      • Net settlement
      • STP exception
    • Nostro reconciliation

      • Account mapping and preferences
      • External manual entry
      • External statement view
      • Manual reconciliation
      • Reconciliation details
      • Reports

        • Adjustment entry report
        • Reconciled entry report
        • Reversed entry report
        • Unreconciled entry report

Balance Classification

Card account can be either in Credit balance or in Debit balance. Balance classification allows the balances to be classified according to certain attributes that the amounts should have. The balance in each balance class is further divided into different Buckets.

These balances in the Balance Classes as well as in the Buckets are held as Book Dated Balances as well as Value Dated Balances at all times.

Balance Classes and Balance update

User can define different balance classes and can map different Transaction codes (TCs) to each balance class. Balances that arise from transactions posted with these transaction codes get accumulated in the respective balance class.

Since balance classes are maintained by the users for each Product, the user can name these balance classes appropriately according to the balance that they hold, for e.g., 'Interest' to hold all interest balances in the account or 'Purchases' to hold all POS transaction balances.

One balance class is always defaulted to hold balances on the credit side and one on the debit side. These default balance classes can also be named by the user to suit different business needs. The default balance class will hold amounts of all transactions arising out of transaction codes that are not mapped to other balance classes. (For more information related to maintenance of balance class please refer to the Card Account Product_Balance Classification User Manual)

Below are some examples of maintenance of balance classes and the update of the balances when transactions are posted. All amounts in the examples are in EUR.

Balance updates Example (Debit)

  1. Data set up at the 'Balance Classification' tab

Debit

Balance Class DescriptionMapped Transaction CodeTransaction code for interest liquidationTransaction code for balance movement
Cash700752852
Purchase701753853
DefaultNone; but, will take in transactions in all other transaction codes that are not mapped to other balance classesTransaction code mapped for the Product as ‘Interest received within limit (DB / Client)’Transaction code mapped for the Product as ‘Movement of debit balances (DB / Client)’

  1. User has posted the following debit transactions into the account:
Transaction CodeAmount (DB)
700800
701112.5
103150

  1. Following are the balance class updates for the above transactions assuming the opening balance in the account is 0.00
Balance Class DescriptionBalance (DB)
Cash800
Purchase112.5
Default150

Balance updates Example (Credit)

  1. Data set up at the 'Balance Classification' tab

Credit

Balance Class DescriptionMapped Transaction CodeTransaction code for interest liquidationTransaction code for balance movement
Payment750754854
DefaultNone; but, will take in transactions in all other transaction codes that are not mapped to other balance classesTransaction code mapped for the Product as ‘Interest paid (CR / Client)’Transaction code mapped for the Product as ‘Movement of credit balances (CR / Client)’

  1. User has posted the following credit transaction into the account:
Transaction CodeAmount (CR)
750120

  1. Following are the balance class updates for the above transactions assuming the opening balance in the account is 0:
Balance Class DescriptionBalance (CR)
Payments120

The impact of the debit balance class movement when the payment transaction comes in (assuming that the account is in debit balance) and vice-versa, please refer to the Additional topics_Replenishment User manual

Buckets

Every balance class on the debit side holds balances internally in different 'buckets'. Following are the buckets that Aura holds these balances in:

  1. Current: This consists of the current cycle's balances

  2. Past: This consists of the immediately preceding cycle's balances. The Current bucket balance moves into the Past bucket during Close-of-Business process on End of Cycle date.

  3. Rolled over: This consists of the balances of all the cycles beyond the previous cycle. The Past bucket balance moves into the Rolled Over bucket during Close-of-Business process on Payment Due Date. This amount is arrived at after overdue balances are moved into the overdue bucket as described below.

  4. Overdue: This consists of the overdue balances -- i.e. when the payment received is less than the Amount required, subject to Thresholds. The Past Bucket balance moves into the Overdue bucket, to the extent of the overdue amount, during Close-of-Business process on Payment Due Date.

Note:

  • Movement into Overdue bucket happens only if the Product has the Treat Overdue Balance flag marked as Yes. In case the flag is set to No, the balance from the Past bucket moves into the Rolled Over bucket, even though it may be overdue.

  • On End-of-Grace-Days, if there are any residual balances for Overdue and Rolled over (i.e., where there is an overdue or Rolled over amount, but, this is less than the threshold specified for the same), these will be moved into Rolled Over and Past Bucket.

The traversing of amounts between different buckets is explained below under various scenarios.

Note:

  • End of Cycle (EOC) Date = End of Month

  • Payment Due Date (PDD) = 10 days after EOC

  • Grace Days = 5 days

  • End of Grace Days (EOGD) = 5 days after PDD

  • Total Outstanding Amount on 31-Jan- is 750.00

  • Amount Required = 20% of Total Outstanding = 20% of 750.00 = 150.00

Full Payment

Account is opened. Transaction is posted. Invoice is generated. Payment is made for full outstanding balance of 750.00 and thus there is no balance for roll-over or overdue.

Partial payment > Amount required

Account is opened. Transaction is posted. Invoice is generated. Partial payment of 250.00 is made, which is greater than 'Amount required'. Since Payment is less than total outstanding, the balance amount will roll-over. Payment is greater than the 'Amount required' as per Invoice and hence, account will not be Overdue

Partial payment = Amount required

Account is opened. Transaction is posted. Invoice is generated. Partial payment of 150.00 is made, which is equal to 'Amount required'. Since Payment is less than total outstanding, the balance amount will roll-over. Payment is equal to 'Amount required' as per Invoice; so account has not gone into Overdue.

Partial payment < Amount required

Account is opened. Transaction is posted. Invoice is generated. Partial payment of 50.00 is made, which is less than 'Amount required'. Since Payment is less than total outstanding, the balance amount will roll-over. Payment is less than the 'Amount required' as per Invoice and hence, account becomes Overdue

Note: in this case, if Treat Overdue as Balance is marked as Yes in the Product, the Overdue bucket will show the overdue amount i.e., 100.00 as the balance and rolled over will be 600.00. If the flag is No, Rolled Over will be 700.00. The overdue amount is internally tracked as 100.00

No Payment

Account is opened. Transaction is posted. Invoice is generated but payment is not made. The entire outstanding balance will roll-over. Payment is less than the 'Amount required' as per Invoice and hence, account becomes Overdue.

Note: In this case, if Treat Overdue as Balance is marked as Yes in the Product, the Overdue bucket will show the overdue amount i.e., 150.00 as the balance and Rolled Over will be 600.00. If the flag is No, Rolled Over will be 750.00. The overdue amount is internally tracked as 150.00

Next
Overdue Days