OVERVIEW
After exporting bills from Bill.com to be imported into Peachtree/Sage 50, use these steps as a guide for formatting the file.
STEPS
- In the Bill.com export file, reorder the columns as follows, and remove any column that is not listed below:
- Vendor Id
- Invoice #
- Invoice Date
- Due Date
- Total Line Items
- Bill Line Item Description
- Bill Line Item Account Number
- Bill Line Item Amount
- Between Due Date and Total Line Items, insert a new, empty column. 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
- Once finished, remove the first row in the Import file (the row that contains the headers)
- In Peachtree / Sage 50, navigate to File > Select Import/Export;
- Click Accounts Payable
- Click Purchases Journal
- Click Import
- 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
- In the Options tab, make sure that "First Row Contains Headings" is deselected