Payment and reversal on a bank statement: keep both rows

An equal and opposite movement may be a reversal, but amount alone cannot prove that relationship. Preserve both printed transactions and record a confirmed link separately. Net zero does not mean that no transaction occurred.

Compare the evidence before linking two movements

1. Compare direction, full reference, description and dates for the potential pair. Consult the bank’s explanation when the label is unclear.

2. Keep both rows in the source table. Add a relationship field only when evidence identifies the original and reversal.

3. If producing a net summary, retain a detailed view and label the summary as a calculation, not the original statement.

Fictional example

A fictional payment P-41 is −64.00; next day, REV P-41 is +64.00. Both remain in the table, giving net zero for the confirmed pair. Another +64.00 has reference R-88: it must not be paired merely because its amount matches.

Keep the relationship separate from the rows

The Banca d’Italia glossary describes statement entries with dates, a description and a signed amount. Those fields are evidence to review; that glossary does not prove a reversal relationship. As a proposed working method, give each source row its own ID and keep a separate note containing the original-row ID, reversal-row ID, source wording and status: confirmed or unresolved. In the fictional case, REV P-41 supplies the explicit reference to check against P-41; R-88 stays outside that pair.

Why retain zero-net rows? Extend the fictional example with an opening balance of 500.00 and include all three movements:

Movement	Signed amount	Balance after movement
P-41	−64.00	436.00
REV P-41	+64.00	500.00
R-88	+64.00	564.00

The detailed table has three rows, gross outgoing 64.00, gross incoming 128.00 and net +64.00. Deleting the confirmed pair leaves one row and the same net +64.00, but falsely changes gross outgoing to zero and incoming to 64.00. A closing-balance check alone misses that loss of history.

If a possible counterpart is +60.00 instead of +64.00, the pair totals −4.00. Do not rename that difference “fees” or invent a missing +4.00 entry. Record the discrepancy and seek source confirmation. The same restraint applies when the possible counterpart appears only in a later statement: preserve the current rows and the unresolved link.

Resolve competing matches before confirming a pair

Start with the same account and currency. Then compare the bank’s actual reference and wording, including any continuation line, before using amount and date as supporting checks. A short interval is a search aid, not proof; do not pair the nearest equal amount automatically.

Evidence in the source	Relationship status	What to do with the rows
Opposite EUR amounts and an explicit reference to the original	Candidate for confirmation	Check full wording and both locations, then record the link
Opposite equal amounts but unrelated references	Unresolved	Keep both; do not assign a reversal label from the amount
Two originals could match one opposite movement	Ambiguous	Record both candidates; confirm neither automatically
Same amount and same direction	Outside this reversal test	Review a possible repeat separately; preserve both meanwhile
Counterpart belongs to another currency or account	No direct pair under this rule	Keep separate groups; do not net them together

In another fictional EUR case, P-41 and P-42 are each −64.00, while REV is +64.00 without a readable original reference. Their total is −64.00 regardless of which payment is paired. Neither the total nor chronological proximity identifies the correct original. Leave the relationship unresolved until a readable reference or bank explanation supplies the missing evidence. A candidate list should also show whether an opposite row has already been linked; silently using the same +64.00 twice creates false confirmations.

Confirm the reversal relationship from an explicit source label and consistent references, retaining both movements. Here, “confirmed” means the recorded evidence supports the relationship, not that software inferred it from a zero sum.

Keep each movement in its statement period

If the fictional payment appears in September and its confirmed reversal in October, September still contains −64.00 and October +64.00. Link them across the two source files without moving either date or deleting either row. A combined two-month summary may show zero for the pair; each monthly review must retain its own movement and closing balance. If the October file is not available, record a missing counterpart rather than adding an expected credit.

Checks and limits

Check row count and gross outgoing/incoming totals as well as net movement. A repeated description is not proof of reversal or duplication. Do not infer merchant disputes or accounting treatment from these fields. Keep the pair unresolved when no reliable source establishes the relationship.

Keep the original file unchanged and record any unresolved item before using the table.

Related checks

Match a reversal to its original and its direction before classifying a duplicate. Overlapping bank exports: review duplicates without losing payments · Debit and credit columns to one signed amount: a bank CSV method · Check a bank statement balance without hiding extraction errors.

BankStatementScan is in preparation. The site offers an access request and a fictional example; it does not currently convert your bank files. See the planned service.

Sources checked on 16 October 2026

• Banca d’Italia — Estratto conto.
• W3C — Model for Tabular Data and Metadata on the Web.