Re: [GNC] Sales Tax Report

2020-01-22 Thread Adrien Monteleone
You don’t have to build the whole app, just your report, and then you need to tell GnuCash how to find it. (covered in the wiki) I’ve added reports others have built to a stock installation of GnuCash without issue. Note, some custom reports *might* require changes to GnuCash itself, but that

Re: [GNC] Sales Tax Report

2020-01-22 Thread Keith Fetterman
? Does writing a report in Scheme require GnuCash software to be built from source? > On Jan 21, 2020, at 3:22 PM, gnucash-user-requ...@gnucash.org wrote: > > > Message: 1 > Date: Tue, 21 Jan 2020 12:41:16 -0600 > From: Adrien Monteleone > To: GnuCash users group >

Re: [GNC] Sales Tax Report

2020-01-21 Thread Adrien Monteleone
> On Jan 19, 2020 w4d19, at 12:22 PM, Keith Fetterman > wrote: > > Adrien, > > Thanks for the help. > > In the state of Washington, we need to report the local city/county sales tax > for each physical location we do work in. The state assigns a tax code based > on address. The

Re: [GNC] Sales Tax Report

2020-01-19 Thread Stephen M. Butler
On 1/19/20 12:13 PM, Michael or Penny Novack wrote: > On 1/19/2020 2:07 PM, Stephen M. Butler wrote: > >> Just this quarter (starting 1 Jan 2020) the State of Washington added >> some Idaho zip codes to its list of taxable zip codes.  These are for >> houses in Washington State that get their mail

Re: [GNC] Sales Tax Report

2020-01-19 Thread Michael or Penny Novack
On 1/19/2020 2:07 PM, Stephen M. Butler wrote: Just this quarter (starting 1 Jan 2020) the State of Washington added some Idaho zip codes to its list of taxable zip codes.  These are for houses in Washington State that get their mail via an Idaho post office.  [ Note, Washington State is one of

Re: [GNC] Sales Tax Report

2020-01-19 Thread Michael or Penny Novack
On 1/19/2020 1:22 PM, Keith Fetterman wrote: Adrien, Thanks for the help. In the state of Washington, we need to report the local city/county sales tax for each physical location we do work in. The state assigns a tax code based on address. The business is a very small landscaping business

Re: [GNC] Sales Tax Report

2020-01-19 Thread Stephen M. Butler
On 1/19/20 10:22 AM, Keith Fetterman wrote: > Adrien, > > Thanks for the help. w > > In the state of Washington, we need to report the local city/county sales tax > for each physical location we do work in. The state assigns a tax code based > on address. The business is a very small

Re: [GNC] Sales Tax Report

2020-01-19 Thread Stephen M. Butler
On 1/18/20 6:19 PM, Michael or Penny Novack wrote: > On 1/18/2020 5:25 PM, Keith Fetterman wrote: > >>   I need to file an end of year sales tax report to the state showing >> the sales by tax code.  I created a tax table for each customer’s >> city and assigned the entries to the customers. .

Re: [GNC] Sales Tax Report

2020-01-19 Thread Keith Fetterman
> -- > > Message: 1 > Date: Sat, 18 Jan 2020 21:53:07 -0600 > From: Adrien Monteleone > To: GnuCash users group > Subject: Re: [GNC] Sales Tax Report > Message-ID: <226840b7-6eb5-4879-b1ff-e32850e5d...@lusfiber.net> > Content-Type: text/plain; charset=utf-

Re: [GNC] Sales Tax Report

2020-01-19 Thread Michael or Penny Novack
On 1/18/2020 10:53 PM, Adrien Monteleone wrote: If you need to break down sales by customer location, that can get real messy really fast. GnuCash isn’t really set up for it out of the box. But you HAVE to do that for mail order or internet sales. Else you don't know whether the items are

Re: [GNC] Sales Tax Report

2020-01-18 Thread Adrien Monteleone
A common method is to post sales tax lines on invoices to a ’sales tax collected’ account or something similar. Then when you file the reports and make the payments, you reduce the amount still unremitted. (some books might then employ a “sales tax due” account as an intermediary when filing,

Re: [GNC] Sales Tax Report

2020-01-18 Thread Christopher Lam
You're welcome. This report is tailor made for simple VAT as applies to UK/Australia etc. It handles multiple VAT rates eg UK's standard 20% reduced 5% zero-rated 0%. See last section of https://wiki.gnucash.org/wiki/Alternate_Australian_GST_setup If you share your account structure (and tax

Re: [GNC] Sales Tax Report

2020-01-18 Thread Keith Fetterman
Christopher, Thank you. This report kinda works. It doesn’t report the tax by tax table. It only reports the tax by the sales tax liability account. But, I can make it work if I create sub accounts under the liability account for each tax table and assign the tax table entries to the

Re: [GNC] Sales Tax Report

2020-01-18 Thread Michael or Penny Novack
On 1/18/2020 5:25 PM, Keith Fetterman wrote: I need to file an end of year sales tax report to the state showing the sales by tax code. I created a tax table for each customer’s city and assigned the entries to the customers. . I'm going to ask you a scary question, Keith. How do

Re: [GNC] Sales Tax Report

2020-01-18 Thread Christopher Lam
You may try the "Income GST Statement" report but it may not necessarily meet your needs. If you wish you can file an enhancement request in bugzilla. On Sat, 18 Jan 2020 at 22:27, Keith Fetterman wrote: > Is there a report in GunCash that shows sales by tax table (tax code)? I > need to file

[GNC] Sales Tax Report

2020-01-18 Thread Keith Fetterman
Is there a report in GunCash that shows sales by tax table (tax code)? I need to file an end of year sales tax report to the state showing the sales by tax code. I created a tax table for each customer’s city and assigned the entries to the customers. Now, I would like to generate a sales