Skip to main content

How to: Filter/Search the General Ledger

Welcome to our guide on how to filter and search the general ledger in GreenSlate. I’ll walk you through each step, so you can complete the process with ease.

1. Open General Ledger

First, navigate to the General Ledger option in the left-hand menu.

Open General Ledger

2. Access All Transactions

Next, select any of the default or custom grid views or tabs. For example, All Transactions.

Access All Transactions

Note: for information on creating your own custom grid view, click here.

3. Sort by Description

Now, type in the filter fields at the top of the desired column to search for a specific transaction or a group of transactions.

Sort by Description

4. Apply Filter Settings

From the filter buttons, you can use the Type filter to isolate certain transaction types only.

Apply Filter Settings

Note: Common ways to filter may include by account, description, amount, transaction number, or transaction date.

5. Apply Funnel Settings

Alternatively, you can click on the funnel for more filtering options. For example, transaction types I.

Apply Funnel Settings

6. Activate Filter

Then, click the Filter button to apply the filters and update the transaction list accordingly.

Activate Filter

7. Click On Transactions

Now, you can select and isolate desired transactions that you may be interested in editing, exporting, or exploring the Bulk Actions options you have for these transactions.

Click On Transactions

8. Apply Bulk Action Selection

From the Actions dropdown, you will see the options to Approve, Post, Void, Commit, Send Email Reminders, Update Notifications, and Delete.

Apply Bulk Action Selection

9. Access Actions

Apply bulk actions to selected transactions by selecting the Bulk Actions drop-down.

Access Actions

10. Open Edit Mode

Instead, if you'd like to edit transaction details of the filtered transaction(s), click Edit toward the top right-hand corner.

Open Edit Mode

Note: For more info on our bulk editing capabilities, click here.

11. Edit Transactions

Now, editable fields appear with a bold border.

Edit Transactions

12. Enter Changes

Make your edits on the column header with the Blue Arrows on the right to edit.

Enter Changes

13. Apply Bulk Changes

When you're ready, you can click on the Blue Arrows to bulk update the information.

Apply Bulk Changes

14. Save Transaction Changes

When you're ready, click Save to submit your changes.

Save Transaction Changes

15. Export Transaction Data

Click Export to generate a file of the current transaction data for external use or recordkeeping.

Export Transaction Data

16. Select Export Type

From the Export dropdown, you will have the choice of what type of file you'd like to use for the export download.

Select Export Type

Note: the PDF option will export only transactions that fit on the page, whereas the Excel option will export transactions on all pages.

That's it. You have successfully filtered and searched the General Ledger in Greenslate. If you have any questions or need more help, please visit our Help Center or reach out via email or chat.

Did this answer your question?