NBCUniversal: Perform accounting duties for a company that distributes foreign-language television channels to cable operators.
This involves recording/tracking subscribers, revenue and Accounts Receivable/Partner Liability journal entries, programming partner revenue share payments and financial reporting.
ESSENTIAL FUNCTIONS
Maintenance of Subscriber Worksheets
- Prepare billing worksheets for subscriber payment entries from cable operators monthly. Annually create a new year billing worksheet for each channel.
- Update worksheets for any partner revenue share rate changes and any cable operator rate changes.
- Post payments received from cable operators. This includes subscriber numbers as well as cash receipts. Communicate with cable operators and internal company sales, marketing and legal personnel to resolve discrepancies.
- Notify management and programming partners of any significant adjustments.
- Reconcile cash and subscribers posted to worksheets to amounts recorded in the check register to facilitate revenue share preparation for programming partners.
- After the month-end close, follow set procedures to save monthly files and prepare for next month’s activity.
- Create new worksheets as needed for new services per the distribution agreement terms.
Recurring Monthly Journal Entries
- Calculate, prepare, document, and enter journal entries.
- Estimated revenue calculation, as well as prior period true-ups
- Reconcile AR balances for each channel and enter any reclass journal entries necessary
- Calculate and enter any foreign tax withholding based on specific channel country location
- Book any Bad Debt based on NBCU policy
- Prepare any other miscellaneous journal entries as necessary
Monthly Revenue Share and Partner Reporting
- Calculate the programming partner’s revenue share per the terms of the partner distribution agreement. Forward check request documents for review and payment processing.
- Prepare and distribute electronic partner monthly reports – include revenue share calculation detail and billing worksheets.
- Prepare any miscellaneous reports requested explicitly by partners.
- Respond to all programming partner inquiries related to monthly reporting.
- Where the programming partner collects license fees, follow up with the partner to collect management fees. It may require the company to issue partners invoices to receive payment.
- Comply with partner audit requests as needed.
Reconciliation Duties
- Maintain General Ledger accounts for assigned balance sheet accounts.
- Prepare accounts reconciliations in accordance with NBCU policy and reporting schedules.
- Maintain reconciliations of each service, verifying affiliate accounts receivable and partner liability.
Tax Duties
Foreign Withholding Tax
- Ensure Form W-8BEN-E forms for foreign partners and vendors are current and filed with Tax Department. Update expired forms as needed and submit them to the Tax Department for review and approval.
- Coordinate potential new foreign vendors with Accounts Payable and calculate withholding as required.
- Calculate required foreign withholding for partners subject to withholding based on gross cash receipts. These calculations are detailed on revenue share documentation.
- Maintain foreign vendor payment worksheet monthly. This worksheet also serves as a source document for additional quarterly reporting.
- Report monthly foreign withholding to Tax Department to initiate payment to Internal Revenue Service.
- Annually prepare Form 1042S for all foreign/W-8 partners and vendors.
Miscellaneous Tax
- Notify the Tax Department of any unique tax situations. Coordinate action/response as needed and provide any requested documentation.
- Work with NBCU Tax Department to provide needed revenue information for NBCU-owned partners.
- Comply with international tax requirements.
Accounts Payable
- Responsible for Accounts Payable activity.
- Upload and work with other team members to ensure proper GL coding of invoices.
- Initiate and follow up with the introduction of any new vendors.
- Enter wire and ACH requests as needed for monthly revenue share payments to programming partners.
Other Duties
- Review partner and cable operators’ contracts as needed for appropriate accounting treatment.
- Assist with special projects as requested.
Qualifications
EDUCATION and EXPERIENCE
- Bachelor’s degree in Accounting or related finance field preferred.
- Four years of previous accounting experience in the following preferred areas: Accounts Receivable, Revenue reconciliation and Accounts Payable.
- Cable industry experience preferred.
Knowledge, Skills and Abilities
- Working knowledge of accounting principles and practices.
- Experience with MS Office products with a strong emphasis on Excel and an understanding of formulas.
- Ability to work with large amounts of data, utilize database applications, and upload data.
- Detail-oriented with high accuracy with data entry.
- The ability to organize and prioritize multiple work assignments, working independently with minimal supervision.
- Ability to work under pressure to meet deadlines.
- Ability to communicate with customers, co-workers, and other business contacts in a courteous and professional manner. Work effectively as a team player.
Salary: 75,000 - 90,000 USD