What you send
The file as it arrived
- Narrative
- Storage, April
- GBP
- £640.50
Sepky / Invoice lines
Excel
Clean invoice lines from Excel
Accounts teams export invoice lines to Excel, then fix the amount column by hand. Sepky does that cleanup from the headers already on the sheet.
What you get back
The columns you saved
- description
- Storage, April
- amount
- 640.50
Column names
In the file
NarrativeGBP
In the result
descriptionamount
How this file is cleaned
- Choose description and amount. Text is trimmed. The number drops the £.
- Attach the line workbook. Narrative and GBP are matched from the first row.
- Download the cleaned lines. Use them in the ledger, or keep the file from History.
Questions
- Do I change the file before sending it? Send the export. The amount column does not need a formula first.
- Which columns come back? The cleaned file uses description, amount.
Related files
Clean this file in Sepky
1,000 lines are free. $100 a month covers 50,000 lines, saved columns, file upload, code send, and History. The original file is not kept.