When you use the T2 AFR, in addition to the data that imports directly into TaxCycle, you can get a .COR file from CRA containing data for the prior year. Doe anyone have software that can read/translate that file? I’m hoping that TaxCycle might eventually be able to import it (at least some of it), so that I don’t have to type in all the prior year comparative info for a new client. But, I’ll settle for a free tool that can read the .COR file and put it into a simple format from which I can copy/paste.
@Nezzer Our original intention when we added T2AFR was to download .cor and also recreate that T2 return. It’s on our list of To Dos.
When I am not certain of a file, especially from the CRA, I try making a copy, then attempt to open the file in Word as a Text file (Rename the extension from .COR to .TXT)
A good part of the time, if the file was just an XML file renamed, I can read the file and figure what the data is.
I personally use Notepad++ to open it. Notepad++ neatly shows the schedule#, line # etc… For example…
In the below screenshot,
Row 14 = Schedule 1
Row 15 = Schedule 1 line number 101 Amount 5,316
Row 50 = Schedule 141
Row 51 = Schedule 141 line 095 No
Row 52 = Schedule 141 line 097 Yes
Awesome! That helps. So:
first 3 digits are the line number (or 4 digits on the S100 and S125?)
1 means No; 2 means Yes (or vice versa on some forms?)
What does GS mean? For instance, line 18 – is that line 295 of Schedule 1?
The files I download all start with “200GS1” – I am assuming that 200 means the T2 itself (main pages)?
Where did you get the field descriptions/details? CRA? I couldn’t find anything when I searched their website.
@anr Each schedule starts off with the schedule #+GS1. You can ignore GS1.
Then, everything underneath until the next schedule # is of line # and value.
1 = Yes 2 = No.
Row 18 is Schedule 1 line 295 with a value of $43.
You are correct, 200GS1 means Schedule 200 which is the T2 jacket.
Field descriptions can be found on the CRA forms themselves and there is no collective document that lists all line #s with descriptions in all CRA forms.
I meant, how did you find out that the first 3 digits are the line number, and that GS1 means the start of a new schedule, etc.?
And line 18 of your example shows 29543GS1 - if that is for line 295, why is there a GS1?
Here is a snip of one of my client files:
It seems the GS indicates something else for Schedule 8 - maybe page#?
The screenshot is a sample of a test case I submitted to the CRA for the last TaxCycle release certification. The # that appears after GS indicates a multi form copy # or a row # in an expandable table. For example, S47 copy 1 is 047GS1, copy 2 is 047GS2.
If there a single form with an expandable table, each row # is marked by the # that appears after GS. For example, if you have S8 CCA class numbers (line 200) of class 8 (row 1) and class 10 (row 2), you will see 2008GS1, 20010GS2 etc…
So, in your example:
008GS1 = S8
1012 = Question 101 = No
2008GS1 = column 200 class 8 row 1
20010GS2 = column 200 class 10 row 2
20045GS3 = column 200 class 45 row 3
Hope this answers your question.
Oh and I am in charge of TaxCycle T2 and that’s how I know these things.
Super! You might want to inform Marc Labrecque that importing the .COR file is on your ToDo list. When I submitted a Support Request about it, he replied to me saying:
“Hi Nelson. As far as I know there is no current plans to do anything with the .COR file that gets downloaded apart from accept it in the data packet CRA sends with a T2 AFR. I will let you know if I hear different but I would imagine reading the file to do anything useful with it would not be a trivial undertaking and there has been very little demand for that up until this point.”
Notepad++ is also great if you are doing any php editing on web pages. It doesn’t automatically include that problem causing BOM (Byte Order Mark) UTF-8 signature that Notepad and some other text editors automatically encode into their files, often causing weird display issues.
I’ve been using Notepad++ for a while now, and it works well for reading .COR files.
But I had some trouble associating file extensions. I’ve tried both the 64 bit and 32 bit versions, and both have the same issue - you have to “Run as Administrator”, go to Settings–Preferences, and type “.COR” under “File Associations”.
And then, I’m not sure if this is related - Windows built-in “Notepad.exe” will no longer accept new file associations. If I create a new text file, and change the extension to, say “.ABC”, then right-click, and “Open With…”, choose Notepad and check the box to “Always use this app…” the setting is never saved. Next time I try to open a .ABC file, Windows again prompts me to chose an app. Similarly, if I open the Properties dialog, the “Opens with:” says, “Pick an application”. I can click [Change], select Notepad, but it never saves my choice.
Do other people who use Notepad++ have the same issue?
I understand what you are saying, that you had to go into Notepad++ and set the file associations through the application before it will allow you to always open with that app as default. I’m not sure whether I had to do that or not. Sometimes it might depend on whether Notepad++ was actually installed on the computer (using the setup process) or whether the Notepad++.exe was just downloaded and running as a portable installation, which you can also do.
I also have an issue with Windows 10 not automatically or permanently associating unknown file types. For instance, I can associate .txt files with Notepad or Notapad++ and clicking the checkmark to “always open with” works. However, if I try that with an unknown extension, such as .abc then it seems Windows will offer to open the file with Notepad or Notepad++, but even if you put a checkmark in the “always open with” it does not remember the next time you try to open that file type. This is not contained to Notepad, it even happens if you try to open .abc files with any other app, for instance Firefox or Microsoft Edge. I don’t think this has anything to do with having Notepad++ on the computer.
I tried to force the file association using the Windows Command Prompt, and even though it appears to goes through the paces, it doesn’t work using the following command;
You guys and gals know that you can log onto CRA’s website, Select “View return status” under corporate tax click on “assessed” for the particular year you want and then you can see the return in detail.
if you click on" Expand all" you can then print the entire return. You can even determine schedule 8 details from this output for new clients.
That being said, being able to recreate the return in Taxcycle would be nice, even better, roll over from the cor.