Accounting Clerk II

Main Purpose and Function

This position works as part of the Accounts Receivable Team and is responsible for a full range of clerical accounting and analytical duties in billing and collecting for either Trade or Rental Accounts Receivable.

An important function of the position is to set up and update contracts in SAP as necessary and to accurately process all billing transactions (invoices, payments, deposits, refund, etc.

in a timely manner. This also includes monitoring customer accounts and following up on outstanding and overdue balances, and initiating the collection process on a regular basis.

Another important task is the reconciliation of customer accounts and the related receivable GL accounts on a monthly basis, and participating in process improvement by providing feedback and support.

Specific Duties and Responsibilities

• Sets up new contracts in SAP and updates existing contracts for changes
• Reviews invoice requests / sales orders to ensure the accuracy, approval, timeliness and completeness of billing information
• Processes billing transactions (invoice, payment, adjustments, write off, etc) through the Accounts Receivable or RE80 modules in SAP
• Issues invoices on a timely basis
• Processes deposits (e.g. Engineering and tenant security deposits, etc.) including setup, application and refund
• Issues refunds for Trade and Tenant receivable accounts after performing adequate checks and reviews
• Reconciles GL accounts (assigned / related to Corporate AR function) on a monthly basis and follows up on reconciling items on a monthly frequency
• Investigates unidentified miscellaneous payments and applies them to appropriate customer accounts in SAP
• Follows up with customers / tenants on outstanding and overdue balances and escalates to supervisor or originating departments
• Initiates the collection process on a timely basis
• Runs and analyzes the trade or rental aged trial balance
• Prepares standard and ad hoc monthly reports / KPIs
• Reconciles trade customer / tenant accounts
• Answers internal and external (including customer / tenant) inquiries within agreed Service level agreement timelines
• Prepares journal entries associated with AR / revenue function and adjusts entries for Quarter and year end purposes
• Prepares year-end working papers for related GL accounts
• Maintains the procedure manual
• Participates in process improvement by providing support and feedback
• Other duties / responsibilities as assigned

Qualifications

Education and Experience :

• Completion of diploma program in Accounting (at least 1 year), plus some related experience; or an equivalent combination of training and experience.
• Experience in using a large integrated financial system such as SAP.
• Advanced level of proficiency in Microsoft Excel or similar software.

Knowledge, Skills and Abilities :

• General knowledge of PSAB accounting Policies and City Policies and procedures
• General knowledge of internal controls for the AR function
• Ability to deal tactfully with a variety of contacts and to maintain effective working relationships with the public, other civic staff and officials.
• Ability to work under pressure and meet deadlines
• Ability to work independently and in a team environment.
• Possesses strong analytical, organizational skills and accuracy in working with numbers
• Ability to maintain sustained attention to detail in checking and recording financial transactions.
• Ability to carry out and analyze established accounting procedures and to suggest methods of improving departmental accounting practices.

Where operationally appropriate and subject to change, the City of Vancouver has a Flexible Work Program. This program allows staff to work remotely 1 4 days a week from locations that are a daily commutable distance from their work at a City worksite.

At this time this position is eligible to be part of the Flexible Work Program.

Business Unit / Department : Finance, Risk & Supply Chain Management (1150)