Accounting Clerk - Finance (Temporary) - Full-time

Full-Time, Temporary (less than 1 year). Located in Mililani Technology Park.

PURPOSE STATEMENT: The purpose of this position is to process subscriber payments, refunds, billing adjustments, and other related transactions and to ensure that customer accounts on the AS400 Billing System and cash accounts in PeopleSoft Financial AART module are updated on a daily basis.

REPORTING RELATIONSHIP: This position generally reports to the Manager, Banking Services.

MAJOR DUTIES AND RESPONSIBILITIES:

ESSENTIAL FUNCTIONS:

1. Accepts subscriber payments on accounts from various sources and then accurately enters payment data in the AS400 billing system.

• Process 3rd party bill payer payments, i.e. Checkfree, Ipay, Metavante, where payment files are downloaded from the web, sorted, and posted to the AS400 (either manually or via upload).
• Handle all “unprocessed” items returned from First Hawaiian Bank and Bank of Hawaii (lock box processor) – including payments without remittance stubs, unmatched payments, returned checks, etc.
• Unposted payment items to be checked daily and corrected. AS400 reports to be downloaded and unposted items to be researched and cleared on a timely basis.

1. Balancing and reconciliation processes.

• Enters daily batches for cash deposits for Oahu to PeopleSoft Financials AART module and coordinate with the Neighbor Island systems for batches processed on their behalf. Obtain authorized approvals for the daily batches entered and balance daily cash in AART.
• Balance all deposits/batches to deposits/adjustments entered into AS400 billing system daily. Reconcile and correct any differences before finalizing and posting.

1. Research, prepare and process subscriber refund checks.

• Ability to research subscriber accounts to prepare and process refund checks.
• Receives proper approval when preparing refunds.
• Handle returned refund checks – resend if forwarding address is available.

1. ACH and Credit Cards.

• Process all new ACH applications.
• Research inquiries for cardholder disputes and process any reversal of credit card payments.

1. Handle research requests from Customer Care which can include misapplied subscriber payments, adjustment requests, etc.

1. Handle inquiries and research requests from Regional Accounting for payments or adjustments received via EFTs or through inter-divisional entries.

1. Performs other duties as assigned.

1. Regular attendance is required.

HUMAN RELATIONS: Has contact with Division and Regional Accounting personnel. Has no supervisory responsibilities.

QUALIFICATIONS:

EDUCATION/EXPERIENCE: High school diploma or equivalent required. Minimum of three to six months in office billing or accounting experience. Stable employment history. Course work in accounting or bookkeeping may be substituted for experience requirement.

SPECIAL SKILLS, KNOWLEDGES AND ABILITIES: Typing 40 words per minute, use of telephone system, and 10-key by touch. Experience using Microsoft Windows based software, including Microsoft Word and Excel is required. Must have excellent math skills.

WORKING CONDITIONS:

MATERIALS AND EQUIPMENT USED: Personal computer, printer, ten key calculator, telephone, and other general office equipment.

PHYSICAL REQUIREMENTS: Sitting for long periods of time. Works inside throughout the year. Typing, reading and data entry on the computer. Typing, reading and data entry on computer. Heavy use of 10-key calculator. Communicating on telephone with other departments, other Division staff and Regional Accounting staff.

Hours: Monday - Friday, 8:00am - 4:30pm. Additional coverage as needed.