Sunday, October 15, 2023

Telecommunication Accounts and Finance -5

 

TR Packages

 The billing of basic services is being done mainly through computerized software packages in many Circles namely, Dotsoft, Trichur etc. The packages facilitate the issue of telephone bills in bulk in time for every bill date through an online system making it possible to realize the revenue in time, to effect the Disconnection and Reconnection in time to process refunds of the lines closed, and finalize the accounts of the closed lines & issue of defaulter Notices thereof etc.Dotsoft is an in-house developed software, integrating the Commercial Activities,Telecom Billing & Accounting, FRS and Directory Enquiry. It has been implemented in all the SSAs of Andhra Pradesh Telecom Circle, Gujarat Telecom Circle and in about 80 other SSAs in the states of Tamilnadu, Karnataka, Maharashtra, M.P., U.P.,Rajasthan, Punjab, J&K and Haryana in the rest of the country. Many telecom circles are planning for Dotsoft implementation in the remaining SSAs.

 Now, the Dotsoft Center had initiated the concept of Help desk not only over phone but also over-net, which helps the users across the country for the day to day changes happening in  services and its application  The general features available to the users of Dotsoft package are listed below.1. Application entry:- Online application entry for landline connections(Permanent, temporary, casual, PTs, Swatantra Senani, Senior Citizens, retired  employees, working employees, gallantry award winners & service connections). Online application entry for WLL connections-Fixed & Mobile (permanent, service). Certain application details can be changed. All India wait list transfer - Incoming & Outgoing.

2. Waitlist: - For all landline (except casual, temporary & service). For WLLmobile (permanent & service). Certain waitlist details can be changed. Out of  turn and All India shift incoming connections can be centralized /decentralized. Waitlist process for landline connections (except casual,temporary & service). Waitlist entry is possible through the offline mode also for landline connections.

3. Phone number store:- Phone numbers can be created for all valid levels and  can be marked reserved/blocked.

4. Messages to field: - Messages can be sent by Commercial Officer to all field units for priority execution, suspension, return back, continue etc.

5. Advice note release: - Capacity allocation to be done before bulk release.Advice notes can be bulk released, single release, cancelled & revised by respective Commercial Officer for land line connections. For WLL, the release is single for cent/decent. Centralized release for out of turn and AIS incoming cases.

6. Advice note routing: - Routing is automatic to the concerned field officer(Outdoor / MDF / Indoor). For WLL mobile the routing is to Indoor only. For WLL fixed the routing is to outdoor & indoor.

7. Advice note completion:- Completion of advice notes is online for all landline (except ISDN) and WLL connections. However it is possible to complete manual released / system released advice notes through the offline mode. For ISDN connections, the completion is only through the offline mode.

8. Subrouting: - COs, DEs-External, AEs-Outdoor, MDF, Indoor, Test desk can delegate their work to their subordinates without disclosing their password.

9. Request registration:- Requests for working lines activities can be registered online. The requests can be approved / suspended / cancelled by CO or referred to AO. After approval, the advice note is generated.

10. Raise D/N: - CO or AO can raise demand note for any activity.

11. Level change: - Level change operations can be done with/without meter change.

12. Area transfer: - Area transfer can be done for a single number or in bulk.

13. Disconnections: - The disconnections for non payment are initiated centrally and flow to AO. After approval, the flow is to Indoor. Reconnections are initiated by AO and then flow to Indoor. No advice notes are released. These operations are possible through the offline mode also.

14. Closures: - The closures for non payment are initiated centrally and flow to AO and then CO. Advice notes are generated by CO which flow to the field. Reconnections are through the request registration module.

15. Fault booking: - This is done online centralized for the SSA. Then the complaints are routed automatically to the respective initial testing operators at MDF.

16. Fault routing: - Based on the initial test results, the fault is routed to the corresponding SFC position (lineman at outdoor, indoor, MDF, cable). After the fault is rectified, it is routed to the final test position.

17. Fault clearance: - The fault is checked at the final test position. It is either cleared or sent back to SFC position.

18. Bulk Billing: - Billing can be done for all landline, ISDN, Centrex & WLL phones (except casual). The billing can be done for some or all exchanges. Call records error generation and clearance is possible. Unaddressed bills are generated for phones not listed in the commercial database. Group billing ispossible for grouped phones. It is possible to bill deposits also.

19. Single Phone billing: - This is possible for any past period, future period or from any past date to current date.

20. Billing periodicity: - Billing can be done monthly for landline (except STDPTs),WLL, Centrex, ISDN phones. Bi-monthly billing possible for all landline phones (except PTs), WLL & Centrex. STD PT billing is fortnightly.

21. Discounts: - Individual bill / Group bill discounts are possible. Discount on installation charges possible.

22. Bill operations: - A bill can be cancelled, given installments, disputed or written off. Instant & Final bills possible for closed connections. Bill adjustments, pay-by-date extension can be done before payment for a singlebill.

23. Bill payment: - Online payments can be done for all bills including group bills. This is authorized to a specific cashier for that day only. After the time expiry of the counter, the daily list is generated and tallied. The AO will then close the counter through a counter close module. Online payment processing is then done. Offline payments entry & processing are also possible through batch control. Receipt cancellation is possible. Surcharge carry forward, waival is possible through authorisation.

24. Trunk calls: - Trunk call / Phonogram entry is possible. Trunk rate evaluation is automatic.

25. Refund order: - Refund of registration deposits is possible if application is cancelled.

26. Ledgers: - Ledgers are generated for revenue, service tax and surcharge.

27. Voluntary deposits:- These deposits are adjusted in the bill. Interest calculation module is also available.

28. Dishonoured cheques: - Bounced cheques can be entered in Dotsoft to nullify the payment.

29. Enquiries: - Enquiries are possible on all customer related data.

30. Reports: - Various reports are possible on all customer related data.31. Dotsoft Mail: - Dotsoft users can use this mail facility and chat even.

Trichur Package

Introduction

The software is developed under SCO UNIX as the operating system and Oracle – 7 RDBMS. The user should have got basic knowledge of UNIX and Oracle.

 Following functions in TRA are handled in this package.

Billing of all telephone connections except causal connections

Billing of Telex

All payment notings and reconciliation

Accounting upto preparation of monthly sub-ledger

Preparation of periodical standard reports

The software is capable of billing for all facilities without advising specifically amount to be collected in each case. The billing is decided as per the parameters fixed which are flexible. The charging pattern is controlled by following table. The entire operation is menu driven for normal work.

Tariff

Rent_table

Slab_rent

Access_rent

Status_change_chrg

 The first 4 tables control normal billing for recurring charges and the 5th one maintains onetime charges to be collected as per the A/N, which are made on certain assumptions.

 Customization

Update table control though SQL

Schedule parameters for CTRA 4.0

The following are the Menus available

MENU–CTRA-MAINTENACE-Flexible Billing – Schedule

parameters - to generate and regulate billing schedule

The function of this table is to generate and regulate the billing

schedules as per the data created

MENU-CTRA-MAINTENACE-LOCAL STATION-RANGE ALONE

o To create local stations

MENU-CTRA-APPLICATION MD ENTRY

o To create master data from manual to computerized one

MENU-CTRA-MAINTENANCE-GROUP CODES

o Creation of group codes

MENU-CTRA-MAINTENACE-TRUNKS-REVERSE-CHARGED

NOS

o For valuation of trunk calls

MENU-CTRA-MAINTENANCE-PAYMENT-PAY PLACE

o For payment Noting

MENU-CTRA-SUPERVISOR-DEPOSIT ENTRY

o For creating Application Deposit Registers

MENU-CTRA-INPUTS-BILLS-MANUAL BILLS

o Creation of Outstanding bills

Maintenance

 

Master Related

Usage code

Class code

Connection types

Category code

Accessory code

Deposit codes

VIP codes

Status code

Creation of local stations with master records

Advice notes

o Manual procedure for the preparation of Advice note for entry

o Link to commercial service management system

o Any time process of advice notes

Metered calls

Trunk calls

Phonograms

Overseas calls

Credit Debit Management

Credit vouchers

Debit vouchers

Bill Processing

The telephone billing module is the final processing module which takes care of

finally performing all the billing related processes and producing of bills.

The following charges are billed

Rent billing of main and accessories

Operator assisted calls billing

o Inland trunk calls

o Overseas calls

o Reverse charged trunk calls

o Phonograms

Misc. charge billing (shifting installation charges etc)

Additional debit and credits

PCO billing and Telex billing

Tariff

It is possible to have divergent types of billing for different types of subscribers. Tariff is maintained customer class-wise and if a set of subscribers require different type of billing from the normal billing, create a new class code and assign that class code to those customers. Then define

the tariff for that class code. Thus separate billing tariffs can be applied for say business people or heavy callers.

Bill Number - A unique Bill No. is given for all bills.

Each and every telephone is billed irrespective of the fact whether working not. If the calls are not metered in a number which is spare, the bill will be removed when the schedule is closed. If calls are registered in a spare no. bill will be printed as unaddressed. This will help the AO (TR) to bill the telephones which are working, but the particulars have not reached the billing  centre.

Billing Group – Helps in staggering the issue of bills, for enabling

even distribution of work load in billing centre and TRA.

Schedule – It maintains a schedule table containing details of next years billing dates, the groups to be billed, the period to be considered for billing rent and call data. The schedule will be automatically generated.

Billing Procedures

The telephone billing process module consists of the following sub-modules.

Open schedule

Local calls

Rent

Trunk calls

Debit / Credit

Pay-by-date

Group Bill consolidation

Preparation

Pin code-wise

Group bill preparation

Bill printing

Close schedule

Credit process

Process list

Message entry

Group consolidation list

Group print list

The following processes are involved in billing procedure

Schedule opening

Local call processing

Rent processing

Trunk processing

Credit / Debit processing

Bill preparation

Bill printing

Schedule closing

Telephone Bills Management

This sub module helps in the maintenance of the bills in the system. It helps in the creation of new manual bills, printing of duplicate bills, cancellation of bills, disputed bills management and enquiry on bills. After issue of bills or after preparation of bills it may become necessary to make certain corrections due to incorrect feeding of data or wrong information of data from the exchange authorities. This module facilitates such corrections which can be done before issue of bills and fresh one of such corrected bills can be issued without further processing.

 Accounts Receivable and Collection Management

Payment Noting:

Payment of bill are made in post offices, telecom centres, cash counters of SSA, E-Seva counters, authorized banks, through ECS etc. Daily lists are received from these centres to the TRA. A list of all payment places is collected for the whole SSA. In the case of sub post offices the head post office is also identified. A unique code is to be allotted for each payment place.

Arrange for printing of computer daily list batch control slip form.

This is for writing the control figure for feeding the payment vouchers. One form is required per day per collection centre.

Prepare a list of all collection centres with details such as payment place code, payment place, Head Post Office, previous month Account Closing date, account head etc.

New identify the disputed bills and transfer to the disputed bill register

Payment noting procedure

o Computer daily list preparation and tallying with P.O daily list at TRA and transfer to computer centre

o Entry of daily list

o Entry of vouchers

o Computer bill payments

o Application D/N payments

o Other payments

Data entry at computer centre

o The first phase of payment noting is to feed the daily list into the computer. This is to be done by the supervisor

o After the daily list entry the bundle is transferred to other operators for the entry of individual vouchers of different category

o The computer bill payment can be entered only after the entry of the daily list of the collection centre

o Application demand note entry

o Other voucher payment noting

o Application demand note enquiry and updating

o Excess / short authorization

o Excess / short confirmation

Bill transfers

o Transfer of disputed / departmental bills to outstanding bill register

o Part transfer of departmental bills to outstanding

o Bill adjustments (cancellation)

Accounting

This module takes care of the accounting related functions of the TR Billing System. This module does final consolidation of all accounting transactions for sub-ledger processing period.

 

The following stages are involved.

Journal voucher entry

Write off entry

Cash refunds

Adjustment refunds

Review (Sub-Ledger)

Sub-Ledger Process

Sub-Ledger Process

The first step is to tally the H.O. summary of payment centres with daily list form individual collection centres entered into the computer. The monthly H.O. summary comparison report is taken and tallied afterwards.

 

Now process the sub-ledger provisionally and run outstanding bill register and make sure that the individual exchange-wise Accounts Receivable tallies with the bill register. During this if the computer locates any daily list for which no vouchers are entered, the process will be aborted and a list of such items will be produced. The system will also check for the voucher-wise account tallying and will produce a list of bills / vouchers in which the debits and credits are not tallying. After rectifying all these defects the final sub-ledger process can be done. The process can be run any

number of times so that any corrections can be incorporated before the final sub ledger is printed. If the sub-ledger is for the last month of the financial year the system will automatically take up the financial year and process and all the registers will be prepared for the next year.

 Public Telephone Billing and Telex Billing

Public Telephone Billing and Accounting, Telex Billing and Accounting and WLL Billing and Accounting etc., can also be managed with this package. Various reports and statements on billing and accounting can be generated in this package.

 =======



No comments:

Post a Comment

Telecommunication Accounts and Finance -15

  Chapter-15   Financial Management   Investment Analysis Telecom Industry is highly capital intensive. After the telecom services in India ...