Hi Sunglo,

Which Sage product are you using?

Thanks,

Derek

Thank you Derek

Sage 50

Ok, since your question relates specifically to Sage 50 CA, I will move your post to that Support Group so that other users of this product will see it and be able to offer their thoughts and insight.

Thanks,

Derek

Hi Sunglo,

If you would like to import an excel file to Sage 50, you will need to follow certain format in order for Sage 50 to accept it.

Please follow the Knowledge Base link below for further instruction.

How to import data into Sage 50—Canadian Edition - KB10187

Hope this helps.

I have a question on this.  It appears to me that the import is only for "records" such as customer, inventory, employees.  What if I wanted to import "transactions" into sage that are in an excel file.  For instance, I have a client who has downloaded mastercard transactions for the month.  Is there some way to import these "transactions" into SAGE?

Many thanks!

Susan

Hi Susan Q,

You will need to create a .imp file and follow the format provided from the dev-import.pdf document after you download and install the SDK

You can download the SDK from the link below:

https://sagena.thruinc.net/ExDn.aspx?id=045BRXUVI6D

After installation, please go to C:\Program Files (x86)\Sage 50 Accounting SDK\Manuals and you will see the dev-import.pdf for the .imp file format.

For more information of how to import the .imp file after you create it, please follow the KB link written below:

How to import purchase invoices, purchase quotes, sales invoices and sales orders? - KB10376

Hope this helps

Bank transactions that have been downloaded in Sage 50 format are designed to import into the bank reconciliation module.

(rather than as new transactions as in a personal finance product such as Quicken).

Hi Susan,

For transactions import we do provide service. Or get their SDK and develop your own.

To know more about our product/service, you may visit our website(s).

Thanks,

www.businnovatech.com  

www.swagsys.com  

www.bithelp.ca  

(905) 944-8900  

LinkedIn   ca.linkedin.com/.../businnovatech  

YouTube  www.youtube.com/.../BITTube3000  

               www.youtube.com/.../swagmansoftware

Have Sage 50 - .imp file needed.  What is this SDK download? do I need that?  And the link below does not work if I do.  As well can I convert an excel to .imp format?  If so how.

The SDK is available for most recent Sage 50 Canadian products.  You have to sign up, then a link will be displayed to download it.

The transaction import file format is a comma delimited file.  The purchase invoice format is the same as the one used when you set up a customer to 'use Sage 50' and 'can import' and 'uses the same item codes', then email an invoice to that customer.

The import guide may turn up in a google search.  It's a PDF file.