John Loor

Dedicated & focused Accounting professional with 30+ years of experience maintaining financial records and reviewing account activity. Proven track record of developing accurate spreadsheets and delivering organized reports with MS Excel. Accomplished in taking on tasks within strict deadlines while prioritizing urgent needs. Well-organized, diligent and focused professional.

• Gannett Inc., Sr. Financial Accountant, Daytona Beach, Florida, 11/01/19, Current, Providing accurate and timely accounting information regarding centralized support, general ledger reconciliations, and financial reporting for GateHouse Newspaper Group Units while maintaining and supporting internal and external audit requirements., Work directly with GateHouse Newspaper Group Units to ensure reconciliations and period end close functions are performed in a timely and accurate manner., Research and verify accurate Newspaper Group’s submission with multi-department interactions in a timely and accurate manner., Perform various GL reconciliations in a timely and accurate manner., Perform and enter journal entries as part of the period end close functions., Run various reports from subsystems to be utilized for month-end close and reconciliation completion., Create advanced Excel spreadsheets for centralized reporting functions., Run and balance system and financial reports., Analyze financial information by developing templates., Advise and work with Business Units concerning procedures, financial information and adjustments to GL., Identify reconciling items and prepare adjustment recommendations to Unit., Implemented new processes looking for improvements as needed ensuring compliance with all GH policies.
• Tarte Cosmetics, Accounting Manager Consultant, New York, New York, 09/01/19, 11/01/19, Prepare payment journals, IC invoices, journal entries and account reconciliations including roll-forwards (PP&E, Trade AP & Accruals, Intercompany, Cash, PPD, Payroll, etc.). Heavy use of MS Navision, Jet Reports & Excel., Prepare payment Journal and complete monthly Payroll Bank reconciliations., Assist the Controller with month-end close process of France, HK and US., Assist in preparing and compiling audit work supporting documentation., Respond to ad-hoc reporting, analysis and special assignments, as needed.
• Faherty Brand, LLC., Senior Accounting Consultant, New York, New York, 05/01/19, 07/01/19, Assist in the preparation of the company’s financial statements and ensure compliance with GAAP reporting to the Controller. Heavy use of QuickBooks Enterprise software and Excel., Supporting month end close by preparing ongoing journal entries for revenue, expense and balance sheet accounts., Prepare weekly and monthly schedules performing reconciliations of balance sheet accounts including fixed assets, prepaid expenses, accrued expenses, accounts receivable and deferred liabilities., Review invoices, expense reports, and capital expenditures as needed insuring proper coding and accounting treatment by Accounts Payable., Respond to ad-hoc reporting, analysis and special assignments, as needed.
• Horizon Media, Inc., Senior Accounting Consultant, New York, New York, 01/01/18, 03/01/19, Assist in the preparation of the company’s financial statements and ensure compliance with GAAP reporting to the Assistant Controller. Heavy use of MS Great Plains & advanced Excel for reporting & analysis., Perform monthly closing procedures and/or reviewing account reconciliations and journal entries., Prepare, review, analyze and communicate financial, accounting and statistical information., Responsible for monthly Fixed Assets accounting & reporting., Respond to ad-hoc reporting, analysis and special assignments, as needed., Review and code invoices to be processed for payment.
• Steinway Inc., Senior Accountant, Queens, New York, 02/01/09, 06/01/17, Carried out general ledger functions, including account analysis and reconciliations, journal entries postings, and AR reports., Managed all fixed assets transactions such as posting asset acquisitions, disposals & retirements, producing financial statements., Prepared management reports and financial summaries using Microsoft Excel detailing company’s financial status., Prepared and filed all sales & use tax returns as well as business property for several states. Heavy use of MS Dynamics Navision & advanced Excel for reporting & analysis., Spearheaded implementation of technology that improved sales & use tax filings with Excel Jet reports which resulted in filings being submitted a week prior to due dates for several states, counties & cities., Reduced monthly closing cycle by 25% with identification and recommendation of enhanced closing procedures specifically related to fixed assets activities.
• Forestdale Inc., Senior Accounting Consultant, Queens, New York, 04/01/07, 05/01/08, Performed general ledger functions, including account analysis, reconciliations and journal entries., Assisted in the preparation of financial statements., Prepared management reports and financial summaries using Microsoft Excel detailing company’s financial status., Generated bank deposits, verify and balance receipts., Payroll, AP and AR supervision and review payroll tax returns., Researched and resolved billing and collections disputes.
• Rockefeller Foundation, Senior Financial Analyst, New York, New York, 10/01/06, 03/01/07, Provided financial expertise and assistance to organization’s CFO and Controller to ensure the accuracy and integrity of financial requirements for this large non-profit in support of overall business objectives., Streamlined and improved COA, Budget Importing process and spreadsheet analysis., Involvement with initial Encumbrance implementation currently in process., Due diligence performed on Encumbrance System, Purchase Requisition, Regional office QuickBooks implementation and Auditing accounting firms.