What is the Running Balance Report
Overview
The Running Balance report recreates the bank transaction page — the same view you see when you log into your bank online — and calculates a running balance at every transaction. It is most useful when a formal bank statement PDF is not available, such as for Capital One accounts or banks that restrict statement downloads. The report now includes a quality grading and verification system so you always know how reliable the numbers are before using them.
What the Running Balance Report Does
- Displays all transactions for a connected account in chronological order
- Calculates the running account balance after each transaction (current balance +/− each debit/credit)
- Shows the balance at any specific date, so you can use the last transaction on or before your closing date as the ending balance for that period
- Provides a quality grade (A–F) and a “verified through” date so you know how trustworthy the balance is
- Flags discrepancies where the calculated balance does not match the bank’s reported balance
How to Use the Running Balance Report
- Select the client from the left panel
- Make sure the bank account is connected to LedgerSync — the Running Balance is calculated from transactions pulled by LedgerSync, so the bank must be connected first
- Navigate to the Running Balance tab for that account
- The system calculates and displays the running balance on the right side of each transaction row
- To find the ending balance for a specific period (e.g., November 30), look at the last transaction on or before that date — its running balance is the closing balance for the period
The Running Balance is not as precise as a bank statement PDF for formal reconciliation. However, for Capital One accounts and banks that do not provide statement PDFs, it is the most reliable available alternative and has been tested to produce consistent results.Quality Grades — How Reliable Is My Running Balance?
Each account’s Running Balance now receives a quality grade from A to F based on how well LedgerSync can verify the calculated balance against external sources:
| Grade | What It Means |
|---|---|
| A | Running balance verified against bank snapshots and a second data source (MX). High confidence — safe to use for closing. |
| B | Verified against bank snapshots. Good confidence. |
| C | Partially verified. Some gaps in transaction data detected but balance is within acceptable range. |
| D | Low verification confidence. Use with caution — transaction data may be incomplete. |
| F | Balance cannot be verified. Significant discrepancies detected or insufficient data. Do not rely on this for closing without further investigation. |
Verified Through Date
Each account shows a “verified through” date alongside the quality grade. This is the most recent date up to which the running balance has been validated. If the verified-through date is older than expected, it may indicate that newer transactions have not been pulled in yet or that a data gap exists.
Discrepancy Flags
If LedgerSync detects that the calculated running balance does not match the bank’s own reported balance (from bank snapshots or MX), it flags the discrepancy rather than silently showing potentially incorrect numbers. A flagged discrepancy means the account needs attention before using the balance for closing purposes.
LedgerSync runs a nightly repair process that automatically attempts to re-pull data for accounts with identified gaps, so many discrepancies resolve on their own by the next business day.
Exporting the Running Balance
The running balance grid can be exported to Excel or PDF using the right-click context menu on the grid. This allows you to share the running balance report with a client or include it in a work file.
Best Use Case — Capital One
Capital One requires manual authentication for every statement fetch, which makes automated monthly statement pulls impractical. LedgerSync’s recommended workflow for Capital One:
- Use the Running Balance report for soft closes throughout the month — the transaction data pulls automatically via the Mastercard API with no MFA required
- Run Capital One statements twice per year for hard reconciliation — LedgerSync fetches 7 months of statements per login session, so you only need to ask the client for their MFA code twice annually
Need Help?
Contact LedgerSync Support at support@ledgersync.com
Related Articles: