tracezilla has a built-in [integration to the accounting system e-conomic] (https://www.tracezilla.com/en/tutorials/e-conomic-integration). With a few clicks you can transfer inventory valuation adjustments from tracezilla to e-conomic, allowing you to post your valuation.
Read more about how tracezilla calculates cost prices.
How you transfer inventory valuation adjustments depends on how your integration is set up. Are you unsure about how your integration is set up? You can read about the two ways to set up the integration here.
Transfer of inventory valuation adjustments (regular invoice)
With just three clicks, you can transfer inventory valuation adjustments, if you use tracezillas standard integration to e-conomic. You can read more about how to transfer inventory valuation adjustments here.
You can request a recalculation of the inventory value before transferring inventory adjustment entries to e-conomic. This can be done under Financial > Inventory valuation.
Note: The recalculation may take some minutes and will affect system performance while it is running. Therefore, do not start a recalculation when you and your colleagues need to work in the system at the same time, as the system will run more slowly.
While the recalculation is in progress, the button will appear greyed out, and the two arrows forming a circle will rotate. Once the recalculation is complete, the arrows will stop rotating, and a timestamp will be displayed.
Transfer of inventory valuation adjustments (manual invoice).
When a General Ledger journal is transferred, it is possible to request the transfer to include inventory valuation adjustments. Read how to create a General Ledger journal here.
You can request a recalculation of the inventory valuation before transferring to e-conomic. The recalculation may take a few minutes. While the recalculation is taking place, the button will turn gray and the two arrows that form a circle will rotate. When the recalculation is complete, the arrows will stop rotating and there will be a time stamp.
Please note that if your company has recently implemented tracezilla, you should not transfer inventory valuation entries to e-conomic for the period in question.
Reason:
A draft entry is created to reflect the valuation increase. However, this entry will not match your actual purchases or the total amount of posted supplier invoices in e-conomic.
When tracezilla is implemented, the stock is uploaded using an import template for lots. During the import, tracezilla creates the lots/batches as lines in purchase orders.
Purchase orders are automatically included as valuation increase (Inbound Total) in the inventory valuation report. This means that the amount recorded as valuation increase will appear higher in the month tracezilla is implemented than your actual purchases - the total of the posted supplier invoices - for that month.
Recommendation:
Instead, you can create a manual entry in e-conomic for the total inventory value in the month your company implemented tracezilla, based on the period-end total in the inventory valuation report.
What happens when transferring inventory valuation adjustments?
During the transfer, tracezilla checks the current movements for each of the individual months from the selected prime month. Deviations will be offset so that the movements in the individual months match the current figures. These posts will be offset against the balance account of the inventory.
When all of the selected months have been offset according to the current movements, the system will check the final balance on your inventory account in e-conomic.
If the final inventory balance in e-conomic deviates from the inventory valuation in tracezilla, an adjustment post dated the 1st of the selected Beginning Month is created.
In case part of the deviation is due to movements outside of the current financial year or in case the deviations come from periods prior to the use of tracezilla, these deviations will be balanced on the account for accruals in e-conomic.
tracezilla can not correct back in a previous financial year, if there are entries in the current year.
Periodicity, Accrual accounting
The transfer can include inventory valuation adjustments up to the last completed month. The time of recording and valuation of stock entries will initially be in the periods in which the expense is posted. The value of the stock entries will not be counted as withdrawal until the stock entry has taken place. If an invoice for a purchase is received after withdrawal has taken place, this withdrawal will be posted during the period in which the expense has been posted.
Updated date: 2021-07-02 09:44:00