Title: Revenue Accountant

Schedule Format - Location: Hybrid - San Francisco

Pay Information: $34.00-$42.00 Hourly

Position Summary:

KQEDs annual operating revenue of about $90 million is derived from sources including contributions from members underwriting revenue foundation & development revenue trade and in-kind donations and fee for service arrangements. The Revenue Accountant is responsible for ensuring timely processing and coding of a high volume of customer billing and cash receipts. The Revenue Accountant is also responsible for the preparation of revenue related journal entries and reports in accordance with GAAP.

KQED envisions a public media organization with a culture that centers on human dignity equity and belonging. This will enable us to better serve and reflect the Bay Area through diverse and inclusive storytelling.

We value the contributions of marginalized people in society including Black Indigenous and all people of color people with disabilities and LGBTQIA people and we believe that these communities must be centered in the work we do and we strongly encourage members of these communities to apply.

KQED Code of Ethics mission that drives us:

KQED provide citizens of Northern California with a community-supported alternative to commercial media. We provide citizens with the knowledge they need to make informed decisions; convene community dialogue; bring the arts to everyone and engage audiences to share their stories. We help students and teachers thrive in 21st-century classrooms and take people of all ages on journeys of exploration- exposing them to new people places and ideas.

This role will work hybrid between working in KQEDs newly renovated headquarters and working remotely.

Essential Functions:

1 Download daily cash transactions from the bank and maintain cumulative month to date data in an Excel workbook. Investigate and collaborate with key individuals across revenue departments Human Resources and Accounts Payable to identify and record unknown cash receipts.

2 Download Previous Day Composite Report from banking website which details the previous days transactions and utilize report to:

• Prepare Daily Cash Report to estimate available cash for operations. This is calculated using the previous days cleared transactions per bank outstanding check activity and estimated disbursements for the day. Reconcile estimated disbursements against actuals.
• Monitor daily activity identifying transactions inquire about unknown transactions or discrepancies and confirm transactions posted.

3 Collate cash and checks into specific deposit batches based upon type of cash receipt (i.e. contribution non-contribution revenue department etc).

• Update AR Check Log Google Sheet which is shared with Development and membership flagging payments that are restricted or with conditions.
• Create PDF support documents to be copied into the KQED Cloud for sharing with other departments.
• Prepare internal paperwork to transfer funds for restricted gifts from the operating account.

4 Prepare cash and checks for deposit into bank.

• Open Finance department mail and distribute or re-route to correct departments within KQED. Isolate checks and collate into deposit batches.
• Receive checks from other departments (Membership Development Sponsorship etc.) and prepare for deposit.
• Scan checks envelopes and other supporting documentation to create redacted PDF documents.
• Deposit checks using e-desktop scanner confirm count and total amount of deposits.
• Deposit in-person at the bank cash/checks received that cannot be deposited electronically.

5 Manage Accounts Receivable email in-box

• Review e-mail at least twice a day and immediately reply to urgent inquiries such as confirming cash received requests for an Account Statement invoices or a single use credit card hyperlink etc.
• Maintain and create e-mail templates or default replies used to efficiently respond to common inquiries.
• Process urgent inquiries and collaborate with Revenue Manager (as needed) on responses for inquiries that require more attention consideration or similar.
• Manage inquiries where AR is awaiting a response until the issue is resolved or information required is received.
• Review e-mails flagged by Mimecast Spam Filter for e-mails that require attention. Review Junk e-mail folder to update white list of approved senders update mailing lists unsubscribe AR from marketing or social media notifications to organize and manage the AR inbox.

6 In conjunction with outside consultant review and reconcile transactions entered in the Customer Relationship Management (CRM) system Revolutionary Online (ROI) to cash receipts (cash checks EFTs and credit cards).

• Collaborate with gift processors in the Membership and Development departments to identify and process missing transactions.
• Investigate issues and work with other departments to resolve. Issues may include incorrect amounts check numbers deposit dates and duplicate entries.
• Re-organize ROI transactions into system Deposit batches which align with deposits made to WFB.
• Prepare cash receipts journal in GL software (Intacct).

7 Become a steward of the WideOrbit (WO) trafficking and payments system and its data as it pertains to Finance. This includes but is not limited to:

• Preventing or eliminating duplicate customers update credit status based on Aging update billing contacts and preferred billing methods.
• Review D&B credit reports for new customers approve WO finance credit stops and identify high risk companies.
• Assist other departments with troubleshooting or making adjustments to transactions as necessary.
• Update and create users for WO payment portal and refresh outdated payment links.
• Follow up on delinquent accounts and prepare monthly reporting for management review for collections priority.
• Draft FAQ for internal and external users of the system.
• Work with Account Executives Corporate Sponsorship Ops Customers and WO Help to prevent invoice errors and investigate over/under payments.

8 Maintain Balance Sheet Analyses of receivable and deferred revenue accounts. Investigate discrepancies and corrections needed.

9 Actively pursue collection of outstanding accounts receivable:

• E-mail monthly account statements and payment past due reminders
• Document communication and efforts to collect maintaining notes in the Aging

10 Reconcile third party reports for vehicle donation program reporting with cash received and prepare journal entries for month end close

11 Other duties as assigned but are not limited to:

• Filing scheduling meeting set-up shredding checks after deposit etc.

Candidate qualifications:

• BA or BS degree in Accounting Finance or Business Administration.
• Minimum of five (5) years experience in accounts receivable accounting or general finance
• Strong attention to detail and 10-key skill.
• Highly organized and dependable.
• Knowledge of generally accepted accounting practices (GAAP).
• Ability to communicate professionally with organization staff/customers through multiple channels of communication (i.e. e-mail Slack in person Zoom and Google sheets).
• Working knowledge of MS software Excel/Google Sheets and Word.
• Ability to work under pressure and meet deadlines has a sense of urgency.
• Ability to work in a team environment as well as to work independently.
• Non-profitindustry experience (preferred)
• Working knowledge and experience with Intacct ROI and WideOrbit software (preferred).

Physical Demands:

• Ability to lift a minimum of fifteen (15) pounds;
• Ability to exert maximum muscle force to lift push pull or carry;
• Ability to use abdominal and lower back muscles over time without fatigue;
• Ability to stand and/or sit for extended periods;
• Ability to bend stoop stretch twist sit and reach;
• Fine motor skills;
• Good visual and auditory acuity.

The physical demands described here represent those that an employee must meet to perform the essential functions of this job successfully.

NOTE: This job description is not intended to be all-inclusive. Employees may be required to perform other related duties as necessary to meet the ongoing needs of this organization.