Decide which cost you are measuring
When an account has been imported twice, an inflated total can be mistaken for a more complete view of spending. Before combining amounts, name the cost you want to explain: a single purchase, the cash paid during a period or the final cost after a settled credit. These measures use related evidence but are not interchangeable. An additional source row does not automatically represent an additional component of cost.
Preserve the complete bank debit as a factual account movement. A purchase breakdown can allocate that movement to goods, delivery or other documented components without adding another payment. If two files contain the same debit, the breakdown still belongs to one event. Keep source evidence and cost components in different parts of the working record.
Reconstruct components from purchase evidence
Use a receipt, order summary or other relevant document to identify what was actually purchased. A bank description may identify the recipient without explaining individual components. Avoid inventing a service charge to explain a difference before checking whether the apparent difference is simply a duplicate imported row.
Where an account charge is genuinely separate, retain it with its own reference and purpose. A separately posted 30-unit charge should neither disappear during deduplication nor become evidence that every repeated 30-unit row is legitimate. Determine whether the source describes a different event, then decide whether that event belongs in the cost measure being calculated.
Work through a complete-cost example
Suppose an illustrative order includes goods of 800 units and delivery of 60, producing one payment of 860. The same account also contains a separate documented charge of 20 associated with the transaction. If the chosen measure includes both payments, the complete cost is 880. Two overlapping files each containing the 860 debit do not raise that cost to 1,740.
Keep the 800 and 60 as allocations underneath the 860 payment, with the 20 represented as its own event. Adding the allocations, the parent payment and the repeated source row would count several descriptions of the same money. The account evidence should support 880 of outgoing cash under the assumptions stated here, while the receipt explains how the principal payment was composed.
Distinguish credits from duplicate debits
A settled credit changes the final cost, whereas removing a duplicate debit changes the accuracy of the record. If a confirmed credit of 100 relates to the illustrative order, the net cost becomes 780 after that credit has completed. This result assumes both the 880 outgoing amount and the 100 incoming amount belong to the same defined purchase scope.
Do not obtain the same result by deleting a genuine part of the order. Preserve the original payment and connect the credit to it. An approval message without a completed credit can be shown as expected information, but it should not reduce a confirmed cash-outflow measure. State which version of the cost is being reported and at what review date.
Keep multiple accounts and periods distinct
One purchase may involve two funding accounts, while one account may pay for several unrelated purchases of the same amount. Match source rows within the correct account before calculating the purchase total. A transfer between accounts can explain funding without adding another external cost to the household.
Also preserve the difference between purchase period and cash date. A bill covering several weeks may be paid once and appear in multiple downloaded intervals. Repeated coverage does not create repeated service. If a comparison allocates the bill across periods, retain the allocation method beside the original full payment so that the analytical breakdown can be reproduced.
Finish with a component-to-cash bridge
Present a small bridge from documented components to actual payments and settled credits. Identify which source rows support each payment and which imported rows were excluded as verified duplicates. Any unexplained difference should remain visible rather than being assigned an invented fee or discount merely to make the numbers agree.
Before using the figure in a budget comparison, check that both the corrected and previous periods use the same scope. A report including delivery and separately posted charges cannot be compared fairly with another report containing only goods. The completed breakdown should explain the real components once and make clear how import overlap was prevented from changing the economic story.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


