Columns for Income and Expense Statement

[songbird331]

I am trying to set up columns for the Income and Expense Statement. I need it to include: 1st column (how much was spent in current month), 2nd column (how much has been spent this year), 3rd column (the Budget for this year), and 4th column (what's left to spend). I need the 4th column to be a
POSITIVE number. Can you help me figure this out, please?

[JohnDMeyers]

If you have $1,000 in budget and you spend $800, the Budget Difference column will show a positive $200.

The only negative numbers will be if you overspent that particular budget line item.

Am I understanding the question correctly?

[songbird331]

I need to know what needs to be put in each column to make the last column a POSITIVE number. It looks just the opposite--a negative number, so if we overspend then the number starts looking positive. And I want it to just the opposite, showing a positive number then if we overspend it goes to a negative number.

[JohnDMeyers]

Did you enter your budget numbers as positive numbers?

What is the selection in the Column drop-down box? Is it " ... Budget Difference" (Current Bugdget Difference or Year to Date Budget Difference, either of those).

[songbird331]

Year to Date Budget difference

[JohnDMeyers]

Oh, yeah. My mistake. You do get a negative balance when you money left to spend.

I am so used to seeing that, that I don't even notice.

What you may have to do is use the Budget Report. Select "Period Only" and use the months to determine how much of the year you want to appear.

For example, right now, I would set the month range from Jan 2012 to Feb 2012, Period Only.

The budget difference is positive on this report.

[songbird331]

OK. Thank you so much. I will try it out.