DealersEdge Professional Forums

Have a dilemma where Parts Dept. tire inventory value (243) and Oil inventory value (244) is regularly incorrect with Accounting Dept. values for each. Reconcile every month end and Parts Dept Tires (243) value is higher than Acct Dept value, as well as Parts Dept Oil (244) value is lower in Parts compared to Acct Dept.

The values are almost offsetting.

We have Sources set up for Tires and Oil that appear to be correctly set up in 'Source Accounting' but something's amiss. We've verified a few Invoices/Repair Orders to see if they have posted to accounting properly and she indicates they've posted correctly.

I have accessed the GM Accounting Manual Online to make sure the correct accounts are being used, and I know it would become a blame game for the discrepancy, but I have every other item in our department 'dead nuts' on. We receipt TIres and Oil just like any other item and 'as far as I can tell', our Source Accounting is correct. It appears the issue is originating when the parts are charged out. I can't review office managers receipting practices.

I have limited access to Accounting, as it should be, but I can only investigate on my side, and I've verified my input methods already.

Anyone else ever had an issue with 243 & 244 accounts?

Thanks

Are the sales and cost of sales account numbers set up correctly as well (490 & 690 for tires and 491 & 691 for GOG)?

I find that those accts are moving targets as the gm billing lags behind. I try to reconcile it at fiscal inv but just look for obvious problems the rest of the year.

LOKI1 wrote:I find that those accts are moving targets as the gm billing lags behind. I try to reconcile it at fiscal inv but just look for obvious problems the rest of the year.

I think that's pretty true with all manufacturers

Do you use a monthly reconciliation form that accounts for items billed and not received and items received and not billed?

I use the one Mike has online each month but I only use it to watch for problems that might arise.

As far as accounts 490/491, 690/691, everything appears to be set up. We checked the posting of a Tire RO and an Oil RO and she claims everything posted okay.

We do account for invoiced but not received and received but not invoiced every month.

After reconcile, she states her value on 243 is approx. $6400.00 while my side is at $17,466.00. Oil in Acct 244 shows approx. $21,000.00, while parts shows $11000.00.
Almost an exact offset somewhere.

I have contacted a Consultant that our owner retains and asked him to look into things as I don't have the access I need to determine the cause.

Have you verified that the cost of your oil and tires are correct every month? I ran into this issue several years ago and found out that the tires and oil
are not on the price tape so if costs increase or decrease monthly like they do on tires then make sure your costs are correct in the parts inventory otherwise
you will be receipting your oil and tires at a different cost than accounting might be posting into those accounts of the daily parts invoices they receive for oil and tires purchases.
Just a thought.