TaxPrep

Owned by Jessica Legault
Last updated: Jan 07, 2021 by Marianne Desrosiers (Unlicensed)
4 min read

Procedure for exporting data to the Taxprep software

INTRODUCTION

This function allows the user to export in a text file (csv), the income of agents for a given period. You can import the generated file into the software TaxPrep Forms . This software can be used to produce T4A and Relevé 1.

If you are doing T4As for incorporated agents, the federal company number will appear if in the agent's profile, the "Company Name" field is completed. The broker’s social insurance number is present for the portion of his income before his company name is added.

If you have a small number of agents, it is possible to produce your T4A and Relevé 1 documents directly on the websites of the provincial and federal governments.

T4A: https://www.canada.ca/en/revenue-agency/services/forms-publications/forms/t4a.html

Relevé 1: https://www.revenuquebec.ca/en/businesses/source-deductions-and-employer-contributions/filing-rl-slips-and-the-rl-1-summary-general-rules/rl-1-slip-employment-and-other-income/how-to-complete-the-rl-1-slip-box-by-box-instructions/

BEFORE EXPORTING

We recommand you print the agents income reports and have them approve the amounts before doing the TaxPrep export. To print this list, go to: Reports> Non-agent brokers> Income


PROCEDURE

1. Go to Accounting> Export> Taxprep (T4A) and click on Create a Taxprep file

 

Make sure you have a social insurance number for each of your agents.

2. Select the parameters: Branches, Agents, dates and the indicator "Generate income from incorporated agents". This indicator must be at Yes if you want to have slips for your incorporated brokers.

3. Click on the Next button to view the details of the export.



4. Click on Process to save the results and create the file.

 

5. Back to the interactive report page, download the saved Taxprep.csv file using the green arrow and save it on your computer.

 

TAXPREP SOFTWARE

  1. Open TaxPrep

  2. Complete the information of your company (Client ID: other than individual)

  3. Select: File - Import Files

  4. Select :T4A / RL-1 / RL-2 Entry screen - Income from pension or other sources

  5. Click on "Browse" to retrieve your file exported from NexOne Office

  6. Enter the comma (',') as a separator

  7. Click on "Next". You can thus link each of the fields manually with the icon circled on the image ("Link" button) OR use the Taxprep template that we have prepared by clicking on the yellow form next to the "Link" button

Downlaod the TaxPrep template:

https://laukencorp.sharepoint.com/sites/NexoneExternal/Shared Documents/Forms/AllItems.aspx?id=%2Fsites%2FNexoneExternal%2FShared Documents%2FTaxprep&p=true&originalPath=aHR0cHM6Ly9sYXVrZW5jb3JwLnNoYXJlcG9pbnQuY29tLzpmOi9zL05leG9uZUV4dGVybmFsL0VpNUljLTl6WlNOR2lidE1iaHphYnlrQlgtajBFZGFCcFhmMjdnODBnRlNkaFE_cnRpbWU9Rm5VczAzeXkyRWc

The Fields in order are:

1.Identification of the recipient (individual or other than an individual);

2.Social Security number;

3.Last name;

4.First name;

5.Federal business number (for other than an individual);

6.Company name (for other than an individual);

7.Address-1st line;

8.City;

9.Province;

10.Country;

11.Postal code;

12.Check this box if you want to print the instructions for the T4A slip;

13.Amount for the commission of a self-employed person Box 020.