Tire Inventory Account w Large Discrepancy

Fixed Ops Mgr
Posts: 192
Joined: Sat Feb 25, 2017 5:32 pm

Tire Inventory Account w Large Discrepancy

Post by Fixed Ops Mgr »

We recently completed our full physical inventory on 10/31/21 and I have a dilemma on my hands that I just can't figure out so I am hoping someone can explain reconciling the tire account process that is supposed to take place in the accounting regularly? We try and keep roughly 80 tires in stock at an parts inventory value of between 12,000 and 14,000 at any given time. When we did our full physical inventory we counted 16,027 worth of tires with a unit count of 98 tires on hand. Everything looks correct and I am feeling good about the inventory until accounting tells me that they show roughly 70,000 worth of tires in stock!! I say there is no way that we would ever have that many tires in stock at that high of a value amount so your accounting is wrong and I can foresee the blame game starting.
I have checked the following on my end: we have all of our tires in a stocking group 109 which places them into the tire inventory account 243 when we purchase and post in the tires, we verify that we are inputting the correct cost of the tire vs what we are billed by GM so that checks out correctly with the cost of the tire being correct when put into inventory and when sold on the RO, my sale account number is 490 and the cost of sale account is 690 and when I looked back over the past 11 months of transactions all the details look correct. The 490 and 690 accounts are hitting the 243 account so I would believe that as we buy and sell tires the 243 inventory account would balance out like our 242 parts account does which our parts account was right on the money. I called DealerTrack and they looked into the situation and they are telling me that nobody in accounting is reconciling tires and that is the reason for the large discrepancy. They tell me that the tire account has to be reconciled manually to make it balance out and I am not fully understanding that process of what needs to happen? I just want to make sure that all my bases are covered before I march into accounting and say that the tires problem is on your end because you are not reconciling the tire account. If anyone could explain how the tire account 243 is handled differently that the 242 account, I would appreciate it.
smoyer
Posts: 396
Joined: Thu Apr 21, 2005 12:00 am

Re: Tire Inventory Account w Large Discrepancy

Post by smoyer »

Do you code all the invoices go to accounting?
do you do a monthly reconciliation? dealer track actually has a pretty good reconciliation procedure
Fixed Ops Mgr
Posts: 192
Joined: Sat Feb 25, 2017 5:32 pm

Re: Tire Inventory Account w Large Discrepancy

Post by Fixed Ops Mgr »

I do code all the parts, tire, oil invoices before they go up to accounting and I give accounting my invoices on a weekly basis after they are coded. That is all that I do on my end. I would be interested in the DealerTrack reconciliation procedure. Where is this found?
smoyer
Posts: 396
Joined: Thu Apr 21, 2005 12:00 am

Re: Tire Inventory Account w Large Discrepancy

Post by smoyer »

Fixed Ops Mgr wrote:I do code all the parts, tire, oil invoices before they go up to accounting and I give accounting my invoices on a weekly basis after they are coded. That is all that I do on my end. I would be interested in the DealerTrack reconciliation procedure. Where is this found?
what is your email I will send you a copy of the excell sheet we use with instructions on how to find the info in dealertrack
Fixed Ops Mgr
Posts: 192
Joined: Sat Feb 25, 2017 5:32 pm

Re: Tire Inventory Account w Large Discrepancy

Post by Fixed Ops Mgr »

jbreitbarth at penzauto dot com
smoyer
Posts: 396
Joined: Thu Apr 21, 2005 12:00 am

Re: Tire Inventory Account w Large Discrepancy

Post by smoyer »

Fixed Ops Mgr wrote:jbreitbarth at penzauto dot com
sent
brparts
Posts: 55
Joined: Thu Sep 29, 2005 12:00 am

Re: Tire Inventory Account w Large Discrepancy

Post by brparts »

i was in this position a few years back. my inventory was alway over by a couple of thousand. one year i was short $23,000, could not find out why. they adjusted the GL to the inventory count. the next year i was over by $25,000. the auditors came in and found a bunch of bookkeeping errors from the prior year.but the office does not make any errors.
C8RFAN
Posts: 189
Joined: Wed Nov 06, 2019 7:03 pm

Re: Tire Inventory Account w Large Discrepancy

Post by C8RFAN »

brparts wrote:but the office does not make any errors.
Just went through the same thing :?
olepartsguy
Posts: 419
Joined: Thu Feb 27, 2020 4:37 pm

Re: Tire Inventory Account w Large Discrepancy

Post by olepartsguy »

AFTER YOUR INVENTORY WERE YOU UP IN 242 AND DOWN IN 243?
918PartsMgr
Posts: 22
Joined: Fri Aug 06, 2021 2:53 pm

Re: Tire Inventory Account w Large Discrepancy

Post by 918PartsMgr »

Does anyone have an excel spreadsheet for month end reconciliation that they wouldn't mind sending me? I'm on CDK if that matters? Having to key everything manually now and it's a pita.

Thank you,

Message me, and I can send you my email.
Post Reply