https://store-images.s-microsoft.com/image/apps.120.1f017543-53bc-4217-aa57-098d0eec6354.b9ee229a-af72-42bf-aaca-0648db4d5f5e.59f84a22-3f15-4965-b2ff-3dc502f6cdcb

Advanced Inventory to G/L Reconcile Report

by Solution Systems, Inc.

This report helps the accounting team reconcile Item Ledger Entries to the General Ledger in BC.

The Inventory to G/L Reconcile report has been available as a standard report within Business Central for many years and without any significant improvements. This report is one of the primary tools used by the accounting and finance team at the end of each accounting period to reconcile the detailed Item Ledger Entries to the General Ledger within Business Central.


While this report has served as an effective way to reconcile the inventory sub-ledger to the General Ledger, this new Advanced Inventory to G/L Reconcile report has been enhanced to improve the visibility to the types of expected costs and changes have been made to make the report more intuitive for users to understand.


These are the changes included in the Advanced Inventory to G/L Reconcile report:

  • A new column “Purch. Returns Shipped not Invoiced” has been added to provide greater visibility to value of purchase-related expected costs.
  • A new column “Sales Returns Received not Invoiced” has been added to provide greater visibility to the value of sales-related expected costs.
  • A new column “WIP” has been added to provide greater visibility to the value of interim work-in-process value.
  • The columns on the report have been reorganized and also have been color-coded in order to make the report easier for users to understand how the various columns relate to one another.
    • The “Value not yet posted to the G/L” has been moved to the far left and colored red to indicate that not all costs are fully reflected in the General Ledger.
    • The various types of expected costs are then displayed before the “Total Expected Cost” which is bolded to signify that this column is a total of the expected cost values.
    • The “Invoiced Value” column has been re-labeled to “Total Actual Cost” to provide greater clarity on how this column relates to the “Total Expected Cost” column.
    • The “Inventory Valuation” column has been moved to the far right side of the report and bolded to indicate that this is the grand total of value for each row and is the sum of the “Total Expected Cost” and “Total Actual Cost” columns.
  • The captions of each column on the report have been color-coded to make the report easier for users to understand which columns relate to one another in terms of reconciling the report to the activity in each G/L Account.

At a glance

https://store-images.s-microsoft.com/image/apps.6844.1f017543-53bc-4217-aa57-098d0eec6354.9753a4b3-fd12-4908-97ed-ea6a9118d694.bc312821-9d51-4c4e-9dfe-f1251c27e92c
/staticstorage/linux/20241105.1/assets/videoOverlay_7299e00c2e43a32cf9fa.png
https://store-images.s-microsoft.com/image/apps.17463.1f017543-53bc-4217-aa57-098d0eec6354.b9ee229a-af72-42bf-aaca-0648db4d5f5e.7fde7d4d-e9ae-4cea-b342-f93d06793e2a
https://store-images.s-microsoft.com/image/apps.30530.1f017543-53bc-4217-aa57-098d0eec6354.b9ee229a-af72-42bf-aaca-0648db4d5f5e.ce558d7b-a2f7-4b1f-926e-7c2353ddce4c
https://store-images.s-microsoft.com/image/apps.53726.1f017543-53bc-4217-aa57-098d0eec6354.b9ee229a-af72-42bf-aaca-0648db4d5f5e.77d9ea52-18d7-4c57-8c07-4648421f3142