Workbook Compare Pro
← Video library

Pause and guess · 60 sec

Which two invoices traded amounts?

Six invoices. Two shuffled payment lists. Both add up to $2,520. Can you find the mix-up?

Link to this video

Read the transcript

The payment file is ready. Six invoices. Twenty-five hundred and twenty dollars. There's just one problem. Two of the amounts got swapped. Here's the morning export and the afternoon export. The rows moved. Which two invoices traded amounts? Pause here and match them by invoice number. Let's line up the invoice numbers. Sixty-four twenty-three went from three fifteen to four thirty-five. Sixty-four fifty-two did the exact opposite. That's an extra hundred and twenty dollars on one invoice and a hundred and twenty short on the other. The total never budged. In Workbook Compare Pro, use Invoice as the key column for these two CSVs. There they are. Two changed amounts.

Try the 7-day evaluation