Spreadsheet: 855609d1705132027-the-following-batch-of-products-is-available-for-use-under-the-fifo-method-at-the-reportin-batch-accounting-of-product-movement2
Sheet: FIFO

Batch accounting of product movement in the warehouse using the FIFO method
example of calculation |  |  | Daily movement
 | Total: |  |  |  |  | Technical columns |  |  |  | the formula incorrectly determines | as it should be | as it should be | as it should be | the formula incorrectly determines | as it should be | as it should be | as it should be
The reporting date (operation date) | Purchased a batch of products | Opening (Inventory) balance | Purchased quantity (Units Purchased) | Used quantity (Units Sold) | Closing balance (Units Remaining) | Cumulative total Purchases | Date difference | value | The date of purchase from which the FIFO batch was used | The date of purchase from which the FIFO batch was used | The date of purchase from which the FIFO batch was used | Used batch of products | Used transitional ending balance of the batch at the reporting date | The date of purchase of the batch in the [NAME] balance as at the reporting date | The date of purchase of the batch in the [NAME] balance as at the reporting date | The following batch of products is available for use under the FIFO method at the reporting date | Transitional Closing balance of the following batch at the reporting date
2023-12-28 00:00:00 | [NAME] | 3000 |  | 0 |  |  |  |  |  |  |  |  |  |  | 2023-12-28 00:00:00
2024-01-03 00:00:00 |  |  |  | 2500 |  |  |  |  |  |  | 2023-12-28 00:00:00 |  |  |  | 2023-12-28 00:00:00 |  | 500
2024-01-05 00:00:00 | [NAME] |  | 1000 | 0 |  |  |  |  |  |  |  |  |  |  | 2023-12-28 00:00:00 |  | 1500
2024-01-10 00:00:00 |  |  |  | 1400 |  |  |  |  |  |  | 2023-12-28 00:00:00 |  |  |  | 2024-01-05 00:00:00 |  | 100
2024-01-12 00:00:00 | [NAME] |  | 500 | 300 |  |  |  |  |  |  | 2024-01-05 00:00:00 |  |  |  | 2024-01-12 00:00:00 |  | 300
2024-01-13 00:00:00 |  |  |  | 100 |  |  |  |  |  |  | 2024-01-12 00:00:00 |  |  |  | 2024-01-12 00:00:00 |  | 200
2024-01-14 00:00:00 | [NAME] |  | 700 | 180 |  |  |  |  |  |  | 2024-01-12 00:00:00 |  |  |  | 2024-01-12 00:00:00 |  | 720
2024-01-18 00:00:00 |  |  |  | 130 |  |  |  |  |  |  | 2024-01-12 00:00:00 |  |  |  | 2024-01-14 00:00:00 |  | 590
2024-01-20 00:00:00 |  |  |  | 590 |  |  |  |  |  |  | 2024-01-14 00:00:00 |  |  |  |  |  | 0
2024-01-21 00:00:00 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2024-01-25 00:00:00 | [NAME] |  | 600 | 500 |  |  |  |  |  |  | 2024-01-25 00:00:00 |  | 500 |  | 2024-01-25 00:00:00 |  | 100
2024-01-29 00:00:00 | [NAME] |  | 900 | 450 |  |  |  |  |  |  | 2024-01-25 00:00:00 |  |  |  | 2024-01-29 00:00:00 |  | 550
2024-02-02 00:00:00 |  |  |  | 510 |  |  |  |  |  |  | 2024-01-29 00:00:00 |  |  |  | 2024-01-29 00:00:00 |  | 40
2024-02-05 00:00:00 | [NAME] |  | 1800 | 420 |  |  |  |  |  |  | 2024-01-29 00:00:00 |  |  |  | 2024-02-05 00:00:00 |  | 1420
2024-02-07 00:00:00 |  |  |  | 1410 |  |  |  |  |  |  | 2024-02-05 00:00:00 |  |  |  | 2024-02-05 00:00:00 |  | 10
2024-02-08 00:00:00 | [NAME] |  | 30 | 25 |  |  |  |  |  |  | 2024-02-05 00:00:00 |  |  |  | 2024-02-08 00:00:00 |  | 15
2024-02-13 00:00:00 |  |  |  | 10 |  |  |  |  |  |  | 2024-02-08 00:00:00 |  |  |  | 2024-02-08 00:00:00 |  | 5
2024-02-13 00:00:00 | Batch 9 |  | 540 | 120 |  |  |  |  |  |  | 2024-02-08 00:00:00 |  |  |  | 2024-02-13 00:00:00 |  | 425