GL
Lexivo ERP
General Ledger
··
› General Ledger› GL Mapping
GL Account Mapping
Document-driven auto-posting engine · UAE VAT treatments · conditional & balancing logic
Posting Rules
41
41 active · 0 off
Auto-Post
32
9 manual review
Scenarios
8
transaction categories
GL Accounts
40
distinct accounts mapped
Validation
100%
41 of 41 balanced
All 41Sales 8Purchases 7Cash, Bank 4Inventory 3Payroll 5Fixed Assets 5Tax — VAT 3Period-End 6
By category
All rules
Posting accounts
Sales & Receivables
8 rules
Sales Invoice — Standard Rated SAL-STD
Customer Invoice  ·  On invoice approval
ValidActiveAuto-post
Standard 5%Taxable supply within the UAE · output VAT at 5%Revenue stream · Cost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR13000Trade ReceivablesGross incl. VAT · Invoice total incl. VAT105,000
CR41000RevenueNet amount · Net revenue100,000
CR21500VAT Payable (Output)VAT (5%) · Output VAT 5%5,000
Sample @ 100,000 — Dr 105,000 · Cr 105,000Balanced
Effective 2018-01-01  ·  Priority 10
Sales Invoice — Zero-Rated SAL-ZERO
Customer Invoice  ·  On invoice approval
ValidActiveAuto-post
Zero-rated 0%Exports & qualifying supplies · VAT charged at 0%Revenue stream
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR13000Trade ReceivablesNet amount · Invoice total (no VAT)100,000
CR41000RevenueNet amount · Net revenue100,000
Sample @ 100,000 — Dr 100,000 · Cr 100,000Balanced
Effective 2018-01-01  ·  Priority 11
Sales Invoice — Exempt SAL-EXM
Customer Invoice  ·  On invoice approval
ValidActiveAuto-post
ExemptExempt supply · no VAT recoverable on related inputsRevenue stream
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR13000Trade ReceivablesNet amount · Invoice total (exempt)60,000
CR41000RevenueNet amount · Net revenue60,000
Sample @ 60,000 — Dr 60,000 · Cr 60,000Balanced
Effective 2018-01-01  ·  Priority 12
Sales Credit Note SAL-CN
Credit Note  ·  On credit-note approval
ValidActiveAuto-post
Standard 5%Reverses SAL-STDReverses a standard-rated sales invoiceRevenue stream
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR41000RevenueNet amount · Revenue reversed25,000
DR21500VAT Payable (Output)VAT (5%) · Output VAT reversed1,250
CR13000Trade ReceivablesGross incl. VAT · Receivable credited26,250
Sample @ 25,000 — Dr 26,250 · Cr 26,250Balanced
Effective 2018-01-01  ·  Priority 13
Customer Receipt SAL-RCT
Receipt  ·  On receipt allocation
ValidActiveAuto-post
Cash / bank settlement of an open invoiceBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR11000Cash & BankSettlement amount · Funds received105,000
CR13000Trade ReceivablesBalancing figure · Settle receivable105,000
Sample @ 105,000 — Dr 105,000 · Cr 105,000Balanced
Effective 2018-01-01  ·  Priority 14
Customer Advance / Deposit SAL-ADV
Receipt  ·  On advance receipt
ValidActiveAuto-post
Advance received before invoicing · held as a liabilityBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR11000Cash & BankSettlement amount · Funds received50,000
CR21800Customer Advances / DepositsBalancing figure · Customer advance (liability)50,000
Sample @ 50,000 — Dr 50,000 · Cr 50,000Balanced
Effective 2018-01-01  ·  Priority 15
Bad-Debt Write-Off SAL-BAD
Adjustment  ·  On approval (manual)
ValidActiveManual
Irrecoverable receivable derecognised · VAT bad-debt relief if >6 monthsCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53600Bad Debt ExpenseNet amount · Bad-debt expense18,000
CR13000Trade ReceivablesBalancing figure · Receivable derecognised18,000
Sample @ 18,000 — Dr 18,000 · Cr 18,000Balanced
Effective 2018-01-01  ·  Priority 16
Early-Settlement Discount SAL-DISC
Receipt  ·  On discounted settlement
ValidActiveAuto-post
Prompt-payment discount granted to a customerRevenue stream
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR41500Sales Returns & DiscountsNet amount · Sales discount2,500
CR13000Trade ReceivablesBalancing figure · Receivable reduced2,500
Sample @ 2,500 — Dr 2,500 · Cr 2,500Balanced
Effective 2018-01-01  ·  Priority 17
Purchases & Payables
7 rules
Vendor Bill — Standard Rated PUR-STD
Vendor Bill  ·  On bill approval
ValidActiveAuto-post
Standard 5%Local taxable purchase · recoverable input VAT at 5%Cost centre · Project
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR51000Cost of SalesNet amount · Cost / expense80,000
DR14500VAT Receivable (Input)VAT (5%) · Input VAT 5%4,000
CR21000Trade PayablesGross incl. VAT · Payable incl. VAT84,000
Sample @ 80,000 — Dr 84,000 · Cr 84,000Balanced
Effective 2018-01-01  ·  Priority 20
Vendor Bill — Reverse Charge (Import) PUR-RCM
Vendor Bill  ·  On import-bill approval
ValidActiveAuto-post
Reverse chargeImport of goods / services · reverse-charge mechanismCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR51000Cost of SalesNet amount · Cost / expense120,000
DR14500VAT Receivable (Input)VAT (5%) · Input VAT (recovered)6,000
CR21500VAT Payable (Output)VAT (5%) · Output VAT (self-charged)6,000
CR21000Trade PayablesNet amount · Payable (net, no VAT)120,000
Sample @ 120,000 — Dr 126,000 · Cr 126,000Balanced
Effective 2018-01-01  ·  Priority 21
Vendor Bill — Zero / Exempt PUR-ZERO
Vendor Bill  ·  On bill approval
ValidActiveAuto-post
Zero-rated 0%Zero-rated or exempt purchase · no recoverable VATCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR51000Cost of SalesNet amount · Cost / expense40,000
CR21000Trade PayablesNet amount · Payable40,000
Sample @ 40,000 — Dr 40,000 · Cr 40,000Balanced
Effective 2018-01-01  ·  Priority 22
Purchase Debit Note PUR-DN
Debit Note  ·  On debit-note approval
ValidActiveAuto-post
Standard 5%Reverses PUR-STDReverses a standard-rated vendor billCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR21000Trade PayablesGross incl. VAT · Payable reduced15,750
CR51000Cost of SalesNet amount · Cost reversed15,000
CR14500VAT Receivable (Input)VAT (5%) · Input VAT reversed750
Sample @ 15,000 — Dr 15,750 · Cr 15,750Balanced
Effective 2018-01-01  ·  Priority 23
Vendor Payment PUR-PAY
Payment  ·  On payment run
ValidActiveAuto-post
Cash / bank settlement of an open billBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR21000Trade PayablesSettlement amount · Settle payable84,000
CR11000Cash & BankBalancing figure · Funds paid84,000
Sample @ 84,000 — Dr 84,000 · Cr 84,000Balanced
Effective 2018-01-01  ·  Priority 24
Vendor Advance / Prepayment PUR-ADV
Payment  ·  On advance payment
ValidActiveAuto-post
Prepayment to a supplier · held as an assetBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR14800Vendor Advances / PrepaymentsSettlement amount · Vendor advance (asset)30,000
CR11000Cash & BankBalancing figure · Funds paid30,000
Sample @ 30,000 — Dr 30,000 · Cr 30,000Balanced
Effective 2018-01-01  ·  Priority 25
Petty-Cash Expense PUR-PC
Petty Cash  ·  On voucher approval
ValidActiveAuto-post
Standard 5%Small expense paid from the petty-cash floatCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53000Administrative ExpensesNet amount · Expense1,200
DR14500VAT Receivable (Input)VAT (5%) · Input VAT 5%60
CR11150Petty Cash FloatGross incl. VAT · Petty-cash float1,260
Sample @ 1,200 — Dr 1,260 · Cr 1,260Balanced
Effective 2018-01-01  ·  Priority 26
Cash, Bank & Treasury
4 rules
Inter-Account Bank Transfer CB-XFER
Bank Transfer  ·  On transfer confirmation
ValidActiveAuto-post
Movement between own bank / deposit accountsBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR11100Short-term DepositsSettlement amount · Destination — deposits500,000
CR11000Cash & BankBalancing figure · Source — current account500,000
Sample @ 500,000 — Dr 500,000 · Cr 500,000Balanced
Effective 2018-01-01  ·  Priority 30
Bank Charges CB-CHG
Bank Statement  ·  On reconciliation
ValidActiveAuto-post
ExemptBank fees & charges (financial service — VAT exempt)Bank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR54100Bank ChargesNet amount · Bank charges850
CR11000Cash & BankBalancing figure · Debited by bank850
Sample @ 850 — Dr 850 · Cr 850Balanced
Effective 2018-01-01  ·  Priority 31
Interest Income CB-INT
Bank Statement  ·  On credit posting
ValidActiveAuto-post
Out of scopeDeposit interest credited by the bankBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR11000Cash & BankSettlement amount · Interest credited6,400
CR42200Interest IncomeBalancing figure · Interest income6,400
Sample @ 6,400 — Dr 6,400 · Cr 6,400Balanced
Effective 2018-01-01  ·  Priority 32
PDC Deposit (Cheque Banked) CB-PDC
Post-Dated Cheque  ·  On cheque deposit
ValidActiveAuto-post
Customer cheque banked pending clearanceBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR11500Bank Clearing / PDCSettlement amount · Bank clearing (uncleared)75,000
CR13000Trade ReceivablesBalancing figure · Settle receivable75,000
Sample @ 75,000 — Dr 75,000 · Cr 75,000Balanced
Effective 2018-01-01  ·  Priority 33
Inventory & COGS
3 rules
Goods Receipt (Perpetual) INV-GRN
GRN  ·  On goods receipt
ValidActiveAuto-post
Stock received before the vendor bill — accrued in GRNIWarehouse
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR14000InventoriesNet amount · Inventory in60,000
CR21100GRNI — Goods Received Not InvoicedBalancing figure · GRNI accrual60,000
Sample @ 60,000 — Dr 60,000 · Cr 60,000Balanced
Effective 2018-01-01  ·  Priority 40
COGS on Sale (Perpetual) INV-COGS
Delivery Note  ·  On dispatch
ValidActiveAuto-post
Cost of goods relieved from stock at point of saleWarehouse · Revenue stream
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR51000Cost of SalesNet amount · Cost of sales42,000
CR14000InventoriesBalancing figure · Inventory relieved42,000
Sample @ 42,000 — Dr 42,000 · Cr 42,000Balanced
Effective 2018-01-01  ·  Priority 41
Inventory Write-Down / Shrinkage INV-ADJ
Stock Adjustment  ·  On stock-count approval
ValidActiveManual
NRV write-down or count varianceWarehouse
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR51500Inventory Write-downNet amount · Inventory write-down9,000
CR14000InventoriesBalancing figure · Inventory reduced9,000
Sample @ 9,000 — Dr 9,000 · Cr 9,000Balanced
Effective 2018-01-01  ·  Priority 42
Payroll & HR
5 rules
Payroll — WPS Salaries PAY-WPS
Payroll Run  ·  On payroll approval
ValidActiveAuto-post
Monthly salaries disbursed via the Wage Protection SystemCost centre · Department
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53100Staff Costs — SalariesNet amount · Gross staff cost480,000
CR21700WPS Salaries PayableBalancing figure · WPS salaries payable480,000
Sample @ 480,000 — Dr 480,000 · Cr 480,000Balanced
Effective 2018-01-01  ·  Priority 50
WPS Disbursement PAY-WPSPAY
Payment  ·  On SIF settlement
ValidActiveAuto-post
Bank pays the approved WPS fileBank account
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR21700WPS Salaries PayableSettlement amount · Clear WPS payable462,000
CR11000Cash & BankBalancing figure · Salaries paid462,000
Sample @ 462,000 — Dr 462,000 · Cr 462,000Balanced
Effective 2018-01-01  ·  Priority 51
EOSB / Gratuity Provision PAY-EOSB
Provision  ·  On month-end accrual
ValidActiveAuto-post
End-of-service benefit accrued · Federal Decree-Law 33/2021Department
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53100Staff Costs — SalariesNet amount · EOSB expense16,000
CR26000Employee End-of-Service BenefitsBalancing figure · EOSB provision16,000
Sample @ 16,000 — Dr 16,000 · Cr 16,000Balanced
Effective 2022-02-02  ·  Priority 52
Leave-Salary Accrual PAY-LV
Provision  ·  On month-end accrual
ValidActiveAuto-post
Accrued annual-leave salary liabilityDepartment
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53100Staff Costs — SalariesNet amount · Leave-salary expense7,000
CR26500Leave Salary ProvisionBalancing figure · Leave-salary provision7,000
Sample @ 7,000 — Dr 7,000 · Cr 7,000Balanced
Effective 2018-01-01  ·  Priority 53
Air-Ticket Provision PAY-TKT
Provision  ·  On month-end accrual
ValidActiveAuto-post
Accrued biennial repatriation-ticket entitlementDepartment
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53100Staff Costs — SalariesNet amount · Air-ticket expense2,500
CR26600Air-Ticket ProvisionBalancing figure · Air-ticket provision2,500
Sample @ 2,500 — Dr 2,500 · Cr 2,500Balanced
Effective 2018-01-01  ·  Priority 54
Fixed Assets
5 rules
Asset Acquisition FA-ACQ
Asset  ·  On capitalisation
ValidActiveAuto-post
Standard 5%Capital purchase recognised in PPE · recoverable input VATAsset class · Cost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR12100PPE — Machinery & EquipmentNet amount · PPE — capitalised250,000
DR14500VAT Receivable (Input)VAT (5%) · Input VAT 5%12,500
CR21000Trade PayablesGross incl. VAT · Payable incl. VAT262,500
Sample @ 250,000 — Dr 262,500 · Cr 262,500Balanced
Effective 2018-01-01  ·  Priority 60
Depreciation Charge FA-DEP
Depreciation Run  ·  On month-end run
ValidActiveAuto-post
Periodic depreciation per the asset scheduleAsset class · Cost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53000Administrative ExpensesNet amount · Depreciation expense12,000
CR12900Accumulated DepreciationBalancing figure · Accumulated depreciation12,000
Sample @ 12,000 — Dr 12,000 · Cr 12,000Balanced
Effective 2018-01-01  ·  Priority 61
Asset Revaluation Surplus FA-REV
Revaluation  ·  On revaluation approval
ValidActiveManual
Upward revaluation under the revaluation model (IAS 16)Asset class
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR12100PPE — Machinery & EquipmentNet amount · PPE uplift140,000
CR31500Revaluation SurplusBalancing figure · Revaluation surplus (equity)140,000
Sample @ 140,000 — Dr 140,000 · Cr 140,000Balanced
Effective 2018-01-01  ·  Priority 62
Asset Disposal FA-DISP
Disposal  ·  On disposal approval
ValidActiveManual
Asset derecognised · gain / loss is the balancing figureAsset class
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR11000Cash & BankSettlement amount · Proceeds received90,000
CR12100PPE — Machinery & Equipmentƒ nbv · Carrying amount removed70,000
CR42100Gain on Asset DisposalBalancing figure · Gain / (loss) on disposal20,000
Sample @ 90,000 — Dr 90,000 · Cr 90,000Balanced
Effective 2018-01-01  ·  Priority 63
Asset Impairment FA-IMP
Impairment  ·  On impairment review
ValidActiveManual
Carrying amount written down to recoverable amount (IAS 36)Asset class
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53800Impairment LossNet amount · Impairment loss35,000
CR12900Accumulated DepreciationBalancing figure · Accumulated impairment35,000
Sample @ 35,000 — Dr 35,000 · Cr 35,000Balanced
Effective 2018-01-01  ·  Priority 64
Tax — VAT & Corporate
3 rules
VAT Return Settlement TAX-VAT
VAT Return  ·  On return filing
ValidActiveManual
Net VAT payable to the FTA = output − input
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR21500VAT Payable (Output)Net amount · Clear output VAT90,000
CR14500VAT Receivable (Input)ƒ invat · Clear input VAT52,000
CR11000Cash & BankBalancing figure · Net VAT paid to FTA38,000
Sample @ 90,000 — Dr 90,000 · Cr 90,000Balanced
Effective 2018-01-01  ·  Priority 70
Corporate-Tax Provision (9%) TAX-CT
Provision  ·  On period-end accrual
ValidActiveAuto-post
UAE Corporate Tax at 9% on taxable income above AED 375k
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR55000Income Tax Expenseƒ net*0.09 · Income-tax expense180,000
CR23000Current Tax PayableBalancing figure · Current tax payable180,000
Sample @ 2,000,000 — Dr 180,000 · Cr 180,000Balanced
Effective 2023-06-01  ·  Priority 71
Deferred-Tax Movement TAX-DT
Provision  ·  On period-end accrual
ValidActiveAuto-post
Temporary differences × 9% (IAS 12)
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR55000Income Tax Expenseƒ net*0.09 · Deferred-tax charge27,000
CR25000Deferred Tax LiabilityBalancing figure · Deferred-tax liability27,000
Sample @ 300,000 — Dr 27,000 · Cr 27,000Balanced
Effective 2023-06-01  ·  Priority 72
Period-End & Adjustments
6 rules
Accrued Expense PE-ACC
Accrual  ·  On month-end
ValidActiveAuto-post
Expense incurred but not yet billedCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53000Administrative ExpensesNet amount · Expense accrued14,000
CR21900Accrued ExpensesBalancing figure · Accrued expenses14,000
Sample @ 14,000 — Dr 14,000 · Cr 14,000Balanced
Effective 2018-01-01  ·  Priority 80
Prepaid-Expense Amortisation PE-PRE
Amortisation  ·  On month-end run
ValidActiveAuto-post
Monthly release of a prepayment to P&LCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR53000Administrative ExpensesNet amount · Expense recognised5,000
CR14900Prepaid ExpensesBalancing figure · Prepaid expense released5,000
Sample @ 5,000 — Dr 5,000 · Cr 5,000Balanced
Effective 2018-01-01  ·  Priority 81
Provision / Accrual Reversal PE-REVS
Reversal  ·  On period open
ValidActiveAuto-post
Reverses PE-ACCAuto-reversal of a prior-period accrualCost centre
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR21900Accrued ExpensesNet amount · Accrual reversed14,000
CR53000Administrative ExpensesBalancing figure · Expense credited back14,000
Sample @ 14,000 — Dr 14,000 · Cr 14,000Balanced
Effective 2018-01-01  ·  Priority 82
FX Revaluation (Unrealised) PE-FX
FX Revaluation  ·  On period-end rates
ValidActiveManual
Out of scopeOpen FC balances restated at the closing rate (IAS 21)Currency
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR13000Trade ReceivablesNet amount · FC receivable restated8,500
CR42000Other IncomeBalancing figure · Unrealised FX gain8,500
Sample @ 8,500 — Dr 8,500 · Cr 8,500Balanced
Effective 2018-01-01  ·  Priority 83
Year-End P&L Close PE-CLOSE
Closing Entry  ·  On year-end lock
ValidActiveManual
Net profit transferred to retained earnings
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR39000Income Summary / P&L ClearingNet amount · Close income summary6,200,000
CR32000Retained Earnings (Opening)Balancing figure · Retained earnings6,200,000
Sample @ 6,200,000 — Dr 6,200,000 · Cr 6,200,000Balanced
Effective 2018-01-01  ·  Priority 84
Dividend Declared PE-DIV
Board Resolution  ·  On declaration
ValidActiveManual
Dividend declared out of retained earnings
Dr/CrAccountAccount NameAmount Basis / DriverSample (AED)
DR33000Dividends PaidNet amount · Dividends declared1,500,000
CR21200Dividends PayableBalancing figure · Dividends payable1,500,000
Sample @ 1,500,000 — Dr 1,500,000 · Cr 1,500,000Balanced
Effective 2018-01-01  ·  Priority 85