Spreadsheet: 874682d1721225660-auto-produce-trial-balance-sunboy-tb-aligw
Sheet: Sheet1

 | I'm requesting for  a formula to auto produce a trial balance as shown on the desired solution
 | Please kindly note that P_L table can expand if more income and expenses accounts are added.
 |  |  |  |  |  |  | Desired Solution
 | Details | Amount | Trial Balance |  |  |  | Details | Debit | Credit |  |  |  | Debit | Credit
 | Income |  |  |  |  |  | Profit/(Loss) | 822330.6350326786 |  |  |  | Profit/(Loss) | 822330.6350326786
 | Bus Fares | 8312.298610000002 | Credit |  |  |  | Bus Fares |  | 8312.298610000002 |  |  | Bus Fares |  | 8312.298610000002
 | Collegiate projects | 1975.18244 | Credit |  |  |  | Collegiate projects |  | 1975.18244 |  |  | Collegiate projects |  | 1975.18244
 | Exam Fees | 37906.02816 | Credit |  |  |  | Exam Fees |  | 37906.02816 |  |  | Exam Fees |  | 37906.02816
 | School Fees | 1619149.312 | Credit |  |  |  | School Fees |  | 1619149.312 |  |  | School Fees |  | 1619149.312
 | Sundry Income | 79004.33167000001 | Credit |  |  |  | Sundry Income |  | 79004.33167000001 |  |  | Sundry Income |  | 79004.33167000001
 | Total Income | 1746347.15288 |  |  |  |  | Accounting fees | 8876.428 |  |  |  | Accounting fees | 8876.428
 | Expenses |  |  |  |  |  | Bank Charges | 2000 |  |  |  | Bank Charges | 2000
 | Accounting fees | 8876.428 | Debit |  |  |  | Cleaning | 2210.279642500001 |  |  |  | Cleaning | 2210.279642500001
 | Bank Charges | 2000 | Debit |  |  |  | Collegiate projects Expenses | 89.50656000000001 |  |  |  | Collegiate projects Expenses | 89.50656000000001
 | Cleaning | 2210.279642500001 | Debit |  |  |  | Electricity | 11119.85887877052 |  |  |  | Electricity | 11119.85887877052
 | Collegiate projects Expenses | 89.50656000000001 | Debit |  |  |  | Feeding Programme | 10508.88986500001 |  |  |  | Feeding Programme | 10508.88986500001
 | Electricity | 11119.85887877052 | Debit |  |  |  | Fuel & Oil | 98319.48319676745 |  |  |  | Fuel & Oil | 98319.48319676745
 | Feeding Programme | 10508.88986500001 | Debit |  |  |  | NEC | 1490 |  |  |  | NEC | 1490
 | Fuel & Oil | 98319.48319676745 | Debit |  |  |  | NSSA | 9486.62246441442 |  |  |  | NSSA | 9486.62246441442
 | NEC | 1490 | Debit |  |  |  | PAYE | 6700 |  |  |  | PAYE | 6700
 | NSSA | 9486.62246441442 | Debit |  |  |  | Payroll Expenses | 7416.138400000001 |  |  |  | Payroll Expenses | 7416.138400000001
 | PAYE | 6700 | Debit |  |  |  | Pension & Life Cover | 3000 |  |  |  | Pension & Life Cover | 3000
 | Payroll Expenses | 7416.138400000001 | Debit |  |  |  | Printing & Stationery | 6157.92653124785 |  |  |  | Printing & Stationery | 6157.92653124785
 | Pension & Life Cover | 3000 | Debit |  |  |  | Property Maintenance | 26541.82456055448 |  |  |  | Property Maintenance | 26541.82456055448
 | Printing & Stationery | 6157.92653124785 | Debit |  |  |  | Salaries & Wages | 18600 |  |  |  | Salaries & Wages | 18600
 | Property Maintenance | 26541.82456055448 | Debit |  |  |  | Subscriptions | 14980.45758 |  |  |  | Subscriptions | 14980.45758
 | Salaries & Wages | 18600 | Debit |  |  |  | Sundry Expenses | 31110.82285949977 |  |  |  | Sundry Expenses | 31110.82285949977
 | Subscriptions | 14980.45758 | Debit |  |  |  | Telephone & Internet | 400 |  |  |  | Telephone & Internet | 400
 | Sundry Expenses | 31110.82285949977 | Debit |  |  |  | Trade union | 567900 |  |  |  | Trade union | 567900
 | Telephone & Internet | 400 | Debit |  |  |  | Vehicle hire | 2396.67219 |  |  |  | Vehicle hire | 2396.67219
 | Trade union | 567900 | Debit |  |  |  | Vehicle insurance & License | 12522.94786931605 |  |  |  | Vehicle insurance & License | 12522.94786931605
 | Vehicle hire | 2396.67219 | Debit |  |  |  | Vehicle Maintenance | 24223.58117925089 |  |  |  | Vehicle Maintenance | 24223.58117925089
 | Vehicle insurance & License | 12522.94786931605 | Debit |  |  |  | Water | 2000 |  |  |  | Water | 2000
 | Vehicle Maintenance | 24223.58117925089 | Debit |  |  |  | Workshop & Conference | 22027.17407 |  |  |  | Workshop & Conference | 22027.17407
 | Water | 2000 | Debit |  |  |  | ZIMSEC fees paid | 33937.904 |  |  |  | ZIMSEC fees paid | 33937.904
 | Workshop & Conference | 22027.17407 | Debit |  |  |  | Check |  |  |  |  | Check | 1746347.15288 | 1746347.15288
 | ZIMSEC fees paid | 33937.904 | Debit
 | Total Expenses
 | Profit/(Loss) |  | Debit