Spreadsheet: 680954d1591277052-summarise-data-using-formulas-example
Sheet: Data

GL | GL Description | Current year | Adjustable item? | Full/portion | Amount (full) | Amount (portion) | Total amount | Impact | DT grouping | Description
5406012100 | Provision for Obsolete Stocks | 79714745.83 | Yes | Full |  |  |  | Temporary difference | Provisions | Provision for obsolete stock
5910105000 | Depreciation - Buildings Res. | 102363094.78 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910106000 | Depreciation - Buildings Non-Res. | 299491378.32 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910107000 | Depreciation - Plant & Machinery | 491608801.66 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910108000 | Depreciation - Container Handling Equipment | 18802587.46 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910109000 | Depreciation - Furniture & Fixtures | 80777780.9 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910110000 | Depreciation - Computer & Other Hardware Equipment | 216023.11 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910111000 | Depreciation - Motor Vehicles | 8168629.11 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910112000 | Depreciation - Trucks | 2634209.08 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
5910118000 | RIGHT of USE ASSET ([NAME]) DEPRECIATION | 683495946.58 | Yes | Full |  |  |  | Non temporary difference |  | Depreciation on [NAME] asset
5995000000 | Depreciation - Berth Rehabilitation | 41667790.99 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
8801120000 | Penalties, Fines & Non-Recoverable Taxes | 47286718 | Yes | Full |  |  |  | Non temporary difference |  | Penalties, fines & non-recoverable taxes
8801190000 | Provisions - Bad & Doubtful balances | 205380617.9 | Yes | Full |  |  |  | Temporary difference | Provisions | Provision for bad & doubtful debt
8910102000 | Depreciation - Buildings Res. | 1361877.03 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
8910103000 | Depreciation - Furniture & Fixtures | 1599838.13 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
8910104000 | Depreciation - Computer & Other Hardware Equipment | 85239.92 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
8910105000 | Depreciation - Motor Vehicles | 5498006.44 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
8910112000 | Depreciation - Plant & Machinery | 4225.8 | Yes | Full |  |  |  | Temporary difference | PPE | Depreciation
9401070000 | Fixed Asset Sales | -13888238.92 | Yes | Full |  |  |  | Temporary difference | PPE | Profit on disposal of PPE
9402080000 | Restructuring Cost - Jnr | 21154365.6 | Yes | Portion |  | 2624324 |  | Temporary difference | Provisions | Provision for restructuring cost-Jnr
9402090000 | Restructuring Cost - Snr | 7629640.33 | Yes | Full |  |  |  | Temporary difference | Provisions | Provision for restructuring cost-Snr
9705008000 | Interest capitalised | 882009346.59 | Yes | Full |  |  |  | Non temporary difference |  | Lease interest expense
9707004000 | Exchange Rate Unrealised - Services | 928284228.63 | Yes | Full |  |  |  | Temporary difference | Exchange differences | Unrealised exchange loss