Re: [GNC] automatically account for gst on random purchases
Interesting enough there are (at least thirteen; 02861, 42223, 59221, 63673, 71749, 73949, 81137, 84536, 86044, 86515, 88063, 89439 & 97635; anyone has fear of triskaidekaphobia?) zip codes that are multi states in the US! I remember when I was working for an on-line retail rental place it was fun figuring out how much tax to charge -- some items on rental are taxed while some are not and even within that some line items are taxed (postage is) and some are not (insurance is not). And to add fun to that, within zip codes we had to consult street address because it could be in one county versus another county and then each county had their own process when they updated their tax schedule. The application was wired up to consult a well-known commercial vendor's system for tax calculations but even then the company used to get regular notices from counties on deficient tax remittance. Then there is the online purchase part where tax is based on where the item is delivered and not where it is purchased. This is one item that is better handled distributed by reporting in rather than centralized ... -Original Message- From: Michael or Penny Novack Sent: Sunday, June 18, 2023 9:49 PM To: gnucash-user@gnucash.org Subject: Re: [GNC] automatically account for gst on random purchases 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
https://lists.gnucash.org/pipermail/gnucash-user/2023-June/107406.html David Cousens wrote: > If you look at this section of the business features setting up tax tables is described. https://www.gnucash.org/docs/v4/C/gnucash-guide/bus_setup.html It works for invoices and should work similarly for bills. That is as automated as it gets. Interesting. Working down through Business setup, Account setup, Setting up sales tax tables, Enter company information, then Setting business preferences as discussed further in https://www.gnucash.org/docs/v5/C/gnucash-manual/set-prefs.html#prefs-biz I note options can be set for Tax included and Invoices/Bills Process payments/Auto pay on posting. That was suggested to me long ago never having used Business Features in GnuCash I imagined it was a manual process. Can I get a minimum working example to establish a set of business books as described in the guide Account setup and Australian Tax Tables, and process a bill for $3300 of fuel including 10% GST? It's not clear to me but I understand the default tax table code is attached to the account code (like Quickbooks). With that scenario I'd expect a csv import of bank transactions to automatically split Expenses:Fuel and Asset:GST:Purchases:Standard. 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.
Hi John, The 5 funds that were showing up as 0 in the Totals column on the account page have been fixed. When I checked the box 'Get Online Quotes', the number of shares along with the symbol showed up in the Totals column. Your help is much appreciated! Bill On Sun, Jun 18, 2023 at 6:21 PM John Ralls wrote: > 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 > > -- 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.