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. And Phone interaction for past due invoices. Managed aging report - identified and contacted customers who have past due balances to secure payments and provided management statuses on overdue receivables.Month end closing - Run and review for accuracy revenue Rev Rec reports. Resolved any issues.Processed Revenue journal entries in Lovis accounting system. And processed journal entries to Inter-company funds.Account Reconciliation: reviewed for accuracy the Revenue account and provisions account. Made any changes or corrections needed. Processed credit card payments with accuracy. And applied the payment to the open invoice. Maintained provider payment information in Lovis to ensure accurate delivery of credit card payments or electronic ACH or wire.Prepared, applied and posted cash receipts to Clients open invoices.Assisted with audits: Liaise with auditors to provide documented backup for inquiries.Supported co-workers submitting expenses.

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 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.

• 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