You can import invoices and expenses (transactions from here on out) from other accounting systems into Quaderno using our CSV template.
You can do this at set-up time or as a normal Quaderno process after initial set-up, as many times as you'd like.
Quaderno uses CSV (Comma-Separated Value) files to perform this kind of bulk task, like in this example: example.csv
To import your transactions, follow these steps:
- Go to the invoices or expenses page, depending on what transactions you’re importing, and click
- Drag & drop your CSV file in the modal window.
When contact duplicates are found via the fields
email_address , any filled field that now comes empty on the CSV, will be removed from the contact.
CSV columns breakdown
total_amount are required. All other fields are optional.
|The contact’s name. If the combination of contact_name + email_address do not already exist in Quaderno, a new contact will be created. In other words, this field is used to find contact duplicates, along with email_address. When contact duplicates are found, any filled field that now comes empty on the CSV, will be removed from the contact.
|The contact’s email address.
|The contact’s address (first line).
|The contact’s address (second line).
|The contact’s city.
|The contact’s postal code.
|The contact’s region, province, or state.
|The contact’s country, represented as 2-letter ISO code. Defaults to your account’s country.
|The contact’s tax id (VAT number). Make sure you fill this for B2B sales! Quaderno will automatically apply reverse charge for invoices issued to contacts with a verified tax id.
|Invoice or credit note number. Defaults to your current sequence in your account.
|Date of creation. Must be entered in the format dd/mm/yyyy. Defaults to the current date.
|An additional reference number (e.g. payment processor transaction id).
|Currency of the amounts (3-letter ISO code). Defaults to your accounting currency.
|Description of the product or service on the invoice.
|Total amount of the transaction with taxes included. Avoid specifying both total_amount and unit_price, use either one or another. E.g. 120.00
|Number of items of the product sold. Defaults to 1.
|Net price for each item. Mandatory if total_amount isn’t specified, but avoid specifying both fields.. E.g. 99.00
|The discount percentage you want to apply to the document. Enter to 2 decimal places, without the % sign, e.g. 10.00
|The name of the tax rate applied to the transaction.
|The tax rate to be applied to the transaction. Enter to 2 decimal places, without the % sign, e.g. 20.00
|The name of the additional tax rate applied to the transaction.
|The additional tax rate to be applied to the transaction. Enter to 2 decimal places, without the % sign, e.g. 20.00
|The tax country (2-letter ISO code) to be applied to the transaction.
|Tax code to be applied to the transaction. Defaults to your default tax class in the preferences page.
|Payment receipt date, only if the document has been paid. Must be in the format dd/mm/yyyy.
|Specify how your document was paid: credit_card, paypal, cash, wire_transfer, direct_debit or other. Defaults to other.