Knowledgebase Support HMRC Useful links
Knowledgebase home
Tax Return Production
Accounts Production
Practice Management
VAT Filer
CloudConnect
Anti-Money Laundering
Support home
Video Training Guides
NEW

Hot Topics
SimpleStep Guides
Release Notes
Technical
Known Issues

Service Status
Useful Links
MTD for Agents MTD for Businesses What is MTD
Preparation
Agent Services Account
MTD for VAT
MTD for Income Tax
MTD for VAT
Digital Record Keeping
Quarterly Updates
Step-by-step Guide
HMRC's MTD Timeline
TaxCalc's MTD Journey

How to create a mail merge for July payment on account

Article ID: 2906
Last updated: 07 Dec, 2021

As a TaxCalc user, reminding client's of their payment on account due by 31st July can now be complete using the Communication Centre option available.

If you have purchased the Communications Centre add-on module you can use a system template for July Payment on Account. Follow KB 3207 Can I create a Mailing List to show me all clients that have had a payment on account? to create your mailing list.

If not, you will have the ability to create mail merge letters with the required information. Firstly, you will need to create the mail merge template within Word to ensure if contains the information required for your letter. 

  1. Open TaxCalc
  2. Open Practice Manager from the home screen.
  3. Select Communications > Mail Merge Templates from the left-hand menu. 
  4. Create template
  5. You will need to ensure you select the Tax Year applicable in your scenario e.g. 2021 will hold the payment on account for July 2022 and then choose a mailing list
    1. If you don't have a mailing list, you will need to create one to include the applicable clients. You can choose to add All Clients, Specific clients or Advanced client selection (Data mine).
  6. You will receive a dialog window confirming word will now have opened in order to begin the construction of your letter template.
  7. Click OK and open the word document accordingly.
  8. You can now utilise the Insert Merge Field feature to begin inputting automated fields in the letter and complete the letter construction. If you would like further follow up to this, please review article KB 2180 How do I use Mail Merge? article which contains a video walkthrough too. 
  9. Once you are happy with the content, save the template to your machine
  10. Return to TaxCalc and click on Import
  11. Browse to the file saved in Step 8 and click on Open
  12. Give the template a Name and Description and ensure you assign the letter to a suitable Category
  13. Click on Save
  14. The file will then be available for use under the Category added within Mail Merge Templates

Once the template is available, you can begin the use of the template for your letters required for your clients.

  1. Open Practice Manager from the home screen.
  2. Select Communications > Mail Merge Templates from the left-hand menu. 
  3. Select the template required from the database (you may already have a template suitable, if not you will need to create one and Import) and then Run mail merge
  4. You will need to ensure you select the Tax Year applicable in your scenario e.g. 2021 will hold the payment on account for July 2022 and then choose a mailing list
  5. Once the Mailing List has been selected, preview the clients in the list and if happy, click on Choose 
  6. You will receive a pop up notification to advise the TaxCalc export has been successful (as shown below)
  7. Within Word, select Mailing (if not already applied) and Preview Results
  8. Word should now display the reminder letters for those clients selected who have a July payment on account due.
    1. Note: If no payment amount is showing, please check the year that has been selected in Step 5 above. 

For more information on Communications Centre, please see KB3199 Communications Centre: Collateral.

Article ID: 2906
Last updated: 07 Dec, 2021
Revision: 5
Views: 654
This article was:  


Also listed in
folder Communications Centre