Re: [GNC] Sales Tax Report

[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 would be entirely 
under your control in how you design the report. (you may find you’ll need to 
add something to the main app to make your report easier to code, but maybe not)

Note, Scheme is not for the faint of heart. All of the other GnuCash reports 
are written in Scheme so you should be able to access anything you need. The 
wiki has links to get you started learning in the custom report section.

If you are more familiar with Python I’d go the PieCash route, or Stephen’s 
route of a separate db.

Regards,
Adrien

> On Jan 22, 2020 w4d22, at 12:50 PM, Keith Fetterman 
>  wrote:
> 
> First off, thanks everyone for responding to my post about Sales Tax Report.  
> I really appreciate it.  It’s helped a lot.
> 
> 
> Adrien,
> 
> I agree that editing the invoice lines is not really option, especially since 
> the customers receive the invoices.  You could include a standardized 
> location code on each line, but what a pain.  And, if a mistake was made, the 
> invoice would have to be unposted to change.  Based on everyone’s comments, I 
> now see that creating sub accounts for each tax table would grow considerably 
> if there were a lot of work locations with different tax tables.
> 
> Stephen’s idea of a separate database is a good idea, especially when 
> customers have multiple locations.  Your idea creating a new report using 
> Scheme is interesting.  I didn't considered that because I haven’t written 
> custom reports before.
> 
> Can you write a report using Scheme that can access invoices?
> 
> Does writing a report in Scheme require GnuCash software to be built from 
> source? 


___
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] Sales Tax Report

[Keith Fetterman]

First off, thanks everyone for responding to my post about Sales Tax Report.  I 
really appreciate it.  It’s helped a lot.


Adrien,

I agree that editing the invoice lines is not really option, especially since 
the customers receive the invoices.  You could include a standardized location 
code on each line, but what a pain.  And, if a mistake was made, the invoice 
would have to be unposted to change.  Based on everyone’s comments, I now see 
that creating sub accounts for each tax table would grow considerably if there 
were a lot of work locations with different tax tables.

Stephen’s idea of a separate database is a good idea, especially when customers 
have multiple locations.  Your idea creating a new report using Scheme is 
interesting.  I didn't considered that because I haven’t written custom reports 
before.

Can you write a report using Scheme that can access invoices?

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 
> Subject: Re: [GNC] Sales Tax Report
> Message-ID: <00d6135e-d567-4933-a327-336d0192a...@lusfiber.net>
> Content-Type: text/plain; charset=utf-8
> 
> 
> 
>> 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 business is a very small landscaping business that 
>> only does work in a few local locations, so fortunately there are not many 
>> tax codes to keep track of. 
> 
> My state is similar as well. I used to work for a furniture store that had to 
> charge and file and remit based on the point of delivery. The situation is 
> such a mess with local jurisdictions that three houses next to each other 
> could be charged three different rates because they each happen to fall in a 
> different jurisdiction. Politicians don?t care and just assume ?computers 
> make it easy."
> 
>> 
>> I have created a tax table for each tax code and assigned it to a customer.  
>> This works because the physical work locations are the customers? homes.  If 
>> work done in a different location, it?s almost always in the same area.
>> 
>> I see what you mean about creating a sub account for each custom location.  
>> In general, this could become very large.  Your suggestion of using filters 
>> is a good one.  I hadn?t thought of it.  But, it doesn?t appear that you add 
>> notes to the memo lines of an invoice.  I tested adding a note in the 
>> invoice to see if it would appear in the memo line in AR.  It doesn?t.  The 
>> invoice transaction in the AR is locked so you can not edit the memo lines. 
>> 
> 
> Yep, special sub-accounts could grow considerably. If however, you routinely 
> do business in a set list of jurisdictions, it might be doable. (but I would 
> probably choose to learn Scheme and write the proper report as I suspect that 
> would be less work in the long run, and of course, ideal as you note.)
> 
> I don?t mean to add notes to a memo line, I mean to use the Description in 
> each line item to include the info you need. Unfortunately, this doesn?t 
> always work well with how you need the invoice itself to look. Also you can?t 
> edit invoice memos in AR as you have discovered. (same for bills in AP) you 
> really shouldn?t be editing either AR/AP directly if you are using the 
> business features. Use the provided methods of invoice/bill/process-payment 
> as needed to make any changes. Think of AR/AP as special read-only registers 
> that show you the resulting transactions that are entered into your books by 
> the business features.
> 
> Regards,
> Adrien
> 
> 
>> The ideal solution is a report of taxable sales by tax table.
> 
> 
>> 
>> 
>> Thanks,
>> Keith
>> 
> 

___
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] Sales Tax Report

[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 business is a very small landscaping business that only does 
> work in a few local locations, so fortunately there are not many tax codes to 
> keep track of. 

My state is similar as well. I used to work for a furniture store that had to 
charge and file and remit based on the point of delivery. The situation is such 
a mess with local jurisdictions that three houses next to each other could be 
charged three different rates because they each happen to fall in a different 
jurisdiction. Politicians don’t care and just assume “computers make it easy."

> 
> I have created a tax table for each tax code and assigned it to a customer.  
> This works because the physical work locations are the customers’ homes.  If 
> work done in a different location, it’s almost always in the same area.
> 
> I see what you mean about creating a sub account for each custom location.  
> In general, this could become very large.  Your suggestion of using filters 
> is a good one.  I hadn’t thought of it.  But, it doesn’t appear that you add 
> notes to the memo lines of an invoice.  I tested adding a note in the invoice 
> to see if it would appear in the memo line in AR.  It doesn’t.  The invoice 
> transaction in the AR is locked so you can not edit the memo lines. 
> 

Yep, special sub-accounts could grow considerably. If however, you routinely do 
business in a set list of jurisdictions, it might be doable. (but I would 
probably choose to learn Scheme and write the proper report as I suspect that 
would be less work in the long run, and of course, ideal as you note.)

I don’t mean to add notes to a memo line, I mean to use the Description in each 
line item to include the info you need. Unfortunately, this doesn’t always work 
well with how you need the invoice itself to look. Also you can’t edit invoice 
memos in AR as you have discovered. (same for bills in AP) you really shouldn’t 
be editing either AR/AP directly if you are using the business features. Use 
the provided methods of invoice/bill/process-payment as needed to make any 
changes. Think of AR/AP as special read-only registers that show you the 
resulting transactions that are entered into your books by the business 
features.

Regards,
Adrien


> The ideal solution is a report of taxable sales by tax table.


>  
> 
> Thanks,
> Keith
> 


___
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] Sales Tax Report

[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 via an Idaho post
>> office.  [ Note, Washington State is one of those that tax sales upon
>> the delivered to address. ]
>>
> I think that legally, almost all do. But in the example you just gave,
> are ALL houses in these "taxable Idaho zip codes" in Washington? In
> that case you are lucky. In the more general case, those Idaho zip
> codes would also include houses that are in Idaho.
>
> Note that this is early days of enforcement of sales tax for mail and
> internet sales. Not yet time for cases to work their way through the
> courts of people claiming wrongfully taxed or states suing states
> because they argue the tax collected should be theirs.
>
> Michael D Novack 

Nobody in that zip code has ordered product yet.  So I don't know what
the "mailing address" will actually show.  If they claim their "mailing
address" is Idaho, I'll not collect. 

Now, I do a post process that looks at the address to figure out what I
should have collected (so I can split local codes that share a common
zip code).  Will be interesting to see as the business grows.

I do ship rather than visit.

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Sales Tax Report

[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 those that tax sales upon
the delivered to address. ]

I think that legally, almost all do. But in the example you just gave, 
are ALL houses in these "taxable Idaho zip codes" in Washington? In that 
case you are lucky. In the more general case, those Idaho zip codes 
would also include houses that are in Idaho.


Note that this is early days of enforcement of sales tax for mail and 
internet sales. Not yet time for cases to work their way through the 
courts of people claiming wrongfully taxed or states suing states 
because they argue the tax collected should be theirs.


Michael D Novack

--
There is no possibility of social justice on a dead planet except the equality 
of the grave.

___
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] Sales Tax Report

[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 that only does 
work in a few local locations, so fortunately there are not many tax codes to 
keep track of.

In your case, you are in luck, because physically going to the address 
where the service is provided, you will know what state it is in. Will 
know that although an address may be served by a Washington post office 
actually in Oregon or vice versa.


I realize that this might not apply to you (not close to a state 
boundary) but I was just pointing out the data issue.


Michael D Novack



___
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] Sales Tax Report

[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 landscaping business that only does 
> work in a few local locations, so fortunately there are not many tax codes to 
> keep track of. 
>
> I have created a tax table for each tax code and assigned it to a customer.  
> This works because the physical work locations are the customers’ homes.  If 
> work done in a different location, it’s almost always in the same area.
>
> I see what you mean about creating a sub account for each custom location.  
> In general, this could become very large.  Your suggestion of using filters 
> is a good one.  I hadn’t thought of it.  But, it doesn’t appear that you add 
> notes to the memo lines of an invoice.  I tested adding a note in the invoice 
> to see if it would appear in the memo line in AR.  It doesn’t.  The invoice 
> transaction in the AR is locked so you can not edit the memo lines. 
>
> The ideal solution is a report of taxable sales by tax table.  
>
> Thanks,
> Keith
>

Keith,

I also have a small business in Washington State that mails product to
the buyers (very small amount of personal sales handed "over the
counter").  I built a SQLite3 database to track the individual orders
along with the State and Local jurisdiction collected taxes.  It is just
too complicated to keep track in GnC.  For 2020Q1 there are 476 distinct
local jurisdictions and 1,185,337 address locators in the states
downloadable files.  In two cases, the same block-face (same zip +
zip-4) has different location codes based on the house number.  However,
the hosting site (Squarespace) will only apply taxes at the zip code
level of which there are 716 different zip codes in the state.

Thankfully I don't have "presence" in any other state (yet).  Also,
thankfully, I can download the orders direct from the web site in CSV
format.  I only have to manually add the very few OTC sales.


--Steve

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8


___
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] Sales Tax Report

[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. .
>
>
> I'm going to ask you a scary question, Keith. How do you KNOW the
> customer's city/state for legal purposes? Are you keeping that data?
> The PHYSICAL location (city/state) as opposed to the city/state/zip of
> the post office that delivers mail to that location. Postal routes do
> NOT respect state boundaries.
>
> Of course you would be in good company with perhaps the majority of
> businesses making mistakes with addresses close to state boundaries.
>
> Michael 


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 those that tax sales upon
the delivered to address. ]

-- 
Stephen M Butler, PMP, PSM
stephen.m.butle...@gmail.com
kg...@arrl.net
253-350-0166
---
GnuPG Fingerprint:  8A25 9726 D439 758D D846 E5D4 282A 5477 0385 81D8

___
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] Sales Tax Report

[Keith Fetterman]

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 that only does 
work in a few local locations, so fortunately there are not many tax codes to 
keep track of. 

I have created a tax table for each tax code and assigned it to a customer.  
This works because the physical work locations are the customers’ homes.  If 
work done in a different location, it’s almost always in the same area.

I see what you mean about creating a sub account for each custom location.  In 
general, this could become very large.  Your suggestion of using filters is a 
good one.  I hadn’t thought of it.  But, it doesn’t appear that you add notes 
to the memo lines of an invoice.  I tested adding a note in the invoice to see 
if it would appear in the memo line in AR.  It doesn’t.  The invoice 
transaction in the AR is locked so you can not edit the memo lines. 

The ideal solution is a report of taxable sales by tax table.  

Thanks,
Keith



> --
> 
> 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-8
> 
> 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, then reduce that account when making payments)
> 
> Reporting varies by jurisdiction of course.
> 
> I?m most familiar (in 3 US states) with filing a report of total sales and 
> total taxable sales, calculating tax due on that amount, and then remitting 
> it. How much you actually collected is irrelevant. (UNLESS, you collected 
> more than you were supposed to, in which case, you had to remit what was 
> actually collected. A business generally can?t ?profit? off of excessive tax 
> charged, though they are in some locales allowed to deduct a tiny if not 
> infinitesimal ?vendor compensation? from the remittance)
> 
> So for some jurisdictions at least, all that would be needed is a total 
> taxable sales report. Comparing that to what was charged to and collected 
> from customers would otherwise be an internal auditing matter to make sure 
> you were collecting the right amount so you don?t lose money or run afoul of 
> the law.
> 
> 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.
> 
> You might be able to employ a little extra work by putting the filter 
> criteria in a note or memo. That way you can run a report restricted to 
> matching that note or memo to aggregate sales.
> 
> As with all such questions, seek the advice of a local CPA before embarking 
> on a particular bookkeeping method.
> 
> Regards,
> Adrien
> 
> 

___
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] Sales Tax Report

[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 taxable, at what rate, and what state gets it.


My earlier comment is that you may not be collecting/keeping the 
(correct) state for that location because the post office serving that 
location might be in a different state << you probably only have the 
customer's MAILING address, town, zip, state but that will not be the 
legal state of that location in all cases.>>


Like I said, in the same boat as many businesses. I do not recall any 
vendors with whom I am currently doing business ask for the information  
"in what state is the location of your mailing address?" In MY case, I 
know that the state is correct (but the "town" is not, has political and 
excise tax ramifications but not sales tax. But I know people for whom 
the state is "incorrect". Mind, I don;t think you are likely to get into 
trouble over this because "same boat".


By contrast, in my working days, where I worked DID collect/keep "legal 
state" (aka, the contract state ) in addition to "mail state" because it 
was THAT state's laws that would apply to the insurance contract, not 
those of the state that delivered the mail.


Michael D Novack


___
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] Sales Tax Report

[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, then reduce that account when making payments)

Reporting varies by jurisdiction of course.

I’m most familiar (in 3 US states) with filing a report of total sales and 
total taxable sales, calculating tax due on that amount, and then remitting it. 
How much you actually collected is irrelevant. (UNLESS, you collected more than 
you were supposed to, in which case, you had to remit what was actually 
collected. A business generally can’t ‘profit’ off of excessive tax charged, 
though they are in some locales allowed to deduct a tiny if not infinitesimal 
‘vendor compensation’ from the remittance)

So for some jurisdictions at least, all that would be needed is a total taxable 
sales report. Comparing that to what was charged to and collected from 
customers would otherwise be an internal auditing matter to make sure you were 
collecting the right amount so you don’t lose money or run afoul of the law.

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.

You might be able to employ a little extra work by putting the filter criteria 
in a note or memo. That way you can run a report restricted to matching that 
note or memo to aggregate sales.

As with all such questions, seek the advice of a local CPA before embarking on 
a particular bookkeeping method.

Regards,
Adrien


> On Jan 18, 2020 w3d18, at 9:27 PM, Keith Fetterman  
> wrote:
> 
> 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 appropriate sub account.  Seems 
> to be a bit of kludge, but maybe that’s how it is intended to work.  I am not 
> an accounting expert.
> 
> Thanks a lot for the help.
> 
> Keith
> 
>> On Jan 18, 2020, at 5:35 PM, Christopher Lam  
>> wrote:
>> 
>> 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 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 report 
>> based on last year’s sales by tax table.  So far, I haven’t found a report 
>> that like this version 3.8, but I may not know what it’s called.  Does it 
>> exist?
>> 
>> If not, how are other people handling this common issue?
>> 
>> Thanks
>> Keith
>> ___
>> 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.


___
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] Sales Tax Report

[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 tables) (and example
transactions) we can review the appropriateness of this report.

On Sun, 19 Jan 2020 at 03:27, Keith Fetterman 
wrote:

> 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 appropriate sub
> account.  Seems to be a bit of kludge, but maybe that’s how it is intended
> to work.  I am not an accounting expert.
>
> Thanks a lot for the help.
>
> Keith
>
> On Jan 18, 2020, at 5:35 PM, Christopher Lam 
> wrote:
>
> 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 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 report
>> based on last year’s sales by tax table.  So far, I haven’t found a report
>> that like this version 3.8, but I may not know what it’s called.  Does it
>> exist?
>>
>> If not, how are other people handling this common issue?
>>
>> Thanks
>> Keith
>> ___
>> 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] Sales Tax Report

[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 appropriate sub account.  Seems to be a 
bit of kludge, but maybe that’s how it is intended to work.  I am not an 
accounting expert.

Thanks a lot for the help.

Keith

> On Jan 18, 2020, at 5:35 PM, Christopher Lam  
> wrote:
> 
> 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 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 report based 
> on last year’s sales by tax table.  So far, I haven’t found a report that 
> like this version 3.8, but I may not know what it’s called.  Does it exist?
> 
> If not, how are other people handling this common issue?
> 
> Thanks
> Keith
> ___
> 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] Sales Tax Report

[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 you KNOW the 
customer's city/state for legal purposes? Are you keeping that data? The 
PHYSICAL location (city/state) as opposed to the city/state/zip of the 
post office that delivers mail to that location. Postal routes do NOT 
respect state boundaries.


Of course you would be in good company with perhaps the majority of 
businesses making mistakes with addresses close to state boundaries.


Michael

___
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] Sales Tax Report

[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 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 report
> based on last year’s sales by tax table.  So far, I haven’t found a report
> that like this version 3.8, but I may not know what it’s called.  Does it
> exist?
>
> If not, how are other people handling this common issue?
>
> Thanks
> Keith
> ___
> 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] Sales Tax Report

[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 report based on last 
year’s sales by tax table.  So far, I haven’t found a report that like this 
version 3.8, but I may not know what it’s called.  Does it exist?

If not, how are other people handling this common issue?

Thanks
Keith
___
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.