Budget vs Cash flow balance

tony.cooper655's Avatar

tony.cooper655

26 Nov, 2018 04:48 AM

I am trying to work out the correlation between your ending balance (fiscal year to date) and the cash flow ending balance, I will post a picture up here later tonight but I would have thought my ending balance on the budget fiscal year to date would equal my cash flow ending balance? its really doing my head in lol, in some categories I am over but others I am under in my spending however this is normal as certain bills come out early in the year compared to others and it will fix up over a period

  1. 1 Posted by tony.cooper655 on 26 Nov, 2018 04:49 AM

    tony.cooper655's Avatar

    Sorry forgot to add this is under the old style with a yearly budget set

  2. 2 Posted by mhoggie on 26 Nov, 2018 06:00 PM

    mhoggie's Avatar

    just a user,

    I'm betting it has something to do with the starting balance on the cash flow report.

  3. 3 Posted by tony.cooper655 on 27 Nov, 2018 11:26 PM

    tony.cooper655's Avatar

    I have deleted my files and will restore them later, but an experiment I have done, START BALL 0, SPENDING FOR FUEL $3650 PA, INCOME $36500 PA FISCAL YEAR 1/7/18 TO 31/06/19, TODAY IS DAY 151 OF THIS
    So the expectation is that at $10 a day fuel usage my budget today should show Budgeted fuel as $1510 and my spending at $1510
    My income should show budgeted income as $15,100 and my actual income as $15,100

    what is showing is in the screen shot
    Budgeted income $1505.56
    Budgeted spending $1500.56
    however cashflow is correct showing a ball of $13500 left to spend

    What am I missing? is this an error which will multiply through your budget?

    This shows my budget at -$5.56 for spending which is wrong

  4. 4 Posted by mhoggie on 28 Nov, 2018 02:08 AM

    mhoggie's Avatar

    just a user,

    Looks to me MD is miscalculating the budgeted cost per day based on your annual budgeted amount. Not sure how they are calculating the daily budgeted amount. You can run the report for different periods and get different values for the daily budgeted amounts. Even if the daily calculation was in error, you would think it would be uniform across different amounts of days. But it's not.
    If MD allowed you to specify the number of days for the annual budget, I'm confident it would be accurate

  5. 5 Posted by tony.cooper655 on 28 Nov, 2018 05:19 AM

    tony.cooper655's Avatar

    What is interesting is if I use a daily figure ie $10 a day for fuel, it calculates it out correctly, this is also working on my normal accounts now if I set them to daily, a budget is either 100% right or its wrong? Perhaps MD needs to provide feedback?

  6. 6 Posted by tony.cooper655 on 28 Nov, 2018 11:10 PM

    tony.cooper655's Avatar

    Interesting, Test 1 is $365 and set for a year with the start being 1/7 to 30/06 so 365 days, Test 2 is $1 and set for daily with the same dates, how can it get a simple equasion I can do with a calculator so wrong?

  7. System closed this discussion on 27 Feb, 2019 11:20 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac