DealershipForum.com

DealershipForum.com (http://www.dealershipforum.com/forums/index.php)
-   Parts (http://www.dealershipforum.com/forums/forumdisplay.php?f=59)
-   -   Battery sales report (http://www.dealershipforum.com/forums/showthread.php?t=4261)

InBloom94 04-27-2018 02:20 PM

Battery sales report
 
Every 3 months our accounting manager wants a report showing how many batteries we sold that quarter for battery tax fee paid...I usually just print out a list of all the stocked batteries in the battery bin and tally up the totals for those 3 months. It's not 100% because of the non GM batteries that we would put on in that time frame I don't really have a way to trace so I usually just add a few to the total. Anyone know how to maybe create an English statement report that would show it or do any of you guys even mess with it?

zep33 04-30-2018 01:20 PM

Do you have batteries in their own source(s)?

If not, you might want to consider it. Would be easy to pull sales from a source

I have to do it with tires every month so they're all in their own source. Toyota in 50 and aftermarket in 51

InBloom94 05-08-2018 03:30 PM

yes, we have batteries in their own source

zep33 05-10-2018 12:56 PM

If you're on CDK - run your MGR report and just choose that source then.


Do that monthly and every 3 months, add them up

Megadraught 05-23-2018 11:09 AM

If you have R&R, you can also make a report on sales by group number.

tnpartsguy 07-05-2018 12:00 PM

I used 19000000-C for my battery core part # on ALL batteries. Made it easy to do that count every month.


All times are GMT -7. The time now is 06:51 AM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright DealershipForum.com - 2008 - 2016