Statement Compiler

The Statement Compiler is a powerful tool that transforms your bank statement PDFs into comprehensive 18-worksheet Excel management accounts. Using AI-powered extraction and classification, it automates hours of manual bookkeeping work.

# How It Works

The compiler uses a multi-step process to transform your statements:

1. Upload — Upload one or more bank statement PDFs
2. Extract — AI extracts all transactions from the PDF
3. Classify — Transactions are automatically categorized
4. Generate — Creates formatted Excel worksheets

# Getting Started

# Upload Your Statements

Navigate to Compile from the main menu. You can upload:

• Single or multiple PDF files
• Statements from different bank accounts
• Statements spanning multiple months

Drag and drop your files or click to browse. The compiler supports most Malaysian bank statement formats including Maybank, CIMB, Public Bank, RHB, and more.

# Processing Your Statements

Once uploaded, the compiler will:

1. Extract transactions using AI-powered document analysis
2. Detect statement ownership (personal vs business account)
3. Classify each transaction into appropriate categories
4. Generate your Excel workbook with all required worksheets

You'll see real-time progress as each step completes.

# Output Worksheets

The compiler generates up to 18 worksheets tailored for Malaysian SME accounting:

# Core Worksheets

• Executive Dashboard — High-level summary with key metrics
• Transaction Register — Complete list of all transactions
• Cash Flow Statement — Monthly cash in/out analysis

# Expense Worksheets

• Operating Expenses — Day-to-day business costs
• Payroll & Staff — Salary and employee expenses
• Professional Fees — Legal, accounting, consulting
• Marketing & Advertising — Promotional expenses
• Travel & Entertainment — Business travel costs
• Utilities & Subscriptions — Recurring bills

# Revenue Worksheets

• Sales Revenue — Income from products/services
• Other Income — Interest, refunds, misc income

# Tax Worksheets

• Tax Deductible Expenses — Expenses eligible for tax relief
• SST/GST Summary — Tax collected and paid

# Extraction Providers

The compiler uses multiple AI providers for maximum accuracy:

Provider	Strengths
Reducto	Financial document specialist, schema-based extraction
OpenAI GPT-4o	Vision-based extraction with structured output
OpenRouter	Universal PDF support with 400+ models

The system automatically selects the best provider based on document type and complexity.

# Output Formats

Based on the timespan of your statements, the compiler adapts its output:

Period	Format
1-3 months	Single worksheet per category
4-6 months	Monthly breakdown sheets
7-12 months	Quarterly summary sheets
12+ months	Multi-file ZIP with annual breakdown

# Tips for Best Results

# Statement Quality

• Use original PDFs from your bank (not scanned copies)
• Ensure statements are complete and not password-protected
• Higher quality PDFs produce more accurate extractions

# Multiple Accounts

• Upload statements from different accounts together
• The compiler will detect and separate transactions by account
• Business and personal accounts are automatically identified

# Review Classifications

• Check the generated classifications for accuracy
• Use the Classification Rules feature to improve future results
• The system learns from your corrections

# Troubleshooting

# Extraction Issues

If transactions are missing or incorrectly extracted:

• Verify the PDF is not corrupted
• Check if the bank format is supported
• Try uploading a cleaner version of the statement

# Classification Accuracy

If transactions are miscategorized:

• Review and correct in the generated Excel
• Add classification rules for common merchants
• The system improves over time with corrections

# Interactive Questions

During processing, the compiler may ask questions to improve accuracy:

# Question Types

• Owner Identification — Is this a personal or business account?
• Transaction Classification — What category does this merchant belong to?
• Ambiguous Entries — Help resolve unclear transactions

# Answering Questions

When prompted, you can:

1. Answer Now — Provide the answer immediately
2. Answer Later — Defer the question to answer later

# Deferred Questions

The "Answer Later" feature lets you defer questions and answer them when convenient:

• Deferred questions are tracked across your workspace
• Access pending questions from the Questions panel
• The compiler continues processing with best-guess classifications
• You can update deferred answers later to improve accuracy

Deferred questions show:

• The original transaction context
• Which cells are affected
• When the question was deferred
• Any notes you added

# Viewing History

Access your compilation history from Compile → History. You can:

• Download previous compilations
• Re-run compilation with updated rules
• View processing logs for troubleshooting