search-icon

Shows the difference between stock on hand value and financial document value on the specified Effective Date. Check here first if you are seeing discrepancies between financial reports (Balance Sheet, Profit and Loss) and Inventory Reports (Inventory Movement Details, Product Availability, etc.). If there are no differences, this report will contain no data. Use this report to reconcile discrepancies between financial and inventory reports. 


Use this report to reconcile discrepancies between financial and inventory reports. Please note stock levels pertain to stocks received value and Balance sheet amount pertains to the invoiced amount. To zero out the difference, you need to make sure that stocks received are invoiced for the same amount the stocks are valued.


Sources of discrepancies include:

  • Goods invoiced, not received
  • Goods received, not invoiced
  • Quantity of product in invoice does not match quantity of product received (especially for Advanced Purchase)
  • Manual journals and additional costs added to a purchase


Prerequisite:



Table of Contents


Data from this report can be exported in Excel, PDF or RTF format. 


Input:

Effective Date ToSelect the effective date up to which to show results
LayoutSet to the Default layout. Allows selection of saved layouts, if any. 
Save Layout AsAllows saving of a layout for potential future use.
Reset LayoutResets layout to the default layout or selected saved layout.


Select Apply Filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing DEAR Reports - Filtering Reports for more detailed information about using filters. 


Output:

The following output fields are available for this report.


Fields
Task #Task number identifying task with detected difference
LinkLink to task associated with difference
AccountAccount name
Transaction TypeType of the task
Data Headers
Stock AmountStock Value in base currency
Document AmountDocument Value in base currency


FAQs

[back to top]


Why is there a stock amount and Document amount difference? And what does this difference mean?

Stock amount refers to the stock value while document amount is the value indicated on the document. Difference in value would occur if the stock received for instance is 100units @5 per unit and total amount would be 500 and stock is received but was not yet invoiced, in this case there will be a discrepancy of 500 where Stock amount is the value of received stocks while document amount is 0 having no invoice authorised for the purchase.  


Why are some tasks that appear on this report not being synced to Xero?

Entries are synced to Xero as soon as journal entry generating tasks are authorised and sync is initiated. Double check that your documents, purchase invoices, sales invoices, etc are authorised and completed to make sure that entries get synced to Xero.


Why does the Financial Transactions VS Stock On Hand Difference does not correspond with the difference between inventory movement summary report and general ledger in DEAR?

A reconciliation is needed to be able to check the differences. Inventory movement report cannot always explain all transactions, sometimes if additional charges is added with this account, it may introduce cost which is not accounted for in inventory cards. Comparison of financial reports is needed on transaction level (reconciliation).


Why haven't my manual journals been added to the stock on hand value? It is causing a discrepancy

If the document of the transaction consists Manual Journals posted with a different inventory account than what is used within the invoice lines, the report data will not capitalise that journal cost to the stock on hand. Please make sure the debit account of the manual journal matches the inventory account of the stock items to capitalise this cost and avoid discrepancies. 


Still no answer to your question? Please do not hesitate to get in touch with DEAR support.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.