Loan Tran: in Santa Ana, CA

? Monitor and analyze transactions for validity of account balances, reserve balances, accruals and financial impact on the financial statements. ? Prepare monthly and quarterly accounting journal entries for accrued and reserved accounts. ? Perform account reconciliations for accrued and true-up accounts such as Merchandising Expenses, Harbor Maintenance Fees, Duty, Wharfage and Dock, Pre-Delivery Inspection, Lemon Law inventory. ? Prepare and upload the adjusting entries through Quadrate Data Workbench for miscoded transactions. ? Book receivable for Core return claims receiving from Ford. ? Research for account discrepancies and book an adjusting entry to fix it. ? Create an analysis and book a journal entry for the Net Realizable Value of the perpetual inventory for both company and Non-Company cars. ? Create a Summary Recap of consolidated reconciliation for vehicles and parts inventory. ? Assist with Year-end Auditing and Sox Compliance Testing. ? Send out True-up entries and reconciliations for approval to Analysis and Pricing Manager. ? Send out reports such as AR aging reports, P&L reports to designated people. ? Download vessel costings and payments reports from Mazda portal website Xnet and NNS system as supporting documents for journal entries and reconciliations.

? Perform bank reconciliations for 50 cash accounts including 27 Depository & Concentration, 15 Payroll, 3 Student Refunds , 2 Accounts Payable, 2 Petty Cash, and 1 Petty Checking accounts in a publicly traded education institution, which has 120 locations over United States and Canada. ? Analyze the operating accounts and compare financial actual results vs. budget, and forecast. ? Prepare consolidated financial statements for multiple entities (120 schools) in $1.5 Billion Revenue company. ? Prepare and book the Trial Balance Entry for the subsidiary companies. ? Preparation and review of inter-company reconciliations, journal entries, accruals from multi-general ledgers in foreign currency for subsidiary companies. ? Reconcile G/L accounts such as Employee Advances, Employee Expenses Clearing, Deferred Loan Fees, Cash Clearing, Petty Cash, Payroll Suspense, Accrued Accounting, Accrued Legal Fees and Escheatment. ? Prepare and upload Manual and System AP accruals into General Ledger. ? Assist on Payroll entry and accrual into General Ledger. ? Assist with Revenue Recognition, review and reconcile A/R postings to General Ledger. ? Book prepaid journal entry and set up amortization schedules for annual dues & subscription, accreditation & licensing, and postage invoices. ? Prepare and upload Monthly Allocation entry for postage, student enrollment fees, Travel and credit cards expenses, petty checking clearing, and call center expenses into General Ledger. ? Response and support for school presidents’ questions regarding their financial statements and prepare journal entry as request. ? Receive, record, and keep track of 240-260 Credit Card Statement submissions. ? Quarterly receive, record, and keep track of 120 Petty Cash On Hand Confirmation submissions from schools. ? Quarterly prepare the Cash Overdraft entry and Petty Cash Confirmation Entry. ? Assist manager with SOX Compliance and E&Y Auditing tests for Quarterly Review and Year-end Auditing. ? Back up for Fixed Asset entries and reconciliations. ? Create a CER # for Fixed Assets Purchase Order and input the date, cost, salvage value, useful life of an asset into AP system. ? Assign and input Purchase Order items for fixed assets into different sub-assets accounts when creating a CER # in AP system. ? Run General Ledger Fixed Asset Activities Report on weekly basis and match with the AP vouchers for Fixed Asset accounts in AP system. ? Allocate and upload the new acquisitions breakdown of each AP voucher for fixed assets into the Sage Fixed Assets System’s sub- accounts. ? Update the disposals and transfers in the Sage Fixed Assets System. ? Run disposals, transfers reports, and Depreciation schedules from the Sage Fixed Asset System and upload the disposals, transfers, depreciation Expenses and its Accumulated Depreciation back into General Ledger fixed asset accounts. ? Research and resolve any out of balances of special projects and ad hoc reports. ? Directly involved with multiple system conversions(SAS, DocLinks, Onbase, Ariba, BlackLine) ? Capable to separate a consolidated cash reconciliation of multi cash accounts, in which have been reconciled together in years into an individual cash reconciliation for each account. ? Capable to reconcile multi- cash disbursement accounts together in one consolidated bank reconciliation.

State Street IMS/Investment Management Services, Newport Beach, CA 2002 – 2003 Staff Accountant ? Heavily reconcile bank statements for different portfolio of clients. ? Reconcile G/L accounts, prepare and post journal entry of the interest and principal payment, buy & sell transactions of stock, journal asset deposits, journal asset withdrawals, buy and sell currencies, and adjusting entries. ? Re-search for the discrepancies of the par & pricing of the stocks. ? Perform full daily and monthly accounting for a single business unit, and support of the monthly consolidations process as well as special projects as assigned by controller. ? Provide details/files upon request to clients. ? Provide monthly variance analysis on General Ledger for management reporting purposes.

? Reconcile bank statements and General Ledger accounts. ? Analyze operating accounts and prepare financial statement for the property owners. ? Book revenues of management fee to A/R sub-ledger and General Ledger. ? Manage A/R sub-ledger and billings, and create and send invoices for property owners. ? Deposit Cash Receipts and post Cash Receipts in General Ledger. ? Work closely with property managers to come up with numbers for budget and forecast. ? Upload Budget and Forecast in General Ledger. ? Prepare and book AP accruals to General Ledger. ? Reconcile and monitor the General Ledger accounts such as Employee Advances, Garnishments, and Child Support. ? Analyze and evaluate financial data and prepare statements, supporting schedules and/or reports for review by management.

? Generate monthly billings for both RENT & CAM. Prepare year-end CAM reconciliation. ? Deposit cash receipts to bank, prepare and post cash receipts journal entry to G/L. ? Keep track of property tax and insurance. Call tenants for collections and release out billing statements & rent increase notices. ? Set up new billing for tenants who have rent increase each month. ? Make necessary billing adjustment to tenants’ aging A/R for late fees and legal fees. ? Abstract leases, set up, maintain, and update tenants’ account.