Migrate your PayTraq data

PayTraq supports bulk CSV import of clients with a downloadable template. Matching is done by name or client code. We map all standard client fields including currency, payment terms, and tax ID into the destination CRM Contacts or Accounts object.

Suppliers are imported via the same CSV template mechanism as clients. We preserve the Supplier object identity and map it to the destination's Vendors or Suppliers object, maintaining purchase terms and default GL accounts.

Products and services are imported separately with different CSV templates. We merge Product and Service price lists into a single destination inventory or items table, handling unit-of-measure and cost/price field mapping where naming conventions differ between systems.

Invoices carry line items that reference Products/Services and Clients. We map invoice headers and line items together, preserving tax rates and discount amounts. Multi-currency invoices require currency-code and exchange-rate field mapping to the destination's currency handling approach.

Purchase Orders reference Suppliers and Products similarly to Sales Invoices. We map PO headers and lines, flagging any that are partially received since the destination may handle partial receipts differently.

Journal Entries are double-entry records with debit/credit lines mapped to GL accounts. We sequence these after the Chart of Accounts is established in the destination. Prepaid expense journal entries carry an allocation schedule that requires manual reconstruction at the destination.

PayTraq uses a standard GL account structure. We map account codes and types (Asset, Liability, Equity, Revenue, Expense) to the destination's chart of accounts. Account groups and cost-center tagging may require field-level mapping depending on the destination schema.

PayTraq tracks stock across multiple warehouses. We map warehouse locations and on-hand quantities per product. Users have noted missing export/import for warehouse items in bulk, so we use the API for inventory snapshots where CSV is insufficient.

PayTraq supports CSV import of employees. We map employee records including compensation fields to the destination HRMS or Users object, preserving effective dates for payroll history where applicable.

Fixed Assets are tracked in PayTraq with acquisition cost, depreciation schedule, and linked GL accounts. We map asset records but flag depreciation methods and accumulated depreciation fields for manual verification since destination accounting engines handle depreciation differently.

PayTraq tracks financial loans as separate records linked to GL accounts. We map loan principal and interest schedules as recurring journal entries, flagging the loan ID reference for manual reconciliation in the destination.

PayTraq records online payment receipts and auto-generates journal entries, but the payment gateway tokens and card data are not exportable. We migrate the payment records as journal entries without the raw payment instrument data.

Tax rates and tax codes are referenced on invoices. We map tax codes to the destination's tax configuration, noting that destination systems may require separate tax agency setup that must be done manually before migration.

PayTraq supports separate price list imports for products and services with multiple price tiers. We map all price list rows to the destination's pricing tables, preserving currency and effective-date fields.