🔎Using the Pemo Universal Template

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.


Part 1: Configuring the Accounting Setup + Adding Your Chart of Accounts

Step 1: Start the Setup Process

  1. Click on Accounting ExportCard Expenses.

  2. From the drop-down list, select Other Accounting System.

  3. Click on Get Started.

  1. Click on Start Setup.

Step 2: Add a Payment Account

  1. Enter the name of your payment account (e.g., Pemo Wallet).

  2. Click Save.

Pemo Power Tip: A payment account is required to export expenses.

Step 3: Add Your Expense Chart of Accounts

  1. Click on Required FieldsChart of Accounts.

  2. Choose one of the two options to add accounts:

    • Manual Input

    • CSV Import

Option 1: Manual Input

  1. Click on Manual Input.

  2. Click on Add Row.

  3. Enter the ID (optional) and name of your account.

  4. Click Save.

Option 2: CSV Import

  1. Click on Upload CSV.

  2. In Step 1, download the Pemo CSV template.

  1. 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.

  1. Save the file.

  2. Return to Pemo and click Browse Files to re-upload the CSV.

  1. Click Confirm once the upload is complete.

Step 4: Finalizing the Setup

  1. Close the Accounting Settings.

  2. Your table of expenses will now display with the correct accounting fields, ready for export.


Part 2: Exporting Your Expenses

Step 1: Assign Accounts to Expenses

  1. Hover over the Account field on the row of your expense until you see the word + Add.

  1. Click on + Add and select one of your accounts for the expense.

Step 2: Mark Expenses as Ready for Export

  1. After selecting your account, click on Mark as Ready.

Step 3: Export Your Expenses

  1. Once marked as ready, click on Export in the top-right corner to download your expense data in a CSV file.

  1. You can now take this downloaded CSV file and upload it on your accounting system.

Last updated

Was this helpful?