Question

Quickbooks recording partial income and sales tax without any applied payments (Cash Basis).

Forum|Forum|5 years ago
April 13, 2021
3 replies
10 views

Hello,

We are a cash basis company and utilize only cash basis reports. Partial income (9.14%) is shown on the P&L as well as a partial sales tax liability (9.14%) on the balance sheet for each invoice created for a specific customer regardless of payment. All other customers are showing correctly on the balance sheet and P&L. For example, $100k in field work is invoiced as well as $9k for sales tax in January. QuickBooks is then recognizing $9,140 as income and $822.60 as due to the Dept of Rev in January. It is considering 9.14% of each line as paid in January even though the invoice shows unpaid with the full balance due. How do I get this to stop? I only want to recognize revenue/liability if the invoice is paid since we are cash basis. Thanks in advance.

Product: Enterprise Solutions 21.0

QuickBooks Desktop

M

mv32

Level 8

Thanks for sharing details, @Construction999.

Let me share some insights on why it appears that reports are calculating partial income and sales tax without applied payments.

When you pull up detailed reports in QuickBooks, their default is accrual basis. Also, summary reports can be on a cash or accrual basis, the keyword to identify is having the word Summary in their titles.

In this case, let's make sure that you've set the company's preferences on a cash basis so it could generate the cash base report you want.

Here's how:

Login to your company file as Admin and run it us Single-User Mode.
Go to the Edit menu and then select Preferences.
From the left pane, select Reports & Graphs and then go to the Company Preferences tab.
Choose Cash and then click OK.

Once done, rerun the Profit and Loss report to see the difference. I'll add this reference to learn more about this setup: Differentiate Cash and Accrual basis.

Additionally, you can modify detailed reports in QuickBooks, simply click the Customize button on a report window. For detailed insights on how to filter and add columns to a report, you can check this reference: Customize reports in QuickBooks Desktop.

Please leave me a comment below if you have other concerns with cash and accrual-based reports. I'll answer them for you. Take care!

C

Construction999Author

Thank you for your message. As I posted in the initial post, all reports are already generating on a cash basis. The error I mentioned occurs when the reports are under cash basis. Partial income and sales tax liability are shown on the balance sheet and P&L even though no payments have been applied to the invoice. Please assist.

Jen_D

Level 8

Thanks for sharing this concern with the Quickbooks Community, @Construction999,

What's happening in your end is rather unusual. In this case, let's diagnose if the problem is caused by minor issues in the program.

Run the Verify/Rebuild Utility to check any data issues within the company file. This built-in tool automatically fixes minor program data issues like the one you experience when running cash basis reports.

Here are the steps to do it:

Go to the File menu, then choose Utilities from the list.
Select the Verify Data tool then wait until the diagnosis is done.
If there are issues, proceed to rebuilding the company file.
Tap the File menu again, then hover over to Utilities.
Choose Rebuild Data then click OK.
Follow the onscreen steps to save a backup.

For your reference, see the following link to learn more about this tool: Resolving Potential Data Issues

Once done, try running the report again and see if it resolves the problem.

However, if you get the same result after doing so, I recommend reaching out to our Support Team. They can initiate a viewing session with you and help diagnose the company file to verify what causes the problem.

To get our support, follow the steps below:

Open QuickBooks and click the Help menu.
Select QuickBooks Desktop Help.
On the pop-up screen select Contact us.
Click the Search for Something else button then type your concern in the Ask us anything box.
Hit Search then scroll down to get your contact options.

Refer to this article to learn more about our contact options and support availability: Contact QuickBooks Desktop support

Also, kindly update me with the result in this thread. I want to make sure this reporting concern is resolved so you're able to view reports with accurate data in it.

BigRedConsulting

Level 15

@Construction999

RE: QuickBooks is then recognizing $9,140 as income and $822.60 as due to the Dept of Rev in January. It is considering 9.14% of each line as paid in January even though the invoice shows unpaid with the full balance due. How do I get this to stop?

Are there any negative line items on the invoice? If so, they can cause this if they are not Discount type items.

This is because negative lines (that are not discounts) are considered returns that "pay" the invoice, just as if you'd created a credit memo for them and applied it to the invoice.

C

Construction999Author

Thanks BigRedConsulting! Support just identified the negative line item as the source of the error. Retention is shown on the invoice. Do you know how to do a negative line item on the invoice without it affecting the reports?

BigRedConsulting

Level 15

Can you describe the case in more detail? What is the nature of the retention that reduces the invoice amount?

MJoy_D

QuickBooks Team

Hello, @icjerk1.

Can you tell me more about the retentions that you're referring to? That will surely help us provide an accurate solution to the concern that you're having.

You can click the Reply button below to add more details.

I'm looking forward to hearing from you soon! Take care, and have a wonderful day!

Sign up

Login with SSO

Let's get you signed in

Login with SSO