Re: [GNC] Quotes again?
Error accessing query2.finance.yahoo.com/v1/test/getcrumb. Someone worked out a patch for the original problem 2 years or so back which involves setting a crumb, but obviously Yahoo has again changed something and it doesn't work anymore. This particular API apparently hasn't been supported for some time, so this is hardly a surprise. On 2025-02-18 16:53, David G. Pickett via gnucash-user wrote: Quotes on yahoo broke today, something unhappy about getcrumb, I'd cop and paste but it does not allow that! ___ 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] Analytics in Accounts payable
Hi Petrovic/GNUCash users, Like Derek, I'm not sure if I understand your questions... what do you mean by "analytics" - ? When you ask, "How can I check for the Supplier "X" in the system?" are you asking how to search GNUCash for a vendor? With that said, https://wiki.gnucash.org/wiki/FAQ#Using_Multiple_Currencies might be helpful as it discusses "Q: Posting invoice or bill results in zero value transaction in Accounts Payable or Accounts Receivable - why and how to fix this?" & "Q: How can I set up a customer or supplier in a foreign currency?" which might be helpful in narrowing down what you are trying to do. https://wiki.gnucash.org/wiki/GnuCash_Quick_Start_Guide_For_Business_Users might also be helpful. --- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://nextdoor.com/profile/01mP46jj8KCzj3sP4 & https://norcal.social/@BradMorrison On 2025-02-18 09:14, Derek Atkins wrote: > Hi, > > I'm not sure I fully understand what you want to do. A/P is touched via a > Vendor Bill, and then Process Payment. There are also "Credit Notes" that > can be used in lieu of processing payment. > > -derek > > On Tue, February 18, 2025 12:06 pm, Financial EpGhana wrote: > >> Dear all, >> when I want to credit a supplier in Accounts payable, how can I have >> analytics? So that >> at the same time I can credit the supplier X and the Accounts payable is >> automatically credited. >> >> How can I check for the Supplier "X" in the system? >> >> Regards, >> >> -- >> Petrovic Jovan, dipl.oec. >> Financial Controller >> Energoprojekt Ghana Limited >> >> Spintex Road No. 98, Accra Ghana >> Mob (Ghana): +233 20 9030 435 >> ___ >> 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.
[GNC] Quotes again?
Quotes on yahoo broke today, something unhappy about getcrumb, I'd cop and paste but it does not allow that! ___ 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] Reporting Exchange Rates
Thank you John for your reply. Yes, I think I'll end up using the manual adjustment of the Dec 31 price as you mentioned until I can figure out a way to convert individual transactions more efficiently. Thanks again. On Sun, Feb 16, 2025 at 3:04 AM John Ralls wrote: > > > > On Feb 14, 2025, at 19:58, Bo Buckley wrote: > > > > In all examples I've seen so far with regards to the handling of foreign > > currencies the user is physically moving money from one currency to > another > > (e.g. an online transfer) where an actual exchange occurs. What about the > > case where users have to do reports for different countries in their own > > respective currency (e.g. Japan in JPY and US in USD). I must report all > > income in both Japan and the US (thanks IRS!) so I need a way to convert > my > > books between USD and JPY. > > > > For example say I have an Expenses:Advertising account with account > > currency USD and book currency USD. I can deduct these as business > expenses > > both on US and Japanese reports, but I must convert them all to JPY to do > > so. Is there any way of doing this within GNUcash? Until now I've just > been > > creating an Income Statement in USD and copying this to a spreadsheet and > > converting from there (not ideal). > > > > I see in the Income Statement options, I can change the Report's currency > > to JPY, but what is going on in the background here? Are all transactions > > converted per date, or just a single rate used on the totals? Based on > what > > I can see at the bottom of the report, it appears to use the most recent > > rate limited by the report ending date (e.g. 12/31/2024), which would not > > be a standard way to report this. The two options I was told from a > > Japanese accountant to use would be > > 1. (Yearly Average TTS + Yearly Average TTB) / 2 from a Japanese bank > > (e.g. https://www.murc-kawasesouba.jp/fx/year_average.php) > > 2. (Preferred) Use exchange rates specific to each transaction. > > > > Thanks in advance for any advice. > > Which rate is used depends on the price source you pick in the commodities > tab of report options. You can manually create a year-average rate on 31 > December using the price editor and set the price source to Closest to > report date (the default). > > Ideally you’d use the splits’ JPY values (assuming that all of your > Japan-taxable transactions begin in a JPY asset account and so have a JPY > transaction currency). Unfortunately even the transaction report doesn’t > provide that. > > Regards, > John Ralls > > > ___ 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] Analytics in Accounts payable
Dear all, when I want to credit a supplier in Accounts payable, how can I have analytics? So that at the same time I can credit the supplier X and the Accounts payable is automatically credited. How can I check for the Supplier "X" in the system? Regards, -- Petrovic Jovan, dipl.oec. Financial Controller Energoprojekt Ghana Limited Spintex Road No. 98, Accra Ghana Mob (Ghana): +233 20 9030 435 ___ 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] Analytics in Accounts payable
Hi, I'm not sure I fully understand what you want to do. A/P is touched via a Vendor Bill, and then Process Payment. There are also "Credit Notes" that can be used in lieu of processing payment. -derek On Tue, February 18, 2025 12:06 pm, Financial EpGhana wrote: > Dear all, > when I want to credit a supplier in Accounts payable, how can I have > analytics? So that > at the same time I can credit the supplier X and the Accounts payable is > automatically credited. > > How can I check for the Supplier "X" in the system? > > Regards, > > -- > Petrovic Jovan, dipl.oec. > Financial Controller > Energoprojekt Ghana Limited > > Spintex Road No. 98, Accra Ghana > Mob (Ghana): +233 20 9030 435 > ___ > 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.
Re: [GNC] Liabilities vs Expenses.
On 2/18/2025 1:56 AM, John Walker via gnucash-user wrote: In standard bookkeeping, a liability is anything that a business owes for more than the accounting period which is usually 12 months. A mortgage is a good example. An expense is something that is paid out within the accounting period. The electricity bill is a good example. Cheers John It is NOT as simple as that. And this is especially true when accounting for a business << more lee way in personal accounting >> There are RULES set by the jurisdictions to which a business needs to report. Organizations are going to fall in between (they may have more freedom to CHOOSE what rules they will follow, but will have to adhere to their choices.) If accounting for a business, be it sole proprietorship, partnership, or incorporated entity, you will need to learn the rules and/or get professional help. Please not that in general the rules will depend not only on the form of the entity but possibly also on line of business (are you a farm? a publisher of books? a whatever? Michael D Novack PS: To give a concrete example, if a corporation with stock/shareholders a dividend becomes a liability when declared by the Board of Directors even though it might be payable after a only a short time (within the same accounting period). Like I said, you either need to learn or have professional advice. I am NOT qualified to give such advice, so won't, except in the case of small organizations. ___ 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] Liabilities vs Expenses.
> On Feb 17, 2025, at 22:56, John Walker via gnucash-user > wrote: > > In standard bookkeeping, a liability is anything that a business owes for > more than the accounting period which is usually 12 months. A mortgage is a > good example. An expense is something that is paid out within the accounting > period. The electricity bill is a good example. Wherever did you get that idea? See https://www.investopedia.com/terms/l/liability.asp and note in particular the section about 1/4 down the page “Current (near-term) Liabilities”: "Analysts ideally want to see that a company can pay current liabilities that are due within a year with cash. Some examples of short-term liabilities include payroll expenses and accounts payable which can include money owed to vendors, monthly utilities, and similar expenses.” Regards, John Ralls ___ 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] Sequoia
Hi John/GNUCash users, https://wiki.gnucash.org/wiki/FAQ#Using_Different_Versions.2C_Up_And_Downgrade - some information on using different versions of GNUCash. https://www.gnucash.org/download.phtml - the latest version is 5.10 --- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://nextdoor.com/profile/01mP46jj8KCzj3sP4 & https://norcal.social/@BradMorrison On 2025-02-17 11:55, R Losey wrote: > There was a known issue with Sequoia that was only fixed in the most recent > release. > > On Sun, Feb 16, 2025 at 3:08 PM John De Martino via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> Hi >> I have recently upgraded to macOS Sequoia and Gnucash won't load. I was >> using Gnucash 4 so upgraded to 5 with the same problem. Is this a common >> issue and is there a solution. >> Sent from my iPhone >> ___ >> 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] GBP shown in Balance sheet (setup is GHS)
Hi Petrovic/GNUCash users, https://wiki.gnucash.org/wiki/Currency_Maintenance & https://wiki.gnucash.org/wiki/FAQ#Using_Multiple_Currencies are 2 places that currencies are discussed on the GNUCash Wiki. Hopefully that information is still valid for the current version of GNUCash, 5.10 - https://www.gnucash.org/download.phtml --- Thanks, Brad - https://www.facebook.com/brad.morrison.12327/ & https://nextdoor.com/profile/01mP46jj8KCzj3sP4 & https://norcal.social/@BradMorrison On 2025-02-16 12:22, Murugan Mariappan wrote: > please check in the following places for the choice of currency > > In Preferences : Reports: Default Report Currency > In Report: Balance Sheet: Options: Commodities > > Saludos Cordiales > > Murugan > > > From: gnucash-user > on behalf of > Financial EpGhana > Sent: 16 February 2025 09:18 > To: gnucash-user@gnucash.org > Subject: [GNC] GBP shown in Balance sheet (setup is GHS) > > Dear team, > I have a problem with the Balance sheet report. I have set up GHS as a > currency but in a > Balance sheet report I also can see GBP. Why is this happening (please see > in attachment)? > > I also can't understand why Description is a fixed column, it is so basic > and simple, and yet > again it is a problem > > -- > Petrovic Jovan, dipl.oec. > Financial Controller > Energoprojekt Ghana Limited > > Spintex Road No. 98, Accra Ghana > Mob (Ghana): +233 20 9030 435 > ___ > 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] GBP shown in Balance sheet (setup is GHS)
Dear Brad, thanks for the information! That's very helpful. Regards, уто, 18. феб 2025. у 13:52 Brad Morrison је написао/ла: > Hi Petrovic/GNUCash users, > > https://wiki.gnucash.org/wiki/Currency_Maintenance & > https://wiki.gnucash.org/wiki/FAQ#Using_Multiple_Currencies are 2 places > that currencies are discussed on the GNUCash Wiki. > > Hopefully that information is still valid for the current version of > GNUCash, 5.10 - https://www.gnucash.org/download.phtml > > --- > Thanks, > > Brad - https://www.facebook.com/brad.morrison.12327/ & > https://nextdoor.com/profile/01mP46jj8KCzj3sP4 & > https://norcal.social/@BradMorrison > > On 2025-02-16 12:22, Murugan Mariappan wrote: > > > please check in the following places for the choice of currency > > > > In Preferences : Reports: Default Report Currency > > In Report: Balance Sheet: Options: Commodities > > > > Saludos Cordiales > > > > Murugan > > > > > > From: gnucash-user hotmail@gnucash.org> on behalf of Financial EpGhana < > financial.epgh...@gmail.com> > > Sent: 16 February 2025 09:18 > > To: gnucash-user@gnucash.org > > Subject: [GNC] GBP shown in Balance sheet (setup is GHS) > > > > Dear team, > > I have a problem with the Balance sheet report. I have set up GHS as a > > currency but in a > > Balance sheet report I also can see GBP. Why is this happening (please > see > > in attachment)? > > > > I also can't understand why Description is a fixed column, it is so basic > > and simple, and yet > > again it is a problem > > > > -- > > Petrovic Jovan, dipl.oec. > > Financial Controller > > Energoprojekt Ghana Limited > > > > Spintex Road No. 98, Accra Ghana > > Mob (Ghana): +233 20 9030 435 > > ___ > > 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. > -- Petrovic Jovan, dipl.oec. Financial Controller Energoprojekt Ghana Limited Spintex Road No. 98, Accra Ghana Mob (Ghana): +233 20 9030 435 ___ 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] Liabilities vs Expenses.
Dear John, Liability can be short-term or long-term (less than 1 year or more than 1 year). Liability arises when Goods are delivered or Services are done. Payment of Goods and Services is another question. It can be prepayment or payment after the job is completed. So when you receive Goods with Invoice, you enter Liability and then close it with payment. So many words, but it would be better to see some examples with debit and credit, please look it up on the internet. The question you have asked is the same as the question of what is the difference between cash flow and income statement. Cash outflows are not equal to expenses and cash inflows are not equal to revenue. It's called accrual accounting. Liability is what you owe to somebody and expense is another side of that coin. Something can be Liability and now expense. For example, you bought materials and these are in your ware house, so you have liability (you owe money) but this isn't an expense since you didn't use these materials. Regards, уто, 18. феб 2025. у 06:57 John Walker via gnucash-user < gnucash-user@gnucash.org> је написао/ла: > In standard bookkeeping, a liability is anything that a business owes > for more than the accounting period which is usually 12 months. A > mortgage is a good example. An expense is something that is paid out > within the accounting period. The electricity bill is a good example. > > Cheers > John > > On 22/11/2024 11:09 pm, Ed Greenberg wrote: > > I do my credit cards the same way, but I don't do individual bills that > > way. For instance the water bill, gas bill, medical copayments, and any > one > > time spending, I just record it as a transaction between the bank and the > > expense. The liability accounts are very good for aggregating what's > going > > to be part of a payment, but they don't do much for you when there's only > > one charge against a payment. > > > > Ed > > > > On Fri, Nov 22, 2024, 07:05 Michael Hendry > wrote: > > > >> > >>> On 21 Nov 2024, at 19:08, Griffin wrote: > >>> > >>> I'm no accountant, so I'm wondering what the difference is between > >> liabilities and expenses, and the importance of that difference. > >> > >> Nor I, so my comments are not definitive. > >> > >>> I currently have GnuCash set up so that everything I spend is an > >> expense. Would it be "better" to have the recurring bills as > liabilities, > >> i.e. rent, utilities, etc. If that is the case, would I place a debt > onto > >> the liability at the statement date, and then payment when I make a > payment. > >> > >> Liabilities accounts are used to record money you’re going to have to > pay > >> at some time in the future, and I use them from credit and debit cards > in > >> my personal Gnucash accounts. > >> > >> Credit card spending is recorded as a transaction between > >> Liabilities:Mastercard and Expenses:Groceries (or whatever) and the > >> Liability disappears when you pay off the credit card (recorded as a > >> transaction between your bank (e.g. Assets:Current Assets:Bank) and > >> Liabilities;Mastercard). > >> > >> Michael > >> > >>> Does it really make any difference to anything? > >> It means you can reconcile expenditure on your credit card with the > credit > >> card statement. > >> > >>> Thanks > >>> > >>> Griffin > >>> > >>> > >>> -- > >>> This email has been checked for viruses by Avast antivirus software. > >>> www.avast.com > >>> ___ > >>> 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. > >> > > ___ > > 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. > -- Petrovic Jovan, dipl.oec. Financial Controller Energoprojekt Ghana Limited Spintex Road No. 98, Accra Ghana Mob (Ghana): +233 20 9030 435 _
