Spreadsheet: 874520d1721121889-dynamic-excel-formular-that-can-not-change-aliginment-when-accounts-change-charts-of-accounts
Sheet: Transactions

 | Date | Bank | Name | I.D Number | Account | Account Number | Group Code | Group | Debit | Credit
 | 2024-01-01 00:00:00 | Cash - US$ | [NAME] | CT 275 | Fees | 3500 | R1 | Income |  | 100
 | 2024-01-02 00:00:00 | US$ | [NAME] | CT 408 | Fees | 3500 | R1 | Income |  | 400
 | 2024-01-03 00:00:00 | US$ | [NAME] | CT 233 | Fees | 3500 | R1 | Income |  | 300
 | 2024-01-04 00:00:00 | US$ | Smith | CT 180 | Fees | 3500 | R1 | Income |  | 50
 | 2024-01-04 00:00:00 | US$ |  |  | Plant & Equipment | 4000 | R2 | Asset | 10000000
 | 2024-01-05 00:00:00 | US$ | [NAME] | CT 002 | Fees | 3500 | R1 | Income |  | 130
 | 2024-01-06 00:00:00 | US$ | [NAME] | CT 275 | Fees | 3500 | R1 | Income |  | 200
 | 2024-01-07 00:00:00 | US$ | [NAME] | CT 420 | Fees | 3500 | R1 | Income |  | 100
 | 2024-01-08 00:00:00 | US$ | [NAME] | CT 004 | Fees | 3500 | R1 | Income |  | 500
 | 2024-01-09 00:00:00 | US$ | Smith | CT 180 | Fees | 3500 | R1 | Income |  | 300
 | 2024-01-10 00:00:00 | US$ | [NAME] | CT 200 | Fees | 3500 | R1 | Income |  | 120
 | 2024-01-12 00:00:00 | Cash - US$ |  |  | Payroll Expenses | 2710 | R1 | Expenses | 2000
 | 2024-01-10 00:00:00 | Cash - US$ |  |  | Pension & Life Cover | 2710 | R1 | Expenses | 29.83552
 | 2024-01-12 00:00:00 | US$ |  |  | Printing & Stationery | 2500 | R1 | Expenses | 14.91776
 | 2024-01-12 00:00:00 | Cash - US$ |  |  | Property Maintenance | 2500 | R1 | Expenses | 49497.12768000001
 | 2024-01-12 00:00:00 | US$ |  |  | Salaries & Wages | 2710 | R1 | Expenses | 1924.39104
 | 2024-01-16 00:00:00 | Cash - US$ |  |  | Subscriptions | 2680 | R1 | Expenses | 3729.440000000001
 | 2024-01-16 00:00:00 | US$ |  |  | Sundry Expenses | 2710 | R1 | Expenses | 895.0656000000001
 | 2024-01-18 00:00:00 | Cash - US$ |  |  | Telephone & Internet | 2710 | R1 | Expenses | 1372.43392
 | 2024-01-18 00:00:00 | US$ |  |  | Trade union | 2810 | R1 | Expenses | 29.83552
 | 2024-01-18 00:00:00 | US$ |  |  | Bus Fares | 2810 | R1 | income |  | 208.84864
 | 2024-01-18 00:00:00 | US$ |  |  | Collegiate projects | 2700 | R1 | income |  | 753.34688
 | 2024-01-18 00:00:00 | US$ |  |  | Exam Fees | 2810 | R1 | income |  | 283.43744
 | 2024-01-18 00:00:00 | US$ | [NAME] | CT 408 | Fees | 2840 | R1 | income |  | 223.7664
 | 2024-01-18 00:00:00 | Cash - US$ |  |  | Sundry Income | 2840 | R1 | income |  | 246.14304
 | 2024-01-22 00:00:00 | Cash - US$ |  |  | Vehicle hire | 2680 |  | Expenses | 52.21216
 | 2024-01-22 00:00:00 | Cash - US$ |  |  | Vehicle insurance & License | 2710 |  | Expenses | 62.65459200000001
 | 2024-01-25 00:00:00 | US$ |  |  | Vehicle Maintenance | 2710 |  | Expenses | 29.83552
 | 2024-01-25 00:00:00 | Cash - US$ |  |  | Water | 2710 |  | Expenses | 1715.5424
 | 2024-01-25 00:00:00 | US$ | Net Salaries | ST 002 | Workshop & Conference | 2500 |  | Expenses | 14.91776
 | 2024-01-25 00:00:00 | US$ |  |  | ZIMSEC fees paid | 2700 |  | Expenses | 73992.0896
 | 2024-01-25 00:00:00 | US$ |  |  | Accounting fees | 2630 |  | Expenses | 11934.208
 | 2024-01-24 00:00:00 | Cash - US$ |  |  | Bank Charges | 2680 |  | Expenses | 2088.4864
 | 2024-01-24 00:00:00 | Cash - US$ |  |  | Cleaning | 2730 |  | Expenses | 223.7664
 | 2024-01-24 00:00:00 | US$ |  |  | Collegiate projects Expenses | 2810 |  | Expenses | 745.888
 | 2024-01-24 00:00:00 |  | Accounting Fees | ST 010 | Electricity | 2880 |  | Expenses | 134.25984
 | 2024-01-25 00:00:00 |  | Accounting Fees | ST 010 | Feeding Programme | 2880 |  | Expenses | 1000
 | 2024-01-01 00:00:00 | ZIG |  |  | Fuel & Oil | 3210 |  | Expenses | 2983.552
 | 2024-01-06 00:00:00 | ZIG |  |  | NEC | 3210 |  | Expenses | 100000
 | 2024-01-09 00:00:00 | ZIG |  |  | NSSA | 2730 |  | Expenses | 10000
 | 2024-01-09 00:00:00 | ZIG |  |  | PAYE | 3210 |  | Expenses | 644100
 | 2024-01-09 00:00:00 | ZIG | [NAME] | CT 002 | Fees | 3500 | R1 | Income |  | 12882
 | 2024-01-10 00:00:00 | ZIG | [NAME] | CT 275 | Fees | 3500 | R1 | Income |  | 6441
 | 2024-01-10 00:00:00 | ZIG | [NAME] | CT 420 | Fees | 3500 | R1 | Income |  | 450000
 | 2024-01-11 00:00:00 | ZIG | [NAME] | CT 004 | Fees | 3500 | R1 | Income |  | 489000
 | 2024-01-11 00:00:00 | ZIG | Smith | CT 180 | Fees | 3500 | R1 | Income |  | 12000
 | 2024-01-11 00:00:00 | ZIG | [NAME] | CT 200 | Fees | 3500 | R1 | Income |  | 662000
 | 2024-01-11 00:00:00 | ZIG |  |  | Motor Vehicle | 2500 |  | Asset | 12000000
 | AW