Average cost v FIFO - thoughts....

NickSNickS Posts: 7Member

LS seems to offer the choice of both methods. We use LS with Xero. The official line is that LSA does not support FIFO therefore Average Cost should be used.

We have just started using LS / Xero. I have been trying to reconcile the inventory total in LS with the one in Xero. If everything goes smoothly they should be the same.

Suffice to say that given manual adjustments to quantity and unit cost don't make it as far as the accounting you are playing catch up before you even start.

Assuming you have caught all of the manual adjustments the rest should be plain sailing. Opening stock add purchases less cost of goods sold equals closing stock right? Wrong. With the 'average cost' setting the cost of good sold going across from LS to Xero is the average. However, the LS stock value is actually the individual units in stock multiplied by their individual purchase prices (which in my case were different depending on which batch). Consequently my inventory did not match after the first 2.5 months.

I'm not sure if this was an isolated incident (as it only seemed to occur with one item), but I did have to spend some considerable time trying to identify the problem.

It also got me to thinking why isn't FIFO supported??? Given all LSA does is send across purchases and cost of goods sold it shouldn't matter. Purchases will be at whatever cost the supplier invoices. COGS could be any number so long as the same number is used for both LS and Xero.

Anyway answers on a postcard - I will be having nightmares between now and the next time I try to reconcile our 2000+ lines of inventory!!

1 comment

  • NickSNickS Posts: 7Member

    A little update - although I still haven't quite gotten to the bottom of it I think LS stock (inventory if you don't speak British English) value in the 'asset' report is only ever a FIFO value (irrespective of whether you choose average or FIFO in settings).

    If you are using Xero you are 'forced' to choose average cost which basically means the total value of stock per LS is never going to agree to the total value of stock in Xero.

    I still don't have a really satisfactory explanation of why FIFO won't work with Xero - I am having to take that on trust (although I'm not the sort of person to do that!!).

    Is anyone else able to reconcile their inventory values between LS and Xero without a lot of additional work and pain??

Sign In or Register to comment.