Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls

Order reports module for X-Cart 4 & 5
 
Reply
   X-Cart forums > News and Announcements
 
Thread Tools
  #11  
Old 02-03-2016, 05:53 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,423
 

Default Re: Order reports module for X-Cart 4 & 5

Hi @hartwellj,

See your message. Will get back to you tomorrow.

Thank you.

Tony
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #12  
Old 03-22-2016, 04:21 AM
 
hartwellj hartwellj is offline
 

Senior Member
  
Join Date: Dec 2007
Posts: 137
 

Default Re: Order reports module for X-Cart 4 & 5

Quote:
Originally Posted by tony_sologubov
Hi @hartwellj,

See your message. Will get back to you tomorrow.

Thank you.

Tony

I have not gotten an update for this? What's the status on the Sales Tax Calculations.
__________________
Version 5.2.10 - Live
Reply With Quote
  #13  
Old 03-22-2016, 04:37 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,423
 

Default Re: Order reports module for X-Cart 4 & 5

Hello @hartwellj,

I have sent you couple of emails after you sent me CSV sample, but I did not get replies. Sorry for the miscommunication happened.

Already emailed you about the module.

Tony
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #14  
Old 03-25-2016, 07:24 AM
 
learnteach learnteach is offline
 

Member
  
Join Date: Sep 2010
Posts: 25
 

Default Re: Order reports module for X-Cart 4 & 5

Quote:
Originally Posted by tony_sologubov
@hartwellj, @thebluedoorboutique, @learnteach, can you pm me or write to sales@x-cart.com with reference to Tony Sologubov and this thread about sales report?

I would want to understand how sales tax report must look like and then extend current module or write a new one, so you could easily handle taxes.

Hi Tony,

I am no tax expert, The report would have to basically total all the sales tax that was actually collected and paid paid by customers at checkout. The actual sales tax charged would be determined what the settings are in the Sales Tax Mod set up by store admin (i.e. sales tax charged at checkout).

We need a total of sales tax "collected / paid by customers" for a specific period and for a specific state. Also need a total sales for the period that was taxed and the total sales not taxed (for the same state). Remember sales tax is not charged on all products. Have a look at some state tax return forms and you will see what info they ask for.

Some companies pay the sales tax to their states treasuries monthly, other quarterly and other annually. Some companies only charge sales tax to customers that reside in their specific state others charge in multiple states if they warehouses in more than one state.

Hope this helps.
__________________
4.4.0
Reply With Quote
  #15  
Old 03-29-2016, 06:53 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,423
 

Default Re: Order reports module for X-Cart 4 & 5

Thanks for more info!

I can easily add a breakdown of sales by taxes paid and state, but I guess it would not be enough.

At the moment I am trying to reach out to merchants who actually want to have automation in preparing tax reports, so they would tell me in what format they want to see the report in.

@learnteach, could you please tell me how do you deal with taxes right now? Once I know the process, I will be able to suggest how to automate and simplify it.

Tony

Quote:
Originally Posted by learnteach
I am no tax expert, The report would have to basically total all the sales tax that was actually collected and paid paid by customers at checkout. The actual sales tax charged would be determined what the settings are in the Sales Tax Mod set up by store admin (i.e. sales tax charged at checkout).

We need a total of sales tax "collected / paid by customers" for a specific period and for a specific state. Also need a total sales for the period that was taxed and the total sales not taxed (for the same state). Remember sales tax is not charged on all products. Have a look at some state tax return forms and you will see what info they ask for.

Some companies pay the sales tax to their states treasuries monthly, other quarterly and other annually. Some companies only charge sales tax to customers that reside in their specific state others charge in multiple states if they warehouses in more than one state.

Hope this helps.
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #16  
Old 04-05-2016, 04:39 PM
  cherie's Avatar 
cherie cherie is offline
 

X-Wizard
  
Join Date: May 2003
Location: USA
Posts: 1,531
 

Default Re: Order reports module for X-Cart 4 & 5

Quote:
Originally Posted by tony_sologubov

automation in preparing tax reports
This is very important.
__________________
redli.me | xcarthelp.com
custom mods and design integration
4.7 linux
Reply With Quote
  #17  
Old 04-05-2016, 04:56 PM
 
hartwellj hartwellj is offline
 

Senior Member
  
Join Date: Dec 2007
Posts: 137
 

Default Re: Order reports module for X-Cart 4 & 5

Automation is hard. I would settle for a simple break down by state. It'll be very hard to find a lookup table for all of the taxes and not to mention some counties have an additional surcharge tax as well.
__________________
Version 5.2.10 - Live
Reply With Quote
  #18  
Old 10-14-2016, 03:53 PM
  cherie's Avatar 
cherie cherie is offline
 

X-Wizard
  
Join Date: May 2003
Location: USA
Posts: 1,531
 

Default Re: Order reports module for X-Cart 4 & 5

Quote:
Originally Posted by tony_sologubov

start simple and will be enhancing the module
Looks like this has become stale. This is a pricey module with promises of future enhancements. Please consider updating datepicker widget and adding more reporting on a regular basis (v4).
__________________
redli.me | xcarthelp.com
custom mods and design integration
4.7 linux
Reply With Quote
  #19  
Old 10-15-2016, 11:52 AM
  tony_sologubov's Avatar 
tony_sologubov tony_sologubov is offline
 

X-Cart team
  
Join Date: Jan 2009
Posts: 2,423
 

Default Re: Order reports module for X-Cart 4 & 5

Hi @cherie,

Thanks for follow up on this. I am actually ready to add new reports on regular basis as long as there is need in them. However, I have not had any requests to add new ones yet. People just buy what we have and if I ask whether they need some extra metrics, they just do not respond.

If you have any clients that would like to see some new reports, let me know so we could discuss the details.

Tony
__________________
Found a bug in X-Cart? Post it to our bug tracker!
Know how to make X-Cart better? Suggest an idea!
Reply With Quote
  #20  
Old 10-15-2016, 12:01 PM
  cherie's Avatar 
cherie cherie is offline
 

X-Wizard
  
Join Date: May 2003
Location: USA
Posts: 1,531
 

Default Re: Order reports module for X-Cart 4 & 5

- Datepicker should be updated
- Columns should be sortable (reported to you separately)
- Tax reporting should be added (noted in this thread)
- Add interactive graphs
- Add integration with other modules, such as the ability to create targeted marketing lists of customers based on sales data/reports (see now-defunct third-party marketing reporting modules).

If you spend a few minutes one-on-one with any store owner who's been using X-Cart for a while they'll give you the feedback you should be looking for. Otherwise, make it free and included. It's too expensive as-is.
__________________
redli.me | xcarthelp.com
custom mods and design integration
4.7 linux
Reply With Quote
Reply
   X-Cart forums > News and Announcements


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 04:37 PM.

   

 
X-Cart forums © 2001-2018