Accounts Payable Report - Expense Account

I need to approve payments for the AP check run. My accountant gives me a report of vendor, invoice, amount, and GL account.  However, the GL account is Accounts Payable account.  I need a report that shows what Expense or Inventory account the invoice is being charged to.  How do I do this?  I’ve been looking at the forums, but have not seen a solution to this.

Parents Reply Children
  • in reply to Best Business Strategies

    Are we saying that Sage 50 is such a poor product on its own that we need to purchase additional products and create additional reports just to see where a check has been charged to?  I've been on many platforms, but this is the first that I have seen where the controller can not get a report showing where a check is being charged to before being asked to sign the check.

  • in reply to Best Business Strategies

    It does appear that we have purchased the additional "Business Intelligence" add in, but have not been able to navigate how to get a report for a specific check run that show what expense account an item was charged to.  Are there really no other accountants out there that want to know where an item has been charged to before putting their signature on a check?

  • in reply to Gregory

    It's because the cash disbursements journal posts to the cash account and AP account if it's applied to an invoice and would only show what you're looking for if it was applied to expenses.  It's also because a check could pay multiple invoices that post to multiple different GL accounts.  That being said we could create a Sage Intelligence report that would show all invoices paid by a check and the respective GL accounts that they were posted to if you'd like to reach out to us directly to discuss -- 1-800-339-8224 or [email protected]