Bookkeeping rconciliation

[Norm35]

Reported daily is Total Income, Total Upkeep, Income From Gambling, Losses From Gambling, and Income From Travelers.

There is of course for each building the cost, weekly income, daily maintenance, salvage value, and number of workers.

These can be compared with the day to day changes in the treasury balance.

I have created a spreadsheet and tried to incorporate all this. I thought I was doing pretty well until I started encouraging tourists to come to the city. Now, I can't get the spreadsheet, the various totals (above) and the treasury balance to reconcile. I have the feeling that some of the numbers overlap each other.

The object of all this is to see how you are doing.

Sims attitude affects their work efficiency and as a result treasury income a lot more than one would realize. However, before you can determine this effect, you must be able to add the numbers up correctly.

Can anyone explain how to incorporate the tourist income, gambling income, and gambling losses so they reconcile with the daily treasury balance?

[MidrealmDM70]

Can anyone explain how to incorporate the tourist income, gambling income, and gambling losses so they reconcile with the daily treasury balance?

Add tourist income
Add gambling income
Subtract gambling losses

[Norm35]

"Add tourist income, Add gambling income, Subtract gambling losses " to what!

The bottom line is the difference between yesterday's Treasury Total and Today's.

The closest I can come is the sum of the non-traveler's income (which is not specifically stated anywhere) and the traveler's income. This sum might match the income reported in the daily city report. The problem is where is the non-travelers income stated?

On top of that, I think the traveler's income might already include gambling income and loss, so adding them in again will be double counting.

[MidrealmDM70]

"Add tourist income, Add gambling income, Subtract gambling losses " to what!

I could be wrong but I think you will find your total does not match any other number reported,

The closest I can come is the sum of the non-traveler's income (which is not specifically stated anywhere) and the traveler's income, which I think might already include gambling income and loss.

I can only guess at this point; that's what I am complaining about!

Apparently I misunderstood your question:
=-=-=-=-=-=-=-=-=-=
Income from Workplaces (variable based on employee hapiness and building down-time)
Plus Income from Tourists
Plus Income from Gambling
Plus income from other sources (such as taxes on luxury homes, synergy bonus income, and other daily or bonuses)
Do retail venues give income to the the city for each item sold?
Plus income from demolishing buildings

Minus Gambling Losses
Minus Upkeep Costs (Strategic Mode only)
Minus Costs to activate building abilities
Minus construction costs
=-=-=-=-

The problem is many of these are variable and not trackable.
You can eliminate some - (don't use activated abilities, don't use buildings that generate additional income, don't play in strategic mode)

If you were doing this in free play mode I would suggest using the Behavior Modification buildings to add conditioning on all homes and workplaces so that all sims are always content, this would help eliminate additional variables in workplace income, and help prevent sims from going rogue and shutting down workplaces for certain times.

But, does money even track if you are in free-play mode? I've never checked.