Skip to main content

How to Import Transactions Using the New Importer

Import invoices and transactions in bulk using ARTERNAL’s importer. Supports line items, shipping, payments, and more.

Written by Kalila Richards

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
Consignment: If a consignment has a date range, then this is the end date

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:

  1. 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.

  2. 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

  1. Click your profile picture in the bottom left.

  2. 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.

Did this answer your question?