Daily transactions Ledgers Invoices Excel analysis Monthly reporting
JOB RESPONSIBILITIES
1. Accounting & Daily Financial Operations
- Manage daily financial transactions, including income, expenses, payments and receipts.
- Maintain accurate accounting records, general ledgers and supporting documentation.
- Prepare and process invoices, payment vouchers, receipts and related financial documents.
- Monitor accounts payable (AP) and accounts receivable (AR), including outstanding payments and collections.
- Perform bank reconciliations and ensure accurate financial records.
2. Financial Reporting & Analysis
- Prepare monthly financial reports, management summaries and financial dashboards.
- Monitor and analyse revenue, operating expenses, cash flow and profitability.
- Track financial performance, payment collections and customer bookings.
- Identify cost trends, financial variances and opportunities for cost optimisation.
- Provide financial insights to support management decision-making.
3. Excel Reporting & Dashboard Management
- Develop and maintain Excel-based financial trackers, reports and management dashboards.
- Use PivotTables, PivotCharts and Excel formulas to analyse financial and operational data.
- Consolidate data from multiple sources to produce accurate monthly reports.
- Prepare visual charts and performance summaries for management review.
- Ensure data accuracy through proper filtering, sorting and validation.
4. Administrative & Operational Support
- Maintain systematic filing of accounting records, invoices, contracts and administrative documents.
- Assist with daily office administration and financial coordination.
- Liaise with customers, suppliers and relevant stakeholders on payment and documentation matters.
- Support month-end closing and other finance-related administrative tasks.
- Perform other relevant duties assigned by management.
JOB REQUIREMENTS
Education & Experience
- Diploma or Bachelor's Degree in Accounting, Finance, Business Administration or a related field.
- Minimum 2–3 years of relevant working experience in SME accounting and administration.
- Familiarity with SQL Accounting, AutoCount, Xero or equivalent accounting software.
- Able to prepare monthly financial reports and management dashboards independently.
- Good understanding of basic accounting principles and financial reporting.
- Microsoft Excel Skills – Intermediate to Advanced
Candidates must demonstrate competency in:
- PivotTables & PivotCharts – Data summarisation, analysis and visual reporting.
- Excel Formulas – SUMIFS, COUNTIFS, XLOOKUP, IF and related functions.
- Data Management – Filtering, sorting, validation and data consolidation.
- Dashboard Development – Preparing monthly management dashboards, charts and KPI reports.
- Financial Tracking – Monitoring revenue, expenses, payments, collections and bookings.
- Financial Analysis – Analysing profitability, cost trends, financial variances and business performance.
PERSONAL ATTRIBUTES
- Detail-oriented, organised and accurate in financial recordkeeping.
- Able to work independently and meet monthly reporting deadlines.
- Strong analytical, problem-solving and time-management skills.
- Responsible, trustworthy and able to maintain financial confidentiality.
- Good communication and interpersonal skills.
- Proactive in improving reporting processes and administrative efficiency.
SALARY RANGE PACKAGE
RM2,500 – RM3,500 per month
* Salary will be commensurate with qualifications, relevant experience and technical competency.
Pay: RM2,500.00 - RM3,500.00 per month
Benefits:
- Opportunities for promotion
- Professional development
Work Location: In person