- Before performing any exports, you will want to verify that the Chart of Accounts accurately reflects the Chart of Accounts in Peachtree. The Account ID entered in ChamberMaster/MemberZone should exactly match the Account ID in Peachtree.
- Verify that the Fee items are assigned to the correct accounts. for instructions on viewing/modifying fee items. You should click on each fee item to verify that the Income Account has been correctly assigned.
- If charging sales tax, verify that each tax item is assigned to a matching account. for instructions on verifying/modifying sales tax items. Click on each Sales Tax Item and verify that the Tax Account listed is correct.
Testing It Out
It’s always a good idea to test out sample transactions before importing a large number of entries. So before any other transactions are created for the day*, go into the Billing module and create a couple of sample entries.
- Create an individual invoice, a payment for that invoice, and a sales receipt in the Billing Module. See for instructions. You will delete these transactions after you are done testing.
- Click Billing in the left-hand navigation panel.
- Click the Reports tab.
- Click on either Journal Entry Export – Accrual Basis or Journal Entry Export – Cash Basis
- Accrual Basis – will display ALL possible transactions that match the selected filter options.
- Cash Basis – will display ONLY Payments and Receipts that match the selected filter options.
- You should see your transactions. If not, click the Refresh Button.
- Note the Account IDs that are being referenced. These are the general journal entries that will be made in your accounting software.
- Select Peachtree CSV
- If needed, deselect any transactions that are not part of your sample entries.
- Click Export
- If prompted, save the file to a location you will remember.
- Open Peachtree
- Select File, Import/Export
- Click General Ledger, General Journal
- Click Import.
- Choose the following fields: Date, Reference, Number of Distributions, G/L Account, Description, Amount.
- From the Options tab Browse to find the file that needs to be imported and place a check by First Row Contains Headings.
- View the imported Journal Entries by going to Reports & Forms, General Ledger, General Journal.
- Delete these sample entries on the report Opened in #3 above
- You should be ready to export now on a regular basis.
Exporting should typically be done for the previous day(s) – not the current day. This will ensure that all transactions are included for the date or date range specified.
- Click Billing in the left-hand menu.
- Click on the Reports Tab.
- Under Executive click on either Journal Entry Export – Accrual Basis or Journal Entry Export Cash Basis
- Accrual Basis – will display ALL possible transactions that match the selected filter options.
- Cash Basis – will display ONLY Payments and Receipts that match the selected filter options.
- Specify the proper date (or date range) and click Refresh Report
- Make any desired filter option selections.
- To ensure you don’t export a transaction multiple times, make sure the check box “Save Export Batch” is selected.
- Browse the transactions for any missing account assignments or anything unusual. If any transaction does not look right do not import until the transactions have been corrected in the billing module.
- From the Format dropdown select Peachtree (CSV)
- Click Export
- Save the file to a location you will remember.
- Open Peachtree
- Select File > Import/Export
- Click General Ledger, General Journal
- Click Import
- Choose the following fields: Date, Reference, Number of Distributions, G/L Account, Description, Amount.
- From the Options tab Browse to find the file that needs to be imported and place a check by First Row Contains Headings.
- View the imported journal entries by going to Reports & Forms, General Ledger, General Journal.