Finance Internship Report

Internship / Project Title: Revenue Operations Specialist Internship / Project Progress: I worked in a Saas-based company as a revenue operation specialist. My main responsibilities were to work closely with the CFO with weekly cash flow analysis and to apply cash, book journal 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 entry samples.Furthermore, I worked closely with account executives in managing over 350 customers, generating invoices and processing payments in Quickbooks and Xero. When my company transferred system, I migrated over 5 GB of system data using Pivot Table and Vlookup and created novel collection metrics and invoice billing charts on daily basis. Besides, I helped AP team to verified over 100 weekly expense reports for employee expense reimbursements and assisted with accounting logs and billing/revenue close process.I a lso supported in preparation of financial statements and management reporting and managed billing schedules for revenue recognition This position helps me understand how a finance department runs in the daily work. Also, I built 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 financial 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 manager expectation. Maintained the budgeting model by the development and improvement of budgeting process to decrease 10% cost on delivery rates and advertisement occupancy.Account Management: Engag ed 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; Built 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; Reconstructed 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 about three important financial statements, which I used and reviewed in my job.