Summary

Learn how to export a general ledger file from Sage 200 (UK).

Extract data

Watch the following video on how to extract data or read the steps outlined below.

Open the video in YouTube for high resolution. 

1. Navigate to the Nominal submenu in the sidebar.
2. Click Nominal Enquiries.
3. Click Transaction Audit Trail List.
   
   
   
4. Right-click on the large table now displayed and select Columns from the menu. You will need to go through and select the relevant columns to ensure they are displayed. We recommend selecting the following columns:
   • Code
   • Entry Source Name
   • Narrative
   • NLAcc Name
   • Nominal Value
   • Posted Date
   • Reference
   • Second Reference
   • Transaction Date
   • Transaction Type
   • Unique Reference Number
   • User Name
   
   

   Note: Every client may use the software slightly differently so it is not possible to provide a definitive list of columns to select. It is recommended to look through the data carefully to ensure you are selecting the correct columns based on the entries your client has made and the fields they are using.

5. Click the Filter icon at the top of the screen.
6. Click New to create a new filter.
7. Give your filter a name (eg. Financial Year 2020).
8. Select column “Financial Year Start Date”.
9. Select condition “Is Equal To”.
10. Enter the value to show your required financial year starting date (eg. 01/01/2020).
11. Click Save.
    
    
    
12. Right click on the table again and select Export > All to Excel.
13. The file should automatically open in Excel. Save this file to your PC.
14. The exported file should look like this:

Next step: Sage 200 (UK): Transform the general ledger