Transactions VS Stock On Hand Difference Report

Transactions VS Stock On Hand Difference Report

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

 

Prerequisites

 

 

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

Input:

Effective Date To

Select the effective date up to which to show results

Layout

Set to the Default layout. Allows selection of saved layouts, if any.

Save Layout As

Allows saving of a layout for potential future use.

Reset Layout

Resets 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 Cin7 Core 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

Link

Link to task associated with difference

Account

Account name

Transaction Type

Type of the task

Data Headers

Stock Amount

Stock Value in base currency

Document Amount

Document Value in base currency

FAQs

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 authorized 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 authorized and sync is initiated. Double check that your documents, purchase invoices, sales invoices, etc are authorized 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 Cin7 Core?

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 Cin7 Core support.

Was this article helpful?

Have more questions? Submit a request