Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.dualentry.com/llms.txt

Use this file to discover all available pages before exploring further.

How to Reconcile Bank Accounts

Bank reconciliation in DualEntry confirms that your GL cash balance agrees with your bank statement balance. You match imported bank transactions to ledger entries, record adjustments for items like fees and interest, and certify the reconciliation when everything ties.

Start a reconciliation

Before starting, confirm that at least one bank connection is active and has imported transactions (see How to Connect Bank Accounts), that the GL account linked to the bank connection has posted transactions for the period, and that you have the bank statement ending balance - DualEntry asks for it when you begin. To start:
  1. Navigate to Cash Management → Bank Reconciliation.
  2. Select the bank connection you want to reconcile.
  3. Enter the statement ending date and statement ending balance from your bank statement.
  4. DualEntry loads all unreconciled bank feed transactions and unreconciled GL transactions for that account into a side-by-side workspace.
The workspace shows the running difference between matched bank items and matched GL items. Your goal is to drive that difference to zero. You can reconcile at any cadence - monthly is typical, but DualEntry does not enforce a schedule. If you have multiple bank connections, you reconcile each one independently.

Auto-matching and manual matching

When you open a reconciliation, DualEntry runs two matching passes before you touch anything. Rule-based matching applies your custom matching rules first. Rules match on criteria you define - amount, date range, description keywords, or reference numbers. When a rule produces a one-to-one match, DualEntry marks the pair as auto-matched. Bank Match AI runs second, scoring remaining unmatched items. Pairs that meet the confidence threshold are auto-matched; everything else goes to the review queue. See Bank Match AI for details on how scoring and thresholds work. Auto-matched items appear in the Matched tab with a badge indicating whether a rule or AI produced the match. You can unmatch any auto-matched pair if the match is wrong. Items that weren’t auto-matched appear in the Unmatched tab. To match manually, select one or more bank feed transactions on the left, select the corresponding GL transaction(s) on the right, and choose Match. You can match one-to-one or many-to-one. The matched amounts don’t need to be identical - DualEntry flags the difference and lets you proceed if you confirm the partial match.
If a bank transaction has no corresponding GL entry - for example, a bank fee that hasn’t been recorded - create an adjustment entry directly from the reconciliation screen instead of switching to the journal entry form.

Adjustment entries and completion

Bank fees, interest income, and other items that appear on the bank statement but not in your ledger need adjustment entries.
  1. In the Unmatched tab, select the bank feed transaction.
  2. Choose Create Adjustment.
  3. DualEntry opens an inline journal entry form pre-populated with the amount, date, and a suggested memo.
  4. Assign the offsetting account (for example, bank fees expense or interest income).
  5. Post the entry. DualEntry automatically matches it to the bank feed transaction.
Adjustment entries are standard journal entries and appear in your journal entry log. They carry a reconciliation reference so you can trace them back to the specific reconciliation that created them. Once the difference between matched bank items and matched GL items is zero:
  1. Review the Matched tab to confirm all pairs look correct.
  2. Choose Complete Reconciliation.
  3. DualEntry locks the reconciled items - they can’t be unmatched or edited without reopening the reconciliation.
  4. Optionally, choose Certify to record your sign-off. Certification stamps the reconciliation with your user ID and a timestamp, visible in the audit trail.
If you close the reconciliation workspace before completing, DualEntry saves your progress. Matched and unmatched items persist, and you can return to finish later.

Reconciliation history and audit trail

Every completed reconciliation is stored under Cash Management → Bank Reconciliation → History. Each record includes the statement ending date and balance, the list of matched pairs, any adjustment entries created during the reconciliation, and who completed and certified the reconciliation. This history is append-only. You can reopen a completed reconciliation to review it, but changes require a new reconciliation for the same period. The full audit trail is also visible in Audit Trail and Compliance.
If you reopen a certified reconciliation and make changes, the original certification is voided and a new certification is required. DualEntry logs the void event in the audit trail.
After completing these steps, your bank account is reconciled for the period. The reconciled balance carries forward as the opening balance for the next reconciliation. For details on how Bank Match AI improves matching accuracy over time, see Bank Match AI.
Last modified on May 28, 2026