Inventory Reconciliation Tips for Multi-Ledger Setup

If you have a multi-ledger setup, you must create a separate Inventory Reconciliation Schedule for each GL Ledger.

Step-by-Step Instructions:

1. Run Balance Sheet Report

   • Generate the Balance Sheet Financial Statement for each GL Ledger

   • Retrieve the month-end GL balances for inventory-related GL accounts

2. Customize the GF1003 Report

   • Open the standard GF1003 – Inventory to GL Reconciliation report

   • Apply a filter by GL Ledger

   • Ensure the correct Base Currency is selected for that ledger

3. Save Ledger-Specific Reports

   • Save a separate report for each GL Ledger for ongoing use

4. Copy the following values into your Excel reconciliation schedule:

   • Expected Cost

   • Invoiced Cost

   • Inventory Value

Article Inventory-Reconciliation-Tips-for-Multi-Ledger-Setup  ·  Last updated October 02, 2025 · GoldFinch ERP Help Center