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.