I was brought onto a project to create deferred revenue reconciliations, which the client hadn’t created before. I went through all the data since the client’s 2013 NetSuite implementation to pull the correct sales order number for each transaction via reports from NetSuite Invoice to Sales Order, Credit Memo to Sales Order, Revenue Commitment Reversal to Sales Order and Return Authorization to Sales Order. I also went through all the 606 conversion backup files to find correct sales order numbers.
Once the transactions had the related sales order numbers, I created a pivot table to show if the sales order had been fully invoiced or amortized or even show the current balance per sales order or customer. Going forward, the client will be able to add on the new monthly data to reconcile the deferred revenue accounts in subsequent months. These reconciliations will help easily track the client’s deferred revenue by customer and sales order, and they will be able to drill down for more detail on a particular customer or sales order.
Careers at 8020 Consulting
We take pride in nurturing long-term relationships with our team members and our clients. If you’re interested in working on our team of accounting and finance consultants, visit the careers section of our website to learn more about life at 8020. You can also put in an application for consideration by following the instructions at the bottom of the page:
Erika has over 12 years of experience in accounting and finance in a diverse set of industries such as Retail, Entertainment, Commercial Real Estate, Manufacturing, and Public Relations. Prior to joining 8020 Consulting, Erika served as Accounting Manager for the retail company Delta Galil Premium Brands who owns the apparel brands 7 for all mankind and Splendid and previously worked for 20th Century Fox as an Accounting Manager. Her specialties include Financial Reporting, Month End Close, General Ledger, Budgeting, Cash Forecasting, and Data Analytics. Erika has an Executive MBA from Loyola Marymount University and received her BS in Business Administration with an emphasis in Accounting from the University of Colorado at Boulder.
Categorized in: Careers