Zero cost of returned goods while having quantity

@Tut Thank you for your input, i will answer your questions to the best of my ability.

I edited my post and attached a photo.

No, I don’t have tracking quantities to receive because I don’t use delivery notes and goods receipts.

I sold these products prior to using Manager some customers returned them because the products are new to the market and we accept returns. This issue should not be uncommon for those transitioning from other programs to Manager.

I don’t know that is why I ask, Maybe use the last/current averaged cost. Bare with me here please, If I had 10 units sold to customer A then and got a credit note for the returned amount of 50 from customer B. How sensible is it that Manager decides that 10 of those 50 units have a cost and the other 40 have no cost even though it is a totally different customer?

Exactly! This should be a deal breaker if someone wanted to transition to Manager they must enter all their previous records from years before using Manager. Because Manager cannot rectify this (If this is acceptable it should be noted in the guides).

So you suggest I enter all the transactions before using Manager? I don’t know what product might return next and how much should I go back maybe 6 months, one year, or two years!

I have worked on other accounting programs in my career and have never seen something like this. I hope I get a better solution because this is really not practical.

Which ones? There is no accounting program that can guess what you sold in the past without you inputting that information. Maybe rather than using credit notes in such instances you should issue a Sales Invoice and thus need to add the Customer to the Suppliers list (copy to Supplier). In such case the items will be added to your inventory and the payment is open and needs to be offset in future agains a Sales Invoice to that customer.

The One System for Accounting or Al-Ameen, are the ones I remember and they used GAAP. As for guessing the cost, I don’t know how they do it. but it is not mission impossible perhaps they used the current cost of the product.

I believe you mean a Purchase Invoice I thought about it but It seemed very complicated. I have to enter the cost myself and then figure out how to add the sales price because I need to deduct the amount from my customer’s account using the selling price not as cost.

@eko @Tut

This picture is from Zoho book

I don’t mind giving you guys examples from other accounting software If you want

Edit: Typos

@BawarYassin it is you as user that enters the information. I could show a similar screenshot from Manager. I f anything the one you showed is having 1 December 2022 as the Date and the other entries are already from January 2022. so one can assume that all transactions were already in the system. Your argument remains void.

@eko

By all means, go ahead and show me, please.

I think there is a misunderstanding Zoho sorts by oldest to newest contrary to how Manager sorts. You can see opening stock is at 01 Jan 2022.

@lubos Manager cannot use averaged cost so it introduces items with zero cost in credits notes! I would argue this is a bug and no other accounting software behaves like this. Average cost makes more sense than zero cost at any given moment.

Your argument is that for whatever reason other accounting programs are clairvoyant and can guess and input information from the past without any user input. Manager is not magical but as mentioned I am curious for you to show others as well because the Zoho example doesn’t show what you argue it would.

There is no magic involved it’s just the last average cost or initial cost. The “user input” can be the initial cost perhaps we start from that.

Zoho clealy shows what I am arguing for. I dont know what you mean.
This is another example from QuickBooks


In Manager the same transaction would report 200 qty and 300 cost value!

Manager doesn’t do FIFO but running average.

Although I share @BawarYassin’s views on costing of inventories, the developer is of the view that inventory cost should never be estimated by Manager in any situation, whether it was production with negative stock or in this case returns of items not in stock.

I think there is value in Manager estimation of transaction costs mainly due to the following:

  1. Whatever effects of estimation on inventory value is highly likely to be corrected once the stock has been revalued at reporting dates.

  2. Non estimation could distort profit and loss statements and cause management to be confused.

The investigation done by @BawarYassin is commendable but normally the user wouldn’t be able to precisely point the finger on where the discrepancy originated. Much like this other topic:

These kinds of errors are difficult to catch and correct and – realistically – this would more likely than not cause management to blame it on the system rather than the original user error.

Imho, I would prefer if Manager could do the cost estimation, but in case it doesn’t, a raised flag of the document (Credit Note in this case) together with a journal view for each document could help users identify such discrepancies and manually correct for them when they arise.

1 Like

@Ealfardan I fail to see the benefit of how the Manager does it but I hope it is worth it.
I have around 4800 USD difference between the actual stock amount and what Manager reports.
I don’t know how to readjust all these items. Using an expense account and journal entry will create a huge dent in my P/L statement.
If the developer has no intention of fixing this then finding an alternative solution is more tempting than entering all the previous transactions.

There is nothing for the developer to “fix”. Any Manager user is strongly advised to use the guides when setting things up. For Inventory Part 1 (of 4) see Manage inventory - Part 1 Introduction | Manager, clearly states that:

Average cost
Manager employs the perpetual average cost method for inventory valuation. This method divides the total acquisition cost of units of an inventory item in stock by the number of that item in stock. Thus, if more units are acquired at a cost higher than the current average cost, the average cost of all units will go up, no matter how many units are acquired or in stock or what their individual costs were.
When items are produced, the cost of inventory consumed is transferred to the new finished goods at the average cost of each input item. Any non-inventory costs are also apportioned among the finished goods.

@eko there is, I clearly stated it in this post I’m certain there are users who have the same issue and haven’t found out yet. Please note, by “fix” I don’t mean to change how Manager calculates cost ( although this is the optimal solution ). I just want to fix these discrepancies. one option is to allow the user to manually input the cost for these “Insufficient Qtys”

@Ealfardan already explained it all very clearly.

This is not due to Manager but

His suggestion for a fix still involves the user to

Therefore there are no shortcuts as you propose and need to “fix” the user errors yourself.

This so so-called error can only be avoided if the user had the superpower of predicting the future.

Fair enough, let us say it is a mistake on my side and Manager has no shortcomings. How can I find these errors to fix them if Manager sweeps them under the rug I have more than 850 inventory items?

Are you now suggesting that Manager or any other accounting package could have such superpower?

You already were capable finding some of the user errors so keep going at it.

No, only Manager makes this impossible. You mention other accounting software I hope you validate your claim and provide at least one example. I have yet to see an accounting software introducing items at zero cost!

It is not like I have a choice. I was hoping to get some help here.

Yes and here it ends.

I disagree. Even though this start with missing information, something could be done here.

Although I understand the thought behind @lubos decision not to estimate cost of stock items, I can also relate to @BawarYassin’s issue with this. Both are valid points.

A similar thread has already been in ideas but I’m hesitant to put this in ideas because I’m not sure whether this is to be handled by another idea, if that makes any sense.

More specifically this:

And this:

So, in case the cost estimates aren’t going to be provided by Manager, a flag needs to be raised and the user should be able to see the accounting effect for the transactions in order to understand how to correct them.

But we will have to see what @lubos thinks of this.

2 Likes

4 posts were split to a new topic: Journal Entries cannot correct for insufficient quantities of inventory