Ana Colon Email & Phone Number

New York, United States

Created and sent invoices to Clients. I worked with the Clients and Sales team to clear any discrepancies.Utilized Clients portals to send invoices and view payment status.Client reconciliation Reviewed, monitored assigned accounts and created Statements reports for open invoices.Collections process including emailing Statements and reminders to Clients..

New York, New York, United States

• Analyzed for accuracy month-end Darwin Revenue reports and imported journal entries into SAP S4 creating next month estimate number and accrual, and Truing up current month.
• Analysis of month-end cash reports for HRP, Telerep MMT and Gamut and reported any anomalies to the team. Applied cash to open invoices and created credit memos
• Accountable for providing Director of Finance with monthly account reconciliations of doubtful accounts, Revenue, Data Charges and Cash( sub-ledger and ledger matching). Prepared Revenue, Accrual and reclassification.
• Compiled monthly aging for HRP, Telerep and MMT for President and GSM's. Worked with my team to lower the unpaid commissions. Working with my team the 120+ days went down 80%
• Guided team of 6 direct reports with the reconciliation of 300 TV Stations, analyzing station reports and updating system, achieving accurate numbers for commercial spots for the month.
• With the transition of Oracle to SAP S4, Collaborated data, tested data in SAP S4 & troubleshoot the process of entering Cash Receipts, Data Charges, Revenue Reporting, and Account Reconciliation. And trained team of 6.

• Reconciled 40-50 stations using Blackline and Medialine, comparing station report and Medialine report and uploaded station numbers in Medialine verifying accuracy of delivered commercial spots on TV station reports..
• Presented reports and worked on testing module for transition of Data Charges from RMS to Great Plains.
• Extracted station month end actual reports from Medialine and analyzed for accuracy of station information. And uploaded Medialine Reports into RMS system, consolidating and analyzing information and Special commission.
• Uploaded Medialine Reports into RMS system, consolidating and analyzing information and Special commission rates, added when needed. And Maintained & updated Client information in RMS.
• Executed RMS reports and uploaded journal entries into Great Plains to create invoices, estimating total for next month and truing-up current month total.
• Compiled aging to identify outstanding balances, wrote off bad debt or notify management for accounts in need of negotiation settlement for Management. And created credit memos in SAP S4 as needed, maintaining accuracy.