History, invoice and CSV have different jobs
Start by choosing what you need to achieve. Finding a session, retaining a supplier document and analysing a month of data are related tasks, but the same file will not necessarily do all three.
| Record | Useful for |
|---|---|
| Charging history | Locating sessions and reviewing available details |
| Original PDF invoice | Retaining the supplier’s billing document |
| CSV summary | Sorting, filtering and reconciling session data |
| Bank transaction | Matching the payment, with any exchange difference |
Get the data from the right source
Review the payer’s charging history and collect the documents for the period. Do not mix a vehicle’s energy statistics with invoice data without explaining which figures came from which source.
If your interface does not provide a suitable CSV, you can prepare a table from the original documents or use an authorised invoice service. Chargefolio exports saved charging records in CSV rather than promising a universal Tesla export button.
Choose columns you can reconcile
Useful fields include date, location, amount paid, currency and a reference or filename that lets you find the PDF. Keep the source account distinguishable if several accounts are involved. Include energy and fees when those values are supplied.
A blank field means the information is missing, not automatically zero. Keep any estimated or manually added data distinct from the exported values.
Open the CSV in Excel or another spreadsheet
If the file opens as one column, use the spreadsheet’s text or CSV import and select the separator actually used in the file. Check encoding and the preview before confirming.
Chargefolio’s CSV uses UTF-8 and a semicolon separator. Your spreadsheet’s regional settings may require you to specify how dates and decimals should be read. Work on a copy when changing column formats.
Group the data by currency before adding amounts. An interface translated into English does not turn EUR, GBP, CAD or AUD into one common currency.
Check the period and duplicates
Use the same time convention for the whole selection. For a calendar month, the start is the first day at midnight and the end is the first day of the next month, excluded. Check sessions near the boundary before assuming a previous-month export contains an extra day.
Match references and source PDFs when combining exports. A session can appear in overlapping files without representing another recharge. Missing PDFs should remain visible as unresolved records.
Send a summary your accountant can use
Chargefolio can include a CSV with monthly or weekly summaries and one-off invoice emails when that preference is enabled. New-invoice emails contain PDFs without that CSV summary.
CSV export can cover a longer period of saved history. Grouped PDF downloads and one-off emails use a period of no more than 31 days, with a connected Tesla account.