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.
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB