Handling Duplicate and Amended Invoices
Learn how to identify and handle duplicate invoices, credit notes, and amended invoices when converting and importing invoice data.
Frequently Asked Questions
How do I identify duplicate invoices?
Check invoice numbers - duplicates often have the same number. Amended invoices may have a suffix (e.g., -R1) or reference the original. Our converter extracts invoice numbers for easy comparison.
How are credit notes shown in the output?
Credit notes are extracted with negative amounts. The invoice number and description will indicate it's a credit. Use the CSV to filter or sort by amount to find credits.
What about amended or replacement invoices?
Amended invoices are converted like any other. Check the invoice number and any 'replaces' or 'cancels' references. You may need to exclude the original when importing if the amended version supersedes it.
Can I convert both an invoice and its credit note?
Yes, convert each separately. Both will appear in your conversion history. The credit note will show negative amounts for easy reconciliation against the original invoice.
How do I avoid importing duplicates?
Before importing, sort your CSV by invoice number and remove or flag duplicates. Most accounting software will also warn or reject duplicate invoice numbers during import.
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...