Revenue Accountant

Revenue Accountant

Schedule Format - Location : Hybrid - San Francisco

Pay Information : $34.00-$42.00 Hourly

Position Summary :

KQED's 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.

This role will work hybrid between working in KQED's newly renovated headquarters and working remotely.

Essential Functions :

• 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.
• Download Previous Day Composite Report from banking website, which details the previous day's transactions, and utilize report to :
• Prepare Daily Cash Report to estimate available cash for operations. This is calculated using the previous day's 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.
• 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.
• 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.
• 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.
• 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).
• 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.
• Maintain Balance Sheet Analyses of receivable and deferred revenue accounts. Investigate discrepancies and corrections needed.
• 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
• Reconcile third party reports for vehicle donation program reporting with cash received, and prepare journal entries for month end close
• Other duties as assigned, but are not limited to :
• Filing, scheduling, meeting set-up, shredding checks after deposit, etc.

Candidate Qualifications :

Physical Demands :

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.