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. Then, just You can import the generated file into the software TaxPrep Forms . Thus, This software makes it possible can be used to produce T4A and Relevé 1.PLEASE NOTE: if
| 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. |
| Info |
|---|
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 STARTINGEXPORTING
We recommand you print the agents income reports and have them approve the amounts before doing the TaxPrep export. 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
...
Create a Taxprep file
...
| Note |
|---|
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.
...
| Note |
|---|
For incorporated brokers, the federal business number in their profile must be completed. |
...
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.
...
...
| Note |
|---|
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
...
Open the TaxPrep software
...
green arrow and save it on your computer.
...
TAXPREP SOFTWARE
Open TaxPrep
Complete the information of your company (Client Identification Section - Other than an ID: other than individual)
In the main menu, select File> Import slips
Select Select: File - Import FilesSelect :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 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 Downlaod the Taxprep NexOne templateTaxPrep template:
| Info |
|---|
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);
...
13.Amount for the commission of a self-employed person Box 020.
| Info |
|---|
The income for Relevé 1 (RL-1 O) is automatically added as well as the code in box O |
| Note |
|---|
If you have removed any incorporated realtors ("Company name" field from the realtor managementprofile), you will have to manually manage the income amounts of these brokers. |
| Infonote |
|---|
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. |
Do not We suggest you don’t give statements and T4A too early to your brokers to avoid it being misplaced or lost.
| Tip |
|---|
Completed! |