I’m frustrated

Total Balance Incorrect (Maybe Because of Multiple Currencies?)

I have accounts in Squirrel which are in Australian dollars and Japanese yen. At first, the accounts were summed correctly to calculate the total balance (by converting the yen into dollars and then adding them). Now however, the figure is completely wrong. At first I thought it was treating yen as dollar amounts but that's not the case.

Is there a way to refresh the calculation of the total balance? I've had a look around and can't see if there is.

In terms of my setup, I have Squirrel 2 for iPhone and am running Squirrel on the Mac. My iPhone is set to use Japanese as my language but my region is Australia. On the Mac, everything is in English and my base currency is Australian dollars.
2 people have
this question
+1
Reply
  • The amount value of each transaction in the base currency is automatically calculated. There is no way to "refresh the calculation", it's constantly updated as you edit amounts.

    You might have some transactions with an incorrect amount in the base currency. You can display a column with this amount by entering "defaults write com.squirrelapp.squirrelmac TransactionTableAmountInBaseCurrencyColumn -bool yes" in the terminal and restarting Squirrel. Type "defaults write com.squirrelapp.squirrelmac TransactionTableAmountInBaseCurrencyColumn -bool no" to hide it again. This column will show the amount in Australian dollars. Let me know if you find any inconsistencies.

    Your settings seem to be OK on both the Mac and the iPhone.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • I’m confident
    Thanks for the reply, Axel :)

    I've changed the defaults and can now see that the problem is occurring in both wallets. To provide greater detail my set up is as follows:

    Credit Card No. 1 ($AUS)
    Credit Card No. 2 (¥JPY)
    Credit Card No. 3 ($AUS)
    Savings No. 1 ($AUS)
    Savings No. 2 ($AUS)
    Savings No. 3 ($AUS)
    Savings No. 4 (¥JPY)
    Savings No. 5 (¥JPY)
    Cash No. 1 (¥JPY)
    Cash No. 2 (¥JPY)

    Obviously all the Australian accounts are fine. For the Japanese currencies, I'll start from the top.

    Credit Card No. 2
    -----------------------

    There are no transactions in this account.

    Savings No. 4
    ------------------

    There are several transactions in this account. They are all correct.

    Savings No. 5
    ------------------

    There are no transactions in this account.

    Cash No. 1
    ---------------

    There are several transactions in this account. Initially, I can see that they were functioning correctly. They started to go haywire after I transferred funds from Cash No. 2. After this, the amounts appear to be incorrect by a large margin.

    For instance, a purchase of 148 yen on 24 November is listed in the base currency as $296.82. I don't have the exchange rates at the time but according to Google 148 yen should be $1.73. It appears that, after this transfer, all further expenses put into this account had the wrong exchange rate.

    Cash No. 2
    --------------

    There are several transactions in this account. Unlike the other cash account this account never seemed to be working properly. The initial amounts are listed in a base currency as being exactly the same. So an expense of 1000 yen is shown in the base currency as $1,000.

    --

    I don't remember clearly but I believe that I created the Cash No. 2 account on the iPhone whereas I created the other accounts on the Mac.

    Suggestions?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • The exchange rate for each transaction is calculated based on the transfer you have between your accounts. For example, if you transfer AUD100 = 8000 JPY to a JPY account, then Squirrel will use this exchange rate for the following transactions.
    If you don't have any transfer, then Squirrel uses the original exchange rate of the account. This exchange rate is the one specified when you create the account on the Mac app. If you create the account on the iPhone app, an exchange rate of 1 is applied.

    Try changing the currency of Cash No. 2 on the Mac application. Set it to AUD, then back to JPY. Squirrel will ask for an exchange rate. Choose the one you want.

    The amounts in Cash No. 1 should be fixed once everything is updated.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated

  • I’m thankful
    Yep! It appears to be fixed (I had to restart the app to see the total correctly update). Thanks for nutting that one out! :)
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. indifferent, undecided, unconcerned happy, confident, thankful, excited kidding, amused, unsure, silly sad, anxious, confused, frustrated