Reconciliation

Reconciliation records which ledger transactions agree with a statement for a period. It supports eligible balance-sheet accounts, including bank, credit-card, clearing, and loan accounts. Resolve the difference to one cent or less before saving the final report.

Open Reconciliation

Select a client, then choose Reconciliation in the client sidebar. The overview lists eligible balance-sheet accounts, recent saved reports, and drafts.

Inactive account rows are hidden by default. Enable Show inactive accounts to access their saved reports and drafts. This display filter does not change parent-account balances, reconciliation account selections, or saved work.

Choose New reconciliation for a new period. You can also open an account from Banking and choose Reconcile, or select Resume draft when a draft exists.

Before you begin

• You need write access to save or change a reconciliation. Read access can inspect saved reports.
• Finish or deliberately defer the account's transaction review. Only ledger activity can be cleared in the worksheet.
• Have the source statement and its opening date, opening balance, ending date, and ending balance.
• Check that the relevant dates are not closed if you expect to post or correct transactions during reconciliation.
• Resolve duplicate accounts and major source gaps before clearing rows.

Set up the period

1. Choose the eligible balance-sheet account or accounts to reconcile.
2. Enter the Opening date and Opening balance.
3. Enter the Ending date and Ending balance from the source statement.
4. Review any suggested period or balance context from earlier saved reports and posted ledger activity.
5. Confirm that the opening balance logically continues from the prior report before opening the worksheet.

Accounts are shown in their parent/subaccount hierarchy. Selecting a parent includes its own activity and all nested subaccounts, including historical inactive subaccounts and subaccounts that are not enabled for standalone reconciliation. Clear individual subaccount checkboxes to exclude them; a partially selected parent shows a mixed checkbox and the included subaccount count. Selecting a parent while searching still includes its whole branch, including subaccounts outside the search results.

Starting from a parent account's Reconcile action includes that hierarchy. Resuming a draft or re-reconciling a saved report preserves its saved account selection, including exclusions. The overview's current balance includes the account and its subaccounts, and its last reconciled balance is shown only for a saved report with that same account scope.

A statement-period shortcut may prefill dates or balances. Treat it as a convenience and verify it against the actual statement.

If Plaid has saved a statement PDF for an unreconciled month, Check statement is available in the account's transaction feed and when setting up reconciliation. With write access, select the PDF to check its printed dates, balances, and transactions against the existing bank feed. This does not import another copy of the transactions. After checking, use the same suggested period, reconciliation, and investigation actions available for uploaded statements. Missing or ambiguous matches need investigation before automatic reconciliation is available.

Clear the statement activity

The worksheet uses account-specific activity columns. Bank accounts show Checks and Payments followed by Deposits and Other Credits. Credit-card accounts show Charges and Cash Advances followed by Payments and Credits. Mixed or other eligible account selections use neutral Decreases and Increases labels. The worksheet can include current-period, prior-period, and already-reconciled rows.

Each transaction table shows Date, Ref, Payee/Memo, Split, and Amount. For a single account, enable Customize → Book balance (running) to see the full ledger balance after each posting; this optional column is hidden by default. This includes earlier activity and both sides of the ledger, even when rows are hidden by filters or split between the payment and deposit panes. It does not change when you select rows and is separate from Cleared balance and Difference. Balances are live ledger values, not saved statement balances. Select a column heading to sort it, or use the filters directly below the headings to narrow several columns at once. Ref uses the available check number, source reference, or transaction type.

Zero-amount transactions are hidden by default. Enable Show zero-amount transactions above the tables, beside Hide transactions after the statement ending date, to inspect them in both tables and open their journal entries. You can select these rows to include them in the reconciliation. A selected zero-amount row adds to the payment or deposit count but does not change the cleared totals or Difference. Zero-amount rows are never selected by default, even when the ledger marks them cleared. A zero amount or a memo mentioning "void" does not establish that the transaction was formally voided.

1. Compare each ledger row with the statement by date, amount, description, and source evidence.
2. Select the rows that cleared the statement.
3. Use search, column filters, sorting, and pagination to locate items, and open supporting documents or transaction detail when needed.
4. Watch the summary: Beginning balance, the account-specific activity totals, Cleared balance, and Difference.
5. Investigate missing, duplicate, mistimed, or incorrectly coded activity instead of selecting a row merely to force zero.

If the statement shows a charge or credit that is not already imported or posted, choose Record adjustment from the worksheet. Select the reconciled account (when reconciling several), the activity date, debit or credit, amount, offset account, and a description. Review the balanced journal preview before recording. Wesley records a ledger entry and refreshes the worksheet; verify and select its bank or card line only if it cleared the statement. Do not enter the difference itself unless you have identified the underlying activity. If the activity is already in Banking, match or correct it instead of posting a duplicate.

Draft selections save automatically and appear as Draft saved. You can resume a draft only in the same browser on the same device; it is not shared with the rest of the firm.

Save the report

Choose Save report when the selections accurately describe the work performed and the difference is one cent or less. A larger nonzero difference cannot be saved as a final report; Wesley keeps the local draft so you can investigate or correct the underlying activity.

Saving creates the report, marks the selected rows as reconciled, and clears the local draft.

Review and export saved evidence

Open a saved report to review its dates, reconciled-by information, notes, source documents, and selected transactions. From the report you can export PDF or Excel, edit report dates, change notes or file name, and delete the report when authorized.

Save the original statement PDF

Open the saved reconciliation report and select Attach PDF in Statement attachments. Select up to 10 PDFs at a time, up to 50 MB each. These attachments are stored with the report and in the client's Shared Files without extracting or importing transactions. You can attach PDFs to a locked report and they remain attached when you re-reconcile it.

Select a file name to view the PDF, or use its download button to save the original. Removing an attachment only unlinks it from that report; the file remains in Shared Files. Uploading statements through Banking or the client portal follows the transaction-import workflow instead.

For very large reconciliations, the saved report shows cleared totals and counts instead of rendering thousands of detailed cleared rows. Wesley still preserves every cleared journal-line association used to determine reconciliation status.

The saved report keeps its canonical account label, including the account code and full name, even if the live chart-of-accounts name changes later. The report list, detail view, PDF, Excel file, and default export filename all reuse that saved label. A custom report title remains separate from the account label.

When a report has a nonzero difference, Investigate can help analyze possible causes. You can attach source documents or continue without them. Review its findings before approving any change to the books.

Result and side effects

• Saving records a reconciliation report and marks its selected ledger rows as reconciled.
• The report preserves the calculated difference at save time.
• Saving removes the draft for that account and period.
• Later journal changes can alter the live ledger without rewriting the saved evidence, which may cause the report and current general ledger to disagree.

Correct, delete, or restart

• Before saving, use Discard draft to remove the local work. A discarded draft cannot be restored.
• Edit report dates, notes, or file name from the saved report when those details—not the underlying accounting—need correction.
• If the accounting needs correction, fix the underlying transactions or journals, then review reconciliation again.
• Deleting a saved report cannot be undone. It removes the saved report and its reconciliation association; confirm the account's feed and reconciliation state afterward.

Never delete a report just to conceal a difference. Preserve or export evidence when the report supports a completed period or audit trail.

Troubleshooting

The opening balance does not continue from the prior report. Check prior-period transactions, changes to reconciled journals, the selected account, and the previous report's ending balance.

A statement row is missing. Confirm it was imported, posted to this bank account, dated within the search range, and not filtered out. Add or match it through Banking if necessary.

The same activity appears twice. Compare the imported transaction with the ledger entry before clearing either one. The imported transaction may need matching or exclusion instead of another posting.

An unposted, unlinked duplicate from an upload can be permanently removed from Banking without reopening the reconciled period. The deletion dialog checks accounting and supporting references first and explains any links that must be reviewed. A posted or referenced transaction remains protected even after a period is reopened. Use Re-reconcile to review an accounting correction and preserve saved evidence; do not delete a report merely to remove a duplicate. Bank-feed transactions should be excluded so future updates keep them excluded.

A draft is missing on another device. Resume it in the original browser and device, or start a new draft from the statement.

Save report says to resolve the difference. The difference is greater than one cent. Use Investigate or correct the underlying activity; the local draft remains available.

A saved report no longer agrees with the ledger. Review journal edit history and reconciled-row warnings. Reperform the reconciliation after approved corrections.

Continue with Journal Entries.