Export format: Payments to Peachtree/Sage 50

After exporting PayMaker payments to be imported into Peachtree/Sage 50, use these steps as a guide for formatting your file:

  1. In the PayMaker export file, reorder the columns as listed below, removing any column not listed:
    • Vendor Id
    • Process Date
    • Payment Account Number
    • Payment Amount
    • Total Line Items
    • Invoice #
    • Payment Payment Amount
  2. After the last column, insert a new column
  3. For each cell of the new column, enter the method of the payment
    • Entering the value "Check" for each cell in the column will suffice for PayMaker importing
    • The value may be specific to the payment, based on the Payment Methods in Peachtree/Sage 50
  4. Remove the first row (the header row) from the Import file
  5. In Peachtree / Sage 50, navigate to File > Select Import/Export
  6. Click Accounts Payable
  7. Click Payments Journal
  8. Click Import
  9. In the Fields tab of the Import window, select Show for only the following fields, deselecting "Show" for all other fields:
    • Vendor ID
    • Date
    • Cash Account
    • Total Paid on Invoice(s)
    • Number of Distributions
    • Invoice Paid
    • Amount
    • Payment Method
  10. In the Options tab, verify that "First Row Contains Headings" is deselected