cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
maksymrudiuk
Level 1

Quickbooks ignores the custom PST amount in Bill and re-calculates it for Invoice.

Hello,

 

I have encountered an issue with the amount and markup calculation in invoicing. Below is a detailed example:

 

Steps to Reproduce

 

Step 1: Create a Bill

 

I created a bill via Expenses > Bills > Add Bill with the following parameters:

  • Amount: $100.00 CAD
  • Sales Tax: GST/PST (BC)
  • Billable: Yes
  • Markup %: 20%

 

Important: I manually adjusted PST (BC) @ 7% on $100.00 from $7.00 to $2.00.

 

Step 2: Create an Invoice

 

I navigated to Sales > Invoices > Create Invoice, selected the line item from the bill above, and observed the following values:

  • Amount: $107.00 CAD
  • Markup: $21.40 CAD

 

Issue Description

  • The expected Amount after my manual tax adjustment should be $102.00 ($100 + $2 adjusted tax).
  • However, the system appears to have recalculated the tax, resulting in $107.00 instead of $102.00.
  • Consequently, the markup calculation is also incorrect:
  • Expected Markup: $20.40 CAD (20% of $102.00)
  • Actual Markup: $21.40 CAD

 

Impact

This issue was initially found in the Sandbox, but my clients have also reported it in the Production environment.

 

Expected Behavior

  • The system should respect user-defined tax adjustments instead of recalculating them automatically.
  • The markup should be based on the adjusted total, not the system-recalculated amount.

 

Could you please confirm if this is a expected behavior or known issue and suggest a possible resolution?

 

Thank you.

Check my loom video.

1 Comment 1
EduardA
QuickBooks Team

Quickbooks ignores the custom PST amount in Bill and re-calculates it for Invoice.

Welcome to the Community, maksymrudiuk. We appreciate you taking the time to provide more details on this matter to facilitate accurate invoice adjustments. I want to provide you with some helpful information regarding on this.

 

If your client is using the Sandbox environment, please note that any adjustments should sync in real time, as QuickBooks has already recalculated them. However, it's essential to double-check these adjustments for accuracy.

 

For the time being, you're encouraged to manually adjust the relevant parameters on either the invoice or bill, as needed, to accurately reflect the intended amounts.

 

If you require immediate assistance, please feel free to contact our live support. Here's how you can do that:

 

  1. Click on the (?) Help icon.


     
  2. Select the Search tab.
  3. Enter 'live support' in the box that says Search questions, keywords, or topics.


     
  4. Click Contact Us.

 

Additionally, we'd like to share this material in case you want to add estimates to progressive invoices in QuickBooks Online: Add project estimate summaries.

 

If you have any further questions concerning invoices, please feel free to revisit this post. The Community page is always prepared to lend its support.

Need to get in touch?

Contact us