[GNC] Multi-currency split

[Murugan Mariappan]

In the example i sent

Grocery : XCD Account
Petty Cash: XCD Account
Credit Card: USD Account

Is this the same way you have structured it?

In your example you state that you are entering XCD 90.2  from credit card what is the counter entry you make in the credit card account?


Saludos Cordiales


Murugan

________________________________
From: Fred Tydeman <tydeman.fred at gmail.com>
Sent: 26 November 2024 19:17
To: Murugan Mariappan <m.muruganandam at hotmail.com>
Cc: Gnucash Users <gnucash-user at gnucash.org>
Subject: Re: [GNC] Multi-currency split

Sorry, but that does not work for me.
I am in the XCD account.  I enter all amounts as if they were the XCD amounts on the receipt.
So, I enter 108.32,  90.02, and 18.30.
Based upon what I see in the splits, the 108.32 is done as USD, not XCD.
Also, the credit card is done as USD, not XCD.
When I click on Enter, an Imbalance-XCD split appears.
Using Jump on the splits, the 108.32 and 90.02 were done as USD.
It appears one needs to know the currency of the other accounts
and enter the amounts in that currency.

If I do it as two separate transactions in the XCD account,
I can enter getting 90.02 from the credit card as first
and spending 108.32 on groceries as second.
That way, I do not need to know the USD amounts


On Mon, Nov 25, 2024 at 8:31 PM Murugan Mariappan <m.muruganandam at hotmail.com<mailto:m.muruganandam at hotmail.com>> wrote:
Fred

Apologies for the miscalculation of 36.16.
Regarding your request to enter the expenses without knowing the USD amount, the transactions should be recorded in XCD. Here’s how the entries would look:

  *   Dr Expenses: Groceries: XCD 108.32
  *   Cr Cash: XCD 18.30
  *
Cr Credit Card (USD): $33.49 (as per your statement), debit amount should be entered as XCD 90.02 on the pop up window.

Check the images, if you are not using trading account, you will not see the additional entries. Let me know if this works for you




Saludos Cordiales


Murugan

________________________________
From: Fred Tydeman <tydeman.fred at gmail.com<mailto:tydeman.fred at gmail.com>>
Sent: 25 November 2024 16:22
To: Murugan Mariappan <m.muruganandam at hotmail.com<mailto:m.muruganandam at hotmail.com>>
Cc: Gnucash Users <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Subject: Re: [GNC] Multi-currency split

Is there a way to do that without knowing the USD cost of the groc.?
If so, in which account should the transaction be made?

I had already done it as two transactions before I asked this question.
Doing it that way, the USD groc. cost is 40.13 (not your 36.16).

The official USD to XCD conversion rate is 2.7
The credit card is using 2.688

On Mon, Nov 25, 2024 at 2:25 PM Murugan Mariappan <m.muruganandam at hotmail.com<mailto:m.muruganandam at hotmail.com>> wrote:
The entries will look like

Dr Expenses: Groceries USD 36.16
Cr Liab: Credit Card USD 33.49
Cr Cash: XCD Cash XCD 18.3 (USD 2.67)

i have assumed the same exchange rate as credit card.





Saludos Cordiales


Murugan

________________________________
From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail.com at gnucash.org<mailto:hotmail.com at gnucash.org>> on behalf of Fred Tydeman <tydeman.fred at gmail.com<mailto:tydeman.fred at gmail.com>>
Sent: 25 November 2024 15:05
To: Gnucash Users <gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>>
Subject: [GNC] Multi-currency split

My home currency is USD
I have an expense account for groc. in USD
I have a cash account for XCD
I have a liability credit card account in USD
I buy some groc. in Antigua
I pay with 18.30 XCD (local currency)
and 90.02 XCD via credit card that shows as USD 33.49

I could record this as two transactions:
  USD 33.49 -> 90.02 XCD;  credit card to cash
  108.32 XCD -> ??? USD; cash to groc expense
How would I record this as one transaction with splits?
And, in which account should I do this?
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
To update your subscription preferences or to unsubscribe:
https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-user&data=05%7C02%7C%7C0cfd0aeb9d104df6ea1d08dd0d7c08a8%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C638681548557227929%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=lv3Hl9GFzynffNyxfVcOlwmlxizprXur3T8cpjzl1b4%3D&reserved=0<https://lists.gnucash.org/mailman/listinfo/gnucash-user>
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.