Ana Colon
Accounts Receivable Specialist at Lightbox OOH Video Network- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Lightbox OOH Video Network
-
United States
-
Advertising Services
-
1 - 100 Employee
-
Accounts Receivable Specialist
-
Sep 2022 - Present
-
-
-
Cox Media Group
-
United States
-
Broadcast Media Production and Distribution
-
700 & Above Employee
-
Revenue Accounting Manager
-
2013 - Sep 2021
• 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 entries.• 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 to learn and implement the new processes• Assured accuracy of delivered impressions per campaign on a monthly basis in a timely manner to meet customer needs.• Verified accuracy of delivered impressions per campaign on a monthly basis for meeting customer needs in a timely manner.• Analyzed accuracy of delivered commercial spots on TV station billing reports for 50 - 60 TV stations.• Set-up payment method of ACH or Wire information for our clients And Managed New Business Special Deals - Maintaining a spreadsheet and sending out payments when needed• Collaborated data, tested data in SAP S4, and troubleshoot process of entering Cash Receipts, Data Charges, Revenue Reporting, and Account Reconciliation for transition of Oracle to SAP S4. Trained team of 6 to learn and implement new processes.
-
-
Accounting Revenue Supervisor
-
1994 - 2013
• 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. If differences Station contacted immediately to avoid discrepancy on aging.• 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 rates, added when needed.• 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 of station totals.• Executed monthly payments of checks, ACH, and wires from Customer clients and posted into Microsoft Dynamics (Great Plains) system, and ran month-end cash reports for all companies.• Investigated and resolved open items or discrepancies on aging by communicating by telephone or email with Sales team, Station, and Management.• Downloaded daily receipts from bank and applied the daily receipts(ACH, Checks and wires) to open invoices via SAP
-
-
Education
-
State University of New York College at Old Westbury
Accounting