What is the Running Balance Report
What is the Running Balance Report and what does it do?
The Running Balance report is a calculated balance report at the transaction level much like one would see a transaction web page of any standard bank web site. Ledgersync is re-creating the bank transaction page that one would see when logging into the bank web site.
** Make sure to please connect the bank in order for Ledgersync to download the bank transactions and calculate the Running Balance.
The math is pretty simple: Take current balance and plus/minus the debits and credits for each transaction and show the account balance at the transaction level.
Why is this needed?
There are two main use cases for this:
1- Showing cash flow at the transaction level
2- In the event a bank statement cannot be provided, the last transaction of the closing period is the ending balance . This is exactly how bank statements ending balance number works. For example, if you need the ending balance on Nov 30 2024 of a Capital One BankStatement, the last transaction on or before Nov 30th is the ending balance for Nov 2024 for that account.
How to use the report?
a) Select the bank account you want to see the running balance for ( make sure to connect the bank account first to Ledgersync)
b) Let the system run and update the numbers
c) You should see the running balance on the right hand side
d) The LAST TRANSACTION on or before the closing date is the Ending Balance.
** We know this is NOT as good as the PDF Bank Statements but after many tests matches up to the statements
*** Ideal for Capital One Bank Statements.
Related Articles
LedgerSync Verified Running Balance Report
What Is the Verified Running Balance Report? The Verified Running Balance report is LedgerSync's solution for customers who cannot access a traditional bank statement — whether because the bank does not support statement downloads, the connection ...Chase Statements — Secondary Account Transactions Appearing on Primary Statement
Overview: If you notice that your Chase bank statement inside LedgerSync contains multiple sections — one for your primary account and additional sections for any secondary accounts under the same login — this is expected behavior, not an error. This ...Line of Credit and Loan Statements: Why They May Be Unavailable and How to Work Around It
Overview Some banks restrict certain account types — including Lines of Credit (LOC), loans, and investment accounts — from being shared via their API connections. This is not a LedgerSync limitation. It is an internal policy decision made by the ...Article 86: LedgerSync Bank Reconciliation Tool
Overview The LedgerSync Bank Reconciliation tool is designed for situations where LedgerSync cannot access a bank statement directly. Rather than leaving you without a closing balance, the tool uses bank transactions to calculate a running balance — ...Best Practices To Fetch Capital One Bank Statements.
Capital One is the largest major bank that does not have any intention of providing access to Capital One Bank Statements. They have an API but they refuse to grant access to their bank statements via their API. To deal with this Ledgersync has ...