VAT codes in the export file
Some ERP systems require VAT codes in the accounting file. In Expense, you link VAT codes (also called export codes) to accounts, and the right code follows along automatically when you export.
🔍 Export formats that support VAT codes
| Format | |
|---|---|
| Axapta3 | ✅ |
| Economic | ✅ |
| Excel5, Excel6 | ✅ |
| SAP, SAP8, SAP10, SAP12 | ✅ |
👉 Applies to: administrators who export to an ERP system that requires VAT codes.
⚙️ Step 1 – Choose an export format with VAT codes
- Go to Administrate > Settings and select Import & Export.
- Choose an export format that supports VAT codes.
- Click Save.
📊 Step 2 – Link VAT codes to accounts
- Go to Accounting > Accounts and select the VAT tab.
- Create VAT codes based on the VAT rate.
- Link the right VAT code to each account.
✅ The VAT code is included in the export file when the account is used.
🍽️ Several VAT rates on the same receipt
A restaurant receipt can have several VAT rates. Then create a sub-account per VAT rate and link the right VAT code to each:
| Sub-account | VAT |
|---|---|
| 🛍️ Takeaway | 6% |
| 🍽️ Food | 12% |
| 🍷 Alcohol | 25% |
When the accounting for the receipt is split, each row gets the right account and the right VAT code in the export file. This is especially important for representation.
👉 See Create a sub-account in the chart of accounts.
❓ Frequently asked questions (FAQ)
Why does the VAT code not show in the export file?
Check that the export format supports VAT codes and that the code is linked to the account.
Can we use our own export format?
Yes, the feature Create a custom export format can be activated through support.
💡 Test an export before you start using the VAT codes for real.
✅ Summary
- ⚙️ Choose an export format that supports VAT codes
- 📊 Link VAT codes to accounts under Accounting > Accounts > the VAT tab
- 🍽️ Use sub-accounts for several VAT rates