Accounting, Bookkeeping and Financial Reporting skills
- 8 years relevant experience in accounting and audit
- can set up chart of accounts
- prepares tax returns
- prepares and process invoices/billings
- allocate bank receipts and disbursements
- prepares journal entries
- reconcile year-end accounts
- prepares financial statements (Balance Sheet, Profit or Loss and Cash Flows), financial models, forecasts and budget
- knows how to manage personal finance
- familiarity with accounting systems and apps (Oracle, Quickbooks, Wave, Sage, Xero)
Excel skills
- automate processes in Excel through VBA coding/Macro
- prepares dynamic dashboards with the use of Pivot Table, Pivot Charts, Slicers
- prepares and assign Macro to shapes, buttons, dropdown lists, text boxes, scroll bars, calendar, etc.
- with knowledge of advance formulas and functions such as vlookup, hlookup, sumif and sumifs, countif and countifs, mid, upper, lower, proper, sum, index, match, offset, indirect
- can do conditional formatting, data validation, data cleaning, text-to-column and data analysis
Data Entry Skills
- can manually type data from pdf to excel or word
- encode data from excel to online website or programs