Export format: Payments to Peachtree/Sage 50

Peachtree / Sage 50 requires a specific format when importing payments.

Export payments from Bill.com

Export payments from Bill.com with the following profile mapping:

  1. Select Settings
  2. Select Import / Export under Import / Export
  3. Select Export next to Payments
  4. Select Modify next to Export Profile
  5. Reorder the Headers into the following order by selecting the arrows next to each header
    • Vendor Id
    • Process Date
    • Payment Account Number
    • Payment Amount
    • Invoice #
  6. Remove any headers not listed by unselecting the checkbox for that header
  7. Assign a profile name; we'll save this profile mapping for you so you just have to select it the next time you need to export payments
  8. Select Continue

Format the file

Follow these steps as a guide to format the file for import into Peachtree / Sage 50:

  1. After the last column, insert a new column
  2. For each cell of the new column, enter the method of the payment
    • The value may be specific to the payment, based on the Payment Methods in Peachtree/Sage 50
  3. Remove the first row (the header row) from the Import file
  4. In Peachtree / Sage 50, navigate to File > Select Import/Export
  5. Select Accounts Payable
  6. Select Payments Journal
  7. Select Import
  8. 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
  9. In the Options tab, verify that First Row Contains Headings is not selected