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) 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
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) 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