SageForum for UK versions of Sage 50- Help and support.

I am a SAGE LINE 50 newbie.
Where can I find details of the file format for importing csv data files for BANK Payments and Receipts?

If you are still looking, then go to the Sage Help; contents and index; press the index tab and type in CSV file structure and choose the one saying Audit Trail. This will show you what information you need.

I import sales receipts and the information is created in Excel, following the string shown in the above structure, then saved in CSV format and imported into sage. One thing though, we need to put the transaction type in as SA rather than SR. I assume it's because Sales Receipts are created when you match a payment to an invoice and if you are importing then you can't do that. It all goes on as payment to account and means I have to manually match the payment to the invoice through the bank. Back-up before you try in case anything goes wrong and you can always restore! Good Luck

Note: some of the versions have different formats.

more stuff on importing to Sage 50 here http://import.makingithappen.co.uk/import_sage_csv.htm