Understanding CSV Column Structure
Complete guide to the CSV column structure and data fields exported by BillToSheet. Learn how to map columns for accounting software import.
Frequently Asked Questions
What columns are in the invoice details CSV?
The invoice details CSV includes: vendor name, invoice number, invoice date, due date, currency, subtotal, tax amount, total amount, and any additional metadata extracted from the invoice.
What columns are in the line items CSV?
The line items CSV includes: description, quantity, unit price, tax amount, and line total for each item. SKUs, product codes, and discounts are included when present in the original invoice.
How do I map columns when importing to accounting software?
Most accounting software has an import wizard that lets you match CSV columns to their fields. Match 'invoice number' to your invoice ID field, 'total amount' to your amount field, and so on.
Are column names consistent across different invoice types?
Yes, we use standardized column names regardless of the original invoice format. This makes it easy to import invoices from different sources into the same accounting system.
Can I customize which columns are exported?
Currently, all available columns are exported by default. You can delete unwanted columns in Excel or Google Sheets before importing to your accounting software.
Related Invoice Converters
Amazon Invoice Converter
Convert Amazon invoices to Excel with line items
Stripe Invoice Converter
Convert Stripe invoices to Excel with line items
PayPal Invoice Converter
Convert PayPal invoices to Excel with line items
More Help Articles
Getting Started with BillToSheet
Learn how to convert your first invoice PDF to CSV or Excel format with BillToSh...
Supported Invoice Formats
Learn which invoice formats and types are supported by BillToSheet. Compatible w...
Understanding Credits
Learn how the BillToSheet credits system works. Information about free conversio...
Downloading Your Converted Files
Learn how to download your converted invoice files in CSV and Excel formats. Acc...