Understanding and Managing Statement Dates in LedgerSync

Understanding and Managing Statement Dates in LedgerSync

LedgerSync reads the date of each bank statement automatically from the statement PDF. The date it looks for is the statement's ending (closing) date. Occasionally the wrong date is picked up, and you can correct any statement date yourself on the Statements page.

Why a Statement Date May Be Wrong

For MasterCard, MX and Statements & Checks connections, LedgerSync reads the statement date from the statement file itself. A date can come out wrong for these reasons:

  • Several dates on the statement: a bank statement shows many dates (for example transaction, closing and due dates), and the wrong one can occasionally be picked.
  • No readable date: if no date can be read from the file, LedgerSync assigns an estimated date, which may not match the statement.

How to Spot an Incorrect Date

Common red flags:

  • A statement dated in the future
  • Dates out of sequence or not matching the usual statement cycle
  • Several statements showing the same date

To check the date printed on a statement, click View on the statement's row to open the PDF.

How to Correct a Statement Date

  1. Log in to LedgerSync.
  2. Select the client in the client list.
  3. Open the Bank Connections menu and choose Statements.
  4. Choose the bank connection at the top of the page.
  5. Find the statement and click its date in the Statement Date column.
  6. Pick the correct ending date from the PDF in the calendar.
  7. When asked "Do you want to update statement date?", click Yes.

You will see "Statement Date Updated" when the change is saved.

When a Connection Has No Statements

Some connections do not provide statements, so there are no statement dates to check or correct for them. When you choose such a connection on the Statements page, a red Images only banner appears.

Connections added with the PDF option (where you upload statement PDFs so LedgerSync can extract the transactions) never list statements on the Statements page. Their statements cannot be viewed, edited, deleted or updated there, and the Update Statements button is not shown for them.

Updating Statements

The Update Statements button at the top of the Statements page asks the bank for statements again for the selected connection.

  • MasterCard and MX connections: a dialog opens where you choose how many months to update and which accounts to include, then click Refresh. For MasterCard connections you first choose Refresh by period or Refresh by index. For MX connections, LedgerSync asks MX to fetch statements for the whole connection, whatever months and accounts you pick.
  • Statements & Checks connections: you choose a date range and click Submit.

When to Report Issues

Contact support when you notice:

  • A pattern of incorrect dates from a specific bank
  • The same bank showing wrong dates across several clients
  • A particular statement format repeatedly causing issues
  • An error message instead of the PDF when you click View or Download (for example "Issue with getting file pdf" or "Statement content is not a valid PDF")

How to Report

  1. Take a screenshot of the Statements page showing the incorrect date or the error.
  2. Email support@ledgersync.com with:
    • Client name
    • Bank name
    • Incorrect date shown
    • Correct date from the PDF
    • Screenshot attachment

Best Practices

  • For new clients, check statement dates for the first 3 months.
  • Include statement date checks in your team's standard procedures.
  • Check that dates match the PDF before you reconcile.
  • Correct errors as soon as you spot them, and report patterns to support.

Related Articles

  • How to Convert Bank PDF Statements to Excel, CSV, QBO, or OFX
  • How to Add a Bank Feed Connection in LedgerSync

Need Help?

Email: support@ledgersync.com