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
How to export transactions to QBO file format.
Ledgersync has the ability to export data to QBO format that is importable to QB Desktop and Online. Follow the steps below to export transactions to QBO 1- Click on a client 2- Select the bank 3- Go the Transactions Tab 4- You can filter the ...Text or Email Clients to Describe Bank/Credit Card Transactions
Easily Categorize Transactions with Ledgersync Struggling with Uncategorized Transactions? If you've ever encountered transactions that you don't recognize, you know how challenging it can be to categorize them. So, how do you handle them? The Old ...Why are the bank transactions truncated at times?
All the data flows directly from the bank, they control what is being sent to Ledgersync and in the format that they want. At times they will send to our provider (MasterCard) a truncated set of transactions at 32 characters for description. Why 32 ...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 ...Ledgersync API
Ledgersync is built on an API. API Documentation Link: https://app.theneo.io/ledgersync/ledgersync-api/ledgersync-rest-api The API allows access to: - Bank Transactions - Bank Balance - Bank Statements - Check Images - Deposit Images - Convert Bank ...