Export format: Bills to Peachtree/Sage 50

After exporting bills from Bill.com to be imported into Peachtree/Sage 50, use these steps as a guide for formatting the file:

  1. In the Bill.com export file, reorder the columns as follows (removing any column not listed)
    • Vendor Id
    • Invoice #
    • Invoice Date
    • Due Date
    • Total Line Items
    • Bill Line Item Description
    • Bill Line Item Account Number
    • Bill Line Item Amount
  2. Between Due Date and Total Line Items, insert a new column
  3. For each field in this new column, enter the Account Number of the AP account
    • If using more than one AP account, enter the correct AP account number for each row
  4. Remove the first row (header row) from the Import file
  5. In Peachtree / Sage 50, navigate to File > Select Import/Export
  6. Click Accounts Payable
  7. Click Purchases Journal
  8. Click Import
  9. In the Fields tab of the Import window, select Show for only the following fields (deselect "Show" for all other fields):
    • Vendor ID
    • Invoice/CM #
    • Date
    • Date Due
    • Accounts Payable Account
    • Number of Distributions
    • Description
    • G/L Account
    • Amount
  10. In the Options tab, confirm that "First Row Contains Headings" is deselected