Re: [GNC] automatically account for gst on random purchases

[Stan Brown]

On 2023-06-18 18:48, Michael or Penny Novack wrote:
> Notice that "point" in "point of sales. That's because the correct tax
> amount depends on the point of sale (the where).

Well, sometimes. In California, for example, the sales tax rate on
purchase of a vehicle is according to where the new owner lives, not
according to where the dealer is located. (I bought my car in LA County,
but the dealer correctly charged me sales tax based on my residence in
Kern County. Had I lived in LA County and bought from a dealer in Kern,
I would have had to pay the higher LA County rate. In either case, the
dealer's location is irrelevant.)

Granted, that's unusual. But as you know, it takes the same amount of
programming effort to handle a given special case whether it occurs
frequently or once in a blue moon.

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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.

Re: [GNC] automatically account for gst on random purchases

[Michael or Penny Novack]

On 6/18/2023 7:43 PM, flywire wrote:

In looking for/expecting and automated solution you are thinking one should

be reasonable. ...I live in the US [which has complex GST]

Yet surely it is reasonable for the automated GST functionality for accrual
accounting to apply to cash accounting. Even USA GST has rules, so it could
be automated.


Yes indeed, sales tax(es) can be computed automatically even here in the 
US. But this is typically done by a POS system at the register and the 
result is fed to the general ledger system.


Notice that "point" in "point of sales. That's because the correct tax 
amount depends on the point of sale (the where). The device (that thing 
that used to be just a "cash register) "knows" where it is. The product 
code is scanned in (or hand entered) and that is used to determine if 
taxable and at what rate. that gets sent to general ledger. Also that a 
widget with that code sold informs the inventory system to deduct one 
(and also send the "cost of good sold" to general ledger. Let's say you 
have  a business located near Port Jarvis with three shops, one in NY, 
one in NJ, and one in PA (the three states meet there). The POS sales in 
each of those shops would be sending DIFFERENT tax amounts to general 
ledger.


You are asking general ledger to do all of this (gnucash is a general 
ledger system). In that case MORE INFORMATION would be needed as part of 
each transaction. Not just things like date, amount, etc. but "legal 
location for this transaction" << for example, the location of the 
customer if a remote sale* >>


Michael D Novack

* BTW, I have yet to do business with any remote seller that does this 
correctly. They tend to use ZIP code, but ZIP code is NOT a reliable 
indication of the legal location of the address. Postal delivery routes 
do not respect state boundaries let alone more local political 
boundaries. My working days were spent in a financial industry where 
"contract state" WAS collected separately from "mail state" << because 
it was very important to be sure what state's laws would apply to the 
contract >> In other words, remote sellers really should "look up on a 
map" (mapping software) where that mailing address is actually located 
and not assume must be the same state/city as the PO that delivers mail 
to that address.


___
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] automatically account for gst on random purchases

[flywire]

> In looking for/expecting and automated solution you are thinking one should
be reasonable. ...I live in the US [which has complex GST]

Yet surely it is reasonable for the automated GST functionality for accrual
accounting to apply to cash accounting. Even USA GST has rules, so it could
be automated.

> flywire: you mentioned that you use QuickBooks for business, have you tried
using Odoo?

I have tried many packages but not Odoo. Manual data entry is the most
time-consuming task so I give accounting package right of veto to
the person doing data entry. Apart from the farm business tracking GST in
Quickbooks all data entry is a semi-automated csv process in GnuCash,
although one set of books uses an 80/20 automated account allocation edited
by someone else after importing.

I switched from KMyMoney to Gnucash with a view to GST support for the
farm, not realising it wasn't automated for cash accounting. Regardless, I
think I can force the farm data into GnuCash and leverage the data.

Regards

>
___
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] Mutual funds total shares not showing up on Account Page.

[John Ralls]

Bill,

Please remember to copy the list on all replies.

It does not answer my questions. I'll try again:

1. What is the exact word or words at the top of the Accounts page over the 
column with the missing balances?
2. Are the balances actually missing, meaning that there is no entry at all, or 
does it show a zero (0) balance with the symbol for the fund?

Regards,
John Ralls

> On Jun 18, 2023, at 3:00 PM, Bill Swanson  wrote:
> 
> Hi John,
> 
> The number of shares purchased or sold get carried over to the Balance column 
> on the fund transaction page. This does not show up in the Totals on the 
> Account page for a few funds. 
> 
> Double clicking in the accounts name column takes me to the fund page but the 
> Balance amount does not show up in the Account page under Topals.
> 
> I hope this answers your question. 
> 
> Your help is appreciated.
> 
> Bill
> 
> On Sun, Jun 18, 2023 at 5:53 PM John Ralls  wrote:
> What column heading are you using for total shares? Is the line in that 
> column blank or 0?
> 
> Regards,
> John Ralls
> 
> > On Jun 18, 2023, at 1:00 PM, Bill Swanson  wrote:
> > 
> > There are a few mutual funds whose total shares do not show up on the
> > Accounts page. I am using SqLite  for the database.
> > 
> > On the account page, when I double click on the fund it takes me to the
> > fund page that shows the ledger but the total shares do not get carried
> > back to the account page.
> > 
> > What can cause a few funds not to show their totals on the account page?
> > 
> > -- 
> > Bill Swanson
> > 207-2443946
> > ___
> > 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.
> 
> 
> 
> -- 
> Bill Swanson
> 207-2443946

___
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] Mutual funds total shares not showing up on Account Page.

[John Ralls]

What column heading are you using for total shares? Is the line in that column 
blank or 0?

Regards,
John Ralls

> On Jun 18, 2023, at 1:00 PM, Bill Swanson  wrote:
> 
> There are a few mutual funds whose total shares do not show up on the
> Accounts page. I am using SqLite  for the database.
> 
> On the account page, when I double click on the fund it takes me to the
> fund page that shows the ledger but the total shares do not get carried
> back to the account page.
> 
> What can cause a few funds not to show their totals on the account page?
> 
> -- 
> Bill Swanson
> 207-2443946
> ___
> 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] Merging Two Accounts

[Matthew Clay]

Dear All,

Thank you all for your help. After changing all account types to "Cash"
(right click -> Edit Account -> select "Cash" for Account Type), I was able
to merge them. Previously, the new account I created was just an "Asset",
not "Cash"!

Thanks again!

Sincerely,
Matthew Clay

On Sun, Jun 18, 2023 at 2:51 PM NoobAlice  wrote:

> I would say, in addition, make sure that neither your source account nor
> your destination account is marked as "hidden" or "placeholder."  Or, if
> it is, use the little configuration icon (for me it is a wrench and a
> screwdriver crossed) to show hidden and placeholder accounts.
>
> Accounts should be the same type, as David says.
> I was not able to delete-merge a type "asset" account into a type "bank"
> account until I changed the "asset" account into a "bank" account.
>
> On 2023-06-18 02:48 PM, David Carlson wrote:
> > Check the account types of the accounts that you want to merge.  There
> are
> > some limitations on account types that will merge.  In release 3.8, IIR,
> it
> > is possible to merge liabilities with assets or expense with income, but
> > not securities with much of anything else.  Perhaps others have
> additional
> > suggestions.
> >
> > On Sun, Jun 18, 2023 at 1:40 PM Matthew Clay  wrote:
> >
> >> Dear Gnucash Community,
> >>
> >> I am trying to merge two accounts in gnucash by deleting one account and
> >> moving all of its transactions to the other account. This is explained
> in a
> >> thread "Merging Two Accounts" dated  Mon May 9 17:15:22 EDT 2011. After
> >> selecting "Delete Account", however, the list of destination accounts in
> >> the "Move to" dropdown menu is severely limited, and even after I
> manually
> >> type in the full path to the destination account, gnucash does not
> >> recognize it. I have tried renaming the accounts and moving them around
> in
> >> the Assets tree, but I still cannot select my target destination
> account.
> >>
> >> Has anybody experienced this issue?
> >>
> >> I am using gnucash 3.8 with build ID 3.8b+(2019-12-29) on an Ubuntu
> system.
> >>
> >> Thanks,
> >> Matthew
> >> ___
> >> 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.

Re: [GNC] Mutual funds total shares not showing up on Account Page.

[Bill Swanson]

There are a few mutual funds whose total shares do not show up on the
Accounts page. I am using SqLite  for the database.

On the account page, when I double click on the fund it takes me to the
fund page that shows the ledger but the total shares do not get carried
back to the account page.

What can cause a few funds not to show their totals on the account page?

-- 
Bill Swanson
207-2443946
___
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] Merging Two Accounts

[NoobAlice]

I would say, in addition, make sure that neither your source account nor 
your destination account is marked as "hidden" or "placeholder."  Or, if 
it is, use the little configuration icon (for me it is a wrench and a 
screwdriver crossed) to show hidden and placeholder accounts.


Accounts should be the same type, as David says.
I was not able to delete-merge a type "asset" account into a type "bank" 
account until I changed the "asset" account into a "bank" account.


On 2023-06-18 02:48 PM, David Carlson wrote:

Check the account types of the accounts that you want to merge.  There are
some limitations on account types that will merge.  In release 3.8, IIR, it
is possible to merge liabilities with assets or expense with income, but
not securities with much of anything else.  Perhaps others have additional
suggestions.

On Sun, Jun 18, 2023 at 1:40 PM Matthew Clay  wrote:


Dear Gnucash Community,

I am trying to merge two accounts in gnucash by deleting one account and
moving all of its transactions to the other account. This is explained in a
thread "Merging Two Accounts" dated  Mon May 9 17:15:22 EDT 2011. After
selecting "Delete Account", however, the list of destination accounts in
the "Move to" dropdown menu is severely limited, and even after I manually
type in the full path to the destination account, gnucash does not
recognize it. I have tried renaming the accounts and moving them around in
the Assets tree, but I still cannot select my target destination account.

Has anybody experienced this issue?

I am using gnucash 3.8 with build ID 3.8b+(2019-12-29) on an Ubuntu system.

Thanks,
Matthew
___
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] Merging Two Accounts

[Stan Brown]

On 2023-06-18 11:39, Matthew Clay wrote:
> I am trying to merge two accounts in gnucash by deleting one account and
> moving all of its transactions to the other account. ... After
> selecting "Delete Account", however, the list of destination accounts in
> the "Move to" dropdown menu is severely limited, and even after I manually
> type in the full path to the destination account, gnucash does not
> recognize it. I have tried renaming the accounts and moving them around in
> the Assets tree, but I still cannot select my target destination account.

For the account you want to delete, please tell us the Account Type,
currency, whether it's a placeholder, and whether it has subaccounts;
then the same information for the account you want to move the
transactions to.

Can you identify anything the accounts in the "severely limited" list
have in common that makes them different from other accounts?

Stan Brown
Tehachapi, CA, USA
https://BrownMath.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.

Re: [GNC] Merging Two Accounts

[David Carlson]

Check the account types of the accounts that you want to merge.  There are
some limitations on account types that will merge.  In release 3.8, IIR, it
is possible to merge liabilities with assets or expense with income, but
not securities with much of anything else.  Perhaps others have additional
suggestions.

On Sun, Jun 18, 2023 at 1:40 PM Matthew Clay  wrote:

> Dear Gnucash Community,
>
> I am trying to merge two accounts in gnucash by deleting one account and
> moving all of its transactions to the other account. This is explained in a
> thread "Merging Two Accounts" dated  Mon May 9 17:15:22 EDT 2011. After
> selecting "Delete Account", however, the list of destination accounts in
> the "Move to" dropdown menu is severely limited, and even after I manually
> type in the full path to the destination account, gnucash does not
> recognize it. I have tried renaming the accounts and moving them around in
> the Assets tree, but I still cannot select my target destination account.
>
> Has anybody experienced this issue?
>
> I am using gnucash 3.8 with build ID 3.8b+(2019-12-29) on an Ubuntu system.
>
> Thanks,
> Matthew
> ___
> 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.
>


-- 
David Carlson
___
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] Merging Two Accounts

[Matthew Clay]

Dear Gnucash Community,

I am trying to merge two accounts in gnucash by deleting one account and
moving all of its transactions to the other account. This is explained in a
thread "Merging Two Accounts" dated  Mon May 9 17:15:22 EDT 2011. After
selecting "Delete Account", however, the list of destination accounts in
the "Move to" dropdown menu is severely limited, and even after I manually
type in the full path to the destination account, gnucash does not
recognize it. I have tried renaming the accounts and moving them around in
the Assets tree, but I still cannot select my target destination account.

Has anybody experienced this issue?

I am using gnucash 3.8 with build ID 3.8b+(2019-12-29) on an Ubuntu system.

Thanks,
Matthew
___
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] Finance::Quote 1.56_02 Available for Evaluation

[Bruce Schuck]

On 6/18/23 10:34, john wrote:


I'm at a loss. Although at the current moment, YahooWeb isn't
required as long other viable quote sources exist. I like the
Date::Business module, I just wish its install honored the
PERL_USE_MM_DEFAULTS environment variable. It would be trivial to
create different holiday subroutines for various
exchanges/countries and use the one for the exchange indicated in
the data returned. I have started the process CPAN/Pause requires
for adopting the Date::Business module namespace if the original
author/authors are unresponsive.



OK, that seems to be the best alternative.


I have somewhat good news. I did some testing with Date::Manip without 
creating a config file. The Date_PrevWorkDay method does skip weekends 
properly as long the $offset is set to 1 when called on Sat/Sun.


I can replace Date::Business with Date::Manip in YahooWeb. At the very 
least it will skip back over weekends for all quotes, and not create 
issues during Date::Business install requiring for user input. We lose 
holiday calculations, but for an "emergency" use module, better than 
nothing.


Again, not optimal, but better than the original version where the trade 
date would be set to "today" regardless of what day F::Q was executed.


Happy Fathers' Day to all the dads.

Bruce S.
___
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] automatically account for gst on random purchases

[Stan Brown]

And to hammer another nail into Michael's point, the tax rate can vary
by date. For example, when I lived in New York state it had a 4% sales
tax rate, including on clothing, _except_ for certain weekends each
year, when clothing below a certain value was taxed at 0% but other
taxable goods were still at 4%.

In fact it was even more complicated than that, because most counties
had their own add-on sales taxes, and some of them also lifted _their_
taxes on the same weekends as the state while others did not. In Ithaca,
we paid 8% tax on clothing most of the year, but 4% on those special
"tax-free" weekends.

As Michael says, GC being a global product, if it were to treat
sales-type taxes specially it would have to keep track of thousands of
rules. Testing that code would be a nightmare, and I'm confident there
would be many, bugs, a significant number of them undetected. That's
particularly bad in tax matters!

Stan Brown
Tehachapi, CA, USA
https://BrownMath.com

On 2023-06-18 08:26, Michael or Penny Novack wrote:
> On 6/17/2023 10:06 PM, Karl May wrote:
>> Hi all,
>>
>> For my business setup I am wondering whether there is a way to
>> automatically
>> account for gst on small random purchases (e.g. hotel, restaurant etc.).
>>
>> ...
>>
>> Any suggestions how this can be automated such that the default is a
>> transaction split and application of a default GST rate?
>>
>> Thanks
> 
> 
> In looking for/expecting and automated solution you are thinking one
> should be reasonable. But that's ONLY for the (very) special case where
> the tax rate on things like "hotel", "restaurant", etc, would be 
> uniform. Since I live in the US, I do not have that expectation. I know
> that every state imposes a different rate (and taxes different things*)
> and some municipalities are allowed to impose local taxes in addition.
> 
> Thus I expect to enter manually from the receipt which will spell out
> the amounts of various taxes. It would be much more work to go to the
> state and/or municipality sites to find out the rates (and its "rounding
> rule") and try to compute it myself. That's what the vendor (hotel,
> restaurant, store, etc.) has a POS system to figure out and of course it
> "knows" where it is located (which rules apply). In other words, even
> adding the complexity of a typical POS system to gnucash would not help,
> because the exact legal location is unlikely to be included in the
> transaction information by the time it gets to gnucash.
> 
> Michael D Novack
> 
> * It can even depend on the sort of business the vendor is as well as
> the item. Thus my own state of MA does not tax items of clothing costing
> below a certain amount. So one winter day, leaving the house,  I forgot
> to put on gloves. So say I stop to get some, it will make a difference
> where I stop. If I stop at the local hardware store  or garden store,
> taxed, as "protective gear". But if I stopped at the general store, not
> taxed, as clothing. So to be automated in gnucash, the POS part would
> not only need to know the legal location but how the item classed by
> that sort of vendor.
> 
> 
> ___
> 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] Finance::Quote 1.56_02 Available for Evaluation

[john]

> On Jun 17, 2023, at 15:03, Bruce Schuck  wrote:
> 
> On June 16, 2023 at 15:11 EDT, John Ralls wrote:
> 
>> On 06/15/2023 12:23 -0700, Bruce S wrote:
> 
>>> Non-production release 1.56_02 is available for evaluation/testing.
> 
>>> It can be installed via cpan/cpanm as 
>>> 'BPSCHUCK/Finance-Quote-1.56_02.tar.gz'.
> 
>>> The YahooWeb module currently requires the Date::Business module. 
>>> Installing it cannot be done unattended, as the Makefile.PL used requires a 
>>> yes/no question be answered. Not updated since January 2000, attempts to 
>>> reach the author have been unsuccessful so far. Maybe you could use 
>>> Date::Manip::Date_PrevWorkDay instead?
> 
> As I mentioned, I was looking at that along with Date::Business. I also 
> looked at Date::Holidays today.
> 
> What I found about Date::Manip is that for business mode calculations the 
> module requires a configuration file. See Date::Manip::Config where is notes:
> 
> "NOTE: if you use business mode calculations, you must have a config file 
> since this is the only place where you can define holidays."
> 
> From the documentation (a rabbit hole of many man pages/PODs) that includes 
> have date_PrevWorkDay skip over weekends (haven't tested if this just means 
> you want to define your own custom work week).
> 
> I going to assume that requiring GnuCash users to have a config file for 
> Date::Manip and keep it updated could be problematic for some.
> 
> What I found about Date::Holidays so far is that users would need to install 
> all the Date::Holidays:: modules that Finance::Quote may use. F::Q 
> would then be at the mercy of all the different authors with respect to those 
> modules being updated. Also, the current US or USFederal modules do not 
> account for Juneteenth or Good Friday. Juneteenth being a newly created 
> holiday here in the US, and Good Friday is observed by the US stock market 
> each year.
> 
>> But either way it's pretty US-centric because of the holidays enumeration. 
>> What about the Monday-Friday trading days assumption?
>> Is that valid for all of the stock markets that Yahoo can get quotes
>> for?
> I'm at a loss. Although at the current moment, YahooWeb isn't required as 
> long other viable quote sources exist. I like the Date::Business module, I 
> just wish its install honored the PERL_USE_MM_DEFAULTS environment variable. 
> It would be trivial to create different holiday subroutines for various 
> exchanges/countries and use the one for the exchange indicated in the data 
> returned. I have started the process CPAN/Pause requires for adopting the 
> Date::Business module namespace if the original author/authors are 
> unresponsive.

OK, that seems to be the best alternative.

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] automatically account for gst on random purchases

[Michael or Penny Novack]

On 6/18/2023 9:14 AM, Brad Morrison wrote:

Thanks flywire!

That GitHub Pull Request link takes me to a comment from John Ralls 
that very succinctly summarizes the difficulties of using GnuCash for 
larger or more complex enterprises.


The rest of that comment is: "Adding those modules is a non-starter: 
Consider that it's been 10 years since we began working on separating 
libgnucash from the application, converting from GObject to C++, and 
changing from a program that can load its data from a SQL database and 
put it back to one that is built around SQL queries. We haven't gotten 
very far. 


There are many parts (component) to a full accounting SYSTEM and which 
of them needed depending on the sort of enterprise. ONE of those 
components would be the one that usually goes by the name "general 
ledger". THAT is what gnucash is, all that it is. A full SYSTEM  might 
include components doing "point of sales" (POS) , handling inventory, 
handling payroll and keeping HR records, etc. In a small, not very 
automated system, these might just produce reports of transactions to be 
manually entered into general ledger. In larger systems, would be 
automated, with these systems creating FILES of transactions to get 
imported.


Look -- if you are a small enterprise in the sense of number of 
transactions, gnucash alone might work for you.


But if you are a large enterprise in the sense of number of 
transactions, employees, quantity and variety of good sold, multiple 
locations, etc. then you will want components to handle inventory, POS, 
payroll, billable hours, etc,  Notice that thinking of these other 
components as PART of general ledger is the wrong way to think. They are 
doing other things as well, "talking" to each other and other 
departments as well as general ledger. Thus POS might send a "sales" 
transaction to general ledger and send a "widget transaction" to 
inventory. Inventory would then send a "cost of goods sold" transaction 
to general ledger but also check the number of remaining widgets against 
the "reorder number" and maybe send something to "ordering" to tell that 
department to order more widgets, etc.


Michael D Novack


___
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] automatically account for gst on random purchases

[Michael or Penny Novack]

On 6/17/2023 10:06 PM, Karl May wrote:

Hi all,

For my business setup I am wondering whether there is a way to automatically
account for gst on small random purchases (e.g. hotel, restaurant etc.).

...

Any suggestions how this can be automated such that the default is a
transaction split and application of a default GST rate?

Thanks



In looking for/expecting and automated solution you are thinking one 
should be reasonable. But that's ONLY for the (very) special case where 
the tax rate on things like "hotel", "restaurant", etc, would be  
uniform. Since I live in the US, I do not have that expectation. I know 
that every state imposes a different rate (and taxes different things*) 
and some municipalities are allowed to impose local taxes in addition.


Thus I expect to enter manually from the receipt which will spell out 
the amounts of various taxes. It would be much more work to go to the 
state and/or municipality sites to find out the rates (and its "rounding 
rule") and try to compute it myself. That's what the vendor (hotel, 
restaurant, store, etc.) has a POS system to figure out and of course it 
"knows" where it is located (which rules apply). In other words, even 
adding the complexity of a typical POS system to gnucash would not help, 
because the exact legal location is unlikely to be included in the 
transaction information by the time it gets to gnucash.


Michael D Novack

* It can even depend on the sort of business the vendor is as well as 
the item. Thus my own state of MA does not tax items of clothing costing 
below a certain amount. So one winter day, leaving the house,  I forgot 
to put on gloves. So say I stop to get some, it will make a difference 
where I stop. If I stop at the local hardware store  or garden store, 
taxed, as "protective gear". But if I stopped at the general store, not 
taxed, as clothing. So to be automated in gnucash, the POS part would 
not only need to know the legal location but how the item classed by 
that sort of vendor.



___
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] automatically account for gst on random purchases

[Brad Morrison]

Thanks flywire!

That GitHub Pull Request link takes me to a comment from John Ralls that 
very succinctly summarizes the difficulties of using GnuCash for larger 
or more complex enterprises.


The rest of that comment is: "Adding those modules is a non-starter: 
Consider that it's been 10 years since we began working on separating 
libgnucash from the application, converting from GObject to C++, and 
changing from a program that can load its data from a SQL database and 
put it back to one that is built around SQL queries. We haven't gotten 
very far.


Those seeking a F/LOSS accounting solution for larger enterprises should 
look to Odoo ."


I had never heard of Odoo before I read that comment 
(https://www.odoo.com/). From Odoo's website, I also found a small list 
of accounting firms that use Odoo (19 are listed for the USA at 
https://www.odoo.com/accounting-firms). Although that listing is 
organized strangely to me, the firms are listed by "city, USA" NOT 
"city, state, USA" or even "state, USA" and the US is a large country 
with 50 states and 330+ million people, so there are many cities with 
the same name... Regardless, some of the firms on that list may also be 
interested in using GnuCash for "tiny & simple" enterprises, thus the 
occasional requests for bookkeeping/accounting help for businesses that 
use GnuCash may have some more leads available!


flywire: you mentioned that you use QuickBooks for business, have you 
tried using Odoo?


For anyone else following this thread, but unsure as to exactly what GST 
is, I'm assuming that we are talking about the tax concept (and not 
likely the American version of GST) - https://en.wikipedia.org/wiki/GST


I'm sure that the GnuCash developers would appreciate any financial 
support from anyone regularly using this software and/or asking for new 
features/updates to be implemented/investigated 
(https://gnucash.org/donate.phtml). For American taxpayers that itemize 
their deductions, just keep in mind that GnuCash is not a 501c3 
nonprofit, nor a fiscally sponsored project of an existing, registered 
501c3 nonprofit 
(https://lists.gnucash.org/pipermail/gnucash-user/2023-May/106798.html), 
so those donations may not be tax deductible 
(https://www.irs.gov/help/ita/can-i-deduct-my-charitable-contributions).


Brad


On 6/18/23 04:37, flywire wrote:

https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278
"GnuCash is for tiny and simple enterprises; we often say individuals and
sole proprietorships. Even having employees makes using GnuCash a dubious
proposition (no payroll module), as does carrying more than a very few line
items of inventory (no inventory module) or performing any sort of
manufacturing (no bill of materials or cost accounting modules)."

GnuCash supports GST for Accrual Accounting but not Cash Accounting, go
figure.

-

I proposed a process for Cash Accounting with Automated GST:
https://lists.gnucash.org/pipermail/gnucash-user/2021-September/097666.html
TLDR; Automate GST for cash accounting by preprocessing transactions to
enrich with GST and import as a multisplit file

1. This isn't going to work on random transactions, you need to know which
accounts have GST
2. I already preprocess bank transactions in a spreadsheet before importing
but I haven't got around to splitting for GST (because I still use
QuickBooks for business)
3. I'd probably do the splits in python and integrate it into LibreOffice
Calc

If anyone is interested I'll work on it.


https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107405.html  R

Losey wrote:

You MIGHT be able to get fancy by getting the data into a spreadsheet,
having macros to assign the GST and travel categories, and then import the
spreadsheet into GnuCash.


https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107404.html

Karl May wrote:

For my business setup I am wondering whether there is a way to
automatically
account for gst on small random purchases (e.g. hotel, restaurant etc.).

My current setup is roughly

Assets:financial_assets:bank_account
Assets:financial_assets:gst
Expense:travel

So far I haven't setup Accounts/payable and Accounts/receivable.

The current process is:

A) import bank account transactions via OFX into "bank_account" and
"imbalanced"
B) manually go through all transaction, use "split transaction",

manually

calculate the gst and assign amounts to Expense:travel and
Assets:financial_assets:gst.


Any suggestions how this can be automated such that the default is a
transaction split and application of a default GST rate?

Regards
___
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 

[GNC] automatically account for gst on random purchases

[flywire]

https://github.com/Gnucash/gnucash/pull/1623#issuecomment-1583966278
"GnuCash is for tiny and simple enterprises; we often say individuals and
sole proprietorships. Even having employees makes using GnuCash a dubious
proposition (no payroll module), as does carrying more than a very few line
items of inventory (no inventory module) or performing any sort of
manufacturing (no bill of materials or cost accounting modules)."

GnuCash supports GST for Accrual Accounting but not Cash Accounting, go
figure.

-

I proposed a process for Cash Accounting with Automated GST:
https://lists.gnucash.org/pipermail/gnucash-user/2021-September/097666.html
TLDR; Automate GST for cash accounting by preprocessing transactions to
enrich with GST and import as a multisplit file

1. This isn't going to work on random transactions, you need to know which
accounts have GST
2. I already preprocess bank transactions in a spreadsheet before importing
but I haven't got around to splitting for GST (because I still use
QuickBooks for business)
3. I'd probably do the splits in python and integrate it into LibreOffice
Calc

If anyone is interested I'll work on it.

> https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107405.html R
Losey wrote:
>
> You MIGHT be able to get fancy by getting the data into a spreadsheet,
> having macros to assign the GST and travel categories, and then import the
> spreadsheet into GnuCash.
>
>
> https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107404.html
Karl May wrote:
>
> > For my business setup I am wondering whether there is a way to
> > automatically
> > account for gst on small random purchases (e.g. hotel, restaurant etc.).
> >
> > My current setup is roughly
> >
> > Assets:financial_assets:bank_account
> > Assets:financial_assets:gst
> > Expense:travel
> >
> > So far I haven't setup Accounts/payable and Accounts/receivable.
> >
> > The current process is:
> >
> > A) import bank account transactions via OFX into "bank_account" and
> > "imbalanced"
> > B) manually go through all transaction, use "split transaction",
manually
> > calculate the gst and assign amounts to Expense:travel and
> > Assets:financial_assets:gst.
> >
> >
> > Any suggestions how this can be automated such that the default is a
> > transaction split and application of a default GST rate?

Regards
___
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] quandary with proper entries for cost-of-goods-sold and inventory

[Fred Bone]

On 17 June 2023 at 15:28, Stan Brown said:

[...]
> One important point: If you receive messages in a  digest, you'll also
> need to (a) edit the subject line, by copy/pasting the subject of the
> individual message you're referring to, and (b) Delete all the text of all
> the messages you're _not_ referring to, as well as any parts of the
> remaining message that are not needed to give context to your answer.

That should read "... If you receive messages in a PLAINTEXT digest ..."

The MIME-Digest works just fine, including having the necessary headers 
to enable "reply all" to work.


___
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] automatically account for gst on random purchases

[Maf. King]

On Sunday, 18 June 2023 03:06:28 BST Karl May wrote:

> 
> Any suggestions how this can be automated such that the default is a
> transaction split and application of a default GST rate?
> 
> Thanks
> 

Hi Karl,

If your "random" transactions are mostly from a regular set of suppliers, then 
I truly think that your best route is to enter the transactions manually and 
not do the import.

Autofill will do a lot of the heavy lifting and create the splits ready for you 
to bash the numbers in, on the 2nd and following transactions for any given 
supplier.

there is no other "more automated" way that I know of.

HTH,
Maf.



___
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.