I would love the ability to create a customized report of transactions. One that I could ask for one column to show account number (even better yet, fund, account, and department in all different columns), the next for account description, then transaction date, transaction description, transaction amount, project ID, grant ID, attributes. I could then use this info in Excel with the filter feature to easily slice the data in different ways using filters. It would also be great to have the option to eliminate transactions that have been reversed.
Currently I run a full GL with project ID and then another with grant ID because if I run them in the same report it shows up on two lines. I then combine them and copy the account numbers to the front of each transaction. I then eliminate the blank lines and lines that have been reversed. It's quite a time consuming process but once I have the data this way, it's easier to mine through and find miscoded items or opportunities to apply expenses to grant funding.
Unfortunately, in our system queries will not work for this if you have payment transactions with multiple accounts posted in the same payment. It will sometimes post the overall amount on each transaction line. So, it renders the information unreliable.
Ah, thanks! I never use queries but will start now.
Create a query with the columns of data that you want.