How to deal with regular transations?

[Johnfewings1]

Hi. After using MS Money for years (in a realy simple way just for our home accounts) I just discoverd the Arixcel programme and have only been using it since yesterday. Everything looks great and as I'm quite familiar with Excel its nice to use.

Ive read through the user guides and on-line info but there is just 1 question after setting up my accounts. Is there a way to generate future/recurring transactions for regular expenditure items, e.g monthly utility bills? So far Ive just created them as accruels but would need to create/or copy them in each month?

Well done for a great Add-in and thanks for your help.

cheers
John

[Support]

Hello John,

It is not possible to automatically add or delete transactions in the current version of Arixcel Accounts. It is designed to handle regular transactions in the following way, for example for a utility bill that is paid on the 14th of every month:

1) You decide to update your accounting spreadsheet on 1 January - you may want to add an accrual for the utility bill to see your "true" amount of available money.
2) Your next update session is on 15 January - you should delete the accrual left over from the previous session because you now have the actual transaction for the utility bill (e.g. loaded from an OFX bank statement).
3) Your next update session is on 1 February - you may want to add the accrual again, now for the February bill.

We will see if there is a good way of automating the above process. So thanks for raising the issue. And if you have any comments or suggestions, please do not hesitate to post them here.

All the best,
Arixcel Support

[Support]

Just one addition to the above post:

If you have many regular transactions and, for example, you are updating your spreadsheet on the 1st of January, you may not want to add all of them as accruals. It would probably be easier to use the Budgets table to figure out the "true" balance of money - by creating a budget for the current month and filling in the right categories with the expected amounts.