# GL Stream Overview: Navigating Data Browser & General Ledger Features In this tutorial, you'll learn how to effectively use the **data browse**r within the **GL Stream** product. You will understand the kind of views you can build with Data browser filter capability. {% embed url="" %} {% stepper %} {% step %} **Understand the GL Stream product** ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FZDQ80Aeqp7qfT0IQ6R3E%2F0.png?alt=media\&token=6ee14551-580f-496a-b750-872186d30ce9) GL Stream has two main sections: **Data browser** and **GL reconciliation**. In the **data browser**, you'll see a trial balance at a GL code level for a specific period, showing the debit and credit recorded for that period. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F5rGBQxxu2qecu7iA4puw%2F1.png?alt=media\&token=7554253e-d734-4c62-8745-cc42c50a5b14) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FZBlSA1hEhpxfjCXe4drf%2F2.png?alt=media\&token=1fdfb3ef-df8d-4895-8780-dce44161bc05) {% endstep %} {% step %} **Navigate to the Trial Balance** ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F9fjFMO0mJN18teTjqfFn%2F3.png?alt=media\&token=a3edcc69-77d1-4f78-a6e8-e556d9ad11d3) If all GL transactions are correct, the debit minus credit should equal zero. This indicates that your vouchers are balanced and all data related to your vouchers is within the GL artifact. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F8may4ETTA7bUgn0GCk1V%2F4.png?alt=media\&token=202e8c85-0ec7-4d87-b9ce-53de486edc19) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2Fqa41H84IxwDa1idu8m5v%2F5.png?alt=media\&token=b7c65c7d-2bcc-411b-8f0d-e07afa28368c) {% endstep %} {% step %} **Use the filter option** The **filter** option lets you view data for a specific company code and period. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FhpGEwZ8mCMEFKE4042Is%2F6.png?alt=media\&token=efb694c9-c277-4d52-8bef-525f413a5452) For example, filter data for company code **CPX1** for the period of **July 2024**. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FYroR8hh3tt9OLPP8jlBr%2F7.png?alt=media\&token=1e611e02-27fc-4380-ac83-a898fb295005) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FYqxcGrK3NSItpiqJuXMz%2F8.png?alt=media\&token=dfdd80c3-6080-4b5e-970b-aadfa00b884a) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F4yxlTq2eN7AhhqG4wzMZ%2F9.png?alt=media\&token=b8941253-64d9-46a6-8fe9-c0829b94c53b) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FcCRMxFT31RV9JHpQni7Z%2F10.png?alt=media\&token=547b0f26-6a04-4377-9eac-426beb490f72) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FeVfL9Ofd9A2gzkow3Rsn%2F11.png?alt=media\&token=35efc1ab-5c09-437f-90d6-27e5769ca6c7) After applying the filter, you'll see the data for this period. If the debit and credit totals equal zero, it means the vouchers for this period are balanced. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2Fj1qRYTTSsnbOfjHhWzGU%2F12.png?alt=media\&token=7adb04cc-8ad8-4f23-aa65-4e38f19829cc) {% endstep %} {% step %} **You can use 'AND' or 'OR' filters** Typically the standard table views that you see in our product are **default 'AND'** however with data browser you have the flexibility to choose 'OR'. Typical use case would be ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FGlz5y5gIC9C5MkAFgMJt%2F13.png?alt=media\&token=833f9ebe-a660-4948-bfe3-be93741d5dcc) If you are looking for a set of documents that belong to particular Business Place 'X' or Profit Center 'Y' ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FE4C7TuSfT9eXA0FyZ5zB%2F14.png?alt=media\&token=b3151004-ee93-4603-92c3-4823c23bdccb) {% endstep %} {% step %} **Save Filters** If you frequently use a specific filter, save it for future use. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2F9vVyZg6Qzy2slbHTiYJS%2F15.png?alt=media\&token=a1f29406-3256-4998-8dc9-eb9302d26d3a) For instance, save a filter as "trial balance for July for CTX1" and reuse it later. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FK1AVwFlOO4M31luASh1R%2F16.png?alt=media\&token=b555f884-4d0d-4752-afc2-de1a1e6ffdbd) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FaBSeD8JxbMvJOqN0QCNB%2F17.png?alt=media\&token=2f352012-31ad-4df6-9930-41d94ee72baa) For instance, save a filter as "trial balance for July for CTX1" and reuse it later. ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FnGyyAh39kTKs3xq5kadU%2F18.png?alt=media\&token=02bed063-ccb5-478a-ae36-ffcd70fc0ccf) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FZBo1N1iOgzAeCLzKcKBs%2F19.png?alt=media\&token=336895d6-019f-4c6e-b6c8-7c54a5ae36f1) ![](https://1228935104-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-MZESjKfghy4dwB5DEJ1%2Fuploads%2FsJJ9RJpxV1rDa7RXg6MI%2F20.png?alt=media\&token=a3844128-3f17-44fc-8879-4f3648366c64) {% endstep %} {% step %} **Use saved filters** When you return to GL Stream and go to the trial balance view, you'll see your saved filter.
Click on the saved filter to apply it.
{% endstep %} {% step %} **Explore the general ledger view**
The General ledger view is a table displaying all relevant information about the accounting / GL data.
Use the same filter features as in the trial balance view.
{% endstep %} {% step %} **Sort the table** Sort the table by company code, voucher number, or voucher date. Look for the small arrow icon in the column header. Initially, the table is sorted in ascending order
Clicking the arrow icon sorts it in descending order.
Clicking the icon again removes the sort. To reapply sorting, click the icon again.
{% endstep %} {% step %} **Download data** Download data by clicking Actions. If the data exceeds a million rows, it's split into multiple files.
{% endstep %} {% step %} **Customize columns** Show, hide, or reorder columns by clicking Actions and selecting Show/Hide Reorder Column.
Choose column names to show or hide.
Reorder columns by dragging them to the desired location.
{% endstep %} {% step %} **Sort multiple columns** To sort multiple columns, click Actions and select SORT.
Add, delete, or prioritize sort options. Select column names and choose ascending or descending order.
{% endstep %} {% step %} ### {% endstep %} {% endstepper %}