Skip to main content
Level 1
December 18, 2020
Question

Can I import a MS Excel file in the FX Module to prepare multiple slips instead of manually preparing each slip?

  • December 18, 2020
  • 2 replies
  • 7 views
No text available
This topic has been closed for replies.

2 replies

Level 8
December 21, 2020

Hi, thank you for using Intuit ProFile Community

Unfortunately ProFile FX has no import functionality. You cannot import from Excel nor from other software.

Hope this helps

Level 2
December 25, 2020

Hello

 

I have been using the attached excel file for the last several years to import hundreds of T4 and T2202 slips into Profile FX

 

Is there a reason it will no longer work in Profile 2020?

 

All I had to do each year was change the Profile FX module from the previous year 2018 to 2019 as an example I did last year.

 

Now the macro gets stuck on the line 

 

Dim FXModule As profile.IProfileModule

 

Please view the Macro for T4andRL1

 

Thanks

Level 2
January 4, 2021

The  Excel worked for me.  I am not a programmer, but clumsily made the macro work to allow the input of the new boxes 57 to 60.  If you can improve this, great.  The macro creates the fx file and you can use it or copy and paste the created T4's from it  to the carried forward file.https://www.dropbox.com/s/o80yljgiiror60d/copy%20of%20wip%202020%20%20slips%20from%20excel%20to%20profile.xlsm?dl=0 

Level 8
January 4, 2021

Hi, thank you for using Intuit ProFile Canada

ProFile does not offer import into the FX module off the shelf. While there is an SDK available it requires programmers to implement and is not therefore useful for all users. If you have programmers available to code the process you need and to provide the required support, you can request the SDK here.  Note that the SDK has not been updated recently

Hope this helps