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
      • 👍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
    • 🛑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

Was this helpful?

  1. Accounting and Pemo
  2. Accounting Setup
  3. Setting up Accounting with Pemo

Pemo Universal CSV

PreviousExporting & Import Expenses to TallyNextUsing the Pemo Universal Template

Last updated 7 months ago

Was this helpful?

If you don't have an accounting system that we offer a direct online integration with you can still synch your expense data using the Pemo Universal CSV, which is a flexible template that you can add more columns using additional fields to match your expected CSV template

Some of the powerful features that come with the Pemo Univerasl CSV are below:

  1. Import any field: Import any field from your provider, such as a merchant, project, department, etc., to code within Pemo

  2. Open text field: Option to create a column or multiple columns of open text fields for employees or bookkeepers to fill out in accordance with how your company does accounting

Fields within the Pemo Universal CSV

Reference# | Expense Date | Submitter Name | Expense Type | Approval Status | Merchant | Total Amount | Currency | Actual Amount | Actual Amount Currency | VAT Amount | Description | Account ID | Account | Supplier | Payment Account

Pemo Power Tip: Customize Your Data! After exporting, you can easily rename these columns to suit your needs. Plus, you can add extra columns using additional fields, so your CSV template is tailored perfectly to your workflow.

📠
🪛
📊
🔎Using the Pemo Universal Template