Author Topic: income sheet - cash flow sheet discrepancy  (Read 31 times)

Stoich

  • Guest
income sheet - cash flow sheet discrepancy
« on: September 01, 2019, 03:14:49 am »
There seems to be a discrepancy between the income sheet and the cash flow sheet. The error seems to be on the income sheet as the balance gets updated by the exact amount stated on the cash flow sheet.



This is the income sheet for week 26261, the profit is 13 mil, pane depreciation is 70.8 mil and the balance at the top is a little over 8 mil.

https://prnt.sc/p0990i

This is the cash flow sheet for week 26261, the cash flow before loans is 74.5 mil.

As the plane depreciation is 70.8 mil, the profit for the week would be 3.7 mil, but it is shown as almost 13 on the income sheet. The difference of about 9.3 mil does not correspond to the loan principle, so it must be something else.

https://prnt.sc/p09996

This is the income sheet for week 26262, the profit is 19.2 mil before transactions, plane depreciation is 70.8 mil and the balance is 74.8 mil

https://prnt.sc/p099ic

This is the cash flow sheet for week 26262, the cash flow before loans and plane purchases is 81.4 mil, after loans it is 66.8 mil (the plane purchase was done the previous week before I took the screen shots, that is why the balance was 8 mil and hence I'm disregarding the plane cost in this week)

The difference between the balance in week 26261 and 26262 is exactly 66.8 mil, which corresponds to what the cash flow sheet shows. Once again there is a discrepancy with the income sheet:

81.4 cash flow - 70.8 mil plane depreciation = 10.6 mil profit, but profit shown on the income sheet is 19.2 mil a difference of 8.6 mil. The difference is less then the previous week and seems to fluctuate a bit, but stay pretty constant at 8-10 mil range. Not sure where it comes from but it is not from the loan principle/interest (though loan interest is shown/counted 2 times, once on income sheet and once on cash flow) and doesn't seem to match any other line of expense. One possibility is that it is lounge cost for passengers using your own flights that end up using the lounges of people not in your own alliance. The cost does not appear in the route expenses tab or the income expenses tab but the game is counting it anyway.

A smaller airline I have however has the opposite result though by very little, where the cash flow adjusted by the plane depreciation is actually higher then the profit. I can post screens of it too if you need.

Stoich

  • Guest
Re: income sheet - cash flow sheet discrepancy
« Reply #1 on: September 01, 2019, 03:18:59 am »
Seems first screensht did not apear, here is the list of all 4 again in order just in case:

26261 income sheet:

https://prnt.sc/p098vy

26261 cash flow sheet:

https://prnt.sc/p0990i

26262 income sheet:

https://prnt.sc/p09996

26262 cash flow sheet:

https://prnt.sc/p099ic

Stoich

  • Guest
Re: income sheet - cash flow sheet discrepancy
« Reply #2 on: September 01, 2019, 03:33:23 am »
Disregard, the bug was found, it was connected with lounges but not on the costs side :D

patson

  • Administrator
  • Hero Member
  • *****
  • Posts: 768
    • View Profile
Re: income sheet - cash flow sheet discrepancy
« Reply #3 on: September 01, 2019, 03:53:43 pm »
kekeke thanks for all the info :)

helped me found the problem :P