Joachim E. Fernandes

Retrieved imported batches and applied affiliate cash imported from bank to Medea Imported and updated subscriber numbers and subscriber revenue daily in Medea Made system level adjustment to reflect actual amount due

AR Accountant - Fox Networks

(2020-02)

• Retrieved imported batches and applied affiliate cash imported from bank to Medea
• Imported and updated subscriber numbers and subscriber revenue daily in Medea
• Made system level adjustment to reflect actual amount due
• Responsible for maintaining 2 of the top 12 accounts
• Reconciled past invoices through subsequent adjustments and reported payment issues to collectors

Accountant / Staff Accountant - Watt Companies, Little Giraffe, Amenecer, MGM Studios and Advanced Air

(2017-08 - 2020-01)

Long Term Contract Assignments

• Applied cash receipts, ran aging reports and accounts receivable reconciliation
• Reviewed, coded and processed vendor invoices
• Monthly bank reconciliation
• GL entries for Cash, Accounts Payable and Accounts Receivable
• Journal entries for cash, accounts receivable and accounts payable
• Account Reconciliation, cash reconciliation and bank reconciliation
• Posted customer receipts to Sage MAS 90 and
• Used EDI system for Nordstrom payments
• Initiated cash collections
• Performed daily, weekly and monthly forecast
• Reviewed, coded and processed construction invoices (Residential) using Newstar accounting system
• Reviewed construction contracts and processed/updated lien releases.
• Reviewed and processed approved contract/Po and non-contract/PO invoices before entering them in Newstar. Filed and maintained Purchase Orders for assigned vendors. Processed expense reports
• Ran daily, weekly and monthly financial reports for management
• Processed 350 to 400 invoices a week using Autopay
• Assisted management on special projects as needed

AR Staff Accountant - CBS Television

(2016-08 - 2016-10)

• Assisted in Cash Management, Cash Log Testing and other computer enhancements testing
• Researched unapplied cash receipts over 30 days old
• Followed-up on old reconciling items that had not been corrected by collectors
• Printed out monthly invoice and did monthly mailing
• Filed Journals and cash applications
• Performed back-up functions for cash application clerks when they were out
• Reconciled Simplier clearing accounts when Financial Analyst/Sr. Financial Analyst was out
• Maintained Cash Log to track that all cash applications submitted by collectors had been posted

AR Accountant - PriceGrabber

(2015-07 - 2016-07)

• Collection of US and Canadian accounts
• Performed monthly accounts receivable account reconciliations and journal entries
• Used Great Plains
• Validated chargebacks and credits
• Created debit and credit memos

AR/Royalty Analyst - Saban Brands

(2015-04 - 2017-07)

• Managed contract compliance with relation to royalties
• Accounts receivable
• Initiated cash collections
• Corresponded with all agents and licensees to collect royalties
• Coordinated with the sales and legal teams
• Posted customer receipts to accounting system
• Trained users to the rights management system for reporting
• Provided weekly status reports of licensing royalty submissions
• Prepared licensee performance analysis on a weekly basis
• Prepared monthly commission reports
• Set up agents with user access to the rights management system
• Maintained accurate records of all licensing agreements
• Participated in month end financial closing requirements

Royalty Analyst - Universal Music Publishing Group (Contract)

(2014-11 - 2015-02)

• Preparing and entering reports for UMPG affiliate territories across the world
• Reconciling cash receipts to electronic royalty statement file
• In Excel, preparing and analyzing data from electronic statement file for use in cash reconciliation worksheet
• Tracked royalty payments and statements weekly
• Preparing electronic adjustment files for reposting income through various report download options in royalty system
• Assisting with reconciling Cash Book to incoming royalty statements processed in the royalty system
• Analyzing and matching song data from incoming royalty statements to appropriate songs in royalty system
• Analyzed electronic statement files for best interface option
• Uploading electronic files through a FTP server, email or disc and organizing archived electronic statement files on the system shared drive
• Collaborated and communicated with UMPG affiliates to fix problems with affiliate royalty reports

Royalty Analyst - Welk Music

(2014-06 - 2014-08)

• Royalty contract compliance audits to determine whether clients were paid royalties to which they were entitled. Used Royalty Share software.
• Tracking of incoming royalty statement to ascertain completeness and accuracy
• Preparation of royalty statements for songwriters

AR Accountant - Paramount Farms (Subsidiary of Roll International) (Contract)

(2012-05 - 2014-05)

• Collection of US and Canadian mass merchant and distribution accounts
• Weekly review of outstanding invoices to ensure customer has adhered to payment arrangements
• Reconciled deductions to credit memos, validated charge-backs and credits
• Responsible for distribution, freight, shipment, order processing and product returns
• GL entries for cash and accounts receivable
• Used Oracle for accounting

Commissions Analyst - Wellpoint (Contract)

(2011-06 - 2012-01)

• Received, checked and entered broker and customer information into finance systems
• Prepared monthly broker commission reportsAdjusted broker commission schedules. Processed NY policies, Unicare renewals, broker of record changes and setup efts
• Tracked reports for reconciliation and analysis. Processed garnishments and levies
• Monitored and updated controls to ensure broker compliance with company rules

Chargeback Analyst - Razorgator(Contract)

(2009-01 - 2011-04)

• Researched chargeback cases to fight charges and reduce company's liability for credit card fraud. Used Great Plains for accounting
• Responsible for verifying freight, shipment, order processing and product returns

Accounts Receivable Accountant and Licensing Fees Analyst - Game Show Network (Entertainment)

(2005-10 - 2008-07)

• Processed licensing fees from affiliates in Medea database. Daily cash application
• Maintained subscriber database, reviewed trends and accurately recorded changes in system roll-up. Worked with large data files to track affiliate revenues.
• Bank reconciliation. Cash reconciliation. Coordinated with customers, sales and legal to implement contractual terms for the customers
• Collection Calls. Coordinated with legal and sales departments to collect past due receivables
• Verified affiliate reporting is complete and paid according to contractual rates as well as maintained accurate records of reporting history.
• Prepared, analyzed and distributed Affiliate A/R aging report. Reported on outstanding balances to Finance and Affiliate Sales executives in monthly meetings
• Assisted with month end, quarter end and year end close
• Generated and mailed monthly invoices to 70 affiliates. Billed 7 million dollars monthly
• Generated and reported revenue estimates to Accounting Manager.
• Reconciled monthly aging report in General Ledger with Medea
• Prepared budget versus forecast variance analysis report
• Prepared Journal Entries

Bachelors of Science - Business Administration with option in Finance - California State University at Northridge