Clean a messy export without losing rows

Módulo 2: Do finance work faster with AI

Conteúdo do curso

Esta aula ainda não está no seu idioma, então aqui está em inglês.

Teste rápido

Guess first, no penalty. AI cleans a 2,000-row expense export for you. Afterwards the total is $1,240 lower than before. What's the most likely cause?

An export is data copied out of a system, like your accounting software, into a spreadsheet. Exports are messy: dates in three formats, amounts stored as text, some figures in thousands, rows that appear twice.

AI cleans this fast. The risk is what "cleaning" quietly does. It can delete a duplicate (a row that appears twice) that was really two real payments, or turn "1,200" into 1.2 when it guesses the wrong format.

So use one rule for every cleanup. Count the rows and total the amount column before and after. If either number moved, every difference needs a reason you can point to. And ask the tool to flag duplicates in a new column instead of deleting them, so you decide.

O resto desta aula faz parte do Learn Pro

O primeiro módulo de cada curso é grátis. O Learn Pro libera todas as aulas de todos os cursos por US$ 10 por mês. Todas as ferramentas do JobRise continuam grátis.