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 EXPORTING

We recommand you primt 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 the Create a Taxprep file

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

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

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.