Re: [GNC] [GNC-dev] Automatically split transactions with sales tax
Hi Christian I had a python program written for me to insert the 10% gst into a qif file download, I reckon it has saved me thousands of hours of manual entry over the last 10 years. If you are interested I can send you a copy. It's not perfect but it does the job. Lawrence On 11/11/18 8:03 am, Christian Kluge wrote: Hi, Am 10.11.2018 um 22:09 schrieb CHRISTOPHER PEARCE: Hello all, I would like Gnucash to automatically create a split transaction for sales tax when a taxable product is bought/sold. I deal with a lot of transactions, and its a pain to manually enter the sales tax for each one. I'd rather just work within the general ledger and have Gnucash do it automatically. This feature has been wanted for a long time: https://bugs.gnucash.org/show_bug.cgi?id=371581 For example, I buy a widget for $100 + 5% GST = $105. I want Gnucash to automatically create the split, and allocate $5.00 to the GST liability account. The only way to do this in a fully automatic fashion is by using the business features with the tax tables and writing invoices. Although this system only really works for accrual accounting, because the VAT/GST will posted to VAT due, unless you route it through some temporary accounts. For entering it in the General Journal directly: I guess you already know the built-in calculator features of gnucash, so that you could write 1*105 to get the $105 paired with the use of account numbers for making the entry easier. But for what it’s worth I also would like to have a way to have a column for the tax-table to use in the transaction register. However for I seem to have understood it’s very deeply ingrained in the business features, that it would be a lot of work to do so. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. -- The choices you make, whether good or bad, make you more of who you are and less of who you could be. ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] [GNC-dev] Automatically split transactions with sales tax
Chris, If for some reason you don’t want to use the business features and prefer to enter transactions manually, the auto-fill feature helps greatly for this case. I enter all of my cash expenses with a separate sales tax split. (I’m not in a VAT locale, this is ‘in addition to’ sales tax) The principle should be the same for VAT but the math might vary. If you’re entering a transaction for the same payee, GnuCash will autofill the splits from the last entry for that payee. So if you’ve entered a split for GST, it will show up there. The difference then for each transaction will be your memo, possibly your income/expense account will need to change, and then the actual math, but the GST split will be added for you saving a few keystrokes. In your case, for the item itself, enter the price as a formula and subtract the GST (I’m presuming it is inclusive) as "price / 1+(GST rate)” So if your price inclusive of tax is $2.10 your formula is: 2.10 / 1.05 which will give you your ‘pre-tax’ amount or in this example: $2.00 Then the GST split will automatically “be” the tax. (if you’ve already entered the opposing split) If you want to double check it with a formula (helpful for more complicated entries with multiple other splits) then enter this as “price - (price / 1(GST rate)” So the above example would be: 2.10 - (2.10 / 1.05) Which would result in a GST split amount of $0.10. Of course, these number look easy but the formulas work no matter how ‘messy’ the rate. It isn’t automatic, but it does save time and is very easy to do, especially with practice. Note, if you really need to enter the price for the item including GST, but also want a separate split to break it off to a GST Due or some such account, then you’ll need an additional split with a memo something like “GST/Tax Inclusive” and make it the reverse entry of the item. (so a credit to an expense account or a debit to a revenue/income account) and set its value to the amount of the GST split, thus your transaction will still balance. For example: Cr. Cash$105 Dr. Expense:Supplies$105 -memo “paper" Cr. Expenses:Supplies $5 -memo “GST Inclusive” Dr. Expenses:GST$5 -memo “GST 5%" - or - Dr. Cash$105 Cr. Revenue:Sales $105 -memo “widgets” Dr. Revenue:Sales $5 -memo “GST inclusive” Cr. Liabilities:GST Due $5 -memo “GST 5%" Of course, talk to a local CPA to make sure your reports are reflecting the proper amounts and adjust these entries as needed. These are just rough examples. *Tip - because I pay different tax rates due to purchase location, I include the rate in the memo line for future reference should I need it. This too autofills not just from the previous entry, but if I start typing a name for the different jurisdiction, the previous rate and any other info from the most recent same memo gets auto-filled as well. Also, while you can enter transaction from the General Journal, entering them from the account that the money is going to/from is less error prone. So if you are paying out of your checking account, enter the transaction from there, one of the splits will HAVE to be a credit to the checking account. The others are going to be debits to balance against it. If you are receiving cash funds for example, then enter that in the Assets:Cash register as a debit and the other splits will have to be the offsetting credits. (likely an income/revenue account) The advantage here is you won’t accidentally choose the wrong account to send or place the money, the only variable here is why it was spent or why it was received. Regards, Adrien > On Nov 10, 2018, at 3:09 PM, CHRISTOPHER PEARCE wrote: > > Hello all, > > I would like Gnucash to automatically create a split transaction for sales > tax when a taxable product is bought/sold. I deal with a lot of > transactions, and its a pain to manually enter the sales tax for each one. > I'd rather just work within the general ledger and have Gnucash do it > automatically. > > For example, I buy a widget for $100 + 5% GST = $105. I want Gnucash to > automatically create the split, and allocate $5.00 to the GST liability > account. > > Of course, the ability to override the default 5% would be necessary. > > Is what I'm asking for possible? I'm not a programmer, so I realize this > may be a dumb question. > > (Frist time on this mailing list, so apologies if I break etiquette) > > Thanks, > Chris > > > > -- > Chris Pearce > - > President > Fernwood Tax Solutions > Victoria, BC Regina,SK > ___ > gnucash-devel mailing list > gnucash-de...@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-devel > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:
Re: [GNC] [GNC-dev] Automatically split transactions with sales tax
Hi, Am 10.11.2018 um 22:09 schrieb CHRISTOPHER PEARCE: > Hello all, > > I would like Gnucash to automatically create a split transaction for sales > tax when a taxable product is bought/sold. I deal with a lot of > transactions, and its a pain to manually enter the sales tax for each one. > I'd rather just work within the general ledger and have Gnucash do it > automatically. This feature has been wanted for a long time: https://bugs.gnucash.org/show_bug.cgi?id=371581 > For example, I buy a widget for $100 + 5% GST = $105. I want Gnucash to > automatically create the split, and allocate $5.00 to the GST liability > account. > The only way to do this in a fully automatic fashion is by using the business features with the tax tables and writing invoices. Although this system only really works for accrual accounting, because the VAT/GST will posted to VAT due, unless you route it through some temporary accounts. For entering it in the General Journal directly: I guess you already know the built-in calculator features of gnucash, so that you could write 1*105 to get the $105 paired with the use of account numbers for making the entry easier. But for what it’s worth I also would like to have a way to have a column for the tax-table to use in the transaction register. However for I seem to have understood it’s very deeply ingrained in the business features, that it would be a lot of work to do so. Kind regards Christian Kluge ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Hidden accounts in account drop down list [Solved]
Many thanks. On 10/11/2018 14:41, Derek Atkins wrote: Hidden has nothing to do with the drop down. Use placeholder to keep an account out of the drop down. -derek Sent using my mobile device. Please excuse any typos. On November 10, 2018 9:33:13 AM David Lynch via gnucash-user wrote: Some of my hidden accounts appear in the account drop down list, others do not. Why? I think it is those that I have hidden most recently that appear. I'd prefer no hidden accounts to appear in the account drop down list. Windows 10 Version: 3.3 Build ID: 3.3+ (2018-09-29) ... behaviour was the same in 3.2 David Lynch ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Hidden accounts in account drop down list
Hidden has nothing to do with the drop down. Use placeholder to keep an account out of the drop down. -derek Sent using my mobile device. Please excuse any typos. On November 10, 2018 9:33:13 AM David Lynch via gnucash-user wrote: Some of my hidden accounts appear in the account drop down list, others do not. Why? I think it is those that I have hidden most recently that appear. I'd prefer no hidden accounts to appear in the account drop down list. Windows 10 Version: 3.3 Build ID: 3.3+ (2018-09-29) ... behaviour was the same in 3.2 David Lynch ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Hidden accounts in account drop down list
Some of my hidden accounts appear in the account drop down list, others do not. Why? I think it is those that I have hidden most recently that appear. I'd prefer no hidden accounts to appear in the account drop down list. Windows 10 Version: 3.3 Build ID: 3.3+ (2018-09-29) ... behaviour was the same in 3.2 David Lynch ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
