Re: [GNC] how to encode ATM withdrawals with fees
It looks like you are missing the Fee JPY split. What you are showing in the splits is that PHP4282.49 = JPY1, but that's not what you listed in 'facts'. That shows PHP4282.29 = JPY10110. I'm guessing your Fee expenses account is in PHP. If so, you have a few choices: 1. Create a Fee JPY account. 2. Use a separate transaction for the Fee 3. Enter the initial withdrawal split in JPY first, let GnuCash add the trading splits, then enter the fee split in JPY and let it either adjust the trading splits or add new ones. (which you might be able to combine afterwards) #1 is probably acceptable, because you did indeed pay the fee in a foreign currency. #2 isn't ideal because it artificially breaks up a real world event, but if #3 doesn't work, or #1 isn't amenable to you, it might be the only way. As your current transaction stands, you could leave the Fee as PHP even though that isn't quite correct, but then you have to reduce the PHP Trading split by PHP311.28, which is also incorrect because it would mean a different exchange rate. (if that is important to you) Others may have better suggestions. Regards, Adrien On 1/14/24 10:04 AM, Gio Bacareza wrote: when withdrawing at a foreign location, most of the time you get charged a fee. So, for example, your bank is in PHP, then when you're in Japan, you withdraw in JPY. Here are the facts: 1. You receive JPY10,000.00 2. ATM charges JPY110.00 3. Your local bank shows a withdrawal of PHP4282.49 4. At the time of this transaction the exchange rate was: JPY1 = PHP0.3928 or PHP1 = JPY2.5456 in GNUCASH, the splits I have are: Account Deposit Withdrawal JPYCash JPY1 0 Fee PHP PHP43.21 0 Imbalance PHP PHP311.28 0 Trading:CURRENCY:PHP PHP3928 0 Local Bank PHP 0 PHP4282.49 Trading:CURRENCY:JPY 0 JPY1 Questions: 1. What is the easiest way to do this? I find this one transaction to be of so many steps. Perhaps there's a way that I don't know of? 2. Is there an easier way to specify the 110JPY fee if my base currency is PHP? I had to manually convert it using the date's exchange rate to come up with the equivalent PHP43.21. 3. The imbalance-PHP was automatically calculated by GNUCASH. Is this considered to be my loss from the difference between the bank's exchange rates and the one I used which I got from https://www.exchange-rates.org/exchange-rate-history/jpy-php? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] FAQ (WAS: End of Year?)
I agree. I think part of this is UI design choices. It isn't that GnuCash made wrong ones, but rather that folks might be more familiar with other design patterns. These might also be the folks that don't like to read manuals. They are never going away, though some may eventually relent and crack the books, and there will always be a new crop of users in this category. It was these folks that I was alluding too with my comment about re-working the website to more prominently highlight the various help & documentation resources. Also, we don't know or hear from new users who *do* bother to read first and/or experiment and investigate on their own before asking questions. They might far outnumber the first crowd. Having first used computers in the very early 80s, by the time I found GnuCash, I was already quite used to apps with extensive menus and lots of functions and features. And I was already somewhat versed in double-entry and basic accounting with no illusions that it should be brain-dead easy, effortless, and simple. I also wasn't scared or timid with computers so much that I was paralyzed mentally from trying or testing anything with my financial data. I've crashed more apps and OSs and even fried more electronics than I can possibly list. (Losing a term paper you worked on for 12 hours straight because the system crashed when you tried to print it will teach you resilience like few other things can.) Thus, when I started using GnuCash, I had an entirely different perspective, expectation, and sense of adventure than likely anyone who is just now in 2023 wanting to 'get on a budget' and track their finances. I offer that little story as an illustration that we are all coming to the use of GnuCash from vastly different places. That will never change. What can change is how GnuCash and its resources appear to the various perspectives of its users. But it doesn't have to change. Regards, Adrien On 1/14/24 4:04 AM, David T. via gnucash-user wrote: On a side rant, the fact that every year there is a spate of new users asking the same set of questions that are covered extensively in some form of the documentation underscores a disconnect that the community hasn't worked out. For whatever reason, the disconnect between how Gnucash is viewed by the outside world and how it actually works seems to cause a significant range of new user difficulties. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] Viewing account balances of today
On the accounts tab, top right corner (down pointing arrow): Click on: Present or Present(USD) Depends upon how you want stocks/mutual funds to show up (shares or dollars) On Sun, Jan 14, 2024 at 8:21 AM Thomas wrote: > Hello everybody, > > I was wondering whether it is possible to change the account overview of > GnuCash to the status of the current day. > > What I mean is the following: > Usually, when I have some scheduled transactions or some expected > transactions for the future, they show up in the balance and in the > account overview immediately, even though they have a date in the future. > > What I am looking for is the possibility to switch the account overview > to include "all bookings up to today" (excluding transactions in the > future). Is there such a feature or possibility to configure GnuCash > like that? > > E.g., > (yesterday) Grocery shopping: 10 € > (today) Brunch: 15 € > > (tomorrow) Monthly energy consumption deposit: 50 € > > I'd like to see the status in the account overview where GnuCash > (literally) draws the line ;-) > > > Thanks a lot in advance for any hints and pointers! > > Best regards, > Thomas > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] how to encode ATM withdrawals with fees
I just do it simply by taking the amount in the foreign currency and the TOTAL amount that affects my bank, and roll any fees into the exchange rate. So in your case, a simple transaction of 10,000 JPY to 4282.49 PHP. Unless there is really some required reason to keep track of the fees? -derek On Sun, January 14, 2024 11:04 am, Gio Bacareza wrote: > when withdrawing at a foreign location, most of the time you get charged a > fee. So, for example, your bank is in PHP, then when you're in Japan, you > withdraw in JPY. > > Here are the facts: > 1. You receive JPY10,000.00 > 2. ATM charges JPY110.00 > 3. Your local bank shows a withdrawal of PHP4282.49 > 4. At the time of this transaction the exchange rate was: JPY1 = PHP0.3928 > or PHP1 = JPY2.5456 > > in GNUCASH, the splits I have are: > > Account Deposit Withdrawal > JPYCash JPY1 0 > Fee PHP PHP43.21 0 > Imbalance PHP PHP311.28 0 > Trading:CURRENCY:PHP PHP3928 0 > Local Bank PHP 0 PHP4282.49 > Trading:CURRENCY:JPY 0 JPY1 > > > Questions: > 1. What is the easiest way to do this? I find this one transaction to be > of > so many steps. Perhaps there's a way that I don't know of? > 2. Is there an easier way to specify the 110JPY fee if my base currency is > PHP? I had to manually convert it using the date's exchange rate to come > up > with the equivalent PHP43.21. > 3. The imbalance-PHP was automatically calculated by GNUCASH. Is this > considered to be my loss from the difference between the bank's exchange > rates and the one I used which I got from > https://www.exchange-rates.org/exchange-rate-history/jpy-php? > > Thanks > > gio > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > 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. > -- Derek Atkins 617-623-3745 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] Viewing account balances of today
Hello everybody, I was wondering whether it is possible to change the account overview of GnuCash to the status of the current day. What I mean is the following: Usually, when I have some scheduled transactions or some expected transactions for the future, they show up in the balance and in the account overview immediately, even though they have a date in the future. What I am looking for is the possibility to switch the account overview to include "all bookings up to today" (excluding transactions in the future). Is there such a feature or possibility to configure GnuCash like that? E.g., (yesterday) Grocery shopping: 10 € (today) Brunch: 15 € (tomorrow) Monthly energy consumption deposit: 50 € I'd like to see the status in the account overview where GnuCash (literally) draws the line ;-) Thanks a lot in advance for any hints and pointers! Best regards, Thomas ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
[GNC] how to encode ATM withdrawals with fees
when withdrawing at a foreign location, most of the time you get charged a fee. So, for example, your bank is in PHP, then when you're in Japan, you withdraw in JPY. Here are the facts: 1. You receive JPY10,000.00 2. ATM charges JPY110.00 3. Your local bank shows a withdrawal of PHP4282.49 4. At the time of this transaction the exchange rate was: JPY1 = PHP0.3928 or PHP1 = JPY2.5456 in GNUCASH, the splits I have are: Account Deposit Withdrawal JPYCash JPY1 0 Fee PHP PHP43.21 0 Imbalance PHP PHP311.28 0 Trading:CURRENCY:PHP PHP3928 0 Local Bank PHP 0 PHP4282.49 Trading:CURRENCY:JPY 0 JPY1 Questions: 1. What is the easiest way to do this? I find this one transaction to be of so many steps. Perhaps there's a way that I don't know of? 2. Is there an easier way to specify the 110JPY fee if my base currency is PHP? I had to manually convert it using the date's exchange rate to come up with the equivalent PHP43.21. 3. The imbalance-PHP was automatically calculated by GNUCASH. Is this considered to be my loss from the difference between the bank's exchange rates and the one I used which I got from https://www.exchange-rates.org/exchange-rate-history/jpy-php? Thanks gio ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] End of Year?
On 1/13/2024 10:27 PM, R Losey wrote: Absolutely; there is no reason to do anything special at the end of the year; for many years, I have just kept using GnuCash and have had no issues, but some people like to make yearly archives, or do the "close the books" thing. This perhaps bears repeating. MOST of us are using gnucash for personal accounting, sole proprietorships, organizations, etc. In other words, our entity type is "sole", which means no need for any accounting of ownership share in equity. So MOST of us have no NEED to do any special YE processing beyond "journal entries"* for things like recording depreciation. Things that would be done BEFORE a "close the books". We can do special YE processing but do not have to. Gnucash can produce the normal YE reports without actually closing the books first. BUT --- other forms of entities that are not "sole", that have to be able to show how shares of ownership and/or shares of income/losses are allocated to each owner, probably will have to do a "close the books" and will have to do much of that manually << the "tool" assumes all going to undivided equity >> They will also need some "equity reports". That means is that either we need to be very clear we are only speaking about entities that are "sole". Maybe a reminder once a month? Something in the documentation? Michael D Novack * adjusting transactions where there is no money in or out ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] End of Year?
Folks trying to imitate Pen & Paper using a computer are always going to have to adjust their workflow or make concessions for the difference in formats. This is true no matter the task at hand, or the software used, and is true of things not even accounting related at all. I'm glad GnuCash gives the choice. Some software forces you to do what *it* wants. Not as much as you think. Assuming you were using "journal view" to enter transactions the only real difference is that software like gnucash is "autoposting" (when you hit enter closing the transaction entry process the journal entry is posted to the ledger accounts WITHOUT ERROR --- errors made during the manual posting of pen and ink on paper days were the bane of our existence and we had to learn all sorts of tricks* to find the errors). That's why we had to do a periodic trial balance> Simply entering simple (two account) transactions directly in the ledger is very like the shortcut sometimes used in pen and ink on paper days known as "cashbook accounting" where a small subset of the most popular accounts had their own book separate from the main journal-ledger. Gnucash (or other similar apps) is simply expanding the subset to the entire ledger. But unlike pen and ink on paper days, gnucash can produce as a report the virtual journal of these transactions (they were never entered in journal form) THAT is why I keep saying "if you don't know how you would enter something pen and ink on paper" then your problem is really a bookkeeping question as opposed to a gnucash question. Michael D Novack * example --- "if the difference (the oob amount) is divisible by 9 then look for a transposition of digits" --- thus 51 -15 = 36 which is divisible by 9 251 - 152 = 99 which is divisible by 9 There were other such rules, but transposition errors during posting were the most common error so this was the most import "rule" ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] register auto-complete
It affects Descriptions for sure. I don't know about Notes and Memos as I don't use them but it would be an easy enough thing to check... Regards, Chuck. On 14/01/2024 1:44 am, Adrien Monteleone wrote: DuckDuckGo was unable to verify sender identity That is interesting. Is this only for Descriptions or for Memos & Notes too? *there is no preference. Bugs and kinks are being worked out though. This sounds like a bug, as I doubt that would be intended behavior. (it certainly isn't reasonable to expect, that I can see) Regards, Adrien On 1/13/24 5:06 AM, chuck elliot wrote: The behaviour of register auto-complete, where current transaction input is matched against previous transactions within an account, seems to have changed recently (v.5.5). It now seems to search only the active categories (unreconciled, cleared etc). I normally hide 'reconciled' and so this is a nuisance as I have to fill in details that I know have been input before. I could not find a preferences option for this. Is is configurable? If not, could it be made so or go back to the old way please? I did not find any reference to this in list archives but apologies if it has been raised before. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.
Re: [GNC] FAQ (WAS: End of Year?)
For the record, I'm also against this popup, but for a different reason. The FAQ is an overwhelming never-shrinking aggregation of items that would be better placed in other documentation. Including it on a monthly basis would not really benefit a new user with a specific problem. When I go to the FAQ, I am usually forced to do a find in the page to locate anything. On a side rant, the fact that every year there is a spate of new users asking the same set of questions that are covered extensively in some form of the documentation underscores a disconnect that the community hasn't worked out. For whatever reason, the disconnect between how Gnucash is viewed by the outside world and how it actually works seems to cause a significant range of new user difficulties. David T. On Jan 14, 2024, 1:23 AM, at 1:23 AM, Adrien Monteleone wrote: >Sorry, I would not like to see an FAQ pop up in this list on any >periodic basis. > >What you are describing there is akin to a 'sticky' or 'pinned' post in > >a web forum. > >This is not a web forum. > >We have the Wiki, which has the FAQ section. We also have the Help >Manual, and the Tutorial & Concepts Guide. Those are better places for >standard, regular advice on how to use the software. This list serves a > >different purpose — to offer assistance that those sources don't (maybe > >yet) cover. > >Some redesign of the website pointing to the FAQ might be in order, but > >that would take some careful analysis, and of course, someone to code >the changes. > >Regards, >Adrien > >On 1/13/24 11:19 AM, R Losey wrote: >> But the larger issue is that I believe this email list could benefit >from a >> FAQ that is posted monthly or every other month to this group. The >wiki has >> some neat ideas about tracking year to year equity growth. > >___ >gnucash-user mailing list >gnucash-user@gnucash.org >To update your subscription preferences or to unsubscribe: >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. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: 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.