.

Tuesday, March 5, 2019

Finance Internship Report

Internship / Project appellation Revenue Operations Specialist Internship / Project Progress I worked in a Saas-based company as a revenue operation specialist. My of import responsibilities were to work closely with the CFO with weekly cash flow epitome and to apply cash, book diary entries and created A/R aging reports in Net Suite and GP. Also, I completed monthly GL account reconciliations and revenue waterfalls and prepared SOX filing, such as sales order and journal first appearance samples.Furthermore, I worked closely with account executives in managing everywhere 350 customers, generating throwaways and processing payments in Quickbooks and Xero. When my company transferred system, I migrated all over 5 GB of system data using Pivot Table and Vlookup and created novel collection metrics and invoice accusation charts on daily basis. Besides, I helped AP team to verified over 100 weekly expense reports for employee expense reimbursements and assisted with accoun ting logs and billing/revenue close process.I also supported in preparation of fiscal statements and management reporting and managed billing schedules for revenue recognition This position helps me deduct how a finance department runs in the daily work. Also, I construct many skills relevant to accounting in the software industry, such as revenue recognition, account receivables and VSOE. I summarized what I learnt and contributed for my company below.Revenue and Budgeting Assisted fiscal team to reached $29 million quarterly revenue target in ahead of one month Managed P&L, aged receivables, income statement, bank reconciliation reports and journal entry for monthly revenue reconciliation Handled revenue waterfall month end closures in an accurate and timely manner, finishing a week before official due date and exceeding four-in-hand expectation. Maintained the budgeting model by the development and improvement of budgeting process to flow 10% cost on delivery rates and advert isement occupancy.Account focusing Engaged professionally with sales personnel to manage over 350 customer master files in QuickBooks and 300 customers in Xeros and to implement leads generations in Salesforce. com CRM strengthened and developed customer relationships to enhance performance in the bank and generated 10% in portfolio revenue. Data Management Posted daily cash applications and journal entries in various accounts in Net Suite, kept track of over checking and money market accounts simultaneously and maintained onsistently 100% accuracy retrace over 5 GB of system data using vlookup and combination formulas in Excel, handled software compatibility issues, input and output parsing, saved company over 30 hours in automating the manual migration of data. Overall, what I learn from class in ITU is well applied to my job. For instance, in Financial Accounting class, we learnt the knowledge roughly three important financial statements, which I used and reviewed in my job.

No comments:

Post a Comment