AP & AR Detailed Report

1

Hi, I’m looking for a report that can detail accounts payable transactions per supplier and the same for accounts receivable. I have looked through all the standard reports and tried to create a custom one, but couldn’t get it to give the transactions per Supplier/Customer grouped together. Is there such a report?

2

Hi @SVS,

You can use Reports > General Ledger Transactions and set your Account field to your Receivable/Payable account.

Screenshot_20250331_005924
Screenshot_20250331_0059241832×880 97.1 KB

3

Hi Ealfardan

Thank you, but that gives me all the AR /AP trx, but not per each supplier or customer and also not in a way that I can sort it to get such, in Excel. The transactions statements cannot be exported to excel.

4

You’re welcome.

To get the transactions for a single customer/supplier you can either:

  1. Go to Customers / Suppliers tab and then click on the linked figure under Accounts receivable /Accounts payable column, or

  2. Go to Reports > Customer Statements (Transactions) / Supplier Statements (Transactions)

To get such a report for all suppliers/customer grouped, you will have to use Reports > Custom Reports

On the report view screen, there is a button labeled Copy to Clipboard. You can click it and paste it into Excel.