Cash Account QuickReport

Let's get this issue reviewed and sort it out, @KM402.

I've tried running an income account QuickReport on a cash basis on my sample company file, and it shows me the paid invoices according to the payment date. 

Since yours isn't working as it seems, it's possible that your company file had a data issue. To get this fix, let's run the Verify and Rebuild Utility tools. This will help fix data damage on your company file. Here's how:

1. Click the File menu, then select Utilities, and choose Verify Data.
2. Click OK when you see the message, QuickBooks detected no problem with your data.
3. If Verify finds an issue with your data, you'll be prompted to Rebuild Now or View Errors.
4. Click Close or View Errors and take note of the specific error message.

Once done, go back and run the report again to double-check. If you get the same result, you can check out this article for more troubleshooting steps: Fix data damage on your QuickBooks Desktop company file.

You may want to run and customize other reports in QuickBooks Desktop. This article will you help with the proper way on customizing reports: Customize reports in QuickBooks Desktop.

Please let me know how things go, @Dav. I'll be around to provide further assistance. 

I verified and rebuilt the data - but my issue is still the same.
I have an invoice for $50,000 dated on 7/26/22
I have one payment for $15,000 dated on 6/13/22
I have one payment for $500 dated on 5/4/22
When I run an accrual account quickreport for July the entire $50,000 shows - which is good, the invoice is in July.
But when I run a cash account quickreport for July what shows is the $15,000 and the $500 - which is not good, these payments where in June and May
What can I do?

Hi there, KM402.

I'd like to get more details about the Account Quickreport you're running. Can you provide a screenshot of the report on an Accrual and Cash basis?

Your screenshots will help us both determine why the $15,000 and $500 amounts will show up in July on Cash basis.

I'll keep this post while waiting for your response.

Hi,
Please see snapshots below, waiting for you advice

Hello @KM402,

Thank you for getting back and providing screenshots of the Account Quickreport. Allow me to chime in to provide clarification regarding the result you're getting when running the report in QuickBooks Desktop.

As you can see in the report, the payments are shown as part of the invoice you created last 7/26/2022 (see screenshot below). This is the basis of the system and the reason why they're appearing within your report date range.

To show your cash income for a specific account, run the Transaction detail by account report. It's similar to Quickreport but provides much more detailed information. You can also change the report basis to either Accrual or Cash.

Here's how to run the report:

1. Click the Reports tab at the top menu bar.
2. Hover your cursor to Accountant & Taxes.
3. Select Transaction Detail by Account.

You can use this link as a reference if you play around with the Display and Filters tab of the report customization in QuickBooks: Customize reports in QuickBooks Desktop.

Let me know how the report goes or if you need more help getting the data you need. I'll be around to lend a hand. Take care.

@AlcaeusF I followed your instructions and created the Transactions Detail by Account Report.
It did not give me the report I need.
And I'm totally confused what the 'Cash Basis' Report is all about if it can't give me a CASH Report.

This is the case:
I have several customers that have running balances.
Some of them pay on old bills, and some of them pay on future bills.
I want a report that will show, within a date range, how much ACTUAL PAYMENTS I received.
If both of these reports (Account QuickReport and Transactions Detail by Account) use the Invoice Date to show on reports I do not get what I'm looking for.

Please advise,

Thanks for getting back to us, KM402.

I'll share additional details about running a report that shows actual payment within a date range in QuickBooks Desktop.

The Cash Basis report only shows income when it is received in cash and expenses when its paid. Meanwhile, the Accrual Basis accounts for income regardless of when it is received or paid.

You can view the payment you received from your customer by running the Deposit detail report. Then, customize it to include the required column and filter the transaction to show only the deposits.

Here's how:

1. Go to the Reports menu.
2. Hover to the Banking, then choose Deposit detail.
3. Ensure it has the correct reporting period.
4. Click Customize Report button.
5. In the Display tab, select the column you want to include in your report.
6. Go to the Filter tab, search for the Transactions Type, then choose Deposit.
7. Once done, hit OK.

In addition, you can also run the Transaction Detail by Account and then filter the transaction type to include multiple transaction types. Please see the image below.

For your reference, you can use this article for additional customization: Customize reports in QuickBooks Desktop.

You can also memorize your report to save the current customization settings. Check out this resource for more insights: Memorize a report.

We're always available to help you, don't hesitate to reply to this post if you need further assistance running your report. Have a great day.

So I ran the Deposit Detail report, and the layout is very hard to work with.
It breaks down every deposit and therefore there are so many lines, No Total Balance, and very hard to work with when exporting to excel.
But my biggest issue is that it is not filterable by 'Income Account'. I don't want to see ALL of my Income, only a specific type.
I usually use Deposits, General Journals and Credit Memos (applied to an invoice), when entering Income. I was unable to bring all of them onto one report (filtered by account).
Please advise,