Statements & Checks connections: how they work and how to pull a custom date range

Statements & Checks connections: how they work and how to pull a custom date range

Statements & Checks is LedgerSync's own type of bank connection. It is the connection type that brings in check images, and it also brings in statements for some banks. To pull a specific period, open the connection, click Refresh data, choose your dates and click Submit. You can go back up to 6 months from today.

How to recognize a Statements & Checks connection

  • When you click Add Bank Connection and choose what you need under What information would you like to aggregate? (Transactions, Statements, Checks), LedgerSync picks the connection type for you. Checks always come through a Statements & Checks connection.
  • If you use Pick Manually, Statements & Checks connections are listed under Premium Bank Connections.
  • On the connection page, a Statements & Checks connection has a Refresh data button where other connections have Update Balance.

A Statements & Checks connection is different from uploading a PDF. A PDF upload only contains the statements you upload. A Statements & Checks connection signs in to the bank with the client's login and keeps updating automatically.

How to pull a custom date range

  1. Go to Bank Connections > Summary and select the connection.
  2. Click Refresh data. A date box opens with the last 2 months already selected.
  3. Choose the start and end dates you want.
  4. Click Submit.

You can also do this from Bank Connections > Statements. Select the connection and click Update Statements. The same date box opens.

You can't choose dates while you add a new connection. Once it is added, use Refresh data to pull an earlier period.

Date range limits

  • The start date can't be more than 6 months before today. If it is, LedgerSync shows: Date range cannot go back more than 6 months.
  • The end date can't be in the future. If it is, LedgerSync shows: End date cannot be in the future.
  • So the longest range you can pull is the last 6 months.

When the bank asks a security question

Some banks ask for a security code or answer during a pull. When that happens, LedgerSync shows a Please answer the question pop-up. Enter the answer and the pull continues.

Extractor Stats pop-up

When a pull you started finishes successfully, LedgerSync shows an Extractor Stats pop-up with the connection and client name and how many items came in:

  • Extracted Statements
  • Extracted Checks
  • Extracted Transactions

It only lists the types of data that bank provides. The pop-up stays open until you close it. If a pull fails, the pop-up does not appear and the connection shows the error message instead.

Broken connections in the Communication Center

Go to Client Actions > Communication Center. If a Statements & Checks connection fails because the bank no longer accepts the client's login, it is counted under Bank Connections with invalid credentials, together with MasterCard and MX connections. Click Notify Clients to send the client a message asking them to fix it.

LedgerSync API

If your firm uses the LedgerSync API, statements from Statements & Checks connections are available through it.

Need help?

Contact LedgerSync Support at support@ledgersync.com.

Related articles