# Print General Ledger Listing

#### How to create?

1\. Navigate to **Admin,** select **Systems** and click  **Manage Reports,** now click on **+Create report** from the menu displayed which looks like the image shown below

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-20%2014-59-28.png?version=1\&modificationDate=1563631373789\&cacheVersion=1\&api=v2\&width=850)

2\. Enter the details for '**Report Name','Report Category', 'User Report'** fields.

{% hint style="danger" %}
Report category must be specified as "**Accounting**"
{% endhint %}

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-25%2017-35-05.png?version=1\&modificationDate=1564072820963\&cacheVersion=1\&api=v2\&width=850)

3.Next in the field provided for '**Sql**', paste the below query:

{% hint style="info" %}

{% endhint %}

| <p>select gl\_code, name<br>From<br>acc\_gl\_account</p> |
| -------------------------------------------------------- |

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-25%2017-43-30.png?version=1\&modificationDate=1564073569048\&cacheVersion=1\&api=v2\&width=850)

4\. Click ![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/4.png?version=1\&modificationDate=1472454868133\&cacheVersion=1\&api=v2\&width=55)

#### How to Print?

1\. Navigate to **Reports** then select  **All** from the drop down menu. In search bar "**Specify the same report name provided at the time of report creation**"

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-25%2018-00-13.png?version=1\&modificationDate=1564074187197\&cacheVersion=1\&api=v2\&width=850)

2\. Click on the report.

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-25%2018-06-44.png?version=1\&modificationDate=1564074476026\&cacheVersion=1\&api=v2\&width=850)

3\.  Click ![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/8.png?version=1\&modificationDate=1472454867085\&cacheVersion=1\&api=v2\&width=65)

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-25%2018-08-48.png?version=1\&modificationDate=1564074614937\&cacheVersion=1\&api=v2\&width=850)

4\. Once "**Run Report**" is clicked all the **Chart of Accounts** are displayed.

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-25%2018-11-25.png?version=1\&modificationDate=1564074795503\&cacheVersion=1\&api=v2\&width=850)

5\. To **Print** the general ledger listing click on ![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/10.png?version=1\&modificationDate=1472454865983\&cacheVersion=1\&api=v2\&width=65)

![](https://mifosforge.jira.com/wiki/download/thumbnails/155058219/Screenshot%20from%202019-07-25%2018-14-00.png?version=2\&modificationDate=1564075194764\&cacheVersion=1\&api=v2\&width=850)