Best Practices To Fetch Capital One Bank Statements.

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 developed a two pronged strategy

Using Bank Transactions For Soft Closes.

1- Connect Capital One via the MasterCard connection.  This will allow Ledgersync to pull in the  Capital One Transactions directly from the bank. Since it's an API it will be 100% perfect. 



2- Use the Running Balance report. This is a calculated running balance that takes current balance +/- the debits and credits. Essentially mimics a bank transaction web site. Pick the closing date you want to close on and the last transaction of that date is the closing balance number. 



Getting PDF Bank Statements

Our recommendation is to run Capital One twice a year for fetching the Capital One  bank statements. Why? Capital One requires a bank token on every login and therefore getting token codes from the client monthly is really difficult. 

As such Ledgersync has changed the fetching process to fetch 7 months of bank statements  for each Capital One Account! 
Why? This way you only have to ask the client only 2x a year for a bank token and Ledgersync will overlap and fetch 7 months of bank statements upon each login. 

Conclusion

In short, use the Running Balance report to do a soft close on Capital One and run the statements 2x a year and fetch the last 7 months of PDF Bank Statements if you need to do a hard reconciliation. 












    • Related Articles

    • Why wont my Capital One Bank Statements automatically sync?

      The Problem with Capital One: Since the inception of BANK FEEDS, Capital One has always been extremely difficult to work with. Most financial institutions understand the need for accountants to be able to fetch data for their clients and offer API ...

    • How to Convert Bank PDF Statements to Excel or QBO

      One of the great features of Ledgersync is the ability to convert Bank PDF Statements to Excel, CSV or .QBO file format. This is really helpful when: 1- Client ONLY gives you access to PDF Bank Statements and you need the transactions 2- Clean up ...

    • What is the best way to manage my clients broken bank feed connections? (Video)

      Handling Broken Bank Feed Connections: During this video we help demonstrate the two different ways you can notify your client about a broken bank feed. Why do BANK FEEDS usually break? The most common reason a bank feed has been interrupted is due ...

    • What Bank Connection to Choose - Ex/ Mastercard API, Ledgersync Premium, MX

      Purpose LedgerSync offers multiple bank connection options to ensure you can access the financial data you need. Choosing the correct connection type helps ensure reliable access to: Bank statements Transactions Check images This article explains ...

    • 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 ...