Is it possible to display the amount due on Jan 31st in a tax letter?
Article ID
ias-11946
Article Name
Is it possible to display the amount due on Jan 31st in a tax letter?
Created Date
29th April 2015
Product
IRIS AutoMail
Problem
In an AutoMail letter, is it possible to add the current tax liability with next year's on account payment to produce the amount due on January 31st?
Resolution
To Produce an AutoMail Template with the current liability tag added to the next year on account you need to
- Check a Final Tax Computation has been run within IRIS Personal Tax
- Insert the amount due 31st Jan in your Automail Template
Check a final tax computation has been run for Personal Tax
For information to show in Automail a Final Tax Computation must be run from IRIS Personal Tax Module:
- Open IRIS Main Menu and Click on Personal Tax.
- Click on Magnifying glass which will display the Client Browser and select your client. e.g (A001)
- Go to Reports | Tax Computation and tick Final and make sure Payments on Accounts is ticked and the click OK
- You can then tick to screen or print the Personal Tax Form and then click on Ok
The Personal Tax figures have been calculated and now accessible in Automail.
Insert the amount due 31st January in your AutoMail template
You will need to insert the January 31st outstanding details in to your Automail Template. Below are instructions to insert these details in to a Word 20072010 document, a Word 2003 document and WordPad document.
For Microsoft Word Templates:
- Open IRIS Main Menu and Click on AutoMail. This will display the letter request browser screen.
- Click on templates and this will open the Letter Template Maintenance Screen
- Highlight your Word template and click on Properties. This will display the Edit Properties Screen.
- Go to context type and click on the drop down and choose Individual Personal Tax. (These will then display the relevant tags required) then click on OK
- Highlight your Word Template and click on edit and this will then open your Word Template
- To add the tags for CYBalLiab and NYOAC, minimize the document and this will display the Tag Selection Box
- Expand on the Particular Client Folder | Individual | Tax Information |Current year and tick CYBalLiab
- Now expand on the Next year folder and tick NYOAC and then Refresh
- Expand your document and place your cursor where you would like to insert the tag
For versions of MS Word 2007 and later :
To Insert and Add the Two Tags Together:
- Click on the Insert tab and then in the ‘text’ section click on Quick Parts | Field
- in the Formula heading, type e.g (=A+B)
- In the Number format heading you can choose the format you require e.g (#,##0.00), then click Ok
- This will be added to the document and will be displayed as e.g {=A+B /#”#,##0.00}
- Now we need to replace A and B and insert tags for LMCLCYBalLiab and LMCLNYOAC
- To do this place cursor in A and delete, now go to the Mailings tab and in the ‘text’ section and click on Insert Merge Field in your Toolbar and highlight LMCLCYBalLiab and click on insert
- Place cursor in B and delete, now go to the Mailings tab and in the ‘text’ section and click on Insert Merge Field in your Toolbar and highlight LMCLNYOAC and click on insert
- Your formula will now be displayed as {={MERGEFIELD “LMCLCYBalLiab” }+{MERGEFIELD LMCLNYOAC} /#”#,##0.00}
- Save the document and Generate your letter
Share This Page
We are sorry you did not find this KB article helpful. Please use the box below to let us know how we can improve it.
