General Ledger

In CMPClosed Converged Monetisation Platform. The MDS Global product that supports customer care and billing for digital service providers., the accountClosed In the Cloud Monetisation Platform, a billing entity that can be used to manage payments on one or more subscriptions or payments for services. An account can hold details such as payments or invoices. balance is held in a ledger system known as the Sales Ledger, which consists of all the invoices and payments relating to a particular account. The ledger system also includes a General Ledger, where the amounts due and payments received are allocated to various General Ledger accounts, depending on how a company wants to organise its financials. A general ledger is a set of numbered accounts that a business uses to keep track of its financial transactions and to prepare financial reports. Each account is a unique record summarising each type of asset, liability, equity, revenue and expense.

The General Ledger job creates a batch detailing the daily breakdown of all payment, invoice, purchase and bond redemption information (along with an associated nominal code) for a particular calendar month.

General Ledger extracts the following based on the job run period:

  • Payments - The payments nominal code is specified at the top of the Payments section in the General Ledger JSONClosed JavaScript Object Notation. JSON is a lightweight format for storing and transporting data, often used when data is sent from a server to a web page. output. The following breakdown exists within the Payments section of the JSON output:
    • Recurring - covers both successful and failed (reversals) recurring payment records accumulated by payment type (Direct Debit, VISA, etc) for each day within the job run period. Failed recurring payments will appear as two records in the extract, one for the original payment and one for the reversal. These transactions may appear on separate days and in separate extracts based on when the payment was drawn and the reversal occurred.
    • Non-recurring - covers only successful one-off payments for each day within the job run period.
    • Online - covers only successful online payments for each day within the job run period.
    • Bond - covers only successful bond payments for each day within the job run period.
    • Refund - covers only successful refund payments for each day within the job run period.
    • Prepaid Balance - covers only successful payments from a prepaid balance for each day within the job run period.
  • Invoices - The invoices nominal codes are specified at the top of the Invoices section in the General Ledger JSON output.
    • Summary of tax - creates a record for each distinct day and tax rate. If there are multiple tax rates separate totals are accumulated for each tax rate.
    • Summary of the nominal charges - accumulates a total per day per nominal code.
  • Bond redemptions - a bond redemption summary record is created totalling bond redemptions for each day within the job run period. Zero totals for a day are not reported. The bond redemptions nominal code is specified at the top of the Bond Redemptions section in the General Ledger JSON output.
  • Purchases - a purchases summary record is created for each purchase type (prepaid, postpaid or balance) totalling purchases for each day within the job run period. Zero totals for a day are not reported. The purchases nominal code is specified at the top of the Purchases section in the General Ledger JSON output for each purchase type.