cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
rui1
Level 1

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

 
8 REPLIES 8
John C
QuickBooks Team

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

Hi rui1

 

We would be grateful if you can provide us with a screen shot of the invoice and a screen shot of the accounts receivable report, you can customise > filter the report for this specific customer.

rui1
Level 1

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

Hi John C,

 

DateTransaction TypeNo.Due DateAmountOpen BalanceForeign Open BalanceCurrency
23/11/2018Invoice11856423/12/20189294438,61566,31USD
30/01/2019Invoice11890401/03/2019988,75988,751250USD
10/05/2019Invoice11953310/05/2019407,67407,67532USD
15/04/2019Invoice11934215/05/2019151,66151,66200USD
24/04/2019Invoice11939524/05/20192426,562426,563200USD
29/04/2019Invoice11939429/05/20191607,51607,51607,5GBP
08/05/2019Invoice11949607/06/20193065,23065,24000USD
12/06/2019Invoice11969312/06/20191046,7571,190USD
14/06/2019Invoice11970414/06/2019145,7623,730USD

 

Here's one example from AR report received by e-mail.

Check Invoice nr 119394, fourth line from bottom. 

 

Filtering by customer USD and GBP are the same

07/06/2019Invoice119679 07/07/2019252,50252,50252,50GBP
16/10/2019Credit NoteCR120426 16/10/2019-252,50-252,50-252,50GBP
16/10/2019Invoice120427 15/11/2019204,94204,94255,82USD

 

So this could be a customer setup that is wrong? 

 

GeorgiaC
QuickBooks Team

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

Hey rui1, 

 

Please confirm the settings of the customer invoiced invoice no. 119394  by going to Sales > Customers > Click into customer > Edit > Payment and Billing and view the currency showing under 'This customer pays me with'.

 

Thanks

rui1
Level 1

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

For that customer it does say

" this customer pays me with

GBP British Pound Sterling".

 

We have one Customer for each currency (One for USD and other for GBP)

This invoice is in GBP and is listed in the customer for GBP invoices which  is setup as GBP for payments.

 

 

John C
QuickBooks Team

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

Hi rui1

 

If you have a home currency of GBP and you have set up a customer that pays in GBP any invoices will show as they are in the report you are running, the open balance and the open foreign balance will show the same. If this in an error on your behalf and the customer should pay you in USD you will have to make that customer inactive and re-create the customer pays you in USD.

rui1
Level 1

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

I'm not sure if I understood.

So you're saying that the balance will show me the values in GBP.  But the Foreign Currency  column will be a mix of GBP and USD.

 

So if I need the AR Foreign balance in USD cannot use your report, because i'm having clients that use GBP currency as payment, is this correct? 

 

Can you please advise a solution?

Jen_D
Moderator

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

Glad to have you back, @rui1,

 

For accounts set up for Multicurrency, reports will always reflect the home currency regardless of was used on the transactions.

 

This way it's easier to track how much income is generated from foreign customers using the default medium of exchange. If you want to view a more detailed report showing separate a Debtor accounts for GBP and USD customers, open a Balance Sheets report.

 

Here's how:

 

  1. Go to the Reports menu and select Balance Sheet.
  2. Update the Report period and click Run report.
  3. On the Debtors section, you'll see a separate line for GBP and USD. Drill-down the report to review each sale.

 

To know more about this feature, please check out these resources:

 

About Multicurrency.

How Multicurrency works?

 

If you have other questions or need further clarification, please let me know in the comment. I'll be more than happy to help whenever you need one! Have a good one!

Anonymous
Not applicable

In the accounts receivable report. A invoice issued in GBP. The balance in dollars is showing the same amount as GBP. Any solution for this?

Likely the exchange rate for this invoices was accidentally set to 1.00.
Edit the invoice and correct it.

Need to get in touch?

Contact us