55 replies to this topic

[talon177]

I would love to see the tax and notax back in, as they're vary important for tax purposes

[zzfritz]

It is useful to know that many appreciated the prior attempt to summarize taxed vs. nontaxed sales, for the same reason I did.  Indeed, it was meant to please an accountant.

One uncertainty I had about taxed/nontaxed is this:  should the distinction be based simply on whether the products were shipped inside or outside the store zone (the presumptive basis for sales tax in the US states).  Earlier versions of the report divided the product subtotals this way.  

The alternative, employed in version 2.0, is to summarize the subtotals of orders which had some tax charged, and those which had no tax.  This has the virtue of being apparently independent of the reason for charging tax (i.e., not based on the shipping destination).  But it could be deceptive if an order included some taxed and some nontaxed items, in which case to get an accurate summary the report would have to walk through each product of each order as the checkout process did.  I am not even certain that all the details available at checkout are retained in the database to permit such an approach.

Maybe I should post three variations of this report:  one without the taxed/nontaxed columns, one with the columns based on store zone, and one based on whether tax was charged.  Opinions, please?

Edited by zzfritz, 13 April 2004 - 12:27 AM.

[azer]

i now understand the trouble that the calculation of taxes can be ..
by the way , im in europe and it would be evene more complicated because some people from inside europe have to pay the taxe , and other form outside dont have to if they are entreprises , but should pay the taxes to their country  .. i dont enter in details since i didnt really understood all the aspect ... but this taxe matters is important , and need to be really precisly implemented , seing all the cases ....   thanks for this usefull report tool .. i m willing to translate it in french if nobody did it already ...

[talon177]

Could it just give the total of products purchased with tax, and then products purchased without tax. In the US you would only charge tax for the state your business is operated in. Having this would surely help accountants and yourself do your taxes.

Thanks again

[kooyan]

Let's see if I can help a little bit.

First of all:
-  I use your report almost everyday to get a hint how my store is doing.

Next:

- I use your report 1.5 2003/01/04
This one works perfect

I want to show what is pulled out of the database and how to read it:

German:
- Monat
- Jahr
- Brutto Wert Rechnungen (inkl. Steuern aber ohne Nachnahme Gebühr)
- Brutto Wert Produkt Verkäufe
- Verkäufe außerhalb Brandenburgs
- Verkäufe in Brandenburg
- Steuern 7% und 16%
- Fracht & Verpackung
- Nachnahme Gebühr

English:
- month
-year
- Gross amount all bills (inkl. tax but without COD Fee)
- Gross amount all products sales
- Sales outside of brandenburg
- Sales in Brandenburg
- Taxes 7% und 16%
- Fright and shipping
- COD Charge

Version 2.1 prints out

German:
- Monat
- Jahr
- Netto Wert Rechnungen (ohne Steuern aber mit Nachnahme Gebühr)
- Brutto Wert Produkt Verkäufe
- Steuern 7% und 16% mit pop up
- Fracht & Verpackung
- Nachnahme Gebühr

English:
- month
- year
- Net amount all bills (without tax but with COD Fee)
- Gross amount all products sales
- Taxes 7% und 16% with pop up
- Fright and shipping
- COD Charge

Pop Up in V2.1
2004/4
-----------------------------------
enthaltene (incl). 16% MwSt: 7.43
enthaltene (incl) 7% MwSt: 0.90
enthaltene (incl) MwSt. 16%: 0.66
-----------------------------------

(I changed of course the values, I made them higher   )

I personally don't use the tax calculation of OSC, because it is not a certified tool, but of course I enjoy reading it. Anyway I am wondering why the tax class 16% shows two times in the pop up. I only definied 2 Tax clases (7% reduced and 16% normal tax).

I would love to have back the total of saales in gross amount (incl. tax) because the number is higher    and I really find it very useful to see how maany people are ordering in the same state (Brandenburg) where we are located, because they could also buy our beer in a normal shop, but they enjoy shopping over the internet. So this is indeed a very interesting figure.

I hope to help the discussion.

With best regards

Stefan Fritsche
www.klosterbrauerei.com

Edited by kooyan, 13 April 2004 - 10:00 AM.

[zzfritz]

Keep the feedback coming, it is helpful.

I am studying the way order totals are calculated in checkout, so the report can reconstruct the summary in the same way.  This requires finding the status (on or off) and the sort order of the configuration variables (MODULE_ORDER_TOTAL_SUBTOTAL_SORT_ORDER, MODULE_ORDER_TOTAL_TAX_SORT_ORDER, etc).  The report could adapt (as it already does to the presence or absence of the low order fee and 'extra' orders total class such as gift voucher) to each store's configuration.

This still leaves the question of whether taxed vs. nontaxed order subtotals are determined by the presence or absence of tax in the order total, or by the shipping zone.  The former (presence or absence of tax) is probably better, although not absolutely perfect.  If an order could contain both taxed and nontaxed items, neither method will produce a correct summary.  That bothers me a little.

Re the popup detail of tax, the method used is simply to group the orders total entries (for the relevant dates and status) by the title field.  To use kooyan's example above, "enthaltene (incl). 16% MwSt:", "enthaltene (incl) 7% MwSt:" and "enthaltene (incl) MwSt. 16%:" are found in this field and therefore summarized separately because they are not identical.  Can anyone explain why checkout (which creates the orders_total table entries), is storing the text description of the 16% tax in two different ways?  If checkout stored the tax_class_id instead of (or in addition to) the tax_class_description, this question would not have to be asked.

[talon177]

Hey Fritz,

Here's another possible example of a order total.

Item Purchased: 10.00
Discount: 1.00
Tax: 8.25% = 0.83
Subtotal: = 9.83
Shipping: = 5.00
Handling: = 0.00
Gift Voucher: 2.00
Grand Total: 12.83

This is just an example.

[kendallb]

Fritz, I am new to this OSC thing, and your module sounds very similar to what I am looking for. One thing missing from your module is the ability to keep track of the cost price of items in the store, so the totals module can total up the profit on those items at the end of the month.

Have you thought about adding something like this to your module? I can't find anything like that right now, so I might start working on adding support for this, perhaps as an extension to your module.

Thanks!

[Kraven_UK]

Fritz,

Just installed Version 2.1.1,
Thanks for putting the 2 colums back, I can live with it now

And now the gross sales are correct too.

Great contribution.

[zzfritz]

Talon's example is a good demonstration of how elaborate a store's order total structure can be, and why it is so difficult to make this report work for everyone.  But I do believe it can be done, using the sort order of the order total components, in the next major revision.

Kendall, the reporting of store profit is a fine objective but must be the subject of another report.  Just reporting the income is complicated enough for this project.

I am looking for feedback to confirm the latest v2.1.1 is okay for those who wanted the nontaxed and taxed columns back in simple store configurations.

[sw45859]

just figured i would post and let you guys know and let the creator know that this is adding the subtotal and total together for all orders so your gross earnings are not reported correctly, they are actually doubled, and i have created the products cost/profit report for this but i have to test a little more before sharing the code for it and i am also going to look at the addition of the total and subtotal and cancel that out and i will let you guys know how it comes along.

[CatDadRick]

Zzfritz,

I installed the contrib but I have a couple of problems with it...

I am unable to "drill down" on anything. I just get the "Monthly Sales/Tax Summary" listing and nothing is clickable.

All sales are listed as "Exempt" even though about half of them are taxable. The "Taxes Paid" column is correct.

Thanks,
CatDadRick

[zzfritz]

CatDadRick:  are you sure you installed v2.1.1 of the report?

The column heading "exempt" was changed to "nontaxed" since v2.0.

Click the Help button, and scroll to the bottom where it says "v 2.1.1"

The month names in the left column should be active links, as should the tax values.

[CatDadRick]

Zzfritz,

Thanks for your reply. I found the problem but could not get into the forums to post.

I have two catalog installations, one live and one just for testing. I installed your mod to my test site, but was trying to get it to work on the live site. When I tried the mod on the test site, it worked flawlessly, so I've installed it to my live site. Great work.

Thanks,
CatDadRick

[jloyzaga]

Sorry to Fritz, I sent him an email before I found this thread.....

Can anyone tell me what the sql would be for getting the report

to be able to select a particular manufacturer to report on.

That way I can get the monthly sales & tax report per manufacturer  so I can see their sales.

It would be great if that could be parameterised but just the sql mod would be great - can anyone help please?

Joe

[cmastere]

  For you people that couldn't get this thing to work right the first time because you can not find this .php file as instructed in step 2 of the installation guide:

admin/includes/filenames.php

try modifing this file instead :

admin/includes/application_top.php

took me a while tring to figure out what's going on, and finally found out that my version of osC ( I just installed today 05/05/04 ) have a different data structure (not only this file).  

Peace Out!

By the way, GREAT WORK, zzfritz , keep it up!

[1nsane]

Has anybody figured out the problems with the CSV output when using SSL?  I have this same problem and a solution would mean a great deal to me.

[1nsane]

anybody?

[Acheron]

kendallb, on Apr 14 2004, 07:14 PM, said:

One thing missing from your module is the ability to keep track of the cost price of items in the store, so the totals module can total up the profit on those items at the end of the month.

I have been thinking about the same thing but as fritz said, it's a totally different animal.  In concept though, it should be fairly easy for someone with decent PHP/SQL knowledge to put it together.  You would need a new field in admin during product entry for the price you paid per item and then link to that to the product sales.  Would display a total sales and total you paid, subtract one from the other for your profit.


Anyway, I was just about to add fritz's mod so I have no comments yet other than to say THANKS!     This mod is perfect for my site as I only sell taxable items and atm at least, I don't use any sort of coupon mod.  And I file my own taxes (and dread doing so) so anything that makes it a little easier is a welcome addition.

[michael23]

Hello everybody,

I was unable to find the solution for my problem, so I have to post it:

The tax for our store, located in Germany, is counted double. Does anybody know how to change this?

Thx, Michael