Profit & Loss Account Sheet has gone haywire

[ahathe60]

Hi there - hope you can help. when I open the Financial Accounts for the period and look at the profit and loss account the purchases after stock adjustment for each month should match the figure in the purchases column of direct material. For April to October this is fine and them in November my Direct Materials column reads 1680 but the P & L says £1724 and then in January direct Materials were £4155 but the P & L is showing a mere £641. This is obviously a disaster as I now do not know what my real profit and loss is and how much tax to put away. Also when I open the Financial Accounts you would press the enable updates button and you would see the figures change. This is not happening. Can someone please help me urgently as I just don't know what to do and I do not know enough about excel to be able to work it out and I know that Terry, very sadly, is no longer available to help. I hope someone will help me quickly !!

[ahathe60]

I also have the problem wth my sales for January. The P & L is showin Sales product A as £374 and it is £439,, the Sales of product B is £6287 and the P & L is only showing £2,589 and finally product C sales are £1796 and the sheet is showing £778. Please Please help me someone

[antonycc]

Hello,

Could you let me know which product you purchased and or send me your direct email (private message me if you like). I'll then check the exact product you purchased to see if there is an error in the formula on the Purchases or Sales sheets.

Alternatively email your sales and purchases sheets to terrycartwright@hotmail.com and I'll check what you have.

Thanks,

Antony.

[ahathe60]

Thanks Antony

I worked it out actually, Just changed my computer and for some reasons the formulas wouldn't update to look at the new drive, so until 5th April I will just update it manually. Only need to do it at month end in any case and then when I purhase for next year I should be fine. Thanks