Accounting Intern
Responsible for monthly data analysis on clients’ credit cards and investment portfolios by utilizing XLOOKUP, cross reference formulas, and reconciliation tables ensuring the accuracy of the general ledgerIn charge of onboarding an investment portfolio for a new client into the accounting software by rebuilding tax lot details and manipulating large data sets in ExcelConducted YTD reconciliation of clients’ credit cards to bank statements in Excel Retrieved new bank and brokerage statements directly from clients’ online accounts and recorded spending activity of the correct date range