Questions? We have answers.

Sage 200 (UK): Export the general ledger

Article author
Jonathon Plowman-Samson
  • Updated

Summary

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


Extract data

  1. Navigate to the Nominal submenu in the sidebar.
  2. Click Nominal Enquiries.
  3. Click Transaction Audit Trail List.
    Sage-200-01.png

  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
    Sage-200-02.png

    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.
    Sage-200-03.png

  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: Sage-200-04.PNG

 



Anything else on your mind?

Head over to the community with your thoughts and inquiries! You can also chat with us, or, submit a request for further assistance.

Share this article on

Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.