IDI version 26.8 is now available.  Click here for details: IDI Updates.

About Managing Account Balances

Prev Next

The IDI platform supports comprehensive account balance management capabilities including:

  • posting and tracking payments and adjustments

  • logging, tracking and resolving disputes

  • crediting invoice items

  • managing deposits

  • administering corporate accounts

    Payment/adjustment transactions can be managed on four levels:

  • Batch files for bulk processing of payment/adjustment transactions for large sections of your customer base.

  • Controlled batches for handling multiple payment transactions when you have more transactions than would be practical to handle individually, but not enough to require a batch file.

  • Tracking and managing payments and adjustments through search tools in Accounts Receivable Management.

  • Managing individual customer accounts via the Customer window.

    The other supporting functions (disputes, credits, deposits) are handled through the Customer window.

    The E-Pay application that lets you configure recurring and non-recurring credit card and ACH (checking/savings) accounts for your customers, is integrated with the Accounts Receivable module so you can load E-Pay transactions and send them to your company's credit card processor.

Understanding Posting and Allocation

You should have a thorough understanding of how transactions are posted and funds allocated before you set up and begin using the applications for managing account balances. The posting process settles payments and adjustments by allocating the funds according to predetermined allocation methods which are assigned to customer accounts through Accounts Receivable Groups. A full history of settlement and allocation is available for tracking and reporting.

For more on posting and allocation see  Posting and Allocation Considerations.

Setup Requirements

There are several tables in the Admin Console Data management application that must be set up before you begin working with account balances in the IDI platform. Refer to the Data Management topic in Admin Console help for further information

Table Name

Description

Adjustment Reasons

Specified when adding an adjustment to an account.

Adjustment Types

Specified when adding an adjustment to an account.

Balance Aging Groups

Every customer is assigned to an Aging Group to determine how delinquent balances are aged.

Allocation Types

Required for allocating deposits.

Deposit Types

Required for logging new deposits.

Deposit Waive Types

Required for waiving deposits.

Deposit Interest Rates

Required for calculating interest on deposits.

Dispute Resolutions

May be specified when closing a dispute.

Payment Types

Specified when adding a payment to an account.

Accounts Receivable Groups

Every customer is assigned to an Accounts Receivable Group to determine how payments are allocated on a customer account.

Invoice Categories

One of two criteria considered when allocating payments. All revenue-generating items including Product Catalog items and usage types are assigned an Invoice Category. Invoice Categories are prioritized according to the sequence number specified in the Accounts Receivable Group detail view.

Working with Account Balances

When you're ready to begin using the IDI platform applications for managing account balances, see:

Working with Account Balances

Working with Backdating

Working with Payments on Customer Accounts

Working with Adjustments

Working with the Balances Tab to Manage Individual Accounts

Working with Deposits

Working with Invoices

Viewing Usage

Working with Disputes