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.