Accountant- Book keeper

Advanced functions like INDEX / MATCH, OFFSET, INDIRECT, and newer dynamic array functions (depending on Excel version). Creating macros (VBA) or automations/scripts to automate repetitive tasks. Creating dashboards, interactive charts, scenario/what-if analyses, data modelling. Handling large datasets, working across multiple sheets/workbooks, linking data, error handling

Using more advanced functions and formulas: VLOOKUP (or newer alternatives), INDEX/MATCH, UNIQUE(), COUNTIF/SUMIF, IFERROR, etc. Use of PivotTables (or pivot style summaries) to summaries large datasets. Use of scripting / automation (Google Apps Script), macros or add‑ons to automate repetitive tasks. Integration with other data sources: importing/exporting data, connecting to other apps or APIs, using Smart Chips or linked data. Protecting sheets/ranges, setting up permissions and data security, especially in collaborative environments. Using advanced visualization or dashboards: conditional formatting, interactive charts, trendlines.

Invoice Processing / Billing: Generating and issuing invoices to customers, ensuring they’re accurate and compliant with company policy. Cash Application / Payment Allocation: Matching incoming payments to the correct invoices/customer accounts, posting them correctly. Accounts Receivable Ledger Management / Reconciliation: Ensuring the AR ledger is accurate, reconciling balances, ageing receivables, and managing outstanding customer balances. Credit Management & Collections: Assessing customer credit, following up on overdue accounts, applying collection strategies to ensure payment. Use of Accounting / ERP Software and Tools: Being proficient with accounting systems Financial Reporting & Analysis Attention to Compliance, Policies & Procedures

Invoice processing & matching: Receiving/validating vendor invoices, matching them to purchase orders (POs) and goods receipts, ensuring data accuracy. Payment preparation: Preparing payment runs (checks, wire transfers), scheduling payments, applying correct payment terms. Vendor account / statement reconciliation: Reconciling vendor statements, resolving discrepancies, monitoring outstanding payables. Data entry & system usage: Entering invoice/payment details into ERP/software, maintaining vendor master files, using spreadsheets. General accounting/bookkeeping knowledge Software / ERP proficiency Compliance & internal controls

Recording and maintaining accurate financial transactions (sales, purchases, receipts, payments) so the books reflect what’s really going on. Understanding basic accounting/bookkeeping principles: general ledger, double-entry bookkeeping (debits and credits), trial balances, etc. Understanding basic accounting/bookkeeping principles: general ledger, double-entry bookkeeping (debits and credits), trial balances, etc. Bank and account reconciliation Using bookkeeping/accounting software, spreadsheets (e.g., Excel) and keeping up with digital tools and automation. Handling accounts receivable/payable, invoicing, payroll, expense tracking.

Setting-up the organisation profile, chart of accounts and financial year-end in Xero, including tax/VAT settings. Navigating the Xero dashboard, managing users & permissions, customizing menus and settings. Recording and managing day-to-day transactions: creating sales invoices, purchase bills, expense claims, handling payables/receivables. Bank feed setup and daily bank reconciliation: matching transactions, applying bank rules, ensuring books match bank statements. Generating and analysing financial reports Working with tracking/categories, cost centres to segment income/expenses for deeper analysis.

Setting up a company file: chart of accounts, preferences, users & access rights. Recording and processing day-to-day transactions: sales/invoices, receipts, vendor bills, payments, credit memos. Bank/credit-card account linking, download/import of transactions, and reconciliation. Generating, customizing and interpreting financial reports: profit & loss statement, balance sheet, cash flow, as well as custom reports and dashboards. Payroll, tax/withholding support (if the version supports it) and compliance aspects.

Risk assessment & internal control evaluation: identifying risks in processes, operations or systems and assessing whether existing controls are effective. Business process understanding Data analysis / audit techniques: working with large amounts of data, extracting insights, detecting anomalies, doing fieldwork Accounting & regulatory knowledge: understanding financial statements, accounting standards, audit standards, compliance regulations. Reporting & documentation: preparing audit reports that clearly communicate findings, remediation plans, recommendations.

Familiarity with System setup/configuration: setting up chart of accounts, accounting preferences Using NetSuite customization features Ability to integrate NetSuite with other systems Advanced Excel skills to complement NetSuite: pivot tables, lookups, formulae, report building.