In QuickBooks, extracting payment and applied transaction details provides insight into which transactions are associated with specific payment records. To access this information, users can follow a series of steps within their QuickBooks account.
Firstly, log in to the QuickBooks account and navigate to the “Reports” section. Within this section, locate and select the “Invoices and Received Payments” report. This report allows users to view both invoices and the payments received against them.
Next, refine the report by selecting a specific date range using the Date filter located at the top of the page. This ensures that the report displays transactions within the desired timeframe, aiding in accurate analysis.
To tailor the report to requirements, click on the “Customize” option. This allows users to add additional columns to the report, providing a more comprehensive view of payment and transaction details. Once the report is customized, proceed to export it to Excel by clicking on the Export icon. Select the “Export to Excel” option to generate a spreadsheet containing the extracted data.
Within the exported report, transactions listed under the payment row signify the transactions applied to that specific payment.
However, it’s important to note that the amount displayed corresponding to each invoice, journal entry, or other transactions represents the total amount of that transaction. This figure does not necessarily reflect the amount applied to a particular payment.