How to Pull a Detailed Transaction Report by GL Account in Sage Intacct

Use this guide to pull transaction-level detailed GL reports in Sage Intacct for accounts such as:

• Bank/Checking account (Deposits)
  
  
• Undeposited Funds
  
  
• Processing Fee GL (Card and ACH network fee)
  
  
• Surcharge Income GL
  
  

1. Navigate to the General Ledger Report

1. Log in to Sage Intacct.
   
   
2. Go to General Ledger.
   
   
3. Click Reports.
   
   
4. Select General Ledger.
   
   

2. Set Filters for GL Account and Date Range

Scroll to the filter section:

A. Filter by GL Account

1. Locate the Multiple Accounts filter for different GL accounts in one report
   
   
2. Choose the GL account you want:
   eg:
   
   • Bank / Checking Account
     
     
   • Undeposited Funds
     
     
   • Processing Fees
     
     
   • Surcharge Income
     

B. Filter by Dates

1. Choose Start Date and End Date.
   
   
2. Select the appropriate period for reconciliation.
   
   

3. Enable Transaction-Level Detail (Required)

Under Show transaction presentation, select:

✔ Details (not Summary)

This ensures every debit/credit line appears.

4. Show Document Number & Important Fields

To match Centime settlements, enable:

1. Under Select doc column value, choose
   ✔ Bill, invoice, or adjustment number
   
   
2. Use the Document Number, Transaction Number, or Memo fields to search for Centime-generated identifiers.
   
   Centime-generated values usually include payment IDs, invoice references, or settlement batch codes ideal for reconciling deposits.

5. Run or Export the Report

1. Click View to run the report or customize further as need
   
   
2. Click Print or Export → CSV/Excel for reconciliation.
   
   

Comparisson in Surchcharge Income vs Card Fee