[GNC] [GNC-dev] Automatically split transactions with sales tax

elvis elvis at dogonfire.com
Sat Nov 10 20:16:46 EST 2018


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 10000*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 at 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.



More information about the gnucash-user mailing list