Edit Linked Ledger and Bank Activity

Review or reverse confirmed bank activity from its linked journal entry without deleting the original posting trail.

Purpose

Use this workflow when a confirmed bank or credit card transaction has a linked journal entry and you need to inspect the posting, reverse the ledger entry, or correct activity that is already part of reconciliation review.

Prerequisites

  • An active company is selected.
  • The bank or credit card transaction is already confirmed.
  • The transaction has a linked journal entry. In Reconcile, eligible rows show an enabled Journal action.
  • You know whether the original bank transaction has already been reconciled.

Steps

  1. Open Reconcile.
  2. Select the bank or credit card account that contains the confirmed transaction.
  3. Set the statement ending date far enough forward for the transaction to appear, then filter or search for the row.
  4. Confirm the row shows an enabled Journal action.

Linked journal action in Reconcile

  1. Select Journal to open the linked journal entry.
  2. Review the entry number, posting date, memo, bank-side line, and offset account lines.

Linked journal entry opened from Reconcile

  1. Select Reverse.
  2. Choose the posting date for the reversal:
  • Today posts the reversal on the current date.
  • Original entry date posts the reversal on the same date as the original entry.
  • Custom date lets you enter a specific reversal date.
  1. Select Reverse only after confirming the reversal date and original entry lines.

Reverse journal date choices

  1. Review Reconcile, Banking, or Ledger to confirm the correction appears in the expected period.

Expected Result

SPRK preserves the original audit trail and creates a separate reversing entry. Current linked bank and ledger behavior as of 2026-05-29:

  • The original journal entry remains in place.
  • The reversal journal entry flips the original debit and credit lines.
  • SPRK prevents reversing a reversal entry.
  • SPRK prevents reversing the same original entry more than once.
  • If the linked bank transaction has not been reconciled, SPRK excludes the original bank row and marks it as excluded because of the journal reversal.
  • If the linked bank transaction has already been reconciled, SPRK leaves the reconciled row in place and creates a confirmed correction bank transaction linked to the reversal journal entry.
  • After a successful reversal from Reconcile, the reconciliation table reloads and SPRK shows Journal entry reversed.

Common Mistakes

  • Treating reversal as delete or edit. The original entry remains visible for audit history.
  • Reversing before confirming whether the transaction has already been reconciled.
  • Choosing a custom reversal date that belongs in the wrong statement period.
  • Expecting every historical row to show Journal. Rows without a persisted journal link do not have the linked journal action.

Info

  • App sections: reconcile, ledger, banking
  • Last validated: 2026-05-29
  • Screenshot status: captured