Different number of the same criteria in reports

1

|For the period from 01/04/2022 to 30/04/2022|

  1. Profit and Loss Statement:

    image
    image867×61 2.21 KB

    which represent the value of inventory write-off
    image
    image1751×1275 221 KB

  2. Inventory Value Summary

    image
    image1563×88 4.83 KB

One is 728…, another is 760…

Can you please tell me the difference of numbers. Thank you.

2

No one can help you with such limited information. Small bits of reports are useless for troubleshooting. You need to show the Edit screens for the reports.

I also suspect you are using the program incorrectly. Inventory write-offs should be rare. But you are entering many in a day. That suggests you are using inventory write-offs to accomplish something for which there are other, built-in features.

3

Here is the edit screen:

image
image1011×1307 25.4 KB

image
image630×687 12.6 KB

Yes, we use inventory write-off instead of sales invoices due to our limitation.

4

What limitation?

5

We use two system to record number.
One for sales invoice, then we pick the total money sales to manager.
So we use inventory write-off to track stock.

6

You should not use inventory write-off for that. If you for example use a POS then your detailed inventory management is done with the POS both on adding and taking away from inventory. You only need to record totals from POS and expend them against the POS total income.

7

Because we create purchase invoice for many customers with different sales price.
But the inventory just need amount.
i.e:

  • Sales invoice for customer A: 1.000.000VNĐ (bought inventory D,E,F)
  • Sales invoice for customer B: 1.500.000VNĐ (bought inventory D,G,H)
    etc

We write-off one for inventory D,E,F,G,H with total amounts sold.

8

Please first note what a write-off is in accounting see for example Write-Offs: Understanding Different Types To Save on Taxes.

This shows that as @Tut already indicated:

9

You can not do that in Manager. Manager assumes all stock items are identical and interchangeable.
You are using the wrong program to accomplish what you want to do.

Choices

  • Use Manager as it is designed to be used (invoices & stock +/- location, delivery notes).

  • Use other software (eg your POS system) to achieve the transaction & stock details and upload only daily totals to your accounting software (Manager).

10

When it works correctly, why do I shouldnot use it?
Everything needs user discovery to complete more. Why do you want us just use it as you want?

11

Because it does not work. Your post is proof of that. Functions built into the program work as they are designed to work, not how you want them to work.

12

I think we should investigate the case a bit further because while it’s true that @huyen maybe using write-offs creatively, but I can’t see how this should introduce differences in inventory value. That shouldn’t be the case anyway.

@huyen:

  1. what’s this account in English: “Gia von hang ban”?

  2. how did you setup your inventory items, do they all go to this Gia von hang ban?

  3. did you reconcile this account to the report? I mean narrow down the difference to a single period or a single item? This would help greatly in investigating this difference.

1 Like
13

Have you tried to uncheck the box that says Exclude inventory with no movement, in the inventory value summary report? This may or may not change anything.

1 Like