Arsenio J.

Good Day! I am Sen from the Philippines. I am a Certified Public Accountant by profession and a Top-rated freelancer in Upwork. I offer the following services: 1) EXCEL AND GOOGLE SHEETS: - help in formulas and functions such as vlookup, hlookup, sumif/s, countif/s, mid, upper, lower, proper, sum, index, match, offset, indirect, date, max, min, average, etc. - Excel table, Pivot Tables/Charts/Slicers, - VBA/MACRO, Google App Script, conditional formatting and data validation - creating automated forms, templates, spreadsheets and dashboards with textfields, combo boxes, dropdown lists, shapes and buttons 2) FINANCIAL REPORTING/MODELING: - manually preparing P&L, Balance Sheet, Cash Flows, General Ledger, AR and AP Aging in Excel/Google Sheets using data from Bank and Credit Card Statements and other documentations - generating P&L, Balance Sheet, Cash Flows, General Ledger, AR and AP Aging from QBO and Xero. - preparing Budget, Forecasts and Calculators in Excel/Google Sheets 3) BOOKKEEPING IN QUICKBOOKS ONLINE, XERO AND EXCEL/GOOGLE SHEETS: - importing bank/credit card transactions to the accounting system - setting up bank rules and chart of accounts - categorizing imported bank transactions/bank feeds - setting up invoices and bills - matching payment of invoices and bills to bank deposits and disbursements - bank reconciliation 4) DATA ENTRY SERVICES: - Converting file from PDF/MS Word to Excel/Google Sheets/MS Word and vice versa - Transfering data from PDF/Website/MS Word to Excel/Google Sheets/MS Word - Encoding data to online systems/platforms - Typing I've been doing freelancing for Five years now and I am currently a top-rated freelancer in Upwork because of the quality of my output and my professionalism. You may check the positive reviews I earned and my work history in my profile. [login to view URL] I can assure you If you hire me I will do whatever it takes to completely deliver and earn a 5 star rating from you. I am looking forward for us to have a long-term working relationship.