Overview
When integrating with QuickBooks, customers may be created with the wrong currency if the system default currency differs from the price list used for invoicing.
For example:
When integrating with QuickBooks, customers may be created with the wrong currency if the system default currency differs from the price list used for invoicing.
For example:
- QuickBooks default currency: USD
- Customer price list: CAD
If the customer's default price list is not configured correctly, the customer may be created in USD, while pricing is coming from a CAD price list, resulting in incorrect invoice totals and currency mismatches.
Cause
This issue typically occurs when:
The customer does not have a default price list assigned, or
The default price list does not have a valid ISO currency code configured, or
Cause
This issue typically occurs when:
The customer does not have a default price list assigned, or
The default price list does not have a valid ISO currency code configured, or
- The QuickBooks default currency differs from the pricing currency used in the system.
When this happens:
The customer is created in QuickBooks with the system default currency (USD).
The customer is created in QuickBooks with the system default currency (USD).
- The price list sends CAD pricing, but QuickBooks interprets it as USD, causing incorrect invoice values.
Solution
Steps to Fix for Quickbooks online Connection
Go to Advanced > Administration > Quickbooks Online > Edit and Toggle Use Default Pricelist
To ensure the correct currency is sent to QuickBooks, the customer must have a valid default price list configured.
Before updating your customer currency ensure that your Pricelist ISO currency code is configured in Advanced> Administration > Portal Settings > Price Lists
Steps to Fix Customer Profile Pricelist
Open the Customer Profile in Blastramp.
Locate the Default Price List field.
Select the appropriate price list for that customer.
- Ensure the selected price list has the correct ISO currency code (for example, CAD or USD).
- Save the customer record.
- Sync invoice to QuickBooks.
Important Notes
The currency sent to QuickBooks is determined by the customer's default price list.
If no price list is selected, QuickBooks will fall back to its default currency.
- All price lists used for QuickBooks integration must have a valid ISO currency code configured.
Best Practices
To avoid currency issues:
Ensure all customers have a default price list assigned.
Verify price lists have correct currency ISO codes.
- Confirm that pricing currency matches the intended QuickBooks billing currency.