Importing General Ledger into Peachtree Accounting

Whether you have created a monthly general ledger (Creating a monthly general ledger report) or a daily transaction listing (Day End), a file will have been created which you can import into Peachtree Accounting.

 

With Peachtree open and your store selected as the active store, open Peachtree's file menu.

file_arrow.png

 

 

Then go to Select Import/Export

select_import_export_arrow.png

 

 

The Select Import/Export window will popup. In this new window, select General Ledger from the left side.

general_ledger_left_side.png

 

 

Then on the right side of the window, select General Journal. (You can create saved templates to make the next few steps easier.)

general_journal_arrow.png

 

 

Now press import_button.png.

import_arrow.png

 

 

This will display the General Journal window with all fields selected. You have to set these fields to match the ones in the file exported from AmberPOS.

general_journal_blank.png

 

 

 

First, click the "Show None" button to disable all the selections.

show_none_button.png

 

 

Then use the checkboxes in the Show field to select the following options in the following order:

fields_ordered.png

If the order of your fields is not the same as in the picture, use the Move Up and Move Down buttons to rearrange them.

 

 

Now at the top of the screen, select the Options tab.

options_tab.png

 

 

Under the Import Options section, check the box labelled First Row Contains Headings.

first_row_checkbox.png

 

 

 

You may wish to use the save_button.png button to save your selections as a template for future imports.

save_arrow.png

 

 

Finally, use the Import/Export File field to select the file to be imported. This will bring up an Open File window.

import_file_arrow.png

 

 

The general ledger files exported from AmberPOS will by default be located in the folder: C:\Program Files (x86)\Pacific Amber\AmberPOS\GL_OUT

and will be .csv (excel) files named "PeachTree1 - <date of report>"   ("Peachtree1-20120209", for a day end report, for example, or "PeachTree--January2012" for a monthly general ledger).

open_computer.png

 

Select the file you would like to import, and press Open to import it.

 

*******  If trying to import into Peach Tree and you get this error message "Illegal characters in path" try the fix below: ********

Please make sure the PO number and invoice number do not have any special characters such as <>&”?/ or Space as this cannot be in a file name.

 

//NOTE: If you forget to populate an account you may get an error when attempting to import the file.  You can open the Text (.txt) or Excel(.csv) format of the file produced to the date to review the results.

1.png

The result will identify the name of the account that is missing an account number.

2.png

 

Related Links:

-Setting Date Format for Peachtree Accounting

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk