← Category Summary

LANGKAH 2 · CATEGORIZE

Bank statement category algorithm

Setiap transaksi Vault diisi kategori oleh 6 lapisan. Kategori itu kemudian dipetakan ke 5 elemen akaun. Balance c/f dikira ikut elemen — bukan Net (CR−DR) rata.

6 lapisan padanan

L1Bank rules — regex merchant/curated85–95%
L2Exact match — sejarah CatDict (description + direction)80–100%
L3Keyword dictionary — kekerapan perkataan CatDict60–85%
L4Fuzzy / Levenshtein terhadap CatDict75–90%
L5Fallback → UNCATEGORIZED0%

Kod: /neuralops/skills/algo/bank_statement_category/CategoryAlgo.php

Balance c/f

ASSET / EXPENSE → Debit − Credit
LIABILITY / EQUITY / REVENUE → Credit − Debit

Contoh hidup

DescriptionCategoryTypeMatchDrCrBalance c/f
SERVICE CHARGE BANK CHARGE EXPENSE bank_rule · 95% 10.00 0.00 10.00
GRAB-EC PETALING JAYA MY FOOD AND BEVERAGE EXPENSE bank_rule · 90% 27.90 0.00 27.90
TIKTOK SHOP SELLER MY TIKTOK EXPENSE bank_rule · 95% 14.78 0.00 14.78
TNG-EWALLET ECOM 2-EC KL MY TNG EXPENSE bank_rule · 92% 17.07 0.00 17.07
DIGI-ONLINE PAYMENT SHAH ALAM MY UTILITIES EXPENSE bank_rule · 92% 150.00 0.00 150.00
DUITNOW(INST TRF) CR RECEIVED FROM MBB ASSET bank_rule · 88% 0.00 300.00 -300.00
DRAWING DRAWING EQUITY bank_rule · 80% 200.00 0.00 -200.00

Peta kategori → 5 elemen

ASSET · 16
CategoryGLAccount
RECEIVED FROM MBB 110000 Bank - MBB OD
ASSET 150000 Fixed Assets
TR TO MBB 110000 Bank - MBB OD
TR TO CIMB 185 110002 Bank - CIMB 185
RECEIVED FROM RESERVE ACC 110000 Bank - MBB OD
RECEIVED FROM BSN 110005 Bank - BSN OD
TR TO BSN 110005 Bank - BSN OD
CC 110006 Bank - Credit Card
RECEIVED FROM CIMB 977 110001 Bank - CIMB 977
PETTY CASH 100100 Petty Cash
TR TO CIMB 997 110001 Bank - CIMB 977
RECEIVED FROM CIMB 185 110002 Bank - CIMB 185
TR TO RESERVE ACC 110000 Bank - MBB OD
TR TO CIMB 923 110003 Bank - CIMB 923 OD
RECEIVED FROM CIMB 923 110003 Bank - CIMB 923 OD
FD 150000 Fixed Deposit
LIABILITY · 3
CategoryGLAccount
LOAN 230000 Loan - Overdraft
PROFITDEDUCTED 210000 SST Payable
TAX PAYABLE 210000 SST Payable
EQUITY · 4
CategoryGLAccount
REFUND DRAWING 330000 Owner's Drawings
DRAWING 330000 Owner's Drawings
OWNER EQUITY 310000 Owner's Equity
OPENING ACC 310001 Opening Balance
EXPENSE · 38
CategoryGLAccount
BANK CHARGE 623000 Bank Charges
SALARY 600000 Salary & Wages
EPF 601000 EPF Contribution
SOCSO 602000 SOCSO Contribution
ZAKAT 651001 Zakat Perniagaan
TIKTOK 634001 TikTok Commission
FOOD AND BEVERAGE 645002 Food & Beverage
TNG 641000 TNG / eWallet
STATIONERY 620001 Stationery
UPKEEP PREMISES 612000 Maintenance & Repairs
TRAVELLING EXPENSES 645001 Accommodation & Hotel
ACCOMODATION AND HOTEL 645001 Accommodation & Hotel
UTILITIES 611000 Utilities - Electricity
SHOPEE 634002 Shopee Commission
ADS 630000 Advertising & Promotion
DONATION 651002 Charity Donation
GENERAL INSURANCE 624000 Insurance
LAZADA 634003 Lazada Commission
MEDICAL FEE 604001 Medical & Dental
PETROL AND DIESEL 640000 Petrol & Diesel
POSTAGE AND COURIER 621000 Postage & Courier
PURCHASE RETURN 560000 Purchase Return
RENTAL 610000 Rental - Office/Factory
SEMINAR AND PROGRAM 650000 Seminar & Program
SERVER SUBC 625002 Server Subscription
STAFF REFRESHMENT 604003 Staff Refreshment
STAFF REWARD 604005 Staff Reward
STAFF TRIP 604004 Staff Trip
TRANSPORTATION 644000 Transportation
UPKEEP VEHICLE 643000 Vehicle Maintenance
RSP 500000 Purchases - Local
MERLIMAU 520000 Direct Materials
REPAIR 612001 Repairs
CATERING 604006 Catering
PURCHASE 500000 Purchases - Local
SERVER 625001 Server Hosting
SALARY ADV 600001 Salary Advance
BAD DEBT 605000 Bad Debt Expense
REVENUE · 13
CategoryGLAccount
HIBAH 740000 Hibah Received
CONSULTATION FEE 421000 Consultation Fee
REFUND 432000 Refund from Suppliers
EP 410002 Sales - Lazada
ID 410001 Sales - Shopee
REFUNDCUST 432000 Refund from Suppliers
TENDANG 420001 Tender Income
SPAY 420003 S-Pay Receipt
AFFILIATE 420000 Service Income
COD SALE 410004 Sales - COD
PT 410003 Sales - Website
OTHER INCOME 420000 Other Income
PAYMENT GATEAWAY 420002 Payment Gateway
UNCATEGORIZED · 2
CategoryGLAccount
TRANSFER OUT
RENT