The Running Balance report lists the posted transactions of a connected bank or card account and shows the account balance after each one, much like the transaction page on your bank's website. Use it to find an ending balance for a date when no bank statement PDF is available, such as for Capital One accounts.

Which accounts it works for

The report works for accounts connected through MasterCard or MX. For an account connected any other way, the page shows a message that the running balance is not available for that bank.

How to open the report

1. Select the client in the client list.
2. Open the Bank Connections menu and choose Running Balance.
3. Pick the account in the account selector at the top of the page.
4. To narrow the list, set a Posted Date range.
5. Read each transaction's balance in the Running Balance column.

Finding an ending balance for a period

To find the balance at the end of a period, for example November 30, look at the last transaction posted on or before that date. Its running balance is the closing balance for the period.

The Running Balance is calculated, so it is not a substitute for a bank statement when you need a formal reconciliation.

Verified and provisional balances

For MasterCard accounts, LedgerSync checks the running balance against the daily balances the bank reports. When it can, the page shows the message Balances verified against bank records through followed by a date. Balances on or before that date are pinned to the bank's own reported balances.

Transactions after that date are provisional. Hover over a provisional balance to see the note that recent activity may still be settling at the bank. A provisional balance can change once pending activity posts.

For MX accounts, every balance is currently provisional, so no verified-through date is shown.

Messages you may see

• The bank has not reported a newer balance; balances are shown as of a date: the bank has not sent a recent balance, so the report only covers transactions up to that date.
• The bank is not reporting a balance for this account, so the running balance cannot be calculated: no balance is available from the bank for this account.

Exporting the Running Balance

Right-click the grid and choose Export to Excel or Export to CSV. If you select rows first, you can also use the Export to Excel and Export to CSV buttons that appear above the grid.

If any rows are selected, only those rows are exported. Otherwise the export includes all rows. Each export adds a Balance Quality column and a note at the top showing the verified-through date when there is one.

Using it for Capital One

Capital One does not provide statements through the MasterCard connection, but its transactions do come in automatically through MasterCard. Many firms use the Running Balance report for soft closes on Capital One accounts during the year, and fetch the PDF statements through Statements & Checks when they need a hard reconciliation.

Need help?

Contact LedgerSync Support at support@ledgersync.com.

Related articles:

• Best Practices to Fetch Capital One Bank Statements
• LedgerSync Close: Overview and How It Works