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 change flow analysis and to apply cash, oblige 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 approach 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 squad up to verified over 100 weekly expense reports for employee expense reimbursements and assisted with accounting logs and billing/revenue clo se process.I also supported in forwardness 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 reinforced 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 positive due date and exceeding manager expectation. Maintained the budgeting model by the development and improvement of budgeting process to decrease 10% cost on livery rates and advertisement occupancy.Account Management Engaged professionally with sales personnel to manage over 350 customer master files in QuickBooks and 300 customers in Xeros and to see 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 construct 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 measurable financial statements, which I used and reviewed in my job.