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.
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.
How do I split the best answer between the two of you as both of you have come up with very good ideas
@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.
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…
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.