---
title: "Sage 100 ERP (MAS 90 & 200) Tips & Tricks #25: General Ledger History to Excel | BCS ProSoft"
description: Sage MAS 90 and Sage MAS 200 allows you to export the data from the History tab in Account Maintenance. Select General Ledger | Main | Account Maintenance. Select the General Ledger Account for which […]
---

Questions? Give us a a call at [**(855) 982-9336**](https://www.bcsprosoft.com/contact/)

- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)

[![BCS-logo-white-red-2](https://blog.bcsprosoft.com/hs-fs/hubfs/BCS-logo-white-red-2.png?width=700&name=BCS-logo-white-red-2.png)](https://www.bcsprosoft.com/)

- Products 
    - Deltek 
          - [Deltek](https://www.bcsprosoft.com/deltek/)
          - [Deltek Vantagepoint](https://www.bcsprosoft.com/deltek/vantagepoint/)
          - [Deltek Cloud](https://www.bcsprosoft.com/deltek/cloud/)
          - [Deltek PIM](https://www.bcsprosoft.com/deltek/pim/)
          - [Deltek CRM](https://www.bcsprosoft.com/deltek/crm/)
    - Sage 
          - [Sage Intacct](https://bcsprosoft.com/sage-intacct/)
          - [Sage 100cloud](https://www.bcsprosoft.com/sage-100/cloud/)
          - [Sage CRM](https://www.bcsprosoft.com/sage-crm/)
          - [Sage HRMS](https://www.bcsprosoft.com/sage-hrms/)
    - [NetSuite](https://www.bcsprosoft.com/netsuite/)
    - [Automated Rental (ARM)](https://www.armsoftware.com/?utm_source=bcsprosoft.com&utm_medium=referral)
- [Services](https://www.bcsprosoft.com/services/)
- Resources 
    - Blog 
          - [Deltek Blog](https://blog.bcsprosoft.com/tag/deltek/)
          - [Sage Blog](https://blog.bcsprosoft.com/tag/sage)
          - [NetSuite Blog](https://blog.bcsprosoft.com/tag/netsuite)
    - Whitepapers 
          - [Deltek Whitepapers](https://www.bcsprosoft.com/resources/deltek-whitepapers/)
          - [Sage Whitepapers](https://www.bcsprosoft.com/resources/sage-whitepapers/)
          - [NetSuite Whitepapers](https://www.bcsprosoft.com/resources/netsuite-whitepapers/)
    - Product Guides 
          - [Deltek Product Guides](https://www.bcsprosoft.com/resources/deltek-product-guides/)
          - [Sage Product Guides](https://www.bcsprosoft.com/resources/sage-product-guides/)
          - [NetSuite Product Guides](https://www.bcsprosoft.com/resources/netsuite-product-guides/)
    - Webinars 
          - [Deltek Webinars](https://www.bcsprosoft.com/resources/deltek-webinars/)
          - [Sage Webinars](https://www.bcsprosoft.com/resources/sage-webinars/)
          - [NetSuite Webinars](https://www.bcsprosoft.com/resources/netsuite-webinars/)
- Company 
    - [About Us](https://www.bcsprosoft.com/about/)
    - [Industries](https://www.bcsprosoft.com/industries/)
    - [Events](https://www.bcsprosoft.com/events/)
    - [Careers](https://www.bcsprosoft.com/careers/)
    - [Support](https://www.bcsprosoft.com/support/)
    - [Referral Program](https://www.bcsprosoft.com/bcs-referral/)
- [Contact Us](https://www.bcsprosoft.com/contact/)

![GLHistorytoExcel](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/GLHistorytoExcel.png "GLHistorytoExcel")

# Sage 100 ERP (MAS 90 & 200) Tips & Tricks #25: General Ledger History to Excel

By [hchavez](https://blog.bcsprosoft.com/author/hchavez) |  Aug 2nd, 10 | Categories: [MAS 90](https://blog.bcsprosoft.com/tag/mas-90), [Tips & Tricks](https://blog.bcsprosoft.com/tag/tips-tricks), [Export to Excel](https://blog.bcsprosoft.com/tag/export-to-excel), [MAS 200](https://blog.bcsprosoft.com/tag/mas-200), [BCS ProSoft](https://blog.bcsprosoft.com/tag/bcs-prosoft), [Hugo Chavez](https://blog.bcsprosoft.com/tag/hugo-chavez), [General Ledger History](https://blog.bcsprosoft.com/tag/general-ledger-history), [Pending Update](https://blog.bcsprosoft.com/tag/pending-update)

Sage MAS 90 and Sage MAS 200 allows you to export the data from the History tab in Account Maintenance.

- Select General Ledger | Main | Account Maintenance.
- Select the General Ledger Account for which you want to export information
- Select the History Tab.

![](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/GLHistorytoExcel.png?width=406&height=296&name=GLHistorytoExcel.png "GLHistorytoExcel")

- Right Click anywhere in the data window and a menu will pop up.
- Select the “Export to Excel” option and Excel will start and the data will be exported.

**Want to see more Tips? Visit our Tips & Tricks** [**Blog**](http://www.bcsprosoft.com/blog/sage-100/)**.**

## About the Tips & Tricks Series

BCS ProSoft is proud to offer you these Tips & Tricks for MAS 90 and MAS 200. These tips were drawn from our extensive technical support knowledge base as well as from the comprehensive experience or our team. Each tip is outlined in detail, including pictures and or drawings where appropriate. There are a couple of things to note in order to use these tips effectively. All tips are written for Sage MAS 90 and Sage MAS 200 versions 4.1 and higher. Some tips should be used with great care and caution. If you are ever in any doubt as to how to use the information provided, please contact our Award Winning Support Center.  [Click here](http://www.bcsprosoft.com/support/) for options on contacting our Support Center.

| [![wordpress](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/wordpress-May-18-2021-05-52-14-44-PM.png?width=30&height=30&name=wordpress-May-18-2021-05-52-14-44-PM.png "wordpress")](https://www.bcsprosoft.com/category/rental/) | [View Other Tips & Tricks](http://www.bcsprosoft.com/blog/sage-100/) | ![twitter](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/twitter-May-18-2021-05-52-14-67-PM.png?width=30&height=30&name=twitter-May-18-2021-05-52-14-67-PM.png "twitter") | Follow Us on Twitter<https://www.bcsprosoft.com/category/rental/> |
| --- | --- | --- | --- |
| [![linkedin](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/linkedin1-May-18-2021-05-52-11-08-PM.png?width=30&height=30&name=linkedin1-May-18-2021-05-52-11-08-PM.png "linkedin")](http://www.linkedin.com/ppl/webprofile?vmi=&id=48273840&pvs=pp&authToken=bux9&authType=name&locale=en_US&trk=ppro_viewmore&lnk=vw_pprofile) | [Join us on Linked-In](http://www.linkedin.com/companies/251171) | [![](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/hatRSS_50X50-May-18-2021-05-52-11-72-PM.png?width=50&height=50&name=hatRSS_50X50-May-18-2021-05-52-11-72-PM.png "hatRSS_50X50")](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/hatRSS_50X50-May-18-2021-05-52-11-72-PM.png) | [Subscribe to our Feed](http://feeds.feedburner.com/BcsProsoft/Xutx)     |

## About the Author

[![](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/Hugo-150x150-2.jpg?width=150&height=150&name=Hugo-150x150-2.jpg "Hugo")](https://blog.bcsprosoft.com/hubfs/Imported_Blog_Media/Hugo.jpg)

Hugo Chavez, Senior Consultant for BCS ProSoft

Hugo Chavez is a Senior Consultant for BCS ProSoft and has been an important member of the organization since 1993 (directly after graduating from Texas A&M).  When asked about his approach to dealing with customers, he commented, “I have a tool bag of knowledge that I take with me when I meet with a customer — that bag is filled with the experiences gained from working with other customers in the past and I pull that experience out of my tool bag every time I meet with a new customer.”

Hugo is married to Velda Chavez (who also works for BCS) and together they have three children, two of which have moved on to create lives of their own and the third is still at home, keeping Hugo and Velda VERY busy. Hugo enjoys spending time in the outdoors with his family. Currently he is very actively involved with his youngest son in the Boy Scout program, camping, hiking, canoeing, and kayaking.

 

#### Share this post with a friend or coworker!

- <http://www.facebook.com/sharer/sharer.php?u=https://blog.bcsprosoft.com/sage-100-erp-mas-90-200-tips-tricks-25-general-ledger-history-to-excel>
- <http://www.linkedin.com/shareArticle?mini=true&url=https://blog.bcsprosoft.com/sage-100-erp-mas-90-200-tips-tricks-25-general-ledger-history-to-excel>
- <http://reddit.com/submit?url=hhttps://blog.bcsprosoft.com/sage-100-erp-mas-90-200-tips-tricks-25-general-ledger-history-to-excel>
- [mailto:?subject=Sage%20100%20ERP%20(MAS%2090%20&%20200)%20Tips%20&%20Tricks%20#25:%20General%20Ledger%20History%20to%20Excel&body=https://blog.bcsprosoft.com/sage-100-erp-mas-90-200-tips-tricks-25-general-ledger-history-to-excel](mailto:?subject=Sage%20100%20ERP%20(MAS%2090%20&%20200)%20Tips%20&%20Tricks%20#25:%20General%20Ledger%20History%20to%20Excel&body=https://blog.bcsprosoft.com/sage-100-erp-mas-90-200-tips-tricks-25-general-ledger-history-to-excel)

### Related posts

![Extend the Functionality of Your Sage Intacct Solution: Learn More at Wednesday Wisdom](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/SI-Wed-Wisdom.jpg?width=200&name=SI-Wed-Wisdom.jpg)

[Extend the Functionality of Your Sage Intacct Solution: Learn More at Wednesday Wisdom](https://blog.bcsprosoft.com/extend-the-functionality-of-your-sage-intacct-solution-learn-more-at-wednesday-wisdom)

 Mar 24th, 21

[Services Sales Tax Spreads Through States](https://blog.bcsprosoft.com/services-sales-tax-spreads-states)

 Feb 8th, 21

![The Best Thing about Sage Intacct Budgeting and Planning? Saying “Goodbye” to Spreadsheet Headaches and Busy Work!](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/SI-BP-Blog-Header.jpg?width=200&name=SI-BP-Blog-Header.jpg)

[The Best Thing about Sage Intacct Budgeting and Planning? Saying “Goodbye” to Spreadsheet Headaches and Busy Work!](https://blog.bcsprosoft.com/sage-intacct-budgeting-planning-series)

 Nov 19th, 20

![Survey Results, Expert Speakers, and Industry Insights – Sage Intacct Hospitality Hangout Has It All](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/Hospitality-Hangout.png?width=200&name=Hospitality-Hangout.png)

[Survey Results, Expert Speakers, and Industry Insights – Sage Intacct Hospitality Hangout Has It All](https://blog.bcsprosoft.com/hospitality-hangout)

 Sep 17th, 20

![The Sage Intacct Healthcare Hangout is Back!](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/SI-Healthcare-Hangout-2.png?width=200&name=SI-Healthcare-Hangout-2.png)

[The Sage Intacct Healthcare Hangout is Back!](https://blog.bcsprosoft.com/healthcare-hangout-2)

 Sep 15th, 20

![Hurricane Laura – Is Your Business Prepared?](https://blog.bcsprosoft.com/hs-fs/hubfs/Imported_Blog_Media/hur-laura-25aug20-8a.jpg?width=200&name=hur-laura-25aug20-8a.jpg)

[Hurricane Laura – Is Your Business Prepared?](https://blog.bcsprosoft.com/hurricane-laura-is-your-business-prepared)

 Aug 26th, 20

This is a search field with an auto-suggest feature attached.

- There are no suggestions because the search field is empty.

### Recent Posts

### Who is BCS ProSoft?

We’re a business technology provider and consulting firm specializing in NetSuite, Deltek and Sage software systems. We’re a Top 30 VAR and ready to get started on your project. Need help? [Let’s talk.](https://www.bcsprosoft.com/contact/)

![BCS-logo-white-red-2](https://blog.bcsprosoft.com/hs-fs/hubfs/BCS-logo-white-red-2.png?width=211&name=BCS-logo-white-red-2.png)

BCS ProSoft is a leading business management technology provider and professional services firm specializing in Sage, Deltek, and NetSuite ERP systems. Based out of San Antonio, Texas, BCS ProSoft serves more than 1,500 clients from its offices in Houston, Denver, Honolulu, and Monterrey, Mexico.

### **Products**

- [Deltek](https://www.bcsprosoft.com/deltek/)
- [Sage Intacct](https://www.bcsprosoft.com/sage-intacct-overiew/)
- [Sage 100](https://www.bcsprosoft.com/sage-100/cloud/)
- [NetSuite](https://www.bcsprosoft.com/netsuite/)
- [Automated Rental (ARM)](https://www.armsoftware.com/)

### **Company**

- [About Us](https://www.bcsprosoft.com/about/)
- [Industries](https://www.bcsprosoft.com/industries/)
- [Events](https://www.bcsprosoft.com/events/calendar/)
- [Careers](https://www.bcsprosoft.com/careers/)
- [Support](https://www.bcsprosoft.com/support/)
- [Referral Program](https://www.bcsprosoft.com/resource/bcs-referral/)

© Copyright 2008-2021, BCS ProSoft, LLC. All rights reserved. | [Legal](https://www.bcsprosoft.com/legal) | [Privacy Policy](https://www.bcsprosoft.com/privacy/)

- [Facebook](https://www.facebook.com/bcsprosoft)
- [Linkedin](https://www.linkedin.com/company/bcs-prosoft)
- [Twitter](https://twitter.com/bcsprosoft)
- [Email](https://www.bcsprosoft.com/contact/)