Documentation
Back

Jortt

Connect Jortt, set up how your orders become invoices, and register PayPal and Stripe payments and fees.

Jortt is Dutch online accounting software for freelancers and small businesses. This page covers connecting your Jortt account to BrickInvoice, setting up how your orders end up there, and registering your Stripe and PayPal payments and fees.

Table of Contents

  • Before you start
  • Connecting Jortt
  • Configuring Jortt
  • VAT for customers abroad and business customers
  • Payments and transaction fees
  • Troubleshooting
  • Next steps

Before you start

You need:

  • a Jortt subscription, with admin access to your Jortt account
  • your settings filled in
  • your BrickLink or Brick Owl store connected

You connect by logging in to Jortt and giving BrickInvoice permission. There are no keys or codes to copy across.

Connecting Jortt

  1. Go to Accounting → Connect (/home/accounting/connect).
  2. Choose Jortt under Select Accounting Package.
  3. Click Connect to Jortt. Jortt opens.
  4. Log in to Jortt and approve the permissions BrickInvoice asks for: invoices, customers, organization details, registering payments and expenses.
  5. Jortt sends you back to BrickInvoice, now connected.

If your Jortt login has access to more than one administration, choose the one BrickInvoice should book in under Jortt Administration, at the top of the configuration page.

Configuring Jortt

Go to Accounting → Configuration to choose how your orders are booked.

General settings

Introduction Text is the text at the top of each invoice. You can use these placeholders:

  • {order_number}: the order number with its store, such as BL 123456 or BO 789012
  • {payment_method}: the payment method, such as PayPal or Stripe

"Order {order_number} - {payment_method}" becomes "Order BL 123456 - PayPal".

Send Method has two choices:

  • True: the invoice is made final in Jortt and can no longer be changed. Jortt does not send it, unless you turn on Email Invoices to Buyers.
  • False: the invoice stays a draft, so you can check it in Jortt first.

Payment registration and fee sync only work with True. Jortt cannot register a payment on a draft, so the settings page will not let you save False together with either of them.

Differentiate BrickLink and Brick Owl: tick this to choose separate ledger accounts for BrickLink and Brick Owl orders. See Platform differentiation.

Contact sync options

Sync Email Addresses adds the buyer's email address to the customer in Jortt. You need it if Jortt should email invoices to your buyers. Leave it off if you would rather not keep buyers' email addresses in your accounting.

Update Existing Contacts: when on, an existing customer is updated with the data from the new order. When off, existing customers keep what they have in Jortt.

Email Invoices to Buyers: when on, Jortt emails every final invoice to the buyer as soon as BrickInvoice creates it, using the email template of your Jortt administration. The invoice is marked as already paid, so the buyer is not asked to pay again.

  • It only works with Sync Email Addresses on and Send Method set to True, because a draft is never emailed. The settings page will not let you save it otherwise.
  • The invoice goes to the email address of the customer in Jortt. With Update Existing Contacts off, an existing customer keeps the address it already has there.
  • A buyer without an email address still gets a final invoice. It is just not emailed.
  • A B2B invoice that stays a draft because the buyer's VAT number is missing is not emailed either.
  • Re-sync with accounting on an order that was already processed creates a new invoice, and Jortt emails that one to the buyer as well.

Ledger accounts per line

Each order becomes an invoice with a separate line for each kind of revenue, so goods with and without VAT stay apart in your Jortt reports.

Product Line Items, for goods with normal VAT, has three ledger accounts chosen by where the customer lives:

  • Domestic Ledger Account: sales within your country, with your country's VAT
  • EU Ledger Account: sales to other EU countries, with your country's VAT
  • Export Ledger Account: sales outside the EU, without VAT

Margin Scheme Line Items, for goods under the margin scheme, has the same three: Domestic Margin Ledger Account, EU Margin Ledger Account and Export Margin Ledger Account. Margin lines are booked as 0% lines on the account you choose.

Shipping Line Items and Other Line Items (Handling Fees) each have one account for everything: Shipping Ledger Account and Handling Fees Ledger Account.

Line descriptions

Each card has a Description field for the text on its lines. You can use these placeholders:

  • {order_number}: the order number, such as 123456
  • {source}: the store, BrickLink or BrickOwl
  • {payment_method}: the payment method, such as PayPal

"Order {order_number} from {source}" becomes "Order 123456 from BrickLink". Some ideas:

  • products: "LEGO Parts" or "Order {order_number} - Products"
  • margin: "Margin Scheme Product" or "Margin - {source} order {order_number}"
  • shipping: "Shipping" or "Delivery - {payment_method}"
  • handling fees: "Handling Fees" or "Processing fees"

VAT for customers abroad and business customers

Jortt decides per customer which VAT rates an invoice may use. That depends on the customer (country, private or business) and on your administration's settings in Jortt, such as the EU One-Stop-Shop (OSS) and the margin scheme. Keep these in line with the VAT settings in BrickInvoice: if you use OSS in BrickInvoice, turn it on in Jortt as well.

B2B orders (VAT reverse charged)

If you use B2B VAT exempt, BrickInvoice creates a B2B buyer in another EU country in Jortt as a business customer with reverse charge. Jortt only accepts 0% VAT for those customers, and requires a VAT number:

  • Brick Owl: BrickInvoice uses the VAT number the buyer entered at checkout.
  • BrickLink: orders do not include the buyer's VAT number, so the customer gets the placeholder ONBEKEND - AANVULLEN. Replace it with the real VAT number in Jortt.

Buyers in your own country or outside the EU

VAT is never reverse charged for them, even when they entered a VAT number. A buyer outside the EU becomes a regular customer with the export rules.

A Brick Owl buyer in your own country who entered a VAT number at checkout becomes a business customer without reverse charge, whether or not you use B2B VAT exempt. The invoice carries your normal VAT and shows the buyer's VAT number. An existing customer only gets this when Update Existing Contacts is on. Text without any digits, such as n.v.t., does not count as a VAT number.

Customers that already exist in Jortt

  • BrickInvoice finds an existing customer by its reference, for example BL_buyername. Only a customer with exactly that reference is used. Otherwise BrickInvoice creates a new customer.
  • A business customer stays a business customer, and a VAT number you entered in Jortt is kept, also when Update Existing Contacts is on.
  • Whether VAT is reverse charged follows the order: on for a B2B order, off for a regular order from the same buyer.
  • A private customer who places a B2B order becomes a business customer with reverse charge.

BrickInvoice updates these VAT details even when Update Existing Contacts is off, because Jortt would otherwise refuse the invoice. Only the VAT details change then. The rest of the customer stays as it is in Jortt.

Checked before sending

Before creating an invoice, BrickInvoice checks the VAT of every line against what Jortt allows for that customer. If Jortt would refuse it, the invoice is not created and you get a notification that names the line and the rates Jortt does allow.

Payments and transaction fees

Payment registration

When a buyer pays with PayPal or Stripe, BrickInvoice can register that payment on the invoice in Jortt, so the invoice is marked paid and the money lands on the right account.

  1. Set Send Method to True. A payment can only be registered on a final invoice.
  2. Turn on Enable Payment Sync.
  3. Tick PayPal, Stripe or both.
  4. Choose, per store, the Jortt account the payment is booked on, such as your PayPal account.
  5. Optionally fill in Payment Description. It takes the same placeholders as the introduction text. Left empty, it is "Payment" followed by the store and order number.

The account list shows the balance accounts in your Jortt administration. Pick the account the money actually arrives on, such as your PayPal or Stripe account.

Some buyers choose Bank Transfer or IBAN and then pay you through a link from your own Stripe account, for example with iDEAL. For those orders, tick Bank Transfer orders, IBAN orders or both under Stripe, separately for BrickLink and Brick Owl. BrickInvoice then registers them as Stripe payments, and books their Stripe fee when Stripe fee sync is on. How that works is in Bank Transfer and IBAN Orders Paid via Stripe.

Every invoice is created as already paid, so it never shows payment instructions: an order only reaches BrickInvoice once the buyer has paid. In Jortt the invoice stays open until BrickInvoice registers the payment, which then settles it.

PayPal and Stripe fees

BrickInvoice can book the fee PayPal or Stripe keeps on each payment as an expense in Jortt. Like payment registration, this needs Send Method set to True.

  1. Connect PayPal, Stripe or both under Connections → Payments in BrickInvoice.
  2. Turn on Enable PayPal Fee Sync, Enable Stripe Fee Sync or both.
  3. Choose, per store, the cost account the fees are booked on.

Fees are booked without VAT, because transaction fees are exempt.

Troubleshooting

Jortt no longer accepts BrickInvoice's access

The access was removed in Jortt or has expired. Connect Jortt again on the connect page.

The connection is missing a permission

A permission was not approved when you connected. Connect Jortt again and approve every permission it asks for.

Jortt does not accept the VAT for this customer

Jortt does not allow the VAT rate of one or more lines for this customer. The notification lists the rates it does allow.

  • OSS: if BrickInvoice uses the VAT of the destination country (OSS), turn on the EU One-Stop-Shop in your Jortt administration as well.
  • B2B orders: check that the customer in Jortt is a business customer with reverse charge and a VAT number.
  • Customer country: check the customer's country in Jortt.

After fixing it, sync the order again.

Fields do not load

Check that Jortt is still connected and that an administration is chosen. Then reload the configuration page.

Next steps

  1. Sync a few orders and check the invoices in Jortt.
  2. Check that your Jortt reports show the amounts you expect.
  3. Turn on the accounting schedule so new orders sync on their own.