Cash Reports

Hi there, @rtervo.

The Check Detail report shows the details of all checks that have been written by a bank account over a period of time.

It's possible that an Accounts Payable (A/P) account was selected as an expense when creating the check. This is the reason why it's showing when viewing the report. 

To check, you can open again the report and click the A/P account to view its transaction. You can create any necessary changes with it and choose the correct Expense account when creating the transaction. That way, it won't show up again when opening the report. 

Moreover, the destination/split field isn't available to be chosen as a table field in Quickbooks Advanced Reporting. I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience.

You can also send feedback to our product developers. That way, they can review your request and most likely include it in our future updates. Here's how:

1. Click the Help menu and select Send Feedback Online.
2. Choose Product Suggestion, then enter the details of your concern.
3. Select Send Feedback and click Close Window.

It's important that we always meet our customer's needs. While we continue to make improvements, I want you to be updated with the latest QuickBooks news and product release through our Firm of the Future site. This is where we share recent happenings and future developments, such as updates to newly added features.

In addition, please check these links if you need more help in handling your financial reports:

• Customize reports in QuickBooks Desktop
• Understand reports

Please let me know how else I can help you with QuickBooks. I've got your back and am always happy to help. Keep safe!

I understand why A/P shows up on the transaction reports.

I think you understand my problems with that. We want the other side of the transaction to show up...the destination account.

It's looking like QB won't solve this issue.

I was hoping someone had an app or report writer or something that provided a work around.

Rebecca

Hi Rebecca,

Thank you for you making a follow-up. I'd to clarify that this is not an issue, but a design.

I understand that you wanted to see the expense accounts. However, that's only possible if you do a direct expense posting into your checking account, and if there's no split.

Those expenses that are posted via bill will go through the A/P account first. Then, when a payment is made. The A/P account becomes the other side of the journal, opposite the checking account. Therefore, when you run a checking account report only the A/P shows up.

You can consider finding a third-party app that can generate a report, showing the expense accounts used in the connected transactions (specifically, on bills).

Let me know if you have any other concerns. Have a good one!

You can get a report of every transaction recorded in your checking account listing the detail account(s) and the other fields you specify.

However this isn't the same as what you appear to be asking for. For example, you say you don't want to see the A/P account, which leads me to believe you're recording bill payment checks. In this case, you can't see the original expense accounts from the bills, as they're not part of the bill payment check transaction. Similarly, the income accounts recorded on sales transactions aren't available for your deposit transactions. These payments and deposits are far removed from the original income and expenses, which are in no way related to your checking account.

To create the report, though, start with a custom transaction detail report. Filter it for the desired bank account and choose the option to show details as shown, and then add the Detail Level filter:

The resulting report will show the one or more detail rows for each transaction recorded in your bank account.

@rtervo   Also, if you really need the report you describe, you'll need a custom solution. If interested, it's something we can build for you. In this case, start on our site an create a support request describing what you need and I'll reply: BRC - home