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

2023-06-29 Thread flywire
Apologies, (no edit on the mailing list), see https://bugs.gnucash.org/show_bug.cgi?id=798987 - the previous link was the multi-split bug fixed in V5.3. On Thu, 29 Jun 2023 at 17:19, flywire wrote: > I've submitted an updated working example with python code as an > enhancement request for the i

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

2023-06-29 Thread flywire
I've submitted an updated working example with python code as an enhancement request for the importer to: https://bugs.gnucash.org/show_bug.cgi?id=798964 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

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

2023-06-21 Thread flywire
This is a preliminary (spreadsheet) process to add GST splits to a bank statement and use a multisplit csv file to import them to GnuCash. 1. Start with Bank Statement based on the Guide Checking Account - see GST_Demo_Statement.csv 2. Accounts should exist for the transactions - see

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

2023-06-21 Thread flywire
John, Hmm, it's all irrelevant with Australian GST. Generally, a return is submitted each quarter with GST collected less GST paid, and a payment is made by the appropriate party for the difference. It doesn't matter if it is income, a capital item, or stock. With my experience of Quickbooks I se

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

2023-06-20 Thread john
> On Jun 20, 2023, at 00:11, flywire wrote: > > > There is an incredible amount of keystrokes, clicks, and human memory > recall to pay a bill: > > Business, Vendor, New Bill, Date Opened:20/06/2023, Vendor: Random, OK > Expense account: Expenses:Auto:Fuel, Quantity: 1, Taxable, Tax included

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

2023-06-20 Thread edodd
On Tue, 20 Jun 2023 17:11:59 +1000 flywire wrote: > There is an incredible amount of keystrokes, clicks, and human memory > recall to pay a bill: That would be a reason I don't use that part of the business features. For invoicing I use the business features as it is worthwhile, even when I get

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

2023-06-20 Thread flywire
On Tue, 20 Jun 2023 at 10:58, David Cousens wrote: > AFAIK the tax tables work only with with invoices. As not all items are > necessarily subject to GST in all business situations in AU. It would be > difficult to automate it because of this and similarly with applying it to > imported transacti

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

2023-06-19 Thread Kalpesh Patel
ck 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 l

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

2023-06-19 Thread flywire
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 b

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

2023-06-18 Thread 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 own

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

2023-06-18 Thread 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 US

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

2023-06-18 Thread 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 automa

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

2023-06-18 Thread 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 st

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

2023-06-18 Thread 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

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

2023-06-18 Thread 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 spli

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

2023-06-18 Thread 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

[GNC] automatically account for gst on random purchases

2023-06-18 Thread 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

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

2023-06-18 Thread 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 trul

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

2023-06-17 Thread David Cousens
Karl, 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. David Cousens On Sun, 2023-06-18 at 12:06 +10

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

2023-06-17 Thread R Losey
For the work you're doing, it seems that importing transactions isn't benefiting you very much, as you still have to go through each one manually. I would just enter everything manually, and do regular balancing of the "bank account". I doubt if it can be automated in GnuCash - there isn't anythi

[GNC] automatically account for gst on random purchases

2023-06-17 Thread Karl May
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.). My current setup is roughly Assets:financial_assets:bank_account Assets:financial_assets:gst Expense:travel So far I haven't setup Accou