John C. Panicali, CPA
******@*****.***; 718-***-****
PROFESSIONAL EXPERIENCE
Accounting Consultant 2011-2015
GoldPoint Partners (2015)
Downloaded daily cash activity reports from BONY website, populated Excel cash reconciliation files, and prepared corresponding journal entries in the Investran Transaction Module to account for all cash movement for Mezzanine Private Equity funds.
Prepared contribution and distribution exhibits which were made available to limited partners, employing V-Lookups and H-Lookups extensively to ascertain completeness and accuracy.
Communicated and interacted with the Treasury Department to facilitate foreign exchange translations and transfers between multiple bank accounts belonging to various limited partnerships.
Recorded month-end accruals for interest income received from debt instruments and securities which encompassed the majority of the portfolios of the various limited partnerships (including PIK and Discount Amortization) and ran and customized various Investran Report Wizard schedules to ensure the accuracy of all corresponding journal entries recorded.
Maintained and updated loan schedules as new debt instruments were added to the Funds’ portfolios on a recurring basis.
Recorded accruals for management fees, audit fees, and tax fees on a monthly basis.
Bank of New York Mellon (2014-2015)
Reviewed cash activity on a daily basis to monitor the validity of the movement of funds.
Prepared financial statement NAV binders and accompanying excel supporting schedules for private equity funds.
Initiated wire payments at the request of clients and interacted with custody and treasury departments ensuring that vendors were paid on a timely basis.
Booked journal entries in Investran and ran supporting financial statements out of Report Wizard to match excel documents.
RE: SOURCES (2014)
Prepared cost driver templates in Excel which were then linked to an Excel IT allocation model and provided a forecast of estimated costs that various agencies would incur.
Interacted extensively with agency account managers to address any issues that arose concerning the amount and extent of cost drivers applied.
Bank of New York Mellon (2014)
Reviewed excel workbooks prepared by accounting department for alternative investment funds of funds.
Prepared financial statements as well as accompanying notes for new clients on an ad hoc basis.
Communicated with clients, the accounting department, and the publishing department so that the creation of financial statements can be executed in a timely and efficient manner.
Brookfield Property Group (2013)
Used Investran Report Wizard to create, customize, update, and export financial reports for the purpose of linking to and providing support for Excel financial statements.
SCOR Reinsurance Company (2013)
Prepared quarterly balance sheet account reconciliations and obtained documentation to support all transactions.
Prepared journal entry templates for upload and posting into SAP general ledger system.
Recorded monthly accrual and reversing journal entries and maintained detailed accrual worksheets to keep track of actual expenses versus budget.
MSCI Inc (2012)
Prepared monthly balance sheet account reconciliations and monthly journal entries using Epicor system to record prepaid medical insurance, prepaid business insurance, and prepaid general amortization.
Updated monthly expense analyses with purchase, accrual, and reversing entries upon the close of Accounts Payable each month.
SocieteGenerale (2011)
Facilitated the execution of confidentiality agreements in order to provide financial reports to clients.
Coordinated the distribution of FOCUS Monthly Reports, and Audited Financial Statements to certain investors upon request.
Citi Private Equity Services 2007-2010
Senior Accountant
Prepared trial balances based on daily cash activity and broke out transactions based on fund contribution and distribution notices.
Updated and maintained Excel schedules to keep track of fund accruals, net asset values, and year-to-date cash activity.
Credit Suisse (USA), Inc 2005-2007
Senior Accountant
Worked with Investran software to record journal entries and ran customized reports such as schedules of investments, remaining commitment analyses, and contribution/distribution activity.
Prepared quarterly work-papers, investor relations templates, and partners’ capital account statements, as well as annual audited financial statements.
Prepared Excel schedules to keep track of fund accruals, net asset values, year-to-date cash activity, and chunk call status (used to record Limited Partner and General Partner funding and draw-downs of reserves).
Rockefeller Group International, Inc 2003-2005
Senior Accountant
Prepared consolidated statements of net income, cash flows, and changes in stockholders’ equity on a monthly basis.
Prepared annual consolidated financial statements including required disclosures, supporting schedules, and footnotes for the company’s main operations as well as for the pension and incentive savings plans.
McGladrey& Pullen LLP 1999-2003
(previously American Express Tax & Business Services, Inc., New York, NY)
(affiliated with Goldstein Golub Kessler LLP, New York, NY)
Auditing Staff
Planned, coordinated and executed audit engagements for investment limited partnerships, funds of funds and offshore funds.
Generated partnership economic and tax allocations, individual partner Schedule K-1’s and audited capital letters as well as prepared tax returns for limited partnerships and limited liability companies.
EDUCATION/AWARDS
PaceUniversity; New York, New York
Bachelor of Business Administration, June 1999
Major: Public Accounting,QPA: 3.71
President’s Scholarship; Beta Alpha Psi;Dean's List graduate, magnacum laude
Certified Public Accountant ("CPA"), licensed in New York
COMPUTER SKILLS
GoSystem Tax, Advent Partner, Microsoft Windows 7, Microsoft Outlook,Microsoft Office Suite (heavy concentration in
Excel), Investran, Lotus Notes, Epicor (Citrix)