Learn about the process of exporting a general ledger file from Sage 50 (UK).

Notes

• The sample company Stationery & Computer Mart UK is being used in this guide.
• We recommend exporting to CSV because Excel exports have row limitations.
  • CSV files can be imported into MindBridge; however, if you would like to view your CSV export in Excel, please see our article: Converting Text Files (delimited or fixed width) to Excel.
    
    

Extract data

Instructions

1. From the Home page, click Modules > Nominal Codes.
   
   
   
2. From the top bar, click Reports.
   
   
   
3. Select the Nominal Activity section and click the Export button.
   
   
   
4. Select ‘csv’ from the menu.
   
   
5. Enter your Transaction dates. Ensure that all codes and transactions are selected by leaving the first box blank and the second one as 99999999. Do not tick the Inc B/Fwd Tran box. Click OK.
   
   
   
6. The exported file should look like this:
   

Next step: Sage 50 (Canada): Transform the general ledger

Anything else on your mind? Chat with us or submit a request for further assistance.