TaxPrep

Procedure for exporting data to the Taxprep software

INTRODUCTION

This function allows to export in a text file, the income of agents for a given period. Then, just import the generated file into the software TaxPrep Forms . Thus, This software makes it possible to produce T4A and Relevé 1.

PLEASE NOTE: 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 few brokers, 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 STARTING

To print this list, simply go to the menu Reports> Non-agent brokers> Income

PROCEDURE

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

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

3. Complete the selection of parameters: Branches, Agents, the period and the indicator "Generate income from incorporated agents". This indicator must be checked if you want to have slips for your incorporated brokers.
   For incorporated brokers, the federal business number in their profile must be completed.
   This number must absolutely be entered in the form 999999999RP9999 otherwise you will have to complete it manually in the Taxprep software.

4. Click on the Next button to view the details of the export.
   Make sure there is no missing information such as the Social Insurance Number, the agent's address, their Postal Code and make sure the amounts are correct.

5. Click on the Process button to save the results.
   Back to the interactive report, simply download the saved Taxprep.csv file using the icon (Green arrow).

6. Open the TaxPrep software

7. complete the information relating to your company (Client Identification Section - Other than an individual)

8. In the main menu, select File> Import slips
   
   Select

9. T4A / RL-1 / RL-2 Entry screen - Income from pension or other sources

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

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

12. Click on the "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

Download the Taxprep NexOne template

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.