Before your first export, set up three things in Pemo: your Chart of Accounts, your VAT codes and any custom fields your accountant needs. Do this once and every expense can be coded correctly from day one.
Before you start: Web only. You need to be a Super Admin, Admin or Accountant (Internal or External). Everything here is under Accounting export in the left sidebar, then Settings above the table.
1. Import your Chart of Accounts
Go to Required fields → Chart of accounts.
CSV import (recommended for many accounts)
Select ⋮ at the top right, then Import Chart of accounts CSV.
Select Download to get the CSV template.
Fill in the template. ID must be a number and Name is the account name. Save it as a CSV file.
Select Next, then drag and drop your file or select Browse files.
Manual (for a few accounts): select Add row, enter the ID and Name, then select Save. Repeat for each account.
2. Import your VAT codes
Go to Advanced fields → VAT Codes.
Select ⋮ at the top right, then Import VAT Codes CSV.
Select Download to get the template.
Fill in Name (the type of VAT), Code (your reference) and Rate (the VAT rate). Save it as a CSV file.
Select Next, then upload your file.
Manual: select Add row, enter Name, Code and Rate, then select Save.
CSV import rules
Save the file as UTF-8 (Unicode). The maximum file size is 20 MB.
A row without a Name is ignored.
Chart of Accounts: every row needs a numeric ID. Rows with no ID or a non-numeric ID fail and are reported; the rest of the file still imports.
Chart of Accounts: an import replaces your existing accounts. The accounts in Pemo are deleted before the rows in your file are created.
VAT codes: a row with a Name but no Code still imports.
3. Add custom fields
Custom fields such as Location, Project or Client keep context attached to each transaction. In Pemo they're called Advanced fields.
Go to Advanced fields and select Create field at the bottom of the list.
Enter a clear Field Name, such as Location.
Choose the type. Text Field lets people type freely. Single Select gives a fixed list of options; after you save, add the options on the field's page, manually or with the CSV template (columns Code and Name).
Turn on Marked as required for export if the field must be filled in before an expense can be exported.
Select Save.
Fields travel with every transaction but don't all appear in exports automatically: select the ones you want in your CSV template's field list. Comments are never exported; use Memo instead.
Tips
Use Single Select for anything you report on monthly, and keep names short and consistent.
Field missing from the export? Check it's under Advanced fields and selected in your CSV template.
Switch on Pemo Copilot to categorize expenses automatically based on past spend.
Next step
Your setup is ready. Now see where you review and export everything: Your Accounting Export page.


