Invoice Import Validator + Formatter

Three safe fixes: dates are reformatted to MM/DD/YYYY (the format QuickBooks expects), currency symbols and thousands separators are cleaned out of amounts, and a missing amount is calculated from quantity × rate when both are present. Every fix is shown on its row, and the fixes are applied in the downloaded CSV.

At minimum a customer column and an invoice date column — the checker accepts common header names such as Customer, Customer Name, Client, Invoice Date, and Txn Date. Invoice number, due date, item (Product/Service, Description), quantity, rate, and amount columns are all picked up when present. If the customer or date column cannot be found at all, the checker tells you exactly what is missing.

They are listed with the error on the row, and they are left out of the downloaded QuickBooks-ready CSV. That way one bad row cannot fail the whole import — you import the clean rows now and fix the flagged rows in your source file at your own pace.

The download uses the column layout QuickBooks Online's invoice import accepts: InvoiceNo, Customer, InvoiceDate, DueDate, ItemName, ItemQuantity, ItemRate, and ItemAmount, with dates in MM/DD/YYYY. Map those columns in the QuickBooks import screen and the invoices go in as single-line invoices.

No. Your CSV is processed in memory to build the report and the cleaned file, and it is not stored afterwards. We never sell or share your financial data.