Export format: Payments to Peachtree/Sage 50
Peachtree / Sage 50 requires a specific format when importing payments.
Export payments from Cashflow360
Export payments from Cashflow360 with the following profile mapping:
- Select Settings
- Select Import / Export under Import / Export
- Select Export next to Payments
- Select Modify next to Export Profile
- 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 #
- Remove any headers not listed by unselecting the checkbox for that header
- 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
- Select Continue
Format the file
Follow these steps as a guide to format the file for import into Peachtree / Sage 50:
- After the last column, insert a new column
- 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
- Remove the first row (the header row) from the Import file
- In Peachtree / Sage 50, navigate to File > Select Import/Export
- Select Accounts Payable
- Select Payments Journal
- Select Import
- 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
- In the Options tab, verify that First Row Contains Headings is not selected
ACCOUNT SETUP View all