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