Importing and exporting data
> Exporting data
New Features
Advanced Search for Accounts and Select From Lists
Bank register changes
Notes on reconciliation and payments
Contact added to Cards List search
Calendar icon on date fields
One click to email
Customizing Jobs
Purge Jobs
Delete deposit on orders
Print Paid Stamp
Job report changes
Direct Web Pay
Introduction
Learn about your AccountEdge software
Manuals
Online help
Other resources
Where to start
Explore your AccountEdge software
Command centers
Action menu
Calendar (date entry)
Calculator
Zoom arrows
Search icons
Select columns
Mouse shortcuts
Shortcut keys
Default screen font
Spell-check
Setting up your company file
Overview
Create a company file
Easy setup assistant
Set up preferences
Set a password for the company file
Set up accounts
Enter account opening balances
Advanced setup
Overview
Set up sales
Do an initial bank reconciliation
Task 1: Identify uncleared withdrawals and deposits
Task 2: Record uncleared withdrawals and deposits
Task 3: Reconcile
Set up Credit Card Processing
Activating Credit Card Processing
Web Pay Setup
Web Store Setup
Manage AccountEdge Connect
Manage AccountEdge Mobile
Manage Rerun
Banking
Receiving money
Bank deposits
Spending money
Entering transactions in the Bank Register window
Transferring money between accounts
Tracking petty cash expenses
Recording miscellaneous transactions
Credit card transactions
Credit card payments using Merchant Account Service
Processing credit card payments using Merchant Account Service
Declined authorization
Timed-out authorization
Voiding Merchant Account Service credit card payments
Reconciling your bank accounts
Undoing an account reconciliation
Importing statements
Analyzing your cash flow [Windows only]
Sales
Creating a Lead Card
Creating a customer card
Entering sales
Task 1: Enter information about the customer
Task 2: Choose the type of sale
Task 3: Enter the items or services you are selling
Task 4: Enter additional information about the sale
Task 5: Complete the sale
Adding and deleting transaction lines, subtotals, and headers in sales transactions
Changing the status of a sale
Reviewing your sales information
Receiving payments
Printing payment receipts
Printing and emailing payment receipts
Credit control
Credit limits
Credit holds
Customer credits
Settling credits
Accounting for bad debts
Process Web Orders
Items
Creating items
Customizing Items
Creating custom lists
Custom lists and item reports
Creating brands list
Brands list and sales reports
Weight
Creating custom fields
Creating tags list
Tag list and item reports
Lists
Adding a record
Adding records using Easy-Add
Setting up tax codes
Finding a record
Changing a record
Inactivating or reactivating a record
Deleting a record
Combining records
Combining cards
Combining accounts
Combining items
Tracking Mileage
Company vehicles list
Mileage Rates
Mileage Slips
Email Templates
Transactions
Finding a transaction
Changing or deleting a transaction
Changing a transaction
Deleting a transaction
Reversing a transaction
Recurring transactions
Setting up recurring transactions
Recording recurring transactions
Reminders
Create copy of a transaction
Publishing to Calendar
Publishing an invoice to Calendar
Publishing a recurring transaction to Calendar
Publishing a reminder to Calendar
Reports
Producing reports
Customizing reports
Task 1: Select the data to be printed
Task 2: Select the required fields
Task 3: Select finishing options
Task 4: Change the report format
Task 5: Print the report
Task 6: Save the report
Changing the default fonts on reports
Frequently used reports
Overview of report details
Forms
Finding forms
Sending forms
Sending forms when you record a transaction
Sending forms in a batch
Advanced filters
Customizing forms
Task 1: Display the form
Task 2: Set up form properties
Task 3: Add and edit elements
Task 4: Preview the customized form
Task 5: Save the customized form
Task 6: Print the customized form
Changing the default fonts on forms
Adding and editing elements
Adding and editing data and label elements
Adding and editing graphic elements
Editing all elements with common commands
Contact management
Creating a card
Keeping in touch with your contacts
Personalized letters
Mailing labels
Reminder log
Other ways to keep in touch
Grouping your contacts
Custom lists
Customizing cards
Card identification codes
Card pictures
Lead Source and Status
Reviewing your contact information
Reminders
Financial control
Tracking financial information
Accounts
Jobs
Task 1: Set up a job
Task 2: Assign expenses to the job
Task 3: Bill the customer
Budgets
Entering budget amounts
Budget Shortcuts window
Auditing your records
Reviewing financial information
End-of-period procedures
Month-end procedures
Task 1: Run the Company Data Auditor
Task 2: Reconcile your bank accounts
Task 3: Review reports
Task 4: Send customer statements
Task 5: Record depreciation
Task 6: Lock periods
Starting a new fiscal year
Task 1: Complete month-end tasks
Task 2: Provide information to your accountant
Task 3: Enter end-of-year adjustments
Task 4: Back up your company file
Task 5: Start a new fiscal year
Task 6: Optimize and verify your company file
Managing user accounts and company files
Managing Master Password
Backing up and restoring company files
Servicing your company file
Checking your company file for errors
Optimizing your company file
Purging information that is no longer needed
Troubleshooting file-locking problems
Changing company file date
Troubleshooting your company file
Alert messages—company file
Alert messages—transactions
Importing and exporting data
Exporting data
Importing data
Importing Quicken (QIF) files
Managing import and export records
Using OfficeLink
Viewing reports in Microsoft Excel (OfficeLink)
Modifying OfficeLink templates for Microsoft Excel
Creating personalized letters (OfficeLink)
OfficeLink templates for personalized letters
Viewing reports in Microsoft Excel
Creating personalized letters using OfficeLink
OfficeLink templates for personalized letters
OfficeLink notes and warnings
AppleScripts
Glossary
Index
Exporting data
You can take data entered in your company file and use it in other software or in other company files. This process is called
exporting data
.
Some of the types of information you can export are: Accounts, Items, General Journal Entries, Receive Money Entries, Spend Money Entries, Sales, Cards, Jobs, Custom Lists, Brands, and Tags.
The data can be exported to a tab-delimited or comma-separated text file.
Before you export data, you should make a backup of your company file. See
‘Backing up and restoring company files’
.
To export data
1
Go to the
File
menu, choose
Export Data
and then choose the type of data you want to export. The
Export File
window appears.
2
Select the export file format and enter other information in this window. For detailed field help,
see
Export File window
.
3
Click
Continue
. The
Export Data
window appears.
4
Choose the fields you want to export and the order in which you want to export them. To do this, click on the first field you want to export in the
AccountEdge Fields
AccountEdge Premier Fields
column.
Field 1
will appear in the
Export Order
column next to the field you selected. The field name will appear at the top of the
Export Fields
column on the left side of the window.
5
Repeat the previous step for each field you want to export.
If you want to remove a field name from the
Export Fields
column, click the name in the
AccountEdgeAccountEdge Fields
column. If you want to export all the fields in the order they’re shown in the
AccountEdge Fields
column, click
Match All
.
6
When you have selected the fields, click
Export
. The
Save As
window appears.
7
Enter a file name and location for the export file and click
Save
. The file is exported.
Related topics
■
Import and export fields
■
Importing data
■
AppleScripts
Top of page