Statement → Xero a Laravel demo

Chart of accounts and rules

The chart follows Xero's default Australian one. Your own rules are tried first, then the shared ones in priority order; the first whose text appears in the bank description wins. A shared income rule is skipped when the money went out (and the reverse).

Rules

WhosePriorityDescription containsAccountTax rate
Shared10SQUARE200 SalesGST on Income
Shared20STRIPE200 SalesGST on Income
Shared30UBER EATS200 SalesGST on Income
Shared40INTEREST270 Interest IncomeGST Free Income
Shared50ACCOUNT FEE404 Bank FeesGST Free Expenses
Shared60MERCHANT FEE404 Bank FeesGST Free Expenses
Shared70BIDFOOD310 Cost of Goods SoldGST Free Expenses
Shared80COFFEE SUPPLY310 Cost of Goods SoldGST Free Expenses
Shared90ORIGIN ENERGY445 Light, Power, HeatingGST on Expenses
Shared100TELSTRA489 Telephone & InternetGST on Expenses
Shared110XERO485 SubscriptionsGST on Expenses
Shared120PROPERTY RENT469 RentGST on Expenses
Shared130AMPOL449 Motor Vehicle ExpensesGST on Expenses
Shared140OFFICEWORKS453 Office ExpensesGST on Expenses
Shared150CLEANING408 CleaningGST on Expenses
Shared160PAYROLL477 Wages and SalariesBAS Excluded
Shared170SUPER478 SuperannuationBAS Excluded
Shared180ALLIANZ433 InsuranceGST on Expenses
Shared190FACEBK400 AdvertisingGST on Expenses
Shared200AUSPOST425 Freight & CourierGST on Expenses

Accounts

CodeNameTypeUsual tax rate
090Business Bank AccountBankBAS Excluded
200SalesRevenueGST on Income
260Other RevenueRevenueGST on Income
270Interest IncomeRevenueGST Free Income
300PurchasesDirect CostsGST on Expenses
310Cost of Goods SoldDirect CostsGST on Expenses
400AdvertisingExpenseGST on Expenses
404Bank FeesExpenseGST Free Expenses
408CleaningExpenseGST on Expenses
412Consulting & AccountingExpenseGST on Expenses
420EntertainmentExpenseGST on Expenses
425Freight & CourierExpenseGST on Expenses
429General ExpensesExpenseGST on Expenses
433InsuranceExpenseGST on Expenses
445Light, Power, HeatingExpenseGST on Expenses
449Motor Vehicle ExpensesExpenseGST on Expenses
453Office ExpensesExpenseGST on Expenses
469RentExpenseGST on Expenses
473Repairs and MaintenanceExpenseGST on Expenses
477Wages and SalariesExpenseBAS Excluded
478SuperannuationExpenseBAS Excluded
485SubscriptionsExpenseGST on Expenses
489Telephone & InternetExpenseGST on Expenses
493Travel - NationalExpenseGST on Expenses
710Office EquipmentFixed AssetGST on Expenses
720Computer EquipmentFixed AssetGST on Expenses
800Accounts PayableCurrent LiabilityBAS Excluded
820GSTCurrent LiabilityBAS Excluded
825PAYG Withholdings PayableCurrent LiabilityBAS Excluded
840Historical AdjustmentCurrent LiabilityBAS Excluded
877Tracking TransfersCurrent LiabilityBAS Excluded
880Owner A DrawingsEquityBAS Excluded
881Owner A Funds IntroducedEquityBAS Excluded
900LoanNon-current LiabilityBAS Excluded