I'm a passionate BOOKKEEPER who can help you:
- GET YOUR BOOKS ORGANIZED AND UPDATED.
- ANALYZE and INTERPRET FINANCIAL RECORDS so you can make proper decisions.
I offer the following services:
1) EXCEL AND GOOGLE SHEETS:
--help with 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 - VBA/MACRO, Google App Script, conditional formatting and data
validation
- creating automated forms, templates, spreadsheets
FINANCIAL REPORTING/MODELING &
ANALYSIS:
-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
- provide Financial Analysis and recommendations
to cut cost/ expenses and maximize profits.
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
- invoicing
- setting up invoices and bills - matching payment of
invoices and bills to bank deposits and disbursements
- bank reconciliation
- month-end journal entries of amortization
4) DATA ENTRY SERVICES:
- Converting file from PDF/MS Word to Excel/Google
Sheets/MS Word and vice versa
- Transferring data from PDF/Website/MS Word to
Excel/Google Sheets/MS Word
- Encoding data to online systems/platforms
- Typing
book a call if you need any help with the above
Looking forward to hearing you,
“The more I stepped away from it, the more successful our Chanel became!”
- Jim Orr
Onlinejobs.ph "ID Proof" indicates if "they are who they say they are".
It DOES NOT indicate skill level.
ID Proof scores are 0 - 99 with 99 being the best. It is calculated based on dozens of data points.
It's intended to help employers know who they're talking to is real, and not a fake identity.