Pemo Knowledge Base
Pemo.ioPricingLogin
  • 📚Pemo Knowledge Base
  • Getting Started
    • ⭐Getting Started as an Admin
      • ✅Verifying the Company
        • 📄How to get a bank reference letter
      • 🚢Invite your Team and Accountant
        • 🧑‍🤝‍🧑Bulk inviting your Team
        • 🧍Inviting a Single Team Member
      • 💰Top up your wallet
      • 💳Ordering your first Pemo Cards
      • 📱Pemo mobile app tour
    • ☕Getting Started as a Team Member
      • 🤝Accept the invite
      • 🚦Complete User Verification
      • 🗣️Request your Pemo Card
      • 💳Activate your physical card
      • 💸How to pay with your Pemo card and attach your receipt
      • 📱Pemo mobile app tour
    • ❓Pemo General FAQs
  • Wallet & Cards
    • 📥Wallet Management
      • 💰Step by step guide to topping up your wallet
        • 💰Guide for older process for topping up
      • 🔎Understanding Your Pemo Wallet Statement
        • 🗃️Tax invoice
        • 🗄️CSV Statement
        • 📂PDF Statements
      • 📬Get notified when your wallet is running low
      • 🤑How cashback works
      • ❓Wallet FAQs
    • 💳Pemo Cards
      • 👨‍🏭Activating a physical card
      • 💁‍♂️Requesting a Pemo card as a team member
      • 🤝Approving request for new cards
      • ℹ️About your card spending limits
        • 🗓️Calculating your total monthly spend limit
      • 📊Request changing the card limits as a team member
      • 👍Approving requests for new card limits
      • 💱Fees associated with card transactions
      • 🍏Apple Pay for your Pemo Cards
        • How to set up Apple Pay for your Pemo cards?
      • 🤳Google Pay for your Pemo Cards
        • How to set up Google Pay for your Pemo cards?
      • 🧙Card benefits & how to redeem
        • 🥦How to redeem your Talabat pro offer using your unique voucher
      • Cards FAQs
    • 📊Budgets
      • 💳Steps to Create a Card-Type Budget
      • 🏋️Steps to Create a Member-Type Budget
      • 🛒Steps to Create a Merchant Category-Type Budget
      • 🧑‍🤝‍🧑Steps to Create a Team-Type Budget
      • ✏️Managing Your Budgets: How to Edit, Delete, or View Budget Details
      • 📩Budget Owner Notifications
    • 🛂Managing Cards as an Admin
      • 💳Ordering new Pemo cards
      • 🔓Setting/updating limits on Pemo cards
      • 🧊Freeze, Unfreeze and terminate cards
      • 🛒Take Control with Merchant Category Restrictions
        • 📇Understanding Merchant Category Codes (MCCs) and How They Work with Your Pemo Cards
      • 👍How to approve new card limits as an Admin
      • 🤝How to approve new card requests as an Admin
  • Expenses
    • 🧾Expense Management
      • 📩Receipts Inbox
        • 👩‍🔧How to add an email address to your mail box as a contact
        • 📨Setting up automatic email forwarding for digital receipts
        • ⁉️Understanding Receipt Statuses in the Pemo Receipts Inbox
      • 💵Creating out-of-pocket expense
      • 👁️‍🗨️Track Expenses as a Team member
      • 👨‍💼Manage Expenses as an Admin/Financial Controller
        • 👍Pemo's Receipt Verification
      • ➕Adding a receipt and note to a card expense
      • ✅Setting up Approval Policies
        • 💳Card Expenses Approval Policy: Step By Step Guide
        • 🆕New Cards & Spending Limits Approval Policy: Step By Step Guide
        • 📤Out-of-pocket Expenses Approval Policy: Step By Step Guide
        • 📄Invoices Approval Policy: Step By Step Guide
        • 💡Editing the Default Policy
    • ⚙️Card Expenses vs. Out-of-Pocket Expenses: What’s the Difference?
    • 👩‍💻Expenses Tab: Statuses & Tracking
  • ⚖️Cash balance
    • 📑Cash balance as an admin or accountants
      • 🔄Exporting Withdrawals & Pocket Expenses
      • 🖇️Linking Users to Accounting Accounts
    • 💵Cash balance as spender (team member)
  • Invoices
    • 📠Invoice Management
    • 🧠Understanding Invoice statuses in Pemo
  • Accounting and Pemo
    • 🎇Submission Polices
      • 🚩What are Submission Policies?
      • 🎙️Default Submission Policies
      • 💳Creating Custom Submission Policies for Card Expenses
      • 🧾Customizing Default Submission Policy for Pocket Expenses
      • 📬Reminders and Notification
    • 📠Accounting Setup
      • 🪛Setting up Accounting with Pemo
        • 📕ZohoBooks Integration
          • 🔗How to Link Zoho Books to Pemo - Step-by-Step Guide
            • 🔐Pemo Integration Permissions with Zoho Books Overview
            • 🔧Troubleshooting Zoho Books Connection issues
          • ✏️How to use our offline integration with ZohoBooks
        • 💻Xero Integration
          • 🔗How to link Pemo to Xero - Step by Step Guide
            • ❓Xero Online Integration FAQ
          • ✏️How to use our offline integration with Xero
        • 🖇️Wafeq Online Integration
          • 🦾How to link Pemo to Wafeq - Guide
          • ❓Wafeq Online Integration FAQ
        • 🔗Quickbooks Integration
          • 📤How to link Quickbooks to Pemo - Step by Step Guide
          • ✏️How to use our offline integration with Quickbooks
        • 🧙Tally Integration
          • ↔️Exporting & Import Expenses to Tally
        • 📊Pemo Universal CSV
          • 🔎Using the Pemo Universal Template
      • 💠AI Powered Accounting
        • 🔷Pemo Copilot
          • 🔹Activating Pemo Copilot
        • 🔶Smart Vendor Creation
          • 🔸How to activate Smart Vendor Creation
    • ❓Accounting FAQs
  • Managing your account as Admin
    • 👩‍🏭User and Team Management
      • ✉️Inviting and deactivating users
      • 👨‍🏫Manage User Roles
      • 📩Inviting an external accountant
      • 👯Organize Pemo Users by Teams
    • 👩‍💻Admining your Account
      • 🔝Subscription plans and pricing
      • 🖇️Changing your company name or address
      • 🚧Company account restriction reasons, timelines, and explanations
      • 🤝Pemo referral program
        • 🛤️How to track your referrals
        • 🎇How to redeem your reward
      • 📧How to manage your email notifications in Pemo
  • 🔐Privacy & Security
    • 👩‍🏭How to protect your account from fraudsters
      • 🚨Payment Fraud – Do’s & Don’ts
    • 🛑How to Handle a Fraudulent Transaction on Your Pemo Card
  • 🥸How to spot and avoid phishing scams targeting your corporate card
  • Video Series
    • 📽 Order your Pemo cards
    • 📽 Add funds to your Pemo account
    • 📽 Edit, terminate and freeze cards
    • 📽 Set up your Approval Policies
    • 📽 Manage card limits
Powered by GitBook
On this page
  • Part 1: Configuring the Accounting Setup + Adding Your Chart of Accounts
  • Part 2: Exporting Your Expenses

Was this helpful?

  1. Accounting and Pemo
  2. Accounting Setup
  3. Setting up Accounting with Pemo
  4. Pemo Universal CSV

Using the Pemo Universal Template

PreviousPemo Universal CSVNextAI Powered Accounting

Last updated 3 months ago

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.


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

Step 1: Start the Setup Process

  1. Click on Accounting Export → Card 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 Fields → Chart 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.

📠
🪛
📊
🔎