Why do bank feed dates in Xero not match my actual bank statement dates?

When you notice that the dates in your Xero bank feed differ from the dates on your bank statement, such as the feed showing 6/1 while your statement shows 5/31, the issue is usually caused by timing or system differences. The mismatch is common and can be corrected by following a few steps.

1. Bank clearing dates may differ from statement dates

The date on your bank statement may represent the posting date, while the bank feed or feed provider records the transaction on the date it actually clears in the bank system. Pending transactions do not import into Xero until they are cleared, which can cause a one day shift.

2. Time zone or cutoff differences

Some banks process transactions across midnight or in a different time zone. A transaction that appears on your statement as 5/31 may show as 6/1 in Xero because of the bank’s internal processing time. Xero recommends using the actual cleared date rather than the statement posted date when reconciling.

3. Bank feed start date or delay in retrieving older transactions

If your bank feed was recently connected or refreshed, older transactions may be imported with different dates or may arrive later than expected. This can result in mismatched dates between Xero and your statement.

4. Reconciliation period or lock date issues

If accounting periods are locked or if you attempt to reconcile outside of the effective date range for the feed, the imported date could be different from what appears on your bank statement.

5. Differences between manual imports and automatic feeds

If you manually import statements while also using automatic bank feeds, the cleared date and the posted date may differ. This can cause the same transactions to appear with different dates depending on how they were imported.

How to fix or minimize the mismatch

1. Identify the last date when balances matched

Run the Bank Reconciliation Summary in Xero for a date when the balances matched your bank. Compare the statement balance in Xero to your actual bank statement. This gives you the correct starting point.

2. Compare feed transactions with your bank statement

Open your bank account in Xero and review account transactions sorted by date. Compare each line with your bank statement, especially where you notice a one day difference such as 5/31 on the statement but 6/1 in the feed.

3. Decide which date to use for reconciliation

The best practice is to reconcile using the date the bank actually clears the transaction. If your bank considers the transaction cleared on 6/1, then reconcile to 6/1 in Xero even if the statement shows 5/31. This prevents reconciliation errors.

4. Adjust your reconciliation date or the transaction date if necessary

If you want to reconcile to the statement date, you may adjust the transaction date in Xero if allowed. If the accounting period is locked or the date cannot be changed, consider treating the difference as a timing variance and discuss the correct approach with your accountant.

5. Confirm that your bank feed is retrieving data correctly

Check that your bank feed is active. Xero only imports transactions once they have cleared, so delays may cause date differences. If a transaction does not appear, you can import the missing statement lines manually and match them in Xero.

6. Account for month-end or cut-off timing

If your bank posts transactions close to midnight or in a different time zone, some transactions may fall into the next day. When closing your month, allow for these timing differences and document your approach for consistency.

Summary

• Date mismatches often occur due to clearing dates, time zones, or feed processing delays.
• The date Xero receives from the bank is usually the true cleared date and should be used for reconciliation.
• Use the Bank Reconciliation Summary to find the point where balances diverge and make adjustments as needed.
• Create a clear policy for handling transactions that cross month-end or time zone boundaries.