Excel to Sage - Import from Excel to sage - see description

Better version of the video here: • The Fastest Way to imp... Excel Sheet available here: sageaccounting.weeblysite.com/
How would you import Data from Excel to Sage. Save time on importing pre-typed data or converted figures or bank statement. The files you would need are here: sageaccounting.weeblysite.com/

[@alisagek3119]

Be sure to check out the new version kzbin.info/www/bejne/g3SkoXWBqJJmqrs

[@pwsunglass]

No need to be RUDE to people who are simply giving you feedback on your video. As you can see from other comments, some people liked your video, and some did not. Keep on posting videos, they help us all and read comments and use them as constructive criticism to make better videos.

[@sanjayvlogz444]

Thanks a lot for showing how to import from excel to sage. This video really help me. Please keep on update & share your knowledge of sage to us.

[@heywoodlass4033]

Hi Ali Karim, Thank you so much for this video. I have been asked to import files to SAGE at work, never done it before - and then I found your video. I tried it out on my own copy of SAGE, and first time of asking, it was happily applying everything. Then, today, they have been working out how to import bank statements to SAGE using Excel - I ran the last part of the video, tried it on my own copy. Needless to say, it was quite happy. I am going to go into work and give them this angle on it. And it is all thanks to you. Thank you for putting this video on and giving confidence.

[@romanmalashenko5379]

Virginia McAllister-Evans

[@alisagek3119]

Be sure to check out the new version kzbin.info/www/bejne/g3SkoXWBqJJmqrs

[@georgedrca9096]

Thanks ALIKARAM, not only did I learn to use SA and PA, but also a way of remembering which is the posting of original entry - e.g. putting a credit sale in the Customer's T-table, and only filling in the Sales T-table at the end of a period, so I can now fix in my mind which is the AccountRef and which the Nominal AccountRef (which you explained).

[@alisagek3119]

Be sure to check out the new version kzbin.info/www/bejne/g3SkoXWBqJJmqrs

[@davidkiguwa6959]

I only give credit when credit is due, this is impressive.

[@alisagek3119]

Be sure to check out the new version kzbin.info/www/bejne/g3SkoXWBqJJmqrs

[@meweda980]

That is very helpful. Thank you!

[@Idrive365ADI]

Am trying to import date from my Sage Line 50 2007 Is it possible to use the same Template???

[@agustintarquini5377]

Hi, do you know how to make a shipment from and excel file in ACCPAC Sage 300 2014?

[@euxhenamati6165]

I really thank you for these amazing videos. Could you please help me to import from Excel to Sage mas 100 or to copy/paste from Excel to Sage mas 100?

[@sharontarantino8272]

Can I import orders to ship say fed ex or ups?

[@mwansachibeti3706]

how do i download that sheet

[@SAMS-TV]

Really fantastic, like it. Kindly let me know is Sage line 50 2012, Number of customer are unlimited or there is limit. I thank you in advance

[@alisagek3119]

It was a while back so can't remember properly but I am certain there's no limit on the number of customers.

[@zainbgg6705]

whats the importance of this program , plz i need an answer

[@michaellatsky7977]

I need to import from nedbank to pastel???

[@JA50N555]

what if your invoice has move than one item with different tax rates. For example: an invoice for a shipping company, there would be customs fees, vat and shipment cost. How do I import this type of transaction to sage 50 from excel?

[@veasnatok8852]

Hello sir, Could you show me how to import report from excel into I/C sage 300? best regards, Thank

[@geaninakowal7913]

You can create your own template in excel in order to import it into Sage. If your Sage version has the import option then is enough to see the mandatory fields required and just have same headings in your excel template. You can see this under 'Field Mappings' in Data import. Follow same steps as per the video as to how to import into Sage and when it comes to choosing the file you want to import just choose any as it doesn't matter because you just want to go to next step to see the 'Field Mappings'. You'll then see 'Sage field' and these are the names you'll want to have as headings in your excel template. Names with asterisks (*) are mandatory and all the rest are optional. If in doubt what goes under each column then watch the video again. Hope it helps

[@sujitsahoo9072]

hello when i am importing purchase excel to sage , it showing error in line no 392 but my my sheet contains up to 391 could u explain why this error coming

[@alisagek3119]

Try this. Copy all data. Paste in a new sheet. Delete the older sheet. Save file import again

[@edd123ie]

Click cancel...The previous 391 lines were already imported. You can double check that they were actually imported

[@geaninakowal7913]

Just delete this row 392, sometimes Sage thinks that something was there in 392 hence the reason is not letting you import but is enough to just delete the entire even though you have no data shown there. If you have an error in one of your rows Sage will not import any rows so you need to go back and amend what Sage doesn't like and then do the import steps again. Hope this helps

[@catfish021954]

Might try being a little bit more prepared next time. Very confusing video, thanks for trying though.

[@toddpelletier3195]

catfish021954

[@idalirisespino2958]

será que alguien puede subir un video de Sage 300 construction & real Estate en español

[@SB-bo4gz]

Hi Please fix your sound quality thanks a lot. I want to import an inventory sheet to Peachtree kindly help.

[@alisagek3119]

kzbin.info/www/bejne/g3SkoXWBqJJmqrs this one has a better sound quality. Never used Peachtree :( But let me know if you'd like me to test it or help you out

[@mohamedmeddah7313]

jai besoin de traduction

[@aqeelahmad6194]

This is very excellent and helpful. But it does not tell about origin of country. It sounds like British. Thanks

[@ammaranwaar4585]

i like all your sage vidios can you send me some more thank you

[@alisagek3119]

It's a bit of hassle to make videos. But what sort of topics would be interesting? I now use a lot of Xero as well. Sage seems too ancient compared to Xero

[@ammaranwaar4585]

thank you

[@advent7324]

Decent attempt, but you were "all over the place" in your delivery. The purpose of your demo was to impot the transactions into SAGE !! You finished by saying that the transactions were now in EXCEL !! But the source was EXCEL ! So you just confused the viewer by this remark. You didn't even show the transactions in the SAGE audit file after the demo !! Poor show !! If you serious about helping people, then please do it right !!

[@alisagek3119]

Be sure to check out the new version kzbin.info/www/bejne/g3SkoXWBqJJmqrs

[@kwokbear4359]

Waste time to view this video

[@narenthakrar5132]

VERY POOR PRESENTATION !!!