Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Dear Quickbooks Community,
We have started to label our customers' payments with the respective "Payment Method". Now, of course, we would like to create corresponding reports for this.
A desired requirement is to create the sum of all income from the previous week, broken down by payment method.
However, if we start a report "Profit & Loss (Detail)" and specify the field "payment method" as an additional evaluation field, then the assignment is not made correctly. While the payment method "bank transfer" is evaluated correctly, this is not the case with "cash". Although the individual transactions are correctly marked with the payment method "cash", they are treated as if no payment method were specified. Even in a detailed report where the colum "payment method" is displayed separately, the specification "cash" does not appear in the corresponding column, the field is displayed as empty.
However, if the single transaction is then called, the entry correctly entered with "cash" appears here again. By the way, it is possible to select the correct payment method for the report "Transaction List by Customer", but we would also need this option for the "Profit & Loss" evaluation.
Is there a way to do this? Many thanks in advance for all suggestions
Albert [removed]
Solved! Go to Solution.
Good day, @AlRei263.
The Profit and Loss (P&L) report is designed to provide an overview of the organization's financial performance, focusing on broader financial outcomes rather than detailing specific transactions like payment methods. I will clarify why the payment method is shown in the P&L report and the Transaction List by Customer report in QuickBooks Desktop (QBDT).
In QBDT, the P&L report summarizes revenues, costs, and expenses over a specific period to show the business's overall financial performance. It consolidates financial data to indicate net income or loss. Still, it does not typically display the payment methods (e.g., cash, credit card, bank transfer) used in transactions, focusing instead on their overall financial impact. Payment methods are only shown for deposits linked to specific income and expense accounts.
On the other hand, the Transaction List by Customer report displays payment methods because it's structured to offer detailed insights into each customer's transactions, including the methods of payment. This report is helpful for businesses to monitor and manage the payment behaviors of their customers.
Additionally, I include an article if you want to send a report on a regular and recurring scheduled time: Set up and modify Scheduled Reports.
Leveraging custom reports addresses particular challenges and offers deeper perspectives on your business’s financial well-being. If you need more help or have other questions, don’t hesitate to contact us. We are committed to aiding your success in financial management.
Good day, @AlRei263.
The Profit and Loss (P&L) report is designed to provide an overview of the organization's financial performance, focusing on broader financial outcomes rather than detailing specific transactions like payment methods. I will clarify why the payment method is shown in the P&L report and the Transaction List by Customer report in QuickBooks Desktop (QBDT).
In QBDT, the P&L report summarizes revenues, costs, and expenses over a specific period to show the business's overall financial performance. It consolidates financial data to indicate net income or loss. Still, it does not typically display the payment methods (e.g., cash, credit card, bank transfer) used in transactions, focusing instead on their overall financial impact. Payment methods are only shown for deposits linked to specific income and expense accounts.
On the other hand, the Transaction List by Customer report displays payment methods because it's structured to offer detailed insights into each customer's transactions, including the methods of payment. This report is helpful for businesses to monitor and manage the payment behaviors of their customers.
Additionally, I include an article if you want to send a report on a regular and recurring scheduled time: Set up and modify Scheduled Reports.
Leveraging custom reports addresses particular challenges and offers deeper perspectives on your business’s financial well-being. If you need more help or have other questions, don’t hesitate to contact us. We are committed to aiding your success in financial management.
Thank you very much for your detailled explanation. It is fine for me.
Good news, AlRei263.
I'm glad to hear that my colleague's insights have helped you resolve matters in QuickBooks. It's always a pleasure to support valued customers like you.
If there's anything else you need help with regarding QuickBooks, just let me know. I'm here to help and will get back to you soon. Take care and have an awesome day!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here