Skip to main content

Billing

How to Assign Ledger Accounts to Products and Tax Codes

Assign the correct ledger accounts to your products and VAT codes in Invoice Office so every invoice line posts to the right account automatically.

Updated 4 min read

When you assign ledger accounts to your products and tax codes in Invoice Office, every invoice line is booked to the right revenue account and the VAT on it to the right VAT account, automatically. You set the accounts once: on the product for revenue, costs and stock, and on the VAT code for the VAT. This guide shows where to set them, which account wins when a customer has its own, and how to check the postings of a finalized invoice.

The accounts you can choose come from your chart of accounts. Add any account you’re missing there first.

Set the ledger accounts on a product

  1. Go to Products and open the product.
  2. Open the Settings tab.
  3. Under Ledger accounts, choose:
    • Profit account: the revenue account the product’s sales are booked to. Only revenue accounts are offered.
    • Cost account: the account its purchases are booked to.
    • COGS ledger account: the cost of goods sold account. It lists your accounts of type cost of goods sold, so it stays empty if your chart has none.
    • Stock account: the account its stock value is booked to.
  4. Click Save.
The Settings tab of product Office chair, ergonomic in Invoice Office, with Profit account Omzet artikelen - 80100000 and Cost account Voorraad goederen - 70000000 outlined under Ledger accounts, and the Save button outlined

When you add the product to an invoice, its Profit account is filled in on the line. On a purchase, the line gets the product’s Cost account.

Which account an invoice line gets

Each invoice line has its own ledger account. When you pick a product, Invoice Office fills it in this order:

  1. The customer’s Profit account, if the customer has one.
  2. Otherwise, the product’s Profit account.

So a Profit account on the customer overrides the product’s for every line on that customer’s invoices. Leave it empty if your products should decide. You’ll find it under the customer’s Settings → General.

The Settings page of customer Fabrikam Interiors with the General section open and the Profit account field outlined and left empty

You can still change the account on a single line. Click the tag icon on the line, or use the ledger account column if you show it, and pick another account.

The account is saved on the line when you add the product. Changing the product’s Profit account later only affects new lines, not invoices you’ve already made.

Assign a ledger account to a VAT code

  1. Go to Settings → VAT codes and open the VAT code.
  2. Choose the ledger account the VAT is booked to:
    • Account vat to pay: for sales VAT codes (shown when VAT type is Sales or Both).
    • Account vat to claim: for purchase VAT codes (shown when VAT type is Procurement or Both).
  3. Click Modify.
The VAT code 01 Hoog tarief in Invoice Office with VAT type Sales and Account vat to pay set to Te betalen omzetbelasting - 18100000; the Account vat to pay field and the Modify button are outlined

The VAT on every invoice line with this VAT code is then booked to that account, separately from the revenue. For more on the other fields, see how to create a VAT code.

Check the postings of an invoice

Postings are made when you finalize an invoice. A concept invoice has none yet.

  1. Open the finalized invoice.
  2. In its Action menu, choose Journal data.

The page lists every line booked for the invoice, with its Date, Ledger account, Ledger account code, Document, Document number, Account, Debit and Credit. Check that the revenue lands on the product’s (or customer’s) Profit account and the VAT on the VAT code’s account. You can filter the list by Document and Ledger account, and export it with Export.

Booked something to the wrong account? Fix the product, customer or VAT code first, so new invoices are right. For an invoice that’s already finalized, a memorial journal entry moves the amount to the right account.

Was this article helpful?

If something is missing or did not work as described, tell us and we will fix the article.

Try it in Invoice Office

Create a free account to follow these steps yourself, or log in if you already have one.