QuickBooks Online and Xero import files
- Three new export data sets, CSV only and behind the finance grant: bills_quickbooks (our invoices as bills in the QuickBooks Online bill import layout), bills_xero (the same in Xero's bill template) and supplier_credits_xero (our credit memos as Xero supplier credit notes, negative unit amounts in the bill template).
- One row per line. The supplier is Balaji Trading, Inc., the bill number is the invoice number, dates are MM/DD/YYYY, and shipping and discounts are their own lines. The account column holds a placeholder (Inventory Asset for QuickBooks, Inventory for Xero) and tax is left at no tax, for you to map on import.
- A file whose lines do not add up to an invoice's total to the cent answers 422 EXPORT_UNBALANCED naming the invoices, and no file. Asking for Excel or PDF of these sets answers 400.
- QuickBooks Online does not import vendor credits, so there is no QuickBooks credits file.