The new ARTERNAL importer lets you upload and manage transactions in bulk, including invoices, consignments, and other record types. Follow the steps below to prep your spreadsheet and complete your import with ease.
Watch a short walkthrough of importing invoices, adding their line items, and undoing both imports.
Step 1: Prepare your transactions spreadsheet
Your CSV should include one row per transaction. Each row can contain invoice or consignment details along with optional billing, shipping, and tax information.
The fields include:
Column Name | Notes |
type | Required. The kind of transaction, such as invoice, consigned in, consigned out, shipping, payable, or released. |
title | Title of transaction |
transaction_number | Transaction or Invoice Number |
inventory_count | Not used by the importer. The count comes from the line items you import. |
paid_status | paid, partially paid, or unpaid. If you leave it blank, it's worked out from amount_paid and total_price. |
date_out | For invoices: Date of Invoice |
date_in | Consignment: If a consignment has a date range, then this is the start date |
subtotal_price | The total price before discounts and taxes |
total_price | The total price |
tax_percent | The tax percentage |
shipping_fee | The shipping amount on invoices |
currency | USD, CAD, etc. |
location | For consignments / other transactions |
first_name | The first name of the contact. If the contact doesn't exist, it will create the profile. |
last_name | The last name of the contact. If the contact doesn't exist, it will create the profile. |
tax_amount | total amount of tax |
ship_to_first_name | First name of ship to - if the first and last name match an existing contact saved in the database, then it will attach that contact, otherwise it will create a new one. |
ship_to_last_name | Last name of ship to - if the first and last name match an existing contact saved in the database, then it will attach that contact, otherwise it will create a new one. |
notes | Transaction notes |
amount_paid | The amount paid. It's saved as a payment and sets the paid status. |
tax_label | Label of the tax rate |
additional_info | The info in the document template for non-invoice transaction. |
created_by | Name of the person who created the transaction. It's saved as text. |
address_street | Street Address |
address_street2 | Line 2 of Street Address (Eg. Apt #) |
address_city | City |
address_state | State |
address_zip | ZIP or Postal Code |
address_country | Country |
billing_email | Email of the bill-to contact. The importer looks for a contact with this email first, then by name. If there's no match, it creates a new contact. |
billing_phone | Not used by the importer. The phone number comes from the contact's profile. |
paid_date | The paid date in the payment history |
voided_at | Not used by the importer. To void an invoice, open it in ARTERNAL after importing. |
💡 Want a template of these columns? Click here:
New Importer: Import Transactions. This creates the invoice and associates it with the contact.
Required fields: Type and Transaction number (invoice number). Add a billing email or the client's name to link each invoice to a contact.
New Importer: Import Transaction Items. This fills in the line items for each invoice, linking the artwork to the invoice.
Required fields: Transaction number. Add the catalog number (inventory number) and price for each work.
Step 2: Launch the importer
Click your profile picture in the bottom left.
Click Import Wizard.
Step 3-A: Import your file
Once in the portal, select:
Import Transactions (to create the transactions).
Import Transaction Items (to add invoice line items).
Start by clicking Import Transactions.
Then upload your prepared .csv or .xlsx file by dragging it in or selecting it from your computer.
Click Continue to proceed.
Step 3-B: Map your columns
After uploading, you’ll see the mapping column view.
Each CSV column will appear, with dropdown options on the right.
The importer will auto-match where possible.
You can manually assign any unmatched fields.
⚠️ Tip: Make sure every important column is mapped before continuing.
Once all mappings look good, click Continue.
Step 3-C: Review and fix errors
After mapping, you’ll be taken to a review screen where you can preview and correct your data:
Check each column for typos, missing values, and dates in the wrong format.
Every cell is editable, so you don't need to re-upload.
Click the trash icon 🗑️ to remove rows you don’t want to import.
When everything looks right, click Continue to complete the import.
Step 3-D: Finalize the import
When your data looks right, click Continue to start the import.
⚠️ Don’t close the window while importing. Wait for the progress bar to complete.
Step 4-A: Import line items
Now that your transactions are imported, you can import line items for each invoice or consignment.
Each row needs the transaction number of an invoice you already imported, plus the work's inventory number. A row with a transaction number that doesn't exist won't import. The invoice total is then worked out from its line items.
Prepare your line items spreadsheet
Your spreadsheet should include one row per line item. Each row needs the transaction number of the invoice or consignment it belongs to.
The fields include:
Column Name | Notes |
transaction_number | Invoice/transaction number |
catalog_number | The inventory number of a work (if no # is provided, then it will create a line item without a work) |
description | The description of the line item if no catalog_number |
price | Price of work |
discount | The discount amount (E.g., 5000) |
discount_percent | The discount percentage (E.g, 10) |
currency | E.g., USD, CAD, EUR, etc. |
tax_percent | The tax percentage |
⚠️ Follow steps 3-A to 3-D once you have the file ready.
Final notes
All data can be reviewed before importing.
If a contact isn't found, a new one is created from the name or email in your sheet.
To undo, open Import History and choose Revert, first on the line items import, then on the transactions import. Revert removes the invoices, their payments, and their line items. Contacts the import created are kept. Delete only removes the import from the list.
Import History also keeps a copy of the spreadsheet you uploaded.
That’s it. Your transactions are now uploaded and ready to go!
If you have any questions or want a second set of eyes on your spreadsheet, feel free to reach out via chat or email us at support@arternal.com. We’re always happy to help.
Frequently asked questions
Q: What transaction types are supported?
A: The most common are invoice, consigned in, consigned out, shipping, payable, and released. Other types include loan, return, transfer, and purchased.
Q: Can I import line items and transactions together?
A: Not at the same time. First import your transactions, then upload the associated items in a separate CSV using the matching transaction_number.
Q: What happens if a contact doesn’t exist in the system?
A: ARTERNAL will automatically create the contact based on the name or email provided.
Q: Can I fix errors in the importer?
A: Yes. Every cell in the review step can be edited before you continue.







