End of Month (EOM) Details Report
The EOM Inventory Report is exclusively available to customers subscribed to our Accelerate or Elevate plans. You can review our pricing plans here.
If you're interested in accessing this report and want to review pricing plans, please reach out to your Settle Customer Representative for assistance.
This report provides full visibility into all of the data used to calculate your End of Month (EOM) Inventory Report. Customers can now validate data at the most granular level, making it easier to verify accuracy, reconcile discrepancies, and identify missing or incorrect data.
If you’ve ever wondered “How did Settle calculate this number?”—this is the report to check.
Why use the EOM Details Report?
The EOM Details Report is designed to give you transparency into the raw data behind your EOM Inventory Report. With it, you can:
Validate Report Accuracy: Review every event that contributed to the month’s ending balances.
Troubleshoot Discrepancies: If your EOM report looks off, the details report helps pinpoint exactly where the difference comes from.
Understand Data Flows: See how movements, costs, and balances are built up, item by item.
Collaborate with Support: Easily share detailed data with your Settle representative if you need help investigating an issue.
Key features
Each EOM Details Report provides a complete export of every event contributing to your month-end balances. The report includes the following columns:
Event Date: The date of the inventory event.
Event Time: Timestamp of the event for precise tracking.
Item Name: Name of the catalog item.
SKU: Unique identifier of the catalog item.
Location: Location where the inventory movement occurred.
Change Type: Type of change (e.g., Received, Transferred, Sold).
Document Type: Associated document type (e.g., Purchase Order, Work Order, GRN).
Document: Identifier of the document that triggered the event.
On Hand Delta: Change in on-hand inventory from the event.
Available Delta: Change in available inventory from the event.
Reserved Delta: Change in reserved inventory from the event.
Batch Received Date: Date the batch was originally received.
Batch Landed Cost per Unit: Landed cost associated with the batch.
Batch Source: The source of the batch (e.g., supplier, transfer).
Beginning Month Balance: Starting balance for the month.
End of Month Balance: Ending balance after all movements are accounted for.
How to access the EOM Details Report
Navigate to Reports: Go to the Reports section in your Settle dashboard.
Select EOM Details Report: Choose the End of Month (EOM) Details Report option.
Choose the Month: Use the dropdown to select a historical month. Note that the report for the current month will only become available on the first day of the next month.
Download the Report: Click Download to export the report in spreadsheet format.
Frequently Asked Questions (FAQs)
Q: How is this report different from the EOM Inventory Report?
The EOM Inventory Report provides a summarized view of balances and valuations. The EOM Details Report, on the other hand, shows all of the raw data (event by event) that was used to calculate those balances.
Q: When should I use this report?
If you or your team believe your EOM Inventory Report looks incorrect, start by pulling the EOM Details Report. It will show the underlying transactions and help identify missing or incorrect data.
Q: Does this report update intra-month?
Yes. Just like the EOM Inventory Report, you can download the EOM Details Report for the current month at any time to see activity up to that day.
Tips for making the most of your EOM Details Report
Validate Your EOM Report: Use this report to verify balances against your internal records.
Spot Data Gaps Early: Identify missing costs, unlinked SKUs, or incorrect movements before they affect reporting.
Collaborate Efficiently: Share the detailed report with your accounting team or Settle Support when troubleshooting.
Combine with the EOM Inventory Report: Use both reports together—summary and detail—for the clearest possible picture of your inventory activity.
For any questions or additional support with the EOM Details Report, please contact our support team.