Need more, need help now? we offer pay-as-you-go support, no contract, tenth of an hour billing, expert help, fast service, no call queue
We can offer lower cost Sage50cloud subscriptions for customer using pay-as-you-go support or who are self-supporting.
Need integration, your shipping system, your website, your invoicing system, your crm.
Need a bespoke solution, Mini Manufacturing, Spreadsheet order import, Back to back orders.
Want web hosting, email, your own domain name, a shop, we do it all!

Importing Data File

Bookkeeping and Management Accounting help does not have to be specific to the use of Sage 50
Post Reply
Posts: 32
Joined: 16 Jan 2020, 12:05
Sage Version: Other

Importing Data File

Post by Office1 » 21 Jan 2020, 19:19


My employers accountant is trying to send me a data file as an email attachment and its a zip file type ADS ? We tried to import it into sage and tried .xls extension choosing transactions but nothing works. Please help as there are 2 months transactions (sept, oct 2019)e.g. supplier invoices I dont want to have to enter in again.

If this file can only be restored, then I will have lost all my current data ?


User avatar
Site Admin
Site Admin
Posts: 4475
Joined: 28 Feb 2006, 09:56
Sage Version: v2017 23 UK/Europe/Africa

Re: Importing Data File

Post by brucedenney » 22 Jan 2020, 10:40

I think you will have to go back to your accountant.

There are 2 typse of import there is the accountants link import which is an .saa file
instructions for this are here ... leid=27180

The other is a "standard" import, this is either an excel worksheet or a csv file. These are imported using File>Import.
More details on this type of import are here
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests