Exporting data

Index

Importing and exporting data > Exporting data

Exporting data

You can take data entered in your software and use it in other software programs or in other company files. This process is called exporting data.

Some of the types of information you can export are: accounts, items, nominal journal entries, Receive Money transactions, Spend Money transactions, sales, purchases, cards, jobs, activities and activity slips.

note : Exporting timesheets

When you export timesheets, only the entries that don’t have activity slips associated with them are included. You must export activity slips to complete the process.

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 Exporting data.

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 Plus Fields (if you’re using AccountEdge, the column is labelled AccountEdge 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 AccountEdge Plus Fields column. If you want to export all the fields in the order they’re shown in the 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

Welcome

AccountEdge Plus Single User AccountEdge Plus Network Edition Activation and Add’l Workstation Licenses New Welcome window design Open the Last Company file Business Insights Card Actions Google Maps New Form Customisation Tools Profit Analysis on Sale Track Shipping Details Enhanced list searching Advance search in Select from List windows Auto Update Company Data Auditor Enhancements Backup now supports ZIP file format

Stock Control Enhancements

Multiple Product Images Brands Weight Tags New Report filters

Import and export enhancements Payroll Enhancements

Learning about your software

Manuals Online help Other resources

Experiment with a sample company’s data

Exploring your software

Command centres Task list Calendar (date entry) Business calendar Calculator Zoom arrows Search icons Select columns Mouse shortcuts Shortcut keys Default screen font

Setting up your company file

Overview Create a company file

Set up accounts

Setting up accounts

Enter account opening balances Set up preferences Set a password for the Administrator user ID

Overview Set up sales Set up purchases Set up payroll

Do an initial bank reconciliation

Task 1: Identify uncleared withdrawals and deposits Task 2: Record uncleared withdrawals and deposits Task 3: Reconcile

Create item records Enter stock opening balances

Receiving money Preparing a bank deposit Spending money Entering transactions in the Bank Register window Transferring money between accounts Tracking petty cash expenses

Reconciling your bank accounts

Undoing an account reconciliation

Importing statements Recording miscellaneous transactions Credit card transactions Analysing your cash flow

Creating a customer card

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

Recording sales with insufficient on-hand item quantities

Allow negative on-hand quantities and values Build, buy or backorder items

Changing the status of a sale Reviewing your sales information Receiving payments Printing payment receipts

Credit limits Credit holds Finance charges paid by customers

Creating customer credits

Settling credit notes

Dealing with a supplier who is also a customer Accounting for bad debts

Creating a supplier card

Entering purchases

Entering a purchase transaction Task 1: Enter information about the supplier Task 2: Choose the type of purchase Task 3: Enter the items or services you are purchasing Task 4: Enter additional information about the purchase Task 5: Complete the purchase Adding lines, subtotals and headers to purchases

Receiving items without a supplier invoice

Setting up an accrual account for items received without a supplier invoice Recording items received without a supplier invoice

Creating a purchase order from a sale Changing the status of a purchase Reviewing your purchase information Paying suppliers

Creating supplier debits

Settling supplier debits

Adding finance charges paid to suppliers

Paying your employees

Payroll setup tasks

Creating payroll categories

Wages Information window Entitlements Information window Deduction Information window Employer Expense Information window Editing payroll categories

Creating employee cards Entering employee payroll information

Delete timesheet entries View timesheet reports

Processing your payroll

Task 1: Select the pay period Task 2: Include employee timesheets Task 3: Select and edit employee pay Task 4: Record the employee paycheques Task 5: Process payments Task 6: Print payroll earnings Task 7: Print/email pay slips

Payroll liabilities

Processing termination payments

Task 1: Determine any outstanding entitlements Task 2: [Optional] Create payroll categories for termination payments Task 3: Process a paycheque for the final pay Task 4: Terminate the employee in the Card File Task 5: Print the employee’s P45

Reviewing payroll information

Viewing pay history Viewing an employee’s entitlement balances Analysing payroll Reviewing payroll liabilities

Preparing and filing payroll tax forms

Enrolling in PAYE Online for Employers Preparing and e-filing original year-end tax forms Preparing and printing year-end tax forms Preparing an amended return Submitting test data before e-filing Additional information about completing year-end tax forms

Data that will print in this field Required/Optional (P14 field title)

Billing for time

About the time billing feature Setting time billing preferences Setting billing rates Creating activities

Creating activity slips

Creating multiple activity slips

Reviewing and changing activity slips Creating time billing invoices Work in progress

Average Cost, Last Cost and Standard Cost

Making stock adjustments

Stock adjustment examples

Multiple stock locations

Recording stock movements between locations

Auto-building items

Count stock Reviewing your stock information Setting item prices

Customising stock

Creating custom price levels Creating custom lists Custom lists and stock reports Creating brands list Brands list and inventory reports Weight Creating custom fields Creating tags list Tag list and inventory reports

International transactions

About the multiple-currency feature

Setting up multiple currencies

Task 1: Select the multiple currency option Task 2: Set up records for foreign currencies Task 3: Create accounts to track foreign-currency transactions Task 4: Assign accounts to foreign currencies Task 5: Assign appropriate currencies to foreign customers and suppliers

Exchange rates

Tracking currency gains and losses

Tracking realised currency gains and losses Unrealised currency gains and losses

Miscellaneous transactions

Transferring funds to a foreign account Entering foreign-currency transactions in a local account Reconciling accounts containing foreign transactions

Setting up VAT codes

Accrual and cash reporting VAT Summary and VAT Summary – Cash reports VAT Detail, VAT Detail – Cash reports VAT Return and VAT Return – Cash reports

Reporting EC sales

Reporting EC purchases VAT Return, VAT Return – Cash reports

Adding a record

Adding records using Easy-Add

Finding a record Changing a record Inactivating or reactivating a record Deleting a record

Combining records

Combining Cards Combining accounts

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 Responding to reminders for recurring transactions

Publishing to iCal

Publishing an invoice or purchase to iCal Publishing a recurring transaction to iCal Publishing a reminder log to iCal

Producing reports Printing report batches

Customising reports

Task 1: Select the data to be printed Task 2: Specify 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

Finding forms

Sending forms immediately Sending forms in a batch Advanced filters

Customising forms

Task 1: Display the form Task 2: Set up form properties Task 3: Adding and editing elements Task 4: Preview the customised form Task 5: Save the customised form Task 6: Print the customised 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

Personalised letters Mailing labels Reminder log More ways to keep in touch

Grouping your contacts

Identifiers Custom lists

Synchronising cards with Mac Address Book cards

Deleting cards Resetting the synchronisation

Customising cards

Card identification codes Card pictures

Reviewing your contact information

Financial control

Tracking financial information

Accounts Categories Jobs

Tracking reimbursable expenses

Task 1: Set up a job Task 2: Assign expenses to the job Task 3: Bill the customer Changing the status of a reimbursable expense

Entering budget amounts Budget Shortcuts window

Auditing your records

Company Data Auditor Audit trail tracking system

Reviewing financial information

End-of-period procedures

Month-end procedures

Task 1: Run the Company Data Auditor Task 2: Review reports Task 3: Send customer statements Task 4: Record depreciation Task 5: Lodge VAT returns Task 6: Pay PAYE and NIC that is due Task 7: Lock periods

Starting a new financial year

Task 1: Complete month-end tasks Task 2: Perform a stocktake Task 3: Provide information to your accountant Task 4: Enter end-of-year adjustments Task 5: Back up your company file Task 6: Start a new financial year Task 7: Optimise and verify your company file

Starting a new payroll year

Task 1: Process the last paycheques for the year Task 2: Print payroll reports Task 3: Prepare and submit payroll tax forms Task 4: Back up your company file Task 5: Start a new payroll year Task 6: Optimise and verify your company file

Managing user accounts and company files

Managing user accounts Backing up and restoring company files

Servicing your company file

Checking your company file for errors Optimising your company file Purging information that is no longer needed Troubleshooting file-locking problems

Troubleshooting your company file

Alert messages—company file Alert messages—transactions

Importing and exporting data

Exporting data Importing data Managing import and export records Glossary AppleScripts

Networking company files Index of windows Table 1: