Stephen Fabian Email & Phone Number

Saint Paul, Mn, Us

Minneapolis, Minnesota, Us

Denver, Colorado, Us

- Created and documented user-friendly processes with Power Query, making tasks as easy as saving datasets, refreshing, reviewing, and importing data.- Leveraged Excel Power Query to automate the creation of import files for journal entries, bills, bill payments, customer invoices, cash receipts. -Mentored a team member, increasing proficiency in Excel formulas, Power Query, and time-saving Excel shortcuts.-Led month-end close processes for two entities, ensuring timely and accurate completion of account reconciliations, including bank and crypto wallet reconciliations, prepaid expenses, and accrued liabilities.

Fargo, North Dakota, Us

- Managed acquired location's accounting process while preparing to move all accounting functions to parent company's accounting team and ERP system- Created Excel bank reconciliation tool that auto-matched general ledger and bank transactions- Automated multi-divisional payroll journal entries with Excel Power Query and formulas- Taught peers how to use Excel pivot tables, formulas, and power query

Burnsville, Mn, Us

- Accounting subject matter expert for a successful NetSuite implementation - Successfully transferred historical financial balances and open transactions into NetSuite- Trained employees on how to use NetSuite saved searches using SQL expressions and editing canned reports- Guided one accountant, contract accountant, and office manager accounting and day-to-day tasks- Implemented Sovos' Global Tax Determination engine- Collaborated with IT to automate dunning process- Automated multiple eCommerce payout reconciliations with Excel Power Query and SUMIFS formulas

Eagan, Minnesota, Us

- Trained and guided accountant with Bookkeeper and Staff Accountant duties- Trained and managed outsource CPA on processing payroll - Reviewed accumulated payroll data and budget vs. actuals to provide management with variance analysis- Created financial tools and/or used Excel formulas to make improvements to accounting spreadsheets: - Budget vs. actuals - Deferred revenue - Commissions - Bi-weekly payroll review - Prepaids - Cashflow forecast - Implemented consolidated invoicing and Avalara's AvaTax sales tax solution- NetSuite ad hoc reporting using SQL expressions- Started using Outlook rules and quick steps to maximize my inbox management

Eagan, Minnesota, Us

- Assisted and completed more month-end close processes- Maintained Bookkeeper responsibilities- Assisted with the budgeting process- Processed and managed payroll and benefits- Improved accounting processes and procedures: - Month-end processes and work papers - Lockbox for customer payments - Time and attendance for PTO and hourly employees- Trained office manager on processing customer payments

Eagan, Minnesota, Us

- Daily accounts receivable and payable tasks - Assisted with month-end close and a sales tax audit- Ordered office supplies and maintained a cleanly office environment- Organized company events including holiday parties on and off-site and company quarterly meetings

Bachelor'S Degree, Accounting

Liberal Arts Degree, Emphasis In Spanish, Liberal Arts And Sciences, General Studies And Humanities

Education record