Budgeting Question

This is for my personal finances.

I pay my water bill every three months. The amount is around £60, so effectively £20 a month.
I also have expenses such as Car Service once a year.

Is there any way to “spend” the money without actually spending it. So in my budget it shows £20 a month spent on Water even though I have not actually spent the money yet. Obviously I want my bank balance in Manager to match exactly what it is on my actual bank account.

Can this be done?

1 Like

Yes, you would need to set up a Balance Sheet account “Water Bill accruals” and then do a journal entry each month

Debit Water Bill Expense account £ 20
Credit Water Bill Accruals £ 20

This will give you an expense of £ 20 each month

When you actually pay the bill then record the spent amount against the accruals account.

You will have to adjust the debit/credit journal entry if the quarterly bill isn’t exactly £ 60

2 Likes

Using the above data, if you have accrued 20 per month and the actual quarter bill is 58, then for the Spend Money enter 60 to the accrual account and an adjustment of -2 to the water account. No need to go back and adjust previous Journals where there is only minor adjustments.

Also, if you are going to have a series of these accrual accounts, (water, vehicle, rates, insurance etc) then could create them as Special Accounts under a single Control Account so the Balance Sheet doesn’t get overly cluttered.

2 Likes

Now the challenging question.

How do I split the best answer between the two of you as both of you have come up with very good ideas :smiley:

@Brucanna I had not considered Special Accounts, but it sounds to me like a very good idea and very applicable to this user case. I will research that when I get back onto my computer later on today.

@Joe91 I had a hazy idea that I had to do something with accruals. I think that I can do a recurring journal entry, so I will do that.

Thank you.

1 Like

There is nothing to split, both suggestions are the same - use accruals with Recurring Journals.
When the actuals come in, leave the accrual Journals untouched at 20, don’t go back and adjust to 19.33 + 19.33 + 19.34 to get to the 58. Just put the adjustment as part of the Spend Money directly to the expense account…

1 Like

Sorry Brucanna, you misunderstood my post.

I was splitting the thanks to both of you!

You for your suggestion of using Special Accounts - This works brilliantly by the way!
And thanks to Joe91 for suggesting using Account Accruals.

I will be going with your suggestion of adjusting Spend Money for the water bill etc, but I will adjust the Recurring Journal Entry for anything where I have overbudgeted/underbudgeted.

Thanks

1 Like