Skip to main content
K
KM402
August 2, 2022
Solved

Cash Account QuickReport

  • August 2, 2022
  • 1 reply
  • 0 views

I'm having an issue with a report

This is what I choose:
1) Account Quickreport - Income Account

2) Cash Basis
3) Date Range

This is what I want to see:
The total amount of Cash Income for this account in the Selected Date Range
I only want invoices to show up with the paid amount according to the date range

Instead - This is what I get:
The total paid amount of the invoices show up according to the invoice date instead of the payment  date which is accrual and not cash

What would you advise?

Best answer by AlcaeusF

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,


Hello again, @KM402.

 

Thank you for keeping in touch with us regarding the report you need. Allow me to chime in and help you obtain the data in QuickBooks Desktop.

 

The closest report you can run to show a specific income account and transactions are the Transaction Detail by Account report. I know I've already shared it in my previous response, but I recommend setting up the filters.

 

Here's how:

 

  1. Click the Reports tab at the top menu bar.
  2. Hover your cursor to Accountant & Taxes.
  3. Select Transaction Detail by Account.
  4. Click Customize.
  5. Go to the Filters tab.
  6. Filter the transaction types.
  7. Add the specific income account to the filter.
  8. Hit OK.

 

Alternatively, you can try creating a custom report for the data. It'll show the list of individual transactions, showing each account involved in a transaction on a separate line.

 

If none of the steps works, you can also reach out to our support team for further assistance. For Pro, Premier, and Plus, our support is available from 6 AM - 6 PM PT (Monday - Friday). For Enterprise, any time, any day.

 

See the steps to get a hold of a specialist:

 

  1. Open QuickBooks Desktop.
  2. Click the Help tab at the top menu bar.
  3. Select QuickBooks Desktop Help. 
  4. Enter your concern, then hit Continue.
  5. Choose Get a callback. 

 

Additionally, I've attached an article you can use to run predefined customer, job, and sales reports in QuickBooks: Customize customer, job, and sales reports in QuickBooks Desktop.

 

Let me know if you have more questions or concerns about the reports available in the Desktop version. The Community is available 24/7 to help out.

1 reply

M
Mark_R
August 2, 2022

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. 

K
KM402Author
August 3, 2022

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?

MaryLandT
MaryLandT
August 3, 2022

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.

Terms & ConditionsAccessibility statement