26.4 PCN Account Mapping for Common SME Transactions
Introduction to Transaction Mappingβ
Mapping business transactions to PCN accounts is a fundamental accounting skill. Every transaction affects at least two accounts (double-entry bookkeeping), and each account must be classified according to PCN standards.
Purchase Transactionsβ
Purchasing Inventory (Goods for Resale)β
Transaction: Purchase β¬500 of inventory on credit from a supplier
PCN Mapping:
- Debit: Account 601 (Purchases of goods) - β¬500
- Credit: Account 401 (Suppliers) - β¬500
With VAT (17%):
- Debit: Account 601 (Purchases) - β¬427.35
- Debit: Account 44551 (Input VAT recoverable) - β¬72.65
- Credit: Account 401 (Suppliers) - β¬500.00
Purchasing Fixed Assetsβ
Transaction: Purchase β¬5,000 equipment, paid by bank transfer
PCN Mapping:
- Debit: Account 218 (Machinery and equipment) - β¬5,000
- Credit: Account 512 (Bank account) - β¬5,000
With VAT:
- Debit: Account 218 (Equipment) - β¬4,273.50
- Debit: Account 44551 (Input VAT) - β¬726.50
- Credit: Account 512 (Bank) - β¬5,000.00
Sales Transactionsβ
Cash Salesβ
Transaction: Sell β¬200 of goods for cash (VAT 17%)
PCN Mapping:
- Debit: Account 530 (Cash) - β¬234.00
- Credit: Account 701 (Sales of goods) - β¬170.94
- Credit: Account 44581 (VAT on sales) - β¬29.06
Credit Salesβ
Transaction: Sell β¬1,000 of services on credit (VAT 17%)
PCN Mapping:
- Debit: Account 411 (Customers) - β¬1,170.00
- Credit: Account 706 (Services rendered) - β¬854.70
- Credit: Account 44581 (VAT on sales) - β¬145.30
Payment Transactionsβ
Paying Suppliersβ
Transaction: Pay β¬800 to supplier (including β¬136 VAT)
PCN Mapping:
- Debit: Account 401 (Suppliers) - β¬800.00
- Credit: Account 512 (Bank account) - β¬800.00
Receiving Customer Paymentsβ
Transaction: Receive β¬1,170 from customer (payment for invoice)
PCN Mapping:
- Debit: Account 512 (Bank account) - β¬1,170.00
- Credit: Account 411 (Customers) - β¬1,170.00
Payroll Transactionsβ
Paying Salariesβ
Transaction: Pay β¬3,000 gross salary (employee portion: β¬600 social charges, employer portion: β¬900)
PCN Mapping:
- Debit: Account 621 (Salaries) - β¬3,000.00
- Debit: Account 641 (Social charges - employer) - β¬900.00
- Credit: Account 431 (Social charges payable) - β¬1,500.00
- Credit: Account 512 (Bank account) - β¬2,400.00
Expense Transactionsβ
Paying Rentβ
Transaction: Pay β¬1,200 monthly rent
PCN Mapping:
- Debit: Account 641 (Rent) - β¬1,200.00
- Credit: Account 512 (Bank account) - β¬1,200.00
Paying Utilitiesβ
Transaction: Pay β¬150 electricity bill (VAT 17%)
PCN Mapping:
- Debit: Account 613 (Electricity) - β¬128.21
- Debit: Account 44551 (Input VAT) - β¬21.79
- Credit: Account 512 (Bank account) - β¬150.00
Depreciation Transactionsβ
Recording Depreciationβ
Transaction: Record β¬200 monthly depreciation on equipment
PCN Mapping:
- Debit: Account 671 (Depreciation of fixed assets) - β¬200.00
- Credit: Account 281 (Accumulated depreciation - equipment) - β¬200.00
VAT Transactionsβ
VAT Return Filingβ
Transaction: File VAT return (VAT collected: β¬1,000, VAT paid: β¬600, net payable: β¬400)
PCN Mapping:
- Debit: Account 44551 (Input VAT recoverable) - β¬600.00
- Credit: Account 44581 (VAT on sales) - β¬1,000.00
- Debit: Account 44571 (VAT payable) - β¬400.00
When paying VAT:
- Debit: Account 44571 (VAT payable) - β¬400.00
- Credit: Account 512 (Bank account) - β¬400.00
Common Transaction Mapping Tableβ
| Transaction Type | Debit Account | Credit Account | Notes |
|---|---|---|---|
| Purchase inventory (cash) | 601 (Purchases) | 512 (Bank) | Add 44551 for VAT |
| Purchase inventory (credit) | 601 (Purchases) | 401 (Suppliers) | Add 44551 for VAT |
| Cash sale | 530 (Cash) | 701 (Sales) | Add 44581 for VAT |
| Credit sale | 411 (Customers) | 701 (Sales) | Add 44581 for VAT |
| Pay supplier | 401 (Suppliers) | 512 (Bank) | |
| Receive payment | 512 (Bank) | 411 (Customers) | |
| Pay salary | 621 (Salaries) | 512 (Bank) | Include 431 for social charges |
| Pay rent | 641 (Rent) | 512 (Bank) | |
| Record depreciation | 671 (Depreciation) | 281 (Accum. Depreciation) | |
| Pay VAT | 44571 (VAT payable) | 512 (Bank) |
Luxembourg Compliance Noteβ
All transactions must be mapped to PCN accounts. When using accounting software, ensure it's configured with PCN 2020 account structure. Manual journal entries should always reference PCN account numbers, not just account names.
Think It Throughβ
Marie's restaurant receives a β¬500 invoice for kitchen equipment maintenance. The invoice includes β¬85 VAT (17%). How would you map this transaction to PCN accounts? What if she pays immediately vs. on credit terms?
Concepts in Practiceβ
Restaurant Daily Operations
Le Petit Bistro processes these transactions daily:
-
Morning: Purchase β¬200 food inventory (cash, VAT 17%)
- Debit 601, Debit 44551, Credit 530
-
Lunch Service: β¬500 cash sales (VAT 17%)
- Debit 530, Credit 701, Credit 44581
-
Afternoon: Pay β¬150 utility bill (VAT 17%)
- Debit 613, Debit 44551, Credit 512
-
End of Day: Record β¬50 depreciation on equipment
- Debit 671, Credit 281
All transactions are properly mapped to PCN accounts, ensuring compliance and accurate reporting.