Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
November 9, 2021
Solved

Quickbooks invoice numbers sequence is different when invoicing in multi currency and home currency

  • November 9, 2021
  • 2 replies
  • 8 views

We invoice customers in USD and in CAD Canadian dollars. Canadian customer are set up for this process, as well as separate USD customers.

 

When invoicing the Canadian dollars customers, Quickbooks assigns an invoice number that is out of sequence with the automatic invoice number assignments. Why does Quickbooks not pick up the next numerical invoice number when invoicing CAD customers, regardless of whether we are invoice USD customers or CAD customers.

Best answer by BigRedConsulting

Just like each of your checking accounts, each A/R account in QuickBooks has its own numbering sequence. In the case of multi-currency, you have to use multiple A/R accounts - one for each currency - and so you'll always have multiple numbering sequences for invoices.

2 replies

Level 4
November 9, 2021

Thanks for inquiring about the process of currency exchange in QuickBooks Online (QBO). You've come to the right place,pennees.

 

Regarding your concern, every currency has different sequence. CAD won't follow the sequence of USD and other currencies. QuickBooks separate sequences every sales transactions to organize and it would not mess up the books. 

 

Read through the overview of this article about setting up Multi-currency in QuickBooks Desktop: Set up and use Multicurrency.

 

Also, when you turn on multicurrency, QuickBooks uses exchange rates to get the home currency values of your foreign currency transactions. The system also uses exchange rates for your reports. It converts foreign currency amounts to home currency values, regardless of what is used in transactions.

 

I'm also adding this helpful article about the maximum number of characters you can enter in each field: Character Limitations.

 

Let me know if you need additional information by commenting below. I'll be around if there's anything else I can do with the number sequence in QuickBooks.

BigRedConsulting
Level 15
November 9, 2021

Just like each of your checking accounts, each A/R account in QuickBooks has its own numbering sequence. In the case of multi-currency, you have to use multiple A/R accounts - one for each currency - and so you'll always have multiple numbering sequences for invoices.