What you send
The file as it arrived
- Line text
- Consulting, March
- Amount due
- $1.250,00
Sepky / Invoice lines
CSV
Clean invoice lines from a CSV
Invoice line exports repeat a description with uneven spacing and an amount that still wears a currency sign. Sepky returns the description and the amount in a shape a ledger can load.
What you get back
The columns you saved
- description
- Consulting, March
- amount
- 1250.00
Column names
In the file
Line textAmount due
In the result
descriptionamount
How this file is cleaned
- Save description as text and amount as a number. The comma-as-decimal amount becomes 1250.00.
- Send the line CSV. One request holds the invoice lines.
- Post the cleaned lines. History keeps the result as a file you can download.
Questions
- Do I change the file before sending it? The invoice file stays a list of lines. Sepky does not need the PDF.
- 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.