Money basics

Savings transfer logged twice? Reconcile it the safe way, in C$

When a savings contribution is double-counted, reconcile it against the account balance first. A step-by-step method with a Canadian-dollar example.

Editorial illustration for Savings transfer logged twice? Reconcile it the safe way, in C$

When a savings contribution is double-counted, do not start deleting lines. Start with the account balance: whatever the bank says is in the pot is the truth, and your tracker has to agree with it. Then make each contribution safe to retry by giving it a unique tag, so recording it again simply finds the first entry instead of adding a second.

Where does the extra line come from?

Retries are the usual culprit. A transfer is submitted, the screen freezes on weak signal at a cottage or on a train, and you submit again to be safe. Either the money went once and you logged twice, or the first attempt failed and you are unsure which line is real. Both are record problems, not money problems.

Step one: write down three numbers

  1. The balance of the savings account or pot today, read from your bank, say C$4,350.
  2. The total your tracker shows for that goal, say C$4,850.
  3. The difference, C$4,850 − C$4,350 = C$500, which you now need to explain.

A difference of C$500 matters because it points to a specific line. If your regular contribution is C$250, you may have two duplicates. If your amounts vary, look for a pair that adds up to C$500.

Step two: find the lines that add up to the gap

List the contributions for the goal newest first. Look for two lines with the same amount within a day or two of each other, or one amount equal to the gap.

DateAmountSourceMatches bank line?
02 JunC$250Typed by handYes
02 JunC$250Statement loadSame payment
16 JunC$250Statement loadYes
16 JunC$250Typed by handSame payment

Two pairs, each counted twice, give 2 × C$250 = C$500, which explains the gap. Remove one line from each pair and the tracker drops to C$4,350, matching the bank.

How do I make retries harmless?

Give each contribution a tag made from the date it left the account and the amount, for instance 0602-250-HOME. When you add a line, search the goal for that tag first. If it exists, you are done; if it does not, add it. Two sources, typed notes and a loaded statement, will then agree because both produce the same tag.

Should the goal tracker or the account be the master?

The account. A goal total in a tracker is a derived figure, the sum of lines you decided belong to it. If the total and the balance disagree, adjust the lines, never the balance. Keep the one correcting entry, if you need one, labelled as a correction with the date and the reason, so you can see later what happened.

What if the numbers still do not match?

Sometimes the gap is not a duplicate at all. A deposit may be missing from the tracker, a withdrawal for an emergency may never have been recorded, or interest and fees may have moved the balance a little. Work through it in order: first duplicates, then missing deposits, then withdrawals, then small bank-side movements. Write each finding beside the three numbers so next month you can see which type of mistake you tend to make. Most people discover one favourite mistake, and knowing it makes the check quicker.

Habits that keep it clean

  • Pick one place for entering contributions: the statement or your own note, not both.
  • After any transfer that behaved oddly, check the bank history before logging.
  • Reconcile on the same day each month, and write down the three numbers even when they match.
  • If you track in several currencies, record each contribution in its own currency and keep your base currency fixed, so a rate change does not look like a missing deposit.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports