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/

Пікірлер: 41

  • @alisagek3119
    @alisagek31194 жыл бұрын

    Be sure to check out the new version kzread.info/dash/bejne/f3d10qSEo5CZpLw.html

  • @pwsunglass
    @pwsunglass8 жыл бұрын

    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
    @sanjayvlogz4449 жыл бұрын

    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
    @heywoodlass40336 жыл бұрын

    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

    @romanmalashenko5379

    6 жыл бұрын

    Virginia McAllister-Evans

  • @alisagek3119

    @alisagek3119

    4 жыл бұрын

    Be sure to check out the new version kzread.info/dash/bejne/f3d10qSEo5CZpLw.html

  • @meweda980
    @meweda9808 жыл бұрын

    That is very helpful. Thank you!

  • @georgedrca9096
    @georgedrca90969 жыл бұрын

    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

    @alisagek3119

    4 жыл бұрын

    Be sure to check out the new version kzread.info/dash/bejne/f3d10qSEo5CZpLw.html

  • @davidkiguwa6959
    @davidkiguwa69594 жыл бұрын

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

  • @alisagek3119

    @alisagek3119

    4 жыл бұрын

    Be sure to check out the new version kzread.info/dash/bejne/f3d10qSEo5CZpLw.html

  • @agustintarquini5377
    @agustintarquini53777 жыл бұрын

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

  • @Idrive365ADI
    @Idrive365ADI10 жыл бұрын

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

  • @sharontarantino8272
    @sharontarantino82725 жыл бұрын

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

  • @euxhenamati6165
    @euxhenamati61653 жыл бұрын

    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?

  • @michaellatsky7977
    @michaellatsky79774 жыл бұрын

    I need to import from nedbank to pastel???

  • @mwansachibeti3706
    @mwansachibeti37066 жыл бұрын

    how do i download that sheet

  • @zainbgg6705
    @zainbgg67055 жыл бұрын

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

  • @JA50N555
    @JA50N5554 жыл бұрын

    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?

  • @idalirisespino2958
    @idalirisespino29587 жыл бұрын

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

  • @veasnatok8852
    @veasnatok88526 жыл бұрын

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

  • @geaninakowal7913

    @geaninakowal7913

    6 жыл бұрын

    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

  • @mohamedmeddah7313
    @mohamedmeddah73138 жыл бұрын

    jai besoin de traduction

  • @SAMS-TV
    @SAMS-TV4 жыл бұрын

    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

    @alisagek3119

    4 жыл бұрын

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

  • @sujitsahoo9072
    @sujitsahoo90728 жыл бұрын

    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

    @alisagek3119

    8 жыл бұрын

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

  • @edd123ie

    @edd123ie

    7 жыл бұрын

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

  • @geaninakowal7913

    @geaninakowal7913

    6 жыл бұрын

    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

  • @SB-bo4gz
    @SB-bo4gz4 жыл бұрын

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

  • @alisagek3119

    @alisagek3119

    4 жыл бұрын

    kzread.info/dash/bejne/f3d10qSEo5CZpLw.html 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

  • @catfish021954
    @catfish0219548 жыл бұрын

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

  • @toddpelletier3195

    @toddpelletier3195

    7 жыл бұрын

    catfish021954

  • @ammaranwaar4585
    @ammaranwaar45858 жыл бұрын

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

  • @alisagek3119

    @alisagek3119

    8 жыл бұрын

    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

    @ammaranwaar4585

    7 жыл бұрын

    thank you

  • @aqeelahmad6194
    @aqeelahmad619410 жыл бұрын

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

  • @advent7324
    @advent73248 жыл бұрын

    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

    @alisagek3119

    4 жыл бұрын

    Be sure to check out the new version kzread.info/dash/bejne/f3d10qSEo5CZpLw.html

  • @kwokbear4359
    @kwokbear43593 жыл бұрын

    Waste time to view this video

  • @narenthakrar5132
    @narenthakrar51328 жыл бұрын

    VERY POOR PRESENTATION !!!