Stock Reconciliation in Cash Flow Inventory: Documentation

Stock reconciliation is a cornerstone of inventory management, empowering organizations to detect and resolve discrepancies between recorded and actual stock levels. By adhering to the detailed workflows presented in this guide, stakeholders—such as inventory managers, warehouse personnel, finance teams, and system administrators—can uphold the reliability of inventory data and ensure compliance with financial reporting standards.

This document provides a guide to the stock reconciliation process in Cash Flow Inventory (CFI). It covers end-to-end workflows, system behaviors, configuration prerequisites, API references, best practices, and troubleshooting. The process ensures that physical stock aligns with system records through structured counts and adjustments, supporting accurate inventory management and financial reporting.

2. Purpose and Scope

1. Objective: Ensure physical stock aligns with system records through structured counts and adjustments.
2. Scope: Applies to all warehouses, stores, and locations managed in CFI.
3. Audience: Inventory managers, warehouse staff, finance teams, and system administrators.

3. Prerequisites

3.1 User Roles & Permissions

1. Inventory Staff: Can create and enter counts.
2. Inventory Manager: Can review, approve, or reject counts.
3. Finance Team: Provides final sign-off for General Ledger (GL) posting.

3.2 Configuration

1. Define storage locations and site hierarchies in CFI.
2. Set tolerance thresholds (e.g., ±2% discrepancy triggers an alert).
3. Configure email notifications for high-value variances.

4. Reconciliation Workflow Overview

The stock reconciliation process in CFI consists of the following stages:

1. Count Definition: Define the type of count (Full, Cycle, Spot Check, or Auto Reconcile).
2. Count Execution: Perform physical enumeration and capture data.
3. Discrepancy Review: Review automated discrepancy calculations and assign reasons.
4. Reconciliation Actions: Approve or reject counts, then post adjustments.
5. Audit & Reporting: Generate logs, reports, and analytics for tracking.

5. Detailed Process Steps

5.1 Initiate Stock Count

The process begins by initiating a new stock count in CFI. The provided screenshot illustrates this step within the “Stock Count & Reconciliation” module.

Steps:

1. Navigate to Inventory > Reconciliation in the sidebar menu.
   • In the screenshot, “Inventory” is highlighted in orange, and “Reconciliation” is highlighted in blue, indicating the active section.
2. The “Stock Count & Reconciliation” page is displayed, featuring:
   • Title: “STOCK COUNT & RECONCILIATION” in bold at the top.
   • Select Stock Count Type: A prompt reads, “Choose the type of stock count you want to perform:” followed by four buttons:
     1. Full Stock Count: Counts all inventory in selected location(s) (highlighted in blue in the screenshot, indicating the default or most common choice).
     2. Cycle Count: Counts a subset of inventory on a rotating schedule.
     3. Spot Check: Quick count of specific items or locations.
     4. Auto Reconcile: Likely an automated reconciliation option.
3. Click the desired count type (e.g., “Full Stock Count”).
4. Specify the following details in the prompted form:
   • Count Type: Full, Cycle, Spot, or Auto Reconcile.
   • Location(s): Select one or multiple sites (default = all active locations).
   • Count Period: Define start and end dates.
   • Notes: Add optional free-text notes (e.g., “Year-end audit”).
5. Click Create Count (implied functionality, not visible in the screenshot). The system generates a unique Count ID (e.g., “JULY-2025_01”).

Screenshot Reference:

1. The “Select Stock Count Type” section displays the four count type options, with “Full Stock Count” highlighted.
2. The “+ New” button at the top-right may also initiate a new count, offering an alternative entry point.

5.2 Capture Count Data

Once initiated, the count appears under “Ongoing Counts” in the interface (as shown in the screenshot). Data can be captured via two methods:

Option A: Manual Entry

1. Go to Ongoing Counts section.
   • Example: “JULY-2025_01 – Full Stock Count” with status “In Progress.”
2. Click the Entry button (blue button next to the count entry in the screenshot).
3. Input the Counted Quantity for each SKU inline.
4. Save periodically to prevent data loss.

Option B: Bulk Import

1. Download a template via Export CSV (not visible in the screenshot but part of standard workflow).
   • Template columns: SKU, System Qty, and a blank Counted Qty.
2. Populate the Counted Qty column in the CSV file.
3. Upload the file via Import CSV.
4. The system validates the format and flags any errors.

5.3 Automated Discrepancy Calculation

After data entry, CFI automatically calculates discrepancies:

1. Formula: Discrepancy = Counted Qty – System Qty.
2. Percentage: (Discrepancy ÷ System Qty) × 100.
3. Items exceeding the configured threshold (e.g., ±2%) are flagged for review.

Screenshot Reference:

• The Discrepancies button next to the ongoing count suggests access to calculated discrepancies.

5.4 Discrepancy Review & Reason Assignment

1. Access the Pending Reconciliation grid (not shown in the screenshot but described in the workflow).
   • Grid columns: SKU Name, System Qty, Counted Qty, Discrepancy, % Variance, Reason (required), Action.
2. Click the Discrepancies button (visible in the screenshot) to view this grid.
3. For each discrepant item:
   • Select a Reason from the dropdown:
     1. Damage
     2. Theft
     3. Mis-count
     4. Data Entry Error
     5. Transfer In Transit
   • Optionally filter by variance or value to prioritize significant issues.

Screenshot Reference:

• The Discrepancies button indicates the entry point for reviewing and assigning reasons to discrepancies.

5.5 Approval Workflow

1. The Inventory Manager reviews the count:
   • Navigate to the ongoing count and click Reconciliation (blue button in the screenshot).
   • Approve: Updates System Qty to match Counted Qty.
   • Reject: Keeps the item pending, triggering a recount workflow.
2. Multi-Level Approval (Optional):
   • Inventory Staff enters counts.
   • Inventory Manager reviews.
   • Finance Team finalizes for GL posting.
3. Finalize the count:
   • Click Approve or Cancel (red button in the screenshot).
   • Approval finalizes the count; cancellation discards it.

5.6 Post-Reconciliation Actions

Upon approval:

1. CFI generates inventory adjustment transactions.
2. Creates journal entries:
   • Debit/Credit the Inventory Adjustment account.
   • Offset the Inventory balance.
3. Memos are auto-populated with “Reconciliation [Count ID] – [Date].”

Screenshot Reference:

• The Approve or Cancel button triggers these actions upon approval.

5.7 Audit & Reporting

1. Access audit logs:
   • Click the Logs button (blue button in the screenshot) to view the audit trail.
2. Generate reports:
   • Reconciliation History: Details user actions, timestamps, and before/after quantities.
   • Variance Summary: Dashboard widget showing top 10 SKUs by variance; trend chart for monthly discrepancy %.
   • Export Options: CSV/PDF for the entire count or filtered selection.
3. Review historical data:
   • The “Previous Stock Counts” section (empty in the screenshot) lists completed counts.

6. Best Practices

1. Schedule cycle counts weekly for high-turnover SKUs.
2. Set realistic variance thresholds to focus on material discrepancies.
3. Use spot checks for high-value or perishable goods.
4. Review discrepancy reasons monthly to identify training needs.
5. Close reconciliation cycles before month-end for accurate financials.

7. Troubleshooting

1. Issue: Discrepancies not visible after entering counts.
   • Solution: Ensure data is saved and the count is not in “Draft” status. Click the Discrepancies button to refresh.
2. Issue: Unable to approve a count.
   • Solution: Verify all discrepancies have assigned reasons and the user has appropriate permissions (Inventory Manager or Finance role).
3. Issue: GL posting fails after approval.
   • Solution: Check GL integration settings and confirm the Inventory Adjustment account is configured correctly.

8. Conclusion

The stock reconciliation process in CFI ensures accurate inventory records through a structured workflow of initiating counts, capturing data, reviewing discrepancies, approving adjustments, and generating reports. Leveraging the intuitive interface shown in the screenshot, users can maintain alignment between physical stock and system records, ensuring financial accuracy and operational efficiency.