Complete guide for Document Extraction and Payroll modules.
Upload invoices, bills, receipts, bank statements — Dokuva AI reads every page, extracts all data, and generates an Excel file ready to import into your accounting software.
| Document Type | Examples | Output Tab |
|---|---|---|
| Invoices & Bills | TNB, Unifi, supplier invoices, PUNB rental | Expenses |
| Receipts | Petrol, F&B, office supplies | Expenses |
| Bank Statements | Maybank, CIMB, RHB, credit card statements | Bank Statement |
| Supplier Statements | Ottica, HOYA, supplier account statements | Supplier Statement |
| Credit/Debit Notes | CN, DN from suppliers | Credit Debit Notes |
Click the upload area or drag & drop files. Supports PDF, JPG, PNG. You can upload multiple files at once.
Choose "Auto Detect" (recommended), "Invoice/Receipt", or "Bank Statement". Auto Detect works for most cases.
AI reads every page. Takes about 5-10 seconds per page. You'll see progress in real-time.
Click the download button when status shows "Done". Excel file contains all extracted data in separate tabs.
| Tab | Contents | SQL Account Import |
|---|---|---|
| Summary | Category breakdown, totals, document counts | Reference only |
| Expenses | All invoices/bills with AccountCode, tax, category | AP → Purchase Invoice |
| Bank Statement | All bank transactions (debit/credit/balance) | CB → Cash Book Entry |
| Supplier Statement | Supplier account balances | Reference for reconciliation |
| Credit Debit Notes | CN/DN adjustments | AP → Credit Note / Debit Note |
Go to AP → Purchase Invoice → Import
Choose the Dokuva Excel file. Select the "Expenses" tab.
Map: Date → DocDate, DocNo → DocNo, VendorName → Supplier, TotalAmount → Amount. AccountCode is pre-filled.
Go to CB → Cash Book Entry → Import. Select "Bank Statement" tab. Map Date, Description, Debit, Credit.
| Code | Category | Examples |
|---|---|---|
| 500-001 | Utilities | TNB, Air Selangor, gas |
| 500-002 | Telecom | TM, Maxis, Unifi |
| 500-003 | Stock Purchase | Goods for resale, raw materials |
| 500-004 | Equipment | Machinery, IT equipment |
| 500-005 | Financing | Loan repayment, hire purchase |
| 500-006 | Rent | Premises rental, sewa kedai |
| 500-007 | Transport | Petrol, toll, parking |
| 500-008 | F&B | Food, beverages, catering |
| 500-009 | Office Supplies | Stationery, printing |
| 500-010 | Professional Services | Legal, accounting, audit |
| 500-011 | Insurance | Business insurance, takaful |
| 500-012 | Government | KWSP, SOCSO, LHDN, SSM |
| 500-013 | Marketing | Advertising, promotion |
| 500-014 | Maintenance | Repair, servicing, cleaning |
| 500-015 | Bank Charges | Bank fees, transaction charges |
Manage employees and run monthly payroll. Auto-calculates KWSP, SOCSO, EIS, and PCB. Generates Excel with Borang A, Borang 8A, CP39 — ready to submit.
In the Payroll tab, click the purple scan button.
Upload any of these — AI will extract all employee data:
AI shows extracted employees in a table. Check names, IC numbers, salaries. Edit any field if wrong. Untick employees you don't want to import.
Confirmed employees are saved. Done — no manual typing needed.
Dokuva auto-calculates for all active employees:
Excel auto-downloads with 6 tabs:
| Tab | Contents | What To Do |
|---|---|---|
| Payroll Summary | All employees: gross, deductions, net pay | Import into SQL Account Payroll |
| KWSP Borang A | Employee + employer contributions | Submit to KWSP (i-Akaun Majikan) |
| SOCSO Borang 8A | SOCSO contributions | Submit to PERKESO (Assist Portal) |
| EIS Schedule | EIS contributions | Submit with SOCSO |
| PCB CP39 | Monthly tax deductions | Submit to LHDN (e-PCB) |
| Bank Payment | Employee bank details + net pay | Use for salary transfer |
Go to Payroll → Payroll Entry → Import
Choose the "Payroll Summary" tab. Map columns: EmployeeID, BasicSalary, EPF_Employee, SOCSO, EIS, PCB, NetPay.
SQL Account shows the imported payroll. Verify totals match. Click Post.
Dokuva auto-generates e-Invoice data in LHDN MyInvois format from your extracted invoices. The "e-Invoice LHDN" tab in your Excel contains all required fields.
Dokuva extracts all data including supplier name, TIN, amounts, tax.
Contains: e-Invoice version, type code, supplier/buyer details, line items, tax type (SST/Exempt), amounts.
Add TIN (Tax Identification Number), BRN (Business Registration Number), and MSIC code where marked. These are required by LHDN.
Use the data to submit via LHDN MyInvois portal or your accounting software's e-Invoice module.
Auto-generates input tax summary from your extracted purchase invoices. Grouped by expense category and SST rate — ready for quarterly SST-02 filing.
| Section | What It Shows |
|---|---|
| A. Input Tax (Purchases) | Each category with account code, amount excl tax, SST rate, tax amount |
| B. Summary for SST-02 | Total taxable purchases, total input tax, total incl SST |
| C. Breakdown by Rate | Totals grouped by SST rate (6%, 8%, exempt) |
AI automatically posts all your extracted documents to a General Ledger and generates P&L, Balance Sheet, and Trial Balance. No manual journal entries needed.
Bank statements, invoices, receipts — same upload flow. AI extracts and auto-posts to GL every 2 minutes.
Click "Upload Sales Data" and upload your POS export (Excel or CSV from StoreHub, Loyverse, or any system). AI reads any format and posts as income.
Click "Set Opening Balances" in Accounting tab. Enter company name, cash in bank, capital, payables, receivables.
P&L, Balance Sheet, GL Ledger — all auto-generated. Select any period to view.
Click "Download Reports (Excel)" — generates Excel with P&L, Balance Sheet, Trial Balance, GL Journal Voucher (SQL Account format), and GL Ledger.
AI checks your accounting completeness and tells you what's missing:
AI scores your books on 8 criteria. Aim for 80%+ to be audit-ready:
| Tab | Contents | Use For |
|---|---|---|
| Profit & Loss | Income and expenses breakdown | Monthly performance review |
| Balance Sheet | Assets, liabilities, equity | Financial position |
| Trial Balance | All accounts with debit/credit | Verification, audit |
| GL_JournalVoucher | SQL Account JV import format | Direct import to SQL Account |
| GL_Ledger | Full ledger with source references | Audit trail |
PDF, JPG, JPEG, PNG for both document extraction and payroll scanning.
High accuracy for printed documents (invoices, bank statements). Always verify before importing.
Yes. The Excel output works with any accounting software that supports Excel import. Column names follow standard accounting conventions.
For payroll: you can edit any field in the review screen before importing. For documents: check the "Confidence" column — "low" confidence items should be reviewed manually.
No. Pages reset at the start of each month.