AIPB Certified Bookkeeper since 2017 to PresentQuickBooks Online Certified ProAdvisor 2019, 2018, 2017QuickBooks Desktop Certified ProAdvisor 2020QuickBooks Desktop Certified ProAdvisor 2019Bookkeeping, account reconciliation, data entry, file system creation and document management for tax preparation, and related business bookkeeping services - accounts payable & bill payment services, invoicing, medical billing receivables services, and daily cash balance reporting. QuickBooks ProAdvisor Program since 2013.

• Data validation of supplier vs. distributor product codes between two internal data systems Ross (ERP system, Mepple system) and external (Supplier) database – advanced use of MS Excel, intermediate use of SQL and MS Access and relational database design concepts.• Use of customer service oriented communication to resolve issues between company and supplier representatives and to solve problems between interdepartmental users.• Electronic Data Interchange (EDI) of monthly sales reconciliations between supplier & distributor databases and validation of data between supplier & distributor databases. • Data validation of standard cost and price data between ERP system and marketing department data using MS Excel, MS Access, SQL code, and aggregate functions.• Performed routine & ad-hoc financial data analysis using MS Excel, MS Access, SQL programming for reporting, trouble-shooting data transmissions, identifying problematic and aberrant data, troubleshooting invoice/credit memo transmissions between the ERP, Mepple database, and ARI network.• Use of MS Word and MS Excel for Job Process documentation and user guide creation, to document and link department policies with job processes, into a user guide format.

• Support to the city budget officer for the 2011 city budget forecast and reporting process: performing budget data entry, ad-hoc financial analyses, analysis of budgeted expense & revenue variances, and ad-hoc support to the accounting and finance department.• Created Excel Spreadsheet downloads from the ASA400 system for budget data entry, expense and revenue allocation, and posting of budgeted expenses & revenues.• Reconciling payroll deductions between city ASA400 and Payflex database for calendar year with supporting summary and detail reports • Reconciling inventory with electronic purchase orders across differing databases • Developed Excel Spreadsheet templates for city contract analysis with filters for periodic reporting at various time intervals – labor savings of 2-4 hours per week.• Developed MS Access transit mileage database system for City of Loveland Transit (COLT) to report daily bus/route mileage and times, execute reports in summary and detail formats for interdepartmental users, external auditors, grant reporting, and federal government agency reporting – labor savings of 2-3 days per month.

• Support to the city budget officer for development of the 2010 city budget and fiscal year forecast process: performing budget data entry and reporting, ad-hoc financial analyses, analysis, account reconciliation and analysis, and posting of budgeted expense & revenue data.• Ad-hoc support to the accounting and finance department staff.• Created Excel Spreadsheet downloads from the ASA400 system for budget data entry, expense and revenue allocation, and posting of budgeted expenses & revenues.• Reconciling payroll deductions between city ASA400 system and Payflex database for calendar year; provided supporting summary and detail reports in MS Access for interdepartmental use.

• Data entry and report production for support of the month-end closing process, allocation and posting of monthly expenses to the General Ledger.• Ad-hoc data and account analysis - employee benefit account reconciliation, receivables going to collections, a/r issues by cpt / medical billing codes. • Preparation of month end and ad-hoc summary reports using MS Excel, MS Access, and Crystal Reports.• Preparation of the daily cash report, daily credit/debit card transaction report• General support to the accounting department and chief financial officer.• Reconciliation and reporting of weekly ACH transactions and integration of with monthly inventory reporting.

2007, 2008, 2009 Season - Greeley Farmers Market Bookkeeper/Market CoordinatorNote: Position is Seasonal May thru November. Bookkeeping & accounting utility maintenance for 2007, 2008, and 2009 Seasons. Market Coordinator and Bookkeeping assistance for 2007, 2008, and 2009 seasons. Volunteer: On-Going Support Provided to this Department,( to address accounting utility issues as department and reporting needs change). Routine Duties:• Developer of departmental bookkeeping & reporting utility.• Data entry of Market Day payables, receivables, city sales taxes received & payable, state sales taxes received & payable, and vendor booth fees.• Reconciliation of market day transactions on debit card / EBT machine with coupon bank• Reconciliation of cash reimbursements and disbursements to market day vendors.• Development & maintenance of Weekly accounting & reporting utility with year-end summary reports by vendor and market day.• Use of customer-oriented communication skills to resolve market day issues and to encourage and maintain compliance with city market day policies.