Finance Internship Report

Internship / Project Title gross Operations Specialist Internship / Project Progress I campaigned in a Saas-based familiarity as a gross operation specialist. My main responsibilities were to work closely with the CFO with hebdomadly cash flow analysis and to apply cash, book journal entries and created A/R aging reports in gelt Suite and GP. Also, I completed calendar monthly GL account reconciliations and gross waterfalls and active SOX filing, such as sales order and journal entry samples.Furthermore, I worked closely with account executives in managing all 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 victimization Pivot Table and Vlookup and created novel collection metrics and invoice direction charts on daily basis. Besides, I helped AP team up to verified over vitamin C 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 direction 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 some(prenominal) 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 forwards of one month Managed P&038L, 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. considerably-kept the budgeting model by the development and improvement of budgeting process to decrease 10% cost on d elivery rates and advertisement occupancy.Account Management move professionally with sales personnel to manage over 350 customer keep in line files in QuickBooks and 300 customers in Xeros and to implement leads generations in Salesforce. com CRM Built and veritable 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 capital 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 ternion important financial statements, which I used and reviewed in my job.