Month-end closing target
Improved the workflow to meet the target without recurring overtime.
Available for Freelance Projects
Mukhamad Alan Nurul Qomar
Finance, Accounting & Tax Professional
I work across financial reporting, month-end closing, reconciliation, tax compliance, budgeting, and accounting process improvement. I also develop workflows and tools using Advanced Excel, Power Query, and Accurate to make accounting work more structured and efficient.
Financial ReportingAdvanced ExcelPower QueryAccurateReconciliationTax & Coretax
LinkedIn ↗EXCEL → ACCURATE MIGRATION
Need to migrate journals from Excel to Accurate?
I have a tool that converts structured Excel journals into XML for an Accurate import workflow, reducing the need to re-enter journals one by one.
Excel Journal→Validation & Mapping→XML→Accurate
- Convert Excel journals into Accurate XML
- Validate data structure and mapping before conversion
- Useful for migration or bulk journal transfer
Bank reconciliation experience
Reconciled multiple bank accounts and transaction sources.
Accounting automation
Reporting, reconciliation tools, and structured workflows.
End-to-end exposure
Reporting, AP/AR, tax, budgeting, fixed assets, and audit support.
Projects & Workflows
Explore all 8 projects ↗Selected Accounting Projects & Workflows
Focused on the workflows, formulas, tools, and accounting controls I use in my work.
Financial Reporting & Automation
Automated Financial Reporting Workbook
An Excel workbook that updates reports from changes in source data without rebuilding the reports manually.
Advanced ExcelSUMIFSEOMONTHLinked Worksheets
View workflow Accounting Automation
Excel → Accurate XML Journal Converter
A tool that reduces re-entry by converting structured Excel journals into XML used in an Accurate import workflow.
ExcelXMLAccurateJournal Migration
View workflow Reconciliation
Bank & Account Reconciliation Workflow
A reconciliation workflow that separates matched items, timing differences, and transactions requiring follow-up.
Bank ReconciliationExcelGeneral LedgerException Review
View workflow Freelance Accounting Services
View all services ↗Freelance Accounting Services
Financial statements, Excel–Accurate migration, reconciliation, tax administration, and other accounting needs.
FS
Financial Statement Preparation
Preparation and review of structured financial reports based on available accounting records.
Discuss this service →AX
Excel ↔ Accurate Migration
Prepare Excel journals, convert them to XML for Accurate import, and export Accurate data back to Excel.
Discuss this service →RC
Bank & Account Reconciliation
Reconcile bank movements, ledger balances, AP, AR, and supporting documents to identify differences and outstanding items.
Discuss this service →TX
PPN, PPh & Coretax Administration
Administrative support for PPN and PPh 21, PPh 23, PPh 25, PPh 4(2), and PPh Unification, including document checks, Coretax input, reconciliation, and reporting support.
Discuss this service →Core Capabilities
Core Capabilities
Financial reporting
From journal entries to financial statements.
Month-end closing
Closing workflows, adjustments, and review controls.
Bank & account reconciliation
Transaction matching and discrepancy investigation.
AP & AR management
Outstanding balances, aging, and payment monitoring.
Tax compliance
PPN, PPh 21, PPh 23, PPh 25, PPh 4(2), and PPh Unification.
Budgeting
Budget vs actual and cash flow monitoring.
Accounting automation
Excel and Power Query reporting workflows.
Process improvement
More consistent reporting and stronger accounting controls.
Accounting Workflow
Accounting Workflow
The flow from transaction data to reporting and accounting controls.
STEP 01Transaction data
Collect source documents and check that the period is complete.
STEP 02Journal entry
Classify each transaction, retain its source reference, and balance debits and credits.
STEP 03General ledger
Group postings by account to trace movements and investigate unusual balances.
STEP 04Trial balance
Confirm that total debits equal total credits before adjustments.
STEP 05Adjustment
Record accruals, prepayments, depreciation, and approved corrections.
STEP 06Reconciliation
Tie balances to bank statements, subledgers, and supporting schedules.
STEP 07Financial statements
Prepare the Profit & Loss, Balance Sheet, and Cash Flow statement.
STEP 08Management reporting
Explain movements, budget variances, and items requiring follow-up.
Tools
Tools
Tools I use for accounting work and automation.
Microsoft Excel
Advanced · formulas, PivotTable, controls & automation
Power Query
Accounting data transformation & automation
Accurate Desktop
Accounting operations & financial reporting
Accurate Online
Accounting operations & reconciliation
Coretax
Tax administration & compliance
Professional Experience
View full experience ↗Professional Experience
Experience across production house, FMCG distribution, and manufacturing.
PT Ama Deo Abadi
April 2026 – PresentFinance, Accounting, and Tax Staff
Financial reporting, closing controls, production finance, tax compliance, budgeting, audit support, and accounting process improvement.
PT Seraya Makmur Indonesia
September 2025 – April 2026Finance, Accounting & Tax Staff
Excel reporting automation, AP & AR monitoring, tax administration, and reconciliation involving 11 bank accounts.
PT Pandawa Agri Indonesia
January 2025 – August 2025Accounting Intern
OPEX, billing, journals, PPh 23, PPN reconciliation, and external audit support.
Certifications
View credentials ↗Certifications
CREDENTIAL / 01
Brevet A & B
Applied Tax Training
Piranha Smart Center
2025
CREDENTIAL / 02
Certified Tax Technician
CTT
Asosiasi Teknisi Perpajakan Indonesia (ATPI)
2025
CREDENTIAL / 03
Junior Accounting Technician
BNSP certification
Badan Nasional Sertifikasi Profesi
2023
Contact Me
Career opportunities and freelance accounting inquiries.