Automatiza la limpieza del Subdiario de Ventas de ARCA con Power Query

Do you download the ARCA Sales VAT Ledger and find the file is a mess? Disordered columns, dates Excel doesn't recognize, and credit notes with positive amounts that don't match the accounting records. In this video, I'll show you how to automatically clean up this CSV file using Power Query, without touching the original file, and in a way that updates the next month with a single click. What you'll learn: • How to connect Power Query to a folder containing ARCA's files • How to combine multiple months into a single table • How to clean and transform columns so they're usable • How to correct the error with Credit Notes (Type 3) that ARCA records with positive amounts If you work with the sales VAT ledger every month, this process will save you hours of work. Did you find this helpful? Leave a comment and subscribe for more content on accounting automation with Excel and Power Query.