Re: [GNC] Foreign Currency Receivable
GnuCash Developers and Maintainers: I believe that I have no more problems with Steam revenue's accounting. Thanks a lot for your help. Regards, Bite Gao May 26th, 2022 On 2022-05-26 12:59, John Ralls Wrote: Gao, You have a couple of options. The simplest would be to just ignore that USD is involved at all and convert all of the USD amounts to CNY and post the CNY amounts to GnuCash. That obviously loses a bit of detail. Next up in complexity would be to create some USD accounts for income, expense, and accounts receivable (make that account type bank, not type accounts receivable, for this approach). You'll post those from the monthly statements. When you receive the actual payment you'll credit accounts payable in USD and debit your CNY bank account using whatever exchange rate your bank gives you on the conversion. Depending on how you handle the withheld taxes you also may need a USD or CNY asset account for pre-paid taxes. If you keep the payments in a USD-denominated account then you'd create a bank account in GnuCash to model it and debit it on payments. If you want to track unit sales you could make the income account in CNY and use the CNY->USD exchange rate reflected in your statement. For example if you price the game at CNY 150, you sold 10 of them in April, and your steam statement says that your revenue was USD 100 then you'd credit income CNY1500 and debit Expenses:commision USD 30, Assets:Prepaid taxes or expenses:taxes (depending on how you have to handle the taxes), and Assets:AccountsPayable USD 60. Then when you get the payment and your bank converts the USD 60 into CNY 800 you'd credit accounts payable USD 60, debit CNY 800 and debit Income:Trading Gains CNY 100. If you want you could go a step further and use the business module to convert the steam statement into an invoice. In that case you'd make the accounts payable account type accounts payable. IIRC the business model doesn't know how to handle the exchange rates and trading gains so you'd have to do that part manually, but it might provide some reports that you'd find useful enough to justify the extra work. On May 25, 2022, at 5:25 PM, Gao Bite wrote: Mr. or Mrs. Novack: Hello! I am probably not making myself clear in the last e-mail, so I wish that you could allow me to clarify myself in this e-mail. I put my game on the Steam platform and priced it in CNY. Let us assume that purchases happen in March. When players in China buy the game, they pay in CNY (without having notice of foreign exchange done by Steam's partner), and Steam possibly receives their payments in USD. At the end of March, I received an invoice telling me about data for the game's sales in March, a 30 percent deduction from the Steam platform, and a 10 percent of income tax. At the end of April, I received my part in USD. I wonder if I clarified myself in this e-mail. If you still have some points not sure about, I wish that you could let me know it. On 2022-05-25 22:23, Michael or Penny Novack wrote: On 5/25/2022 12:01 AM, Gao Bite wrote: GnuCash Developers and Maintainers: Hello! I am a Chinese developer who sells games on the Steam platform. When I sell my game work on steam, I receive the sales report every month containing data for last month's game selling. And I will receive last month's money in USD at the end of this month. My base currency is CNY. How can I perform my accounting to record the gain and losses from game selling and foreign exchange separately? What data is on this statement beyond gross amount in USD? Is the site doing all transactions in USD (games sold for some price in USD as opposed to the currency of the buyer). If you are selling different games at various prices, unless you are told how many of each However it might be simpler for somebody like yourself who is the fabricator of an intangible << most sellers would be selling tangible goods with an associated "cost of goods" but possibly/probably you do not* >> ARE you selling goods at some price in USD, does your statement make clear how many units sold (at what price) , does it show the fees the agent is deducting, etc? Possibly there is no currency exchange involved YET. Maybe the only gains/losses form currency exchange would between the time you receive this statement and payment in USD and you get that converted into CNY in your bank account. In other words, if you receive a statement from the agent "sales in March were $XXX (as of 3/31) but you do not receive into your bank account YYY in CNY until April 25th you might want to consider the value of ($xxx - fees) in CNY as of march 31 the base and any difference between that and the CNY going into your bank on April 25th a gain or loss from currency exchange. Michael D Novack * But if you had programmers working for you, you possibly/probably would be associating a "cost of goods" separating your business operation between "production" and
Re: [GNC] Foreign Currency Receivable
Gao, You have a couple of options. The simplest would be to just ignore that USD is involved at all and convert all of the USD amounts to CNY and post the CNY amounts to GnuCash. That obviously loses a bit of detail. Next up in complexity would be to create some USD accounts for income, expense, and accounts receivable (make that account type bank, not type accounts receivable, for this approach). You'll post those from the monthly statements. When you receive the actual payment you'll credit accounts payable in USD and debit your CNY bank account using whatever exchange rate your bank gives you on the conversion. Depending on how you handle the withheld taxes you also may need a USD or CNY asset account for pre-paid taxes. If you keep the payments in a USD-denominated account then you'd create a bank account in GnuCash to model it and debit it on payments. If you want to track unit sales you could make the income account in CNY and use the CNY->USD exchange rate reflected in your statement. For example if you price the game at CNY 150, you sold 10 of them in April, and your steam statement says that your revenue was USD 100 then you'd credit income CNY1500 and debit Expenses:commision USD 30, As sets:Prepaid taxes or expenses:taxes (depending on how you have to handle the taxes), and Assets:AccountsPayable USD 60. Then when you get the payment and your bank converts the USD 60 into CNY 800 you'd credit accounts payable USD 60, debit CNY 800 and debit Income:Trading Gains CNY 100. If you want you could go a step further and use the business module to convert the steam statement into an invoice. In that case you'd make the accounts payable account type accounts payable. IIRC the business model doesn't know how to handle the exchange rates and trading gains so you'd have to do that part manually, but it might provide some reports that you'd find useful enough to justify the extra work. Regards, John Ralls > On May 25, 2022, at 5:25 PM, Gao Bite wrote: > > Mr. or Mrs. Novack: > > Hello! I am probably not making myself clear in the last e-mail, so I wish > that you could allow me to clarify myself in this e-mail. > > I put my game on the Steam platform and priced it in CNY. Let us assume that > purchases happen in March. When players in China buy the game, they pay in > CNY (without having notice of foreign exchange done by Steam's partner), and > Steam possibly receives their payments in USD. At the end of March, I > received an invoice telling me about data for the game's sales in March, a 30 > percent deduction from the Steam platform, and a 10 percent of income tax. At > the end of April, I received my part in USD. > > I wonder if I clarified myself in this e-mail. If you still have some points > not sure about, I wish that you could let me know it. > > Yours, > > >Bite Gao > > May 26th, 2021 > > On 2022-05-25 22:23, Michael or Penny Novack wrote: >> On 5/25/2022 12:01 AM, Gao Bite wrote: >>> GnuCash Developers and Maintainers: >>> >>> Hello! I am a Chinese developer who sells games on the Steam platform. >>> When I sell my game work on steam, I receive the sales report every month >>> containing data for last month's game selling. And I will receive last >>> month's money in USD at the end of this month. My base currency is CNY. >>> >>> How can I perform my accounting to record the gain and losses from game >>> selling and foreign exchange separately? >> >> >> What data is on this statement beyond gross amount in USD? Is the site doing >> all transactions in USD (games sold for some price in USD as opposed to the >> currency of the buyer). If you are selling different games at various >> prices, unless you are told how many of each However it might be >> simpler for somebody like yourself who is the fabricator of an intangible << >> most sellers would be selling tangible goods with an associated "cost of >> goods" but possibly/probably you do not* >> >> >> ARE you selling goods at some price in USD, does your statement make clear >> how many units sold (at what price) , does it show the fees the agent is >> deducting, etc? Possibly there is no currency exchange involved YET. Maybe >> the only gains/losses form currency exchange would between the time you >> receive this statement and payment in USD and you get that converted into >> CNY in your bank account. >> >> In other words, if you receive a statement from the agent "sales in March >> were $XXX (as of 3/31) but you do not receive into your bank account YYY in >> CNY until April 25th you might want to consider the value of ($xxx - fees) >> in CNY as of march 31 the base and any difference between that and the CNY >> going into your bank on April 25th a gain or loss from currency exchange. >> >> Michael D Novack >> >> * But if you had programmers working for you, you possibly/probably would be >> associating a "cost of goods" separating your business opera
[GNC] register description field width
I have found how to make the fonts large enough to read through inspection of the mailing list history. it is now 14pt. This is great but now the gnucash window has to be almost, 80% of my screen width. 70% of that width is due to the width of the description field. through the mailing lists I have found that double clicking the vertical bars between the fields will adjust them to the width of the data. It works for all but the description field. This field behaves as if there is an extra 200 spaces attached to the end of each entry. Trying to pull the right hand vertical bar will move the header, temporarily, but the field width remains the same. Is there some way to hard code, force, change the width of the description field? Kevin ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Foreign Currency Receivable
Mr. or Mrs. Novack: Hello! I am probably not making myself clear in the last e-mail, so I wish that you could allow me to clarify myself in this e-mail. I put my game on the Steam platform and priced it in CNY. Let us assume that purchases happen in March. When players in China buy the game, they pay in CNY (without having notice of foreign exchange done by Steam's partner), and Steam possibly receives their payments in USD. At the end of March, I received an invoice telling me about data for the game's sales in March, a 30 percent deduction from the Steam platform, and a 10 percent of income tax. At the end of April, I received my part in USD. I wonder if I clarified myself in this e-mail. If you still have some points not sure about, I wish that you could let me know it. Yours, Bite Gao May 26th, 2021 On 2022-05-25 22:23, Michael or Penny Novack wrote: On 5/25/2022 12:01 AM, Gao Bite wrote: GnuCash Developers and Maintainers: Hello! I am a Chinese developer who sells games on the Steam platform. When I sell my game work on steam, I receive the sales report every month containing data for last month's game selling. And I will receive last month's money in USD at the end of this month. My base currency is CNY. How can I perform my accounting to record the gain and losses from game selling and foreign exchange separately? What data is on this statement beyond gross amount in USD? Is the site doing all transactions in USD (games sold for some price in USD as opposed to the currency of the buyer). If you are selling different games at various prices, unless you are told how many of each However it might be simpler for somebody like yourself who is the fabricator of an intangible << most sellers would be selling tangible goods with an associated "cost of goods" but possibly/probably you do not* >> ARE you selling goods at some price in USD, does your statement make clear how many units sold (at what price) , does it show the fees the agent is deducting, etc? Possibly there is no currency exchange involved YET. Maybe the only gains/losses form currency exchange would between the time you receive this statement and payment in USD and you get that converted into CNY in your bank account. In other words, if you receive a statement from the agent "sales in March were $XXX (as of 3/31) but you do not receive into your bank account YYY in CNY until April 25th you might want to consider the value of ($xxx - fees) in CNY as of march 31 the base and any difference between that and the CNY going into your bank on April 25th a gain or loss from currency exchange. Michael D Novack * But if you had programmers working for you, you possibly/probably would be associating a "cost of goods" separating your business operation between "production" and "marketing" because you might want to see how each is doing separately. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Foreign Currency Receivable
On 5/25/2022 12:01 AM, Gao Bite wrote: GnuCash Developers and Maintainers: Hello! I am a Chinese developer who sells games on the Steam platform. When I sell my game work on steam, I receive the sales report every month containing data for last month's game selling. And I will receive last month's money in USD at the end of this month. My base currency is CNY. How can I perform my accounting to record the gain and losses from game selling and foreign exchange separately? What data is on this statement beyond gross amount in USD? Is the site doing all transactions in USD (games sold for some price in USD as opposed to the currency of the buyer). If you are selling different games at various prices, unless you are told how many of each However it might be simpler for somebody like yourself who is the fabricator of an intangible << most sellers would be selling tangible goods with an associated "cost of goods" but possibly/probably you do not* >> ARE you selling goods at some price in USD, does your statement make clear how many units sold (at what price) , does it show the fees the agent is deducting, etc? Possibly there is no currency exchange involved YET. Maybe the only gains/losses form currency exchange would between the time you receive this statement and payment in USD and you get that converted into CNY in your bank account. In other words, if you receive a statement from the agent "sales in March were $XXX (as of 3/31) but you do not receive into your bank account YYY in CNY until April 25th you might want to consider the value of ($xxx - fees) in CNY as of march 31 the base and any difference between that and the CNY going into your bank on April 25th a gain or loss from currency exchange. Michael D Novack * But if you had programmers working for you, you possibly/probably would be associating a "cost of goods" separating your business operation between "production" and "marketing" because you might want to see how each is doing separately. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
