📊 Finance

• Financial Reporting

• Consolidation

• CFO Insight

A GOOD FINANCIAL MODEL STARTS WITH RELIABLE DATA AND TESTABLE ASSUMPTIONS

Learn how reliable data, testable assumptions, and scenario analysis create financial models that support better business decisions. 

A financial model can look highly professional.

It may contain comprehensive tables, complex formulas, and projections showing promising business growth.

However, a model that looks convincing is not necessarily reliable enough to support management decisions.

The quality of a financial model is determined not only by its formulas but, more importantly, by the quality of the underlying data and assumptions.

Historical Data as the Foundation

Historical data helps management understand the company’s actual performance and financial condition.

Several important questions should be considered:

• How has the company’s revenue grown over time?

• What profit margin can realistically be maintained?

• How long does it usually take to collect receivables?

• How much inventory is required to support sales?

• What are the company’s recurring cash expenditure patterns?

The answers provide a more reasonable basis for developing financial assumptions.

However, assumptions are not certainties.

Every assumption in a financial model should therefore be adjustable and testable.

Testing the Assumptions

Management should be able to assess what would happen if:

• Revenue grew by only 10% instead of 25%.

• Profit margins declined.

• Customers took longer to pay their invoices.

• Raw material costs increased.

• The company required additional capital expenditure.

A change in just one assumption may simultaneously affect the income statement, balance sheet, cash flow, and financing requirements.

For example, higher revenue may increase reported profit. However, it may also lead to higher inventory levels, larger trade receivables, additional operating expenses, and greater working capital requirements.

This is why financial modelling should not focus solely on revenue and profit projections.

It should show how each business assumption affects the company’s overall financial position.

Separating Data, Assumptions, and Results

A well-designed financial model should clearly separate:

• Historical data

• Financial and operational assumptions

• Calculation formulas

• Projected results

With this structure, management can adjust assumptions and run simulations without rebuilding the entire model.

It also makes the model easier to review, explain, and update when business conditions change.

Developing Multiple Scenarios

I generally recommend preparing at least three scenarios:

1. Base-case scenario
   Based on the conditions considered most likely to occur.

2. Optimistic scenario
   Based on stronger business performance and more favourable market conditions.

3. Conservative scenario
   Designed to anticipate potential pressures, disruptions, or business risks.

These scenarios allow management to understand the possible financial outcomes under different conditions.

They can also help the company prepare appropriate actions before risks materialise.

A Tool for Better Decision-Making

The purpose of financial modelling is not to produce the most attractive projection.

Its purpose is to help management understand what may happen and prepare appropriate decisions for each possible scenario.

A good financial model does more than calculate numbers.

It helps management:

• Evaluate business plans.

• Test key assumptions.

• Identify financial risks.

• Estimate working capital requirements.

• Anticipate funding needs.

• Make more informed decisions before implementing a strategy.

Ultimately, financial modelling is not about predicting the future with absolute certainty.

It is about understanding how different decisions and business conditions could affect profitability, cash flow, financial position, and funding requirements.

Are the assumptions in your company’s financial model easy to adjust, test, and evaluate?

#FinancialModelling #FinancialPlanning #BusinessForecasting #ScenarioAnalysis #CashFlow #Finance #FractionalCFO #FinanceConsultant #BusinessStrategy #KKPITIRAWAN

Automation Consolidated Financial Statements with ERP)

Manual processes for consolidated financial statements are time-consuming and error-prone. Automation significantly reduces these issues. Here's a streamlined approach:

I. Consolidation Structure: Define the structure, including the parent
  company and all subsidiaries (and sub-subsidiaries).

II. Consolidation Period: Specify the reporting period (e.g., monthly,
  quarterly, annually).
 

III. Data Transfer:
  1. Import Trial Balances: Import all subsidiaries trial balances for
  processing but there are so many weakness with this methode because
  off  human error.
  2. System Integration: If the parent and subsidiaries use the same ERP
  system (like Odoo), automate data integration.
  3. Third-Party Systems: If different ERP systems are used, a third-party
  system might be necessary for data integration (this presents a greater
  challenge).
 
IV. Account Mapping and Elimination:
  a. Common Stock: Eliminate common stock of subsidiaries.
  b. Retained Earnings: Eliminate retained earnings of subsidiaries.
  c. Intercompany Transactions: Eliminate transactions between affiliates
V. Report Generation: Once the setup is complete, generate the
  consolidated financial report with a single click.

#odoo #Consolidation #DigitalisasiLaporanKeuangan #EliminationJournal #NonControllingInterest 

⚙️ ERP

• Odoo ERP

• Digital Transformation

• ERP Implementation

Implementation of Enterprise Resource Planning (ERP)

 for 

Independent Power Producers (IPP)

Phases in an IPP Company:

1. Investing: From feasibility studies to obtaining the Power Purchase                         

Agreement (PPA).

2. Development/Construction: Building the power plant.

3. Maintenance and Operation: Ongoing management of the power plant.

4. Reporting/Dashboard: Monitoring and reporting performance metrics.

Key Considerations for ERP Implementation:

1. Multi-Company Accommodation:

Due to legal requirements, each IPP must operate as a separate entity.

Therefore, the ERP system must support:

▪ Consolidated Financial Reporting: To provide a comprehensive

view of financial performance across all subsidiaries.

▪ Intercompany Transactions: All transactions during the

investment phase are conducted by the Holding Company and

later transferred to Subsidiaries (Special Purpose Companies -

SPC) once they commence operations.

2. Development Phase Considerations:

o Validation of Capital Budget: This must be distinct from operational

expenditures.

o Budget Oversight: Establish clear responsibilities for managing budget

excesses and approvals for additional funding.

o Construction Progress Control: Implement tools to monitor and report

on construction milestones and timelines.

o Vendor Payments: Ensure payment processes are efficient, utilizing

methods such as Letters of Credit (LC), Standby Letters of

Credit (SKBDN), or Supply Chain Financing (SCF).

3. Maintenance and Operation:

o Develop a structured maintenance plan that includes:

▪ Daily, weekly, biweekly, monthly, semester, and annual

maintenance schedules.o Use maintenance data to inform budget planning and resource allocation.

4. Real-Time Reporting Needs:

o Management requires immediate access to operational reports, focusing

on:

▪ KWh Export: Daily production data, monthly targets for excess

production pricing, and annual targets for penalties related to

production shortfalls.

▪ KWh Import: Monitoring energy imports to manage overall energy

balance.

▪ Budget Dashboard: A comparison between planned budgets and

actual expenditures to facilitate informed decision-making.

Conclusion

Implementing an ERP system for an IPP involves careful planning and consideration of

various operational phases. By addressing these key areas, the ERP can enhance

efficiency, ensure compliance, and provide valuable insights for management.

#ERPOdoo #PLTM #Energy #DigitalisasiLaporanKeiuangan #AccountingRenewableEnergy

In ERP Implementation, You Need to Know When Configuration Is Enough, When Business Process Adjustment Is Needed, and When Customization Is Truly Justified

One of the biggest mistakes in ERP implementation is assuming that every business requirement must be solved through customization.

In reality, successful ERP implementation starts by understanding when configuration is enough, when business processes should change, and when customization is truly justified.

1. Configuration Is Sufficient

Use configuration when business requirements can be fulfilled using the ERP's standard capabilities.

Examples:

• Setting up the Chart of Accounts, taxes, and approval matrices

• Configuring inventory parameters, pricing, and payment terms

• Defining user roles, access rights, and standard workflows

Key principle:
Do not change the system logic—simply configure the available settings.

2. Business Process Adjustment (Process Alignment / Routing)

Use business process adjustment when the gap lies in the way the business operates, not in the ERP system itself.

Examples:

• Adopting the ERP's standard approval workflow instead of creating a new one

• Simplifying overly manual processes

• Changing user practices to align with ERP best practices

Key principle:
The business should adapt to the system, rather than forcing the system to replicate every existing process.

3. Customization (Development)

Customization should only be considered when business requirements cannot be fulfilled through configuration or process adjustments.

Customization is justified when it:

• Is required to comply with specific regulations or legal requirements

• Supports a company's competitive advantage

• Has a significant impact on revenue generation or risk management

• Cannot be achieved through standard ERP features or officially supported add-ons

Examples:

• Industry-specific calculation methods

• Complex integrations with external systems

• Mission-critical workflows unique to the organization

• Compliance with industry-specific laws, government regulations, or other legally binding requirements

Key principle:
Modify the system only when there is no practical alternative.

Successful ERP implementation is not about changing the software to fit every business process. It is about finding the right balance between configuration, process improvement, and customization to create long-term business value.

Summary

• Configuration → When the ERP already provides the required functionality and only needs to be configured.

• Business Process Adjustment → When people and processes need to change to align with ERP best practices.

• Customization → When the standard ERP capabilities are insufficient and the business impact justifies development.

If every business requirement immediately results in customization, the real challenge is often not the ERP system—but the organization's willingness to embrace change.

#ERP #ERPImplementation #DigitalTransformation #BusinessProcess #ChangeManagement #Odoo #BusinessConsulting #KKPdanITIrawan #DigitalisasiLaporanKeuangan #DigitalisasiPerpajakan

TAX PLANNING AND TAX CONSULTANT

AI Will Not Replace Tax Consultants.

But Tax Consultants Who Use AI Will Replace Those Who Don't.

A few years ago, many tax-related tasks were performed manually. Researching tax regulations, preparing working papers, reconciling financial data, and compiling supporting documentation often required hours of effort.

Today, with the help of Artificial Intelligence (AI), many of these processes can be completed much faster.

AI can help:

• ✅ Summarize lengthy tax regulations into clear, actionable key points.

• ✅ Identify potential tax risks from financial data and supporting documents.

• ✅ Draft tax Standard Operating Procedures (SOPs) and internal policies.

• ✅ Assist in reconciling accounting and tax data.

• ✅ Prepare summaries of tax audit findings or SP2DK (Request for Explanation of Data and/or Information).

• ✅ Support the preparation of tax documentation and working papers.

However, one important fact remains.

AI is not a replacement for tax consultants, accountants, or tax professionals.

AI is a tool.

Final decisions still require business understanding, regulatory interpretation, professional experience, and sound judgment—qualities that only experienced professionals can provide.

Therefore, I believe the more relevant question today is no longer:

"Will AI transform the tax profession?"

Instead, we should ask:

• ✅ How can we leverage AI to work faster?

• ✅ How can AI help us improve accuracy?

• ✅ How can AI enable us to deliver greater value to taxpayers and businesses?

Just as spreadsheets transformed the way we worked with numbers, AI is transforming the way we work with information.

Those who embrace this change will gain a significant competitive advantage—not because AI replaces people, but because AI empowers professionals to work smarter.

What about you?

Have you already started using AI in your finance, accounting, or tax practice?

Keywords: Artificial Intelligence, AI, Tax Technology, Digital Tax Transformation, Finance Transformation, ERP, Accounting, Tax Consulting, Business Transformation, Digital Transformation, Digitalisasi Perpajakan, Kkp dan IT Irawan.

Consulting Firm

Building an AI-Powered Consulting Firm

What if a consulting firm could serve more clients without continuously increasing its headcount?

What will a consulting firm look like in the next 5–10 years?

Will it still operate the same way it does today?

• More employees.

• More administrative work.

• More time spent preparing reports than analyzing them.

I believe the answer is beginning to change.

I envision a consulting firm that continues to rely on human expertise, professional judgment, and integrity, while leveraging technology to deliver services faster, more accurately, and more efficiently.

The Foundation I Am Building Today

🏠 Notion serves as the central hub for knowledge management, standard operating procedures (SOPs), templates, documentation, and project management.

⚙️ Docker provides a secure and independent infrastructure for running multiple business services.

🔄 n8n automates repetitive workflows, from approval processes and application integration to report generation.

🤖 AI technologies such as ChatGPT, Claude, Gemini, and other language models act as intelligent assistants that help with analysis, document preparation, and information processing.

📊 ERP systems remain the single source of truth, ensuring that every business transaction is recorded once and utilized across the entire organization.

My Vision

My vision is simple.

One day, a business owner will only need to submit business documents such as invoices, receipts, or proof of payment.

From there, an integrated AI-powered system will assist in:

• Classifying transactions

• Generating accounting journal entries

• Updating the ERP system

• Preparing financial statements

• Organizing tax-related information

• Producing management dashboards and business insights

One Thing Will Never Change

Despite all these technological advances, one principle remains unchanged:

Decisions will always belong to humans.

AI accelerates work.

ERP maintains data consistency.

Automation eliminates repetitive tasks.

But professional judgment, ethical responsibility, business experience, and strategic decision-making remain the responsibility of the consultant.

The Future of Finance, Accounting, Tax, and ERP

I believe the future of Finance, Accounting, Tax, and ERP professionals is not about competing with AI.

It is about leveraging AI so that professionals can spend more time doing what truly creates value:

• Thinking critically

• Performing meaningful analysis

• Solving business problems

• Advising clients

• Supporting better business decisions

Building the Foundation

I am still in the foundation-building phase.

Every day I continue to:

• Learn new technologies

• Experiment with AI solutions

• Design workflows

• Develop SOPs

• Build reusable templates

• Create business automations

Because I believe digital transformation does not begin with purchasing technology.

It begins with building the right business systems.

The Future of Consulting

The future of consulting is not about replacing people with AI.

It is about combining human expertise with artificial intelligence to deliver consulting services that are faster, more accurate, and more valuable to clients.

That is the future I believe in.

And that is the future I have chosen to start building today.

Tags:

AI • Artificial Intelligence • Digital Transformation • Business Consulting • Finance • Accounting • Tax • ERP • Workflow Automation • n8n • Docker • Notion • Fractional CFO • Business Process Automation • Digital Consulting • AI Consulting • Finance Transformation • KKP & IT Irawan • Digitalisasi Perpajakan • Digitalisasi Laporan Keuangan 

Payroll and Coretax Integration: From PPh 21 Calculation to Bank Payment and Automated Journals

Managing employee payroll involves more than calculating monthly salaries. Companies must also calculate PPh 21, prepare employee payments, record payroll expenses and liabilities, and submit the required tax information through Coretax.

When each process is handled separately, Human Resources, Finance, Accounting, and Tax teams often repeat the same work using different files. This increases the risk of calculation errors, inconsistent information, delayed payments, and discrepancies between payroll records, accounting journals, and tax reports.

An integrated payroll system connects the entire process—from employee attendance and PPh 21 calculation to bank payment, automated accounting journals, and Coretax reporting.

One Integrated Source of Payroll Data

The process begins with employee and payroll-related information, including:

• Employee master data

• Tax identification and employment status

• Attendance records

• Overtime

• Leave and time off

• Allowances and deductions

• Employee loans

• Other taxable and non-taxable payroll components

These inputs are processed within the payroll system to calculate gross income, deductions, take-home pay, and the applicable PPh 21.

Because the calculation uses information from the same integrated database, the company does not need to re-enter payroll data separately for salary payments, accounting, and tax reporting.

Integrated PPh 21 Calculation

PPh 21 calculation is one of the most critical parts of payroll administration.

Errors may occur when employee tax status, taxable income, tax object codes, or applicable tax rates are maintained manually across multiple spreadsheets or systems.

An integrated payroll system can calculate PPh 21 as part of the monthly payroll process using the configured employee and income information.

The calculation results can then be used consistently for:

• Employee payslips

• Payroll reports

• Salary payment registers

• Accounting journal entries

• PPh 21 reporting

• Coretax XML generation

This integration helps reduce discrepancies between the PPh 21 deducted from employees, the amount recorded in the accounting system, and the information reported through Coretax.

Automation does not eliminate the need for professional review. Tax configurations, employee information, income components, and calculation results must still be reviewed regularly to ensure that the appropriate tax treatment is applied.

Payroll-to-Bank Payment Integration

Once payroll has been calculated, reviewed, and approved, the system can prepare a salary payment register or bank payment file.

The integrated process follows a structured sequence:

Payroll calculation → Payroll approval → Bank payment register → Salary payment

This reduces the need to manually recreate salary payment information in a separate banking template.

It also strengthens payment controls because the amount transferred to employees can be reconciled directly with the approved payroll report and employee payslips.

Companies should maintain proper authorization controls, including payroll review, payment approval, access restrictions, and segregation of duties between payroll preparation and bank authorization.

Automated Payroll Journal Entries

Payroll transactions affect several accounting accounts, including:

• Salary and wage expenses

• Allowance expenses

• Overtime expenses

• Employee receivables or loans

• PPh 21 payable

• Other employee deductions

• Payroll payable

• Cash or bank accounts

Without integration, the Accounting team must summarize payroll information and manually prepare journal entries every month. This requires additional time and may result in discrepancies between payroll reports and the general ledger.

An integrated payroll system can automatically generate payroll journal entries based on the approved payroll calculation.

The journal can be posted to the accounting system using the company’s chart of accounts and accounting dimensions, such as departments, branches, cost centers, or business units.

Automated journal entries provide several advantages:

• Faster month-end closing

• Fewer manual entries

• Consistent payroll and accounting records

• Easier reconciliation

• Better allocation of employee costs

• A clearer audit trail

Direct Preparation for Coretax Reporting

The same approved payroll data can be transformed into the required tax reporting structure.

The system can generate a Coretax XML file containing relevant information, such as:

• Tax period and tax year

• Employee or income recipient identification

• Tax status

• Position or employment information

• Tax object code

• Gross income

• Applicable tax rate

• Place of business activity identification

• Withholding date

The authorized user selects the relevant reporting period, generates the XML file, reviews its contents, and uses it in the Coretax reporting process.

The reporting data therefore originates from the same payroll calculation used for employee payments and accounting records.

This eliminates another layer of repeated data entry and reduces the risk of discrepancies between payroll, accounting, and tax reporting.

One Verified Process, Multiple Integrated Outputs

The main advantage of payroll integration is the ability to transform one verified payroll calculation into several connected outputs.

Employee data, attendance, overtime, leave, loans, and tax information are processed through one controlled workflow that supports salary payments, automated accounting entries, and Coretax reporting.

The company no longer treats payroll, tax, banking, and accounting as separate processes. They become one integrated end-to-end workflow.

Key Business Benefits

1. More Reliable PPh 21 Calculations

Employee data, payroll components, and tax information are processed within the same system, reducing the risk of calculations being based on inconsistent sources.

2. Faster Coretax Reporting

Coretax reporting data can be prepared directly from approved payroll results without rebuilding the information in a separate spreadsheet.

3. More Efficient Salary Payments

Bank payment registers or payment files are generated from approved payroll data, reducing manual payment preparation.

4. Automated Accounting Records

Salary expenses, deductions, payroll liabilities, PPh 21 payable, and bank transactions can be recorded through system-generated journal entries.

5. Easier Monthly Reconciliation

Payroll, PPh 21, bank payments, and accounting journals originate from the same transaction data, making reconciliation more efficient.

6. Faster Month-End Closing

Automated payroll journals reduce the time required to prepare and verify accounting entries at the end of each month.

7. Stronger Internal Control

The system creates a clearer separation between data input, payroll calculation, review, approval, payment, journal posting, and tax reporting.

8. Better Audit Trail

Every payment, journal entry, and tax reporting output can be traced back to the employee data and payroll calculation that generated it.

Internal Controls Remain Essential

Although integration reduces manual work, companies must continue to apply appropriate internal controls.

These should include:

• Validation of employee identity and tax information

• Regular review of payroll and PPh 21 configurations

• Approval of payroll before payment and journal posting

• Reconciliation of payroll reports with bank payment records

• Reconciliation of PPh 21 deductions with tax payable accounts

• Review of the Coretax XML file before submission

• Role-based access to payroll and tax information

• Documentation of payroll adjustments and corrections

• Protection of confidential employee information

Automation makes the process faster, but governance ensures that the output remains accurate, secure, and reliable.

Digitalization Is More Than Replacing Spreadsheets

The real benefit of payroll digitalization is not limited to calculating salaries or generating a Coretax XML file.

Its value lies in connecting the entire process:

Employee data → Payroll calculation → PPh 21 calculation → Bank payment → Automated accounting journal → Coretax reporting

With an integrated workflow, companies can reduce repetitive administrative work, improve data consistency, accelerate monthly closing, strengthen internal controls, and build a more reliable tax reporting process.

Technology should not merely replace spreadsheets. It should connect business processes and transform the same verified data into multiple reliable outputs.

Conclusion

Payroll and Coretax integration provides companies with a more efficient and controlled approach to managing employee tax obligations.

One approved payroll process can support PPh 21 calculation, employee salary payments, automated accounting journals, and Coretax reporting.

However, successful implementation requires more than technical integration. Companies must ensure that employee data is accurate, payroll and tax configurations are properly maintained, accounting records are reconciled, access is controlled, and every tax submission is reviewed by an authorized person.

Technology accelerates the process. Strong governance ensures that the results remain accurate and compliant.

Need Assistance with Payroll, Tax, and ERP Integration?

KKP & IT Irawan helps companies improve tax administration, financial reporting, ERP implementation, payroll integration, and business process digitalization.

Visit www.kkpitirawan.com to discuss your business requirements.

Meta Description

Discover how payroll integration connects PPh 21 calculation, bank payments, automated accounting journals, and Coretax reporting in one controlled workflow.

URL Slug

payroll-pph21-coretax-integration

Website Tags

Coretax, PPh 21, Payroll Integration, Tax Digitalization, Bank Payment Integration, Automated Journal Entries, ERP, Accounting Automation, Tax Compliance, Financial Digitalization

Hashtags

#Coretax #PPh21 #PayrollIntegration #TaxDigitalization #ERP #AccountingAutomation #TaxCompliance #FinancialDigitalization #BusinessProcessAutomation #KKPITIrawan

CORETAX ACCESS SUSPENDED DUE TO OUTSTANDING ARTICLE 21 WITHHOLDING TAX RETURNS

Recently, I handled a case in which a company’s access to Coretax was suspended, preventing it from completing several tax administration processes.

After reviewing the company’s tax status, we found that several 2025 Monthly Article 21 Withholding Tax Returns (SPT Masa PPh Pasal 21) had not yet been filed.

The first step was to resolve these outstanding obligations. This involved identifying the unfiled tax periods, verifying that the underlying data and tax payments were accurate, and submitting the outstanding Article 21 Withholding Tax Returns.

However, the process did not end once the returns had been filed.

We then submitted a formal request to have the suspension lifted, supported by the following documents:

• Tax payment receipts
• Tax return filing receipts or submission acknowledgements
• Other supporting documents as required

After submitting the request, we continued monitoring its status until the suspension was lifted and the company could access Coretax normally again.

This experience serves as an important reminder that companies should not only ensure that their taxes have been accurately calculated and paid.

The filing status for every tax period must also be reviewed regularly.

Several preventive measures can be implemented:

• Reconcile payroll data with the Article 21 withholding tax calculations
• Ensure that both payment and filing obligations are completed for every tax period
• Maintain organised records of payment receipts and filing acknowledgements
• Regularly review the Coretax dashboard and the status of outstanding tax obligations
• Immediately follow up on any unresolved tax obligations

A Coretax suspension can disrupt a company’s tax administration processes. Therefore, tax compliance monitoring should not be performed only when the annual corporate income tax return deadline is approaching.

Tax compliance is not only about making payments. It also requires timely filing and properly maintained supporting documentation.

Has your company confirmed that all 2025 Monthly Article 21 Withholding Tax Returns have been filed?

For tax information and consultation:
www.kkpitirawan.com

#Coretax #Article21WithholdingTax #TaxReturn #TaxCompliance #TaxAdministration #TaxConsultant #TaxDigitalisation #kkpitirawan