See how Inventory Reconciliation works
Click a topic and Controlly explains how Inventory Reconciliation works.
With Update the app analyzes your value entries and G/L entries. Every next update continues from the last analyzed entry and can run at night through the job scheduler.
Result for you
An up-to-date reconciliation without manual work.
Reconciling inventory is hard
In standard Business Central, the reconciliation of inventory and work in progress with the general ledger is difficult to monitor. When differences appear, you get almost no insight into the cause.
Business Central does not show where a difference between inventory and ledger comes from.
For many users it is hard to follow how inventory transactions end up in the general ledger.
Finding the causes of differences in inventory valuation takes controllers a lot of time.
Every difference explained, per G/L account
Inventory Reconciliation analyzes the subledger (value entries) and the general ledger, and shows the result per general ledger account in clear pages. Finance teams and controllers can then explain every difference instead of searching for it.
- Inventory and work in progress reconciled with the general ledger
- Differences split into manual and other automatic postings
- Drill down per period or per posting group
How it works
Inventory Reconciliation works inside Business Central, online and on-premises.
Install the app from Microsoft Marketplace and register it with the wizard. This starts the free 30-day trial.
Choose Update to build the analysis. The first run can take a long time, so let it run at night through the job scheduler.
Open the analysis per general ledger account and drill down per period or posting group until the difference is explained.
Everything you need for a reliable inventory value
Reconciliation, explanation and analysis of differences in one app, right inside Business Central.
Inventory accounts
Subledger next to the ledger
Inventory, inventory (interim) and work in progress per G/L account compared with the general ledger.
Applied accounts
Result accounts too
Reconcile the accounts for sales, purchase and production variances with the general ledger.
Difference split
Manual or automatic
The difference is split into manual postings and automatic postings without a link to a value entry.
Setup then and now
Changes in posting groups found
Compare the posting group setup used at posting time with the current setup.
Drill down
Per period and posting group
Trace a difference back to the period or posting group in which it arose.
Nightly update
Always up to date
Let the analysis update automatically at night through the job scheduler. Every update continues where the previous one stopped.
Skipped entries
See what does not reconcile yet
Entries that could not be analyzed are shown with the reason, such as inventory cost not yet posted to the general ledger.
Date compression and dimensions
As detailed as you need
Analyze per day, week, month, quarter, year or accounting period, and on up to four dimensions.
Wizard
Get started quickly
A wizard helps with registration and checks the source code for inventory adjustments.
What is in it for you?
Every difference in the inventory value explained.
- Continuous insight into the reliability of your inventory value
- Differences explained instead of searched for
- Better prepared for year-end closing and the auditor
Insight without customization.
- Runs at night through the job scheduler
- No customization needed in Business Central
- Skipped entries shown with the reason
Quick answers to your customers' inventory questions.
- Reconciliation per G/L account, instantly visible
- A 30-day trial to test together
- Works online and on-premises
License and pricing
- Free 30-day trial, with insight into your first three months of inventory ledger
- Per month: 150.00 EUR/USD
- Per year: 1,800.00 EUR/USD
Good to know
The first update takes time
The first analysis processes all value entries and G/L entries and can, depending on your data, take a whole weekend. After that, every update continues from the last entry and is much faster.
Choose your settings first
Choose the date compression and dimensions before the first update. If you change them later, the analysis is rebuilt.
Accounting periods needed
The analysis needs accounting periods that cover the posting dates of your entries.
Start with a reliable inventory value today.
- Reconciliation per G/L account
- Differences explained right away
- Free 30-day trial
Built by 2-Controlware, specialists in authorization management for Microsoft Dynamics.
Discover our other apps
In addition to Inventory Reconciliation, we offer compliance apps for security, data quality and permissions in Business Central.
Field Security
Authorize on field and dataset level
Optimize the standard permissions structure at field, filter and action level.
Field Validation
Field validation on user level
Set up business rules for your data quality, so data complies before it is used in further processes.
Advanced Permissions Management
Track, review and roll back permission changes
See every permission set change, who made it and when, and undo a mistake in a few steps.
Advanced Permissions Recorder
Record, clean up and target permissions
Record the permissions of other users in a few clicks and clean up unnecessary entries automatically.
