Understanding the Review & Export Workflow

Understanding the Review & Export Workflow

Overview

The Review & Export workflow is the core process in LedgerSync for Accounting CS. This article explains each step from selecting a client to exporting transactions for Accounting CS.

The 4-Step Workflow

  1. Select - Choose client, bank account, and date range
  2. Load & Match - Retrieve transactions and apply matching rules
  3. Review - Verify vendor codes and GL codes
  4. Export - Generate CSV file formatted for Accounting CS

Step 1: Select Client and Parameters

When you open Review & Export, you'll see four dropdown controls:

  • Client - All clients from your LedgerSync account
  • Bank Account - Bank accounts for the selected client
  • Start Date / End Date - Date range for transactions

Best Practices:

  • First time: Start with 1 month to test
  • Recurring: Match your accounting close periods
  • Large volumes: Process in smaller chunks

Step 2: Load & Match Transactions

Click Load Transactions. The system:

  1. Retrieves transactions from LedgerSync (5-15 seconds)
  2. Applies rule-based matching (60-75% match rate)
  3. Uses AI matching for unmatched items (15-20%)
  4. Applies semantic matching as fallback (5-10%)

Match Indicators:

  • Green - Rule match (high confidence)
  • Yellow - AI match (review recommended)
  • Blue - Semantic match (verify carefully)
  • Red - No match (requires manual assignment)

Step 3: Review Transactions

Transactions appear in a table with columns:

  • Date, Description, Amount
  • Vendor (editable), GL Code (editable)
  • Status (match method used)

Making Corrections

  1. Click on the transaction row
  2. Click in the Vendor or GL Code field
  3. Type to search, select from autocomplete
  4. Press Enter to save
  5. System offers to create a rule

Bulk Editing

  1. Check boxes next to multiple transactions
  2. Click "Bulk Edit"
  3. Choose "Set Vendor" or "Set GL Code"
  4. Apply the change

Step 4: Export to CSV

When all transactions are assigned:

  1. Click Export to ACS Format
  2. System generates 11-column CSV file (2-5 seconds)
  3. Download link appears in Export History
  4. Save file for Accounting CS import

CSV File Format

The exported file contains 11 columns:

  1. Date (MM/DD/YYYY)
  2. Transaction ID
  3. Vendor Code
  4. Description
  5. Debit / Credit
  6. GL Code
  7. Department, Reference, Memo, Class

Workflow Tips

  • Process in batches - Do multiple clients in one session
  • Review largest amounts first - Catch errors on important transactions
  • Create rules as you go - Each correction improves future matching
  • Double-check AI matches - Yellow highlights need verification

Common Questions

Q: Can I save progress and return later?
A: Yes, edits are auto-saved. Close the browser and return anytime.

Q: Can I export multiple times?
A: Yes, each export creates a new timestamped file in Export History.

Updated: March 19, 2026

    • Related Articles

    • Understanding the Review & Export Workflow

      Overview The LedgerSync for Accounting CS application uses a 4-step workflow to process bank transactions: Select, Load & Match, Review, and Export. This article explains each step in detail and how to use the workflow effectively. The 4-Step ...
    • Understanding Ledgersync Pricing - Complete Guide

      Overview Ledgersync offers transparent, volume-based pricing designed specifically for accounting firms, bookkeepers, and tax professionals managing multiple clients. Our all-in-one bundled pricing includes statements, transactions, check images, and ...
    • Creating and Managing GL Code Rules

      Overview GL Code rules in LedgerSync for Accounting CS help automatically assign correct GL codes to transactions. This article explains how to create and manage GL code rules. Understanding GL Codes GL codes are numeric identifiers that categorize ...
    • What is LedgerSync for Accounting CS?

      Overview LedgerSync for Accounting CS is a specialized web application designed specifically for accounting firms using Thomson Reuters Accounting CS. It automates the process of categorizing and exporting bank transactions from LedgerSync directly ...
    • Understanding Bank Connection Security and Token Requirements

      Overview When connecting bank accounts to LedgerSync, you may occasionally encounter security requirements such as token codes or multi-factor authentication (MFA). This article explains why these security measures exist and how LedgerSync works to ...