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
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.
For incorporated brokers, the federal business number in their profile must be completed.
This number must be entered in the format 999999999RP9999 otherwise you will have to complete it manually in the Taxprep software.
3. Click on the Next button to view the details of the export.
Verify the informations and amounts are correct
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
Open TaxPrep
Complete the information of your company (Client ID: other than individual)
Select: File - Import Files
Select :T4A / RL-1 / RL-2 Entry screen - Income from pension or other sources
Click on "Browse" to retrieve your file exported from NexOne Office
Enter the comma (',') as a separator
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
Note that the file is compressed with the .zip extension. You must extract the Taxprep BMDL.eim file that is included inside the .zip.
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.
The income for Relevé 1 (RL-1 O) is automatically added as well as the code in box O
If you have removed any incorporated realtors ("Company name" field from the realtor profile), you will have to manually manage the income amounts of these brokers.
Make sure there is no Pink box on the Slip Type (Rel.1) line because the RL-1 summary will not add up the slips.
We suggest you don’t give statements and T4A too early to your brokers to avoid it being misplaced or lost.
Completed!
Add Comment