Offset Account - Financial Information, Liabilities

Hi, This may be a silly question but here goes. I can find details on how to add offset accounts in xTools modelling however, how do you record mortgage and offset accounts within financial info...

advice production

leah.saunders
3 months ago
Hey Shane

This response will depend on how your groups are set up on your site, but this is what is available. If yours does not look like this, step 1 is to reach out to your Site Administrator.

I would add the Asset (Cash), and give it a description of Offset Account, (this shows in Liabilities)

When you go to your liabilities section, you should see Assets, and you can link to the Offset Account.

Something to think about if you want the output is that the merge code looks a little different. I suggest that you look at this code here, as it talks about linked liabilities and assets

Also, because this was an interesting question, I tested it going to XTools+ modelling. If you input it as above, and then create your XTools+ scenario and import the data, it brings the Asset through as an Associate to the loan.

I hope this helps!

Kind regards,

Leah

shane.oconnor

Valued Supporter

3 months ago

Thanks Leah,

Appreciate the reply. Yes, I have found plenty of (good) information related to modelling offset accounts.

I don't seem to be able to find the same level of articles/details to see if there is a way to add offset accounts in the client focus, assets and liabilities section of Xplan. I want to have this in client focus, as this is the area the data is pulled for advice documents showing assets and liabilities, and we don't always have modelling included (or needed as part of the advice document being provided).

Just not sure if I am missing something, or it is unavailable. I am assuming (dangerous I know) that the only way is to add an asset called offset account? My preference would be the ability to have the offset added at time of adding the liability.

Appreciate the response, happy to be corrected if needed.

Thanks

Shane

leah.saunders

Iress Contributor

3 months ago

Hey Shane

This response will depend on how your groups are set up on your site, but this is what is available. If yours does not look like this, step 1 is to reach out to your Site Administrator.

I would add the Asset (Cash), and give it a description of Offset Account, (this shows in Liabilities)

When you go to your liabilities section, you should see Assets, and you can link to the Offset Account.

Something to think about if you want the output is that the merge code looks a little different. I suggest that you look at this code here, as it talks about linked liabilities and assets

Also, because this was an interesting question, I tested it going to XTools+ modelling. If you input it as above, and then create your XTools+ scenario and import the data, it brings the Asset through as an Associate to the loan.

I hope this helps!

Kind regards,

Leah

Welcome to the Advisely forums!

This is where financial advice professionals from all walks of life come together to share knowledge, swap ideas, solve problems, and talk all things growth and efficiency.

Here are some tips when posting in the forums:

Be respectful and courteous to fellow members
If a reply helped you, mark it as a solution so other users can find it easily
Take a moment to read through our Community Guidelines
For Xplan support issues, it's best to raise a ticket in Iress Connect first. You can also search the discussions for posts about the same issue first before starting a new thread.
Keep an eye out for our 'Ask me anything (AMA)' threads – these are live text-based Q&As with industry and Xplan experts during a set period of time. Find out when the next one is happening here.
Don’t be shy! You don’t need to be an expert to help someone out. Many users are looking for practical advice, shared experiences, or just a fresh perspective
Introduce yourself and meet other members here!