Using the Pemo Universal Template
Last updated
Was this helpful?
Last updated
Was this helpful?
The Pemo Universal CSV Template streamlines the process of exporting your card expenses to your accounting system. This process is divided into two stages:
Part 1: Configuring the accounting setup + adding your chart of accounts – This includes setting up your payment account and importing your chart of accounts using manual input or CSV import.
Part 2: Exporting your expenses – This involves assigning accounts to expenses and exporting the data in a CSV format.
Follow the step-by-step guide below to ensure a smooth setup and export process.
Click on Accounting Export → Card Expenses.
From the drop-down list, select Other Accounting System.
Click on Get Started.
Click on Start Setup.
Step 2: Add a Payment Account
Enter the name of your payment account (e.g., Pemo Wallet).
Click Save.
Pemo Power Tip: A payment account is required to export expenses.
Click on Required Fields → Chart of Accounts.
Choose one of the two options to add accounts:
Manual Input
CSV Import
Option 1: Manual Input
Click on Manual Input.
Click on Add Row.
Enter the ID (optional) and name of your account.
Click Save.
Option 2: CSV Import
Click on Upload CSV.
In Step 1, download the Pemo CSV template.
Open the file and add your expense accounts:
ID field (optional)
Name field (mandatory)
Extract your chart of accounts from your accounting software and copy the account names into the template.
Save the file.
Return to Pemo and click Browse Files to re-upload the CSV.
Click Confirm once the upload is complete.
Close the Accounting Settings.
Your table of expenses will now display with the correct accounting fields, ready for export.
Hover over the Account field on the row of your expense until you see the word + Add.
Click on + Add and select one of your accounts for the expense.
After selecting your account, click on Mark as Ready.
Once marked as ready, click on Export in the top-right corner to download your expense data in a CSV file.
You can now take this downloaded CSV file and upload it on your accounting system.