Accounts Receivable

Information System for decision-making.

This system allows management to analyze and manage accounts receivable in a simple way through Excel.

It allows different types of current account analysis, debt from different views to make decisions. It allows knowing the overdue debt, debt to be settled, sale by client in last trimester, by seller, by client, by area, by time, analysis of average of payment of clients, analysis of credit limits, analysis of returned checks by client and seller among other queries.

With this tool, the reports can be created and configured according to the needs. You can combine the available information as desired with excellent response speed allowing decision-making. Speed, ease of use and variability are the main differences with conventional management system reports.

The current account manager will be able to choose and combine the Sellers, Customers, Areas, Company, Time (trimesters, months, years) with the variables of only the accounts receivable or the current account to analyze collections, returned checks, debits, etc.

The source of the information comes from the Magnus system, which is automatically processed to be displayed in this system.

MOST IMPORTANT FUNCTIONALITIES

  • Analysis of customer behavior according to Sales, debt and payment method.
  • Debt by Customer
  • Overdue Debt and to be settled by Seller in time
  • Overdue Debt and to be settled by Customer in time
  • Accounts Receivable by Area in time
  • Accounts Receivable by Seller and Area in time
  • Distribution of Debt by Seller
  • Payment average (receipts) per Seller
  • Analysis of returned checks by Seller
  • Analysis of rejected values by Seller and Area
  • Analysis of customers exceeding the credit limit
  • Analysis of customers exceeding the credit limit in third party securities
  • Analysis of customers exceeding the credit limit in own securities

DIMENSIONS OF ANALYSIS

  • The user can combine the different dimensions according to the need for information; they can analyze and combine Sellers, Customers, Areas, Time (trimesters, months, years) and Collection Days.

VARIABLES OF ANALYSIS

  • Debt only
    Variable showing the outstanding debts
  • Full Current Account
    It contains all the information of the current account (Collections, Debits and Credits by voucher code). This variable is used to analyze for example the debits by rejected check, receipts, and credits by bonus, etc.
  • Average days of the payment of the last 5 Receipts
    It measures the average short-term payment, taken from the last 5 payments to know how the customer is paying.
  • Average days of the payment of the last 20 Receipts
    It measures the average long-term payment by taking the last 20 receipts. Comparing the average payment days of the last 5 receipts and the last 20 receipts it can be established if the customer improved or worsened the form of payment according to the collection policies applied.
  • Sale Previous Month
    It indicates last month’s sales per customer. It is useful to establish a relationship between debt and sale.
  • Last trimester´s sales
    It indicates the last trimester’s sales per customer. It is useful to establish a relationship between debt and sale.
  • Current Account Balance
    It indicates the current account balance at present.
  • Current Account Limit
    It shows the stated limit for the customer in current account.
  • Current Account Credit
    It indicates what the customer has as available to withdraw from current account. It is the difference between Limit - Balance Current Account
  • Own Securities Balance
    It indicates the own securities received from the customer that are still pending to be credited. When the securities are credited, the balance will increase.
  • Own Securities Limit
    It is the limit stipulated to the customer on his/her own securities
  • Own Securities Credit
    It indicates what the customer has as available to deliver own securities. It is the difference between the limit of own securities - The balance of own securities.
  • Third Party Securities Balance
    It indicates the third party securities received from the customer that are still pending to be credited. When the securities are credited, the balance will increase.
  • Third Party Securities Limit
    It is the limit stipulated to the customer on third party securities.
  • Third Party Securities Credit
    It indicates what the customer has as available to deliver third party securities. It is the difference between the limit of third party securities - The balance of third party securities

Do you want to lower operating costs and automate
processes for wholesale?