Export format: Bills to Peachtree/Sage 50

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

Export bills from Key CashFlow

Export bills from Key CashFlow with the following profile mapping:

  1. Select Settings
  2. Select Import / Export under Import / Export
  3. Select Export next to Bills
  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
    • Invoice #
    • Invoice Date
    • Due Date
    • Bill Line Item Order
    • Bill Line Item Description
    • Bill Line Item Account Number
    • Bill Line Item Amount
  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 bills
  8. Select Continue

Format the file

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

  1. Between Due Date and Total Line Items, insert a new column
  2. 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
  3. Remove the first row (header row) from the file
  4. In Peachtree / Sage 50, navigate to File > Select Import/Export
  5. Select Accounts Payable
  6. Select Purchases Journal
  7. Select Import
  8. 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
  9. In the Options tab, confirm that First Row Contains Headings is deselected