GL Report - Expenses

Art Davila

Is there a way to pull a GL report that contains the Expense Detail/Purpose or Description instead of only the vendor name?

Angela Tuttle

Hi Art!

The Vendor Activity Report shows the details below. I like to use this report when reviewing 1099s.

To run in FE Database View (Accounts Payable > Reports > Vendor Reports > Vendor Activity Report.

Angela Tuttle

If you want to see the GL account numbers there is the Account Distribution Report.

In the FE Database view run by: (Accounts Payable > Reports > Invoice Reports > Account Distribution Report.)

This report breaks expenses down by GL account and includes the following information (you can also add project distribution):

Paul Wu

One item to make sure you setup is in the AP Posting process.

There is a spot where you can define what flows from AP into the GL detail. We use the syntax below. This will then include the text entered in the AP Description line. If nothing is being entered when AP is being processed, then that is another issue.

For example in my detail gl listing, I have a line that reads:

“Vendor name-210919-Translation service for articles by xxxxx”

So when I print out the gl for departments, not only does the vendor and invoice # show up, but the description is included.

Art Davila

Thank You! This is a feature that I have overlooked and should provide what I need.

Janet Tucker

So currently there is not a way to run Vendor Activity Report in NXT?

Paul Wu

As far as I can tell, not in NXT. I have only been able to do it in the database view.

Janet Tucker

I think it should be added to NXT