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.

  • The information that you need is on the Purchase Journal, which is located in Reports & Forms in the Accounts Payable section. https://pcosupport.com 

  • You would need a Business Intelligence report to get the specific information you are looking for.. 

  • in reply to termerins

    The Purchase Journal does not list the checks being printed and signed today, only a list of items that are being recorded in a particular period. I need a report that shows me where items are being "charged to" when I sing or approve a check run to ensure that things are being entered correctly.  I am seeing a lot of errors and inconsistencies as I am reviewing prior period financial reports.

  • 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]