The Payment Summary by Invoice report shows a detailed breakdown of the payments applied to each invoice, down to the line item. It is located in the Financials workbook.
When to use it
Use this report when you need to trace exactly how a payment was applied. Each row ties a payment to its invoice and the line items it covered, which makes it the right place to answer questions like "which invoice did this payment go to?" or "how was this invoice paid off?"
How to Filter
Set the date range for the period you want, and narrow by customer or invoice to follow one payment trail. For an invoice-level rollup without payment application detail, use the Invoices Summary report; for a payment-first audit trail, use Payment Details.
Column Names and descriptions
Organization Name | Name of the organization receiving the payment. |
Invoice Id | Unique identifier for the invoice associated with the payment. |
Payment Id | Unique identifier for the payment transaction. |
Line Item Id | The identifier for a unique line item. |
Paying User Name | Name of the paying user. User: A global Bond account with a unique email that can be associated with multiple organizations. |
GL Code | The General Ledger code associated with the product. |
Payment Method | The method used to complete a transaction. Examples include card-on-terminal, card, cash, void, void-adjustment, us_bank_account, check, discount, discount-adjustment, and balance. |
Payment Amount | The amount of the payment applied to the line item. |
Transaction Fees | The processing fee deducted. |
Non Tax Payment Amount | The portion of total payments that does not include tax deductions. |
Tax Payment Amount | The portion of payments attributed to taxes. |