This file outlines the payment details of every invoice issued in Kimelo for a given seller as known to Kimelo. It allows sellers to reconcile their books with data from Kimelo to track unpaid invoices, not invoiced orders and confirm payment amounts. Sample file:

invoice_payment_status_yyyy-mm-dd-hh-mm-ss.csv

Kimelo accepts payment processing in the Kimelo app. This is the file format for communicating payment details, including amounts, fees, taxes, and payment status updates.

Kimelo generates this file every 24 hours, 15 minutes after bank closure, at 8:15PM Eastern Standard Time (5:15PM Pacific Time.)

Column Name Data Type Required Description
erp_invoice_id integer Required Kimelo-generated invoice number.
kimelo_order_id integer Required Kimelo-generated order number
kimelo_payment_id integer Optional Payment ID from the payment processor (e.g., Stripe). Can be empty when payment_status is NoCharged
erp_customer_id integer Required Unique identifier for the customer location
delivery_date date Required Delivery date committed in the Kimelo app.
invoice_generation_date date Required Date of invoice generation.
payment_due_date date Payment due date as per invoice and terms rules.
charge_timestamp_update timestamp Optional Timestamp when the payment processor transaction status was last updated. Can be empty when payment_status is NoCharged
order_status string Required Current status of the order. Normally 'checkout' (order placed) for orders getting payment updates.
cart_total Currency Required Total price of items in the order, without taxes.
credit_card_charge Currency Required Credit card surcharge.
other_fees Currency Required Sum of all incremental fees.
sales_tax Currency Required Sales tax amount.
crv_tax Currency Required CRV or recycling tax.
sugar_tax Currency Required Sugar tax.
invoice_total Currency Required Total amount on the invoice including taxes and fees.
vendor_payment_amount Currency Required Amount paid to the distributor.
payment_status string Required Status of payment from Stripe: