cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Arden7
Level 3

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

Hi Fiona, I have had so many problems with QBO foreign currencies especially in the purchase ledger...with no cumulatve balances in foreign amounts, having to export to excel to get my balances....its been an absolute nightmare...and for this and issues such as yours,  I for one would not enrol anymore clients to QBO. There keep on giving standard replies and not changing anything..these foreign currencies issues are so basic and yet QBO are giving the users a hard time.

jean-howardwilso
Level 2

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

If only that were the only issue I am having.....Stock is a complete nightmare as well.  Anything with a foreign currency leaves 1ps even if everything is sold.  You end up with a list of zero qtys but a value of 0.01 !!!! Changing to FIFO was a ridiculous mistake by Intuit.  There are also glitches when is doesn't put the COS into the P&L.  You have to delete the line on the invoice, re-enter it and miraculously it appears.  Anyone who doesn't reconcile the COGS account to sales is going to end up with balance sheet being overvalued and P&L overstated.  My advise, if you have stock, DONT use QBO, find an alternative otherwise your accounts will not be correct, or it will take hours to find the differences.  Luckily for me, I am old school, grew up having to do accounts manually without the use of computers.  Anyone without that background does not have a hope in hell of looking for differences.  

Arden7
Level 3

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

i know QBO is a complete nightmare!

you are having deep issues with stock, others are having issues with fx balance sheet. Can see this, can see that....What the F*** are QBO doing!

i am having fundamental issues with the purchase ledger, and even the presentation is rubbish. In an individual purchase/supplier account at top right shows OPEN Balance and OVERDUE balance....guess what...it does not show the straight actual balance!...So if you have not tied everything invoices to payments....you will be seeing the wrong balances...The way to see the correct balance is to go back to your supplier list!....Mama mia! have to do so many more searches to see the correct info....a disgraceful software...

Arden7
Level 3

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

Should read: Can't see this, can't see that....What the F*** are QBO doing!

Arden7
Level 3

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

..and to follow up...on ...Supplier in foreign currency: "guess what...it does not show the straight actual balance!.."

there is a balance at the bottom of the supplier page...but its in the home currency! causing more confusion! It should be in the same currency as the transactions. And it shouldnt be at the bottom....It should be at the top where new transaction are being placed...QBO a complete nightmare!

Arden7
Level 3

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

Its simple Fix the issues, Don't give us bullsh*t,   or  Resign from this company and work for a company that produes a good robust product!

amalvinoth
Level 1

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

Focus on functionality first before focusing on report layout and beautification bu*lsh*t (I'm referring to 'New Enhanced Experience' - My foot). Honestly, at least add a temporary report for now (even a crappy one) to see the balances I can truly collect from my customers. In my country, the exchange rate fluctuates like a roller coaster and this has created redundancy in my organization to maintain multiple sheets to see the actual balances.

Arden7
Level 3

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

there is no report that i've found. QBO have not fixed the issue. And I don't know whether they ever will!

I maintain loads of foreign currency balances in the foreign currency in EXCEL!  I have no option but to duplicate my work in order to see the correct balances and running balances in the foreign currency. QBO is a disgrace.

Suggestion: keep an eye open on other products on the market...and as son as you see something better go for it and dump QBO. QBO are not responsive. They have their own agenda of pasting "lip-stick" on their product and "crab-trap" as many customers as they can! The old adage applies "buyer beaware".

jean-howardwilso
Level 2

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

Trouble is those of us who were on Desktop (which was brilliant) had no choice but to transfer to Online which is substandard in comparison.  If I had 1p for every time I say "you could do this on desktop but cant' on online" I would be a millionaire!!  I keep posting negative feedback but never any response. If they asked users, they would ditch the fancy report layouts and focus on content.  I don't want an excel report that I keep having to unwrap text and take off merged cells.  They don't understand why we want to put data into excel!!!!

Arden7
Level 3

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

I have been complaining - more appropriately pointing out their flaws- for a while but it seems QBO have wax in their ears! I am having to use Excel like a partner software to QBO. That is without Excel, the QBO software would be completely useless.

 

You are correct Desktop was brilliant. We were not offered a choice. Or at least the choice was accept QBO or leave. Those who accepted QBO are (slowly...slowly...) finding they were guided into a trap. I expect there are stil people buying into QBO and they will not know that they are trapped until a year or two has elapsed! Its a shame / and a disgrace.

JC_1984
Level 1

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

Still no solution from QB for this???

Aldren18
QuickBooks Team

Is there a report that shows foreign balance and home currency balance of all balance sheet accounts ?

I appreciate your patience, JC. The ability to view both foreign and home currency balances is vital for your business. While QuickBooks Online (QBO) doesn’t currently provide this report, I can suggest some effective workarounds to meet your requirements.

 

First and foremost, I encourage you to communicate your thoughts directly with our product development team. They genuinely value customer input and are eager to hear your suggestions.

 

To proceed, here's how:

 

  1. Open your QBO account.
  2. Go to the Gear icon located at the top-right corner of your screen.
  3. Under the Profile section, select Feedback.
  4. Type in your suggestions and then click on Next.

 

In the meantime, you can run the Balance Sheet Detail report and export it to Excel for manual adjustments to display foreign balances alongside home currency balances.

 

For detailed steps, here's how:

 

  1. Open the Balance Sheet Detail report.
  2. Click on the Export dropdown and select Export to Excel.
  3. Open the downloaded file and manually add a column for the home and foreign currency balances.

 

I've included a screenshot for your reference:

 

03d1cb2b-a74b-4c9d-b06a-cceb9d0f56a8.png

 

You could also explore third-party applications specializing in multi-currency reporting in our QuickBooks App Store. You can find available options by navigating to the CATEGORIES section to select an app that best suits your needs.

 

Moreover, I'd like to share this valuable resource to help you optimize your reporting in QBO: Customise reports in QBO.

 

Your insights are invaluable as we strive to improve our reporting capabilities and better serve our users. If you have further questions or concerns navigating our software, reply to this forum. I’m dedicated to ensuring you receive a prompt response.