Uploading Sales Invoice into Sage50

Hi there

Currently we are using excel to create invoices for our customers, about 100 per day.  We want to send this data to Sage 50 so that we can track the data in Sage50.  Currently don't see any option to have the ability to upload/import this data to the AR subledger/Revenue.  There must be a better way to streamline this bookeeping.  Help please!

Parents
  • Hello Bobpaz,

    Unfortunately, there is not going to be an easy way to import invoices created in excel into Sage 50. There is an import format, .imp, but the data needs to be formatted properly in order for it to import. You can see the format on our knowledgebase here. You may be able to get them to import using Auto-entry or a 3rd party software. Another alternative is entering the invoices in Sage 50 first rather than entering them in excel.

    Thanks,
    Chris Parrish

Reply
  • Hello Bobpaz,

    Unfortunately, there is not going to be an easy way to import invoices created in excel into Sage 50. There is an import format, .imp, but the data needs to be formatted properly in order for it to import. You can see the format on our knowledgebase here. You may be able to get them to import using Auto-entry or a 3rd party software. Another alternative is entering the invoices in Sage 50 first rather than entering them in excel.

    Thanks,
    Chris Parrish

Children
No Data