Chapter 17: Import/Export - MCCC

1 Chapter 17: import /ExportMcGraw-Hill/IrwinCopyright 2013 by The McGraw-Hill Companies, Inc. All rights translates data from other programs into a format that Peachtree can use. Data can be imported into copies Peachtree data into a format that other programs can read and use. Data is exported from Peachtree. 17-2 Importing, p. 683 PeachtreeSpreadsheet Database fileOther accountingprogram Importing translates data from other programs into a format that Peachtree can pp. 683-684 Database programSpreadsheetprogramWord processing programPeachtreeOtheraccounting programExporting copies Peachtree data into a format that other programs can TipsThe word processing program used to illustrate PCA s exporting feature is Microsoft may use any word processing program that supports ASCII to complete Chapter export data from Bellwether Garden Supply in Chapter import Bellwether s chart of accounts into a newly set up up and Saved File in Chapter 17, p.

2 656 Peachtree Backup (.ptb)Excel (.xlsx) and Adobe (.pdf) KBPage KB691 Exercise KB701 Exercise 17-2_Vendor KB701 Exercise 17-2_Chart of `87 KB701 Exercise 17-2_Vendor List and Chart of KB70117-6 Select Import/Export windowFor importing and exporting templates, use the Select Import/Export window located on the File menu. Observe that the window is organized by software module: Accounts Receivable, Accounts Payable, Payroll, General Ledger, Inventory, Jobs, Account Reconciliation, of TermsChapter 1717-8 Importing, 683 Importing translates data from other programs into a format that Peachtree can use. Data can be imported into , p. 683 Exporting copies Peachtree data into a format that other programs can read and use. Data can be exported from , p. 684 Files are a group of related records; for example, customer files and journal , p.

3 684 Records are a group of fields that contain information on one subject; for example, the general journal, purchase journal, cash disbursements journal, sales journal, or cash receipts , p. 684 Fields are an individual piece of data; for example, invoice numbers, account numbers, debit amount, credit Separated Values, p. 685 Comma separated value files (CSV extensions) are commonly used for transferring data between applications in a text-based , p. 686 ASCII is an acronym for American Standard Code for Information Interchange. It is one of the standard formats for representing characters on a computer. Most word processing, spreadsheet, and database programs can read ASCII to the Net, p. 698 Access the Peachtree Add-Onswebsite at Complete the nine Peachtree to Third-Party Add-Ons, then Point of Sale. The URL is Briefly explain the Point of Sale Question, p. 701 What is the purpose of importing and exporting?

4 Importing translates data from other programs, such as a word processing or spreadsheet application, into a format that Peachtree can use. Data can be imported into copies Peachtree data into a format that other programs can read and use. Data is exported from Rubric, p. 701 ReportMenuSelectionsand LinksFile Name, Extension, and Report IDCustomer ListFile Menu; Select Import/Export . In the Accounts Receivable list, select Customer List. Select the export icon. Save file to external media or default report shown on Select Import/Export Learning Center Go online to additional resources. Link to Student Edition, select Chapter TestingoGlossary of TermsoFeature QuizoNarrated PowerPointsoAssessment RubricoGoing to the NetoQA Templates17-19