What are the responsibilities and job description for the Revenue Accountant position at Bandai Namco Entertainment America?
POSITION SUMMARY
Bandai Namco Entertainment America is looking for a Revenue Accountant to play an integral role on the finance and business operations team. In this role, you will have a broad range of duties including various aspects of monthly close and general ledger responsibilities. To be successful, you will need to be a self-starter and possess impeccable attention to detail, strong financial savvy, high aptitude for technology and financial systems and a strong desire and ability to work in a fast-paced environment.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Handle daily reporting of revenue by reviewing the data from different sources, such as digital sales data from BIOne Data Warehouse originating from 1st party portals, Free-2-Play and Mobile portals as well as box data from Oracle.
- Access to partners' portal to retrieve monthly or quarterly statements. Identify and investigate variances between invoiced sales numbers generated from 1st party portals and final statement received from their finance departments. Process adjustment invoices in Oracle via BIOne Data Warehouse after reconciliation is reviewed and completed.
- To create and maintain the mapping between raw sale data, final statement and Oracle game code and revenue account code, the information on new products including game titles on various platforms, bundling and DLCs is essential. For setting up the allocation on bundle, pricing and component information are required. Research and understand our products by checking company website, self-studying on 1st party websites, making inquiry to producers as well as marketing team within the company is needed. Create new title groups in BIOne mapping, link the new titles from the raw sales data/final statements to the correct title group within the mapping, provide each title group with correlated GL code, Oracle game code and parent grouping details. Send request for new item numbers to be created when not existed in Oracle.
- Work with Apps Team on the enhancement of invoice automation process including portal invoices, catch up invoices, adjustment invoices and statement invoices
- Experience in royalty in-bound accounting; review IP licensing agreement to process the invoice for minimum guarantee, keep track of recoupment stated in the royalty statement received from licensors, follow up with licensors for missing royalty statements, process invoices in Oracle, follow up on collection of payment from licensors
- Follow up on past due digital sales statements from 1st parties and collection issues on digital accounts
- Give detail instruction to Cash Application when payment is received
- Coordinate with Apps Team to ensure the completeness and accuracy of the flash sales data and monthly/ quarterly statements in BIOne Data Warehouse
- Reconcile and balance revenue, deferred revenue, accrued AR account at month end closing, investigate and research if there are any variances
- Prepare manual journal entries for the month end estimated sales accrual, keep track of revenue related entries and reversal entries under RevSym Revenue system and Oracle.
- Review RevSym system generated revenue entries and reports per manager's requirement. Reconcile based on specific project/products as well as transactions from Oracle.
- Prepare month end revenue report by business unit with game title details, month end revenue report by customers and other reports per request.
- Provide audit PBC as requested and communicate with auditors
- Work on ad hoc assignments such as state apportionment, analysis of Downloadable Contents value per title, etc.
QUALIFICATIONS/REQUIREMENTS
- BS in Accounting/Finance
- 5 years in Accounting
- Experience working with applications, data, and other technical teams preferred
- Strong organizational, verbal, and written communication skills
- Advance excel skills
- Strong analytical and problem-solving skills
- Highly detail-oriented, strong ability to prioritize and multi-task to meet deadlines