Capital One does not provide bank statements through the MasterCard connection. LedgerSync handles Capital One in two ways: the MasterCard connection and the Running Balance report for soft closes, and the Capital One (Statements) connection in Statements & Checks for PDF bank statements.

Using Bank Transactions For Soft Closes

1. Connect Capital One through the MasterCard connection. LedgerSync pulls the Capital One transactions and the account balance from the bank through this connection.
2. Open Bank Connections, go to the Running Balance tab and select the Capital One account. The report starts from the current balance reported by the bank and works back through the transactions, so each row shows the balance after that transaction. Newest transactions are listed first. Pick the date you want to close on: the running balance on the top row for that date is the closing balance.

Getting PDF Bank Statements

Capital One statements are fetched through the Capital One (Statements) connection in Statements & Checks. Capital One usually asks for a security code each time statements are fetched, and the person whose Capital One login is used has to provide it. Getting a code from your client every month can be hard, so we recommend fetching Capital One statements about twice a year.

Each fetch can reach back at most 6 months, so plan your fetches to overlap:

• Fetch a little less than 6 months after your previous fetch.
• On the Statements tab, select the Capital One account and click Update Statements. The date range starts at the last 2 months, so widen it to start on or before the date of your previous fetch (no more than 6 months back), then click Submit.

Conclusion

In short, use the Running Balance report to do a soft close on Capital One, and fetch the PDF bank statements about twice a year, each time covering up to the last 6 months, if you need to do a hard reconciliation.