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