Export Purchase Invoices to Accounts

<< Click to Display Table of Contents >>

Navigation:  Purchase Orders >

Export Purchase Invoices to Accounts

You can export purchase invoices into Sage Accounts 50 (version 11 and above), Sage Instant Accounts and Quick Books (2003 and above). It is a 2 part procedure where data is stored in an intermediate file and then imported in your accounts package.

 

Before you export invoices make sure you have suppliers in your accounts package and that their account references match those customers in EQ. If you are starting with a new database you can export your suppliers from EQ otherwise you will need to assign your account code to the supplier on the account details

 

Part 1 Export

 

In EQ:

 

1.Close all open windows so that you are at the EQ main screen.

2.Go to File > Export... > Export Purchase Invoices

3.Enter invoice dates into the From and To boxes and click Search

4.All invoices matching these dates are shown. Tick each invoice in the Exp column or press Select All to tick them all

5.Click Export Purchase Invoices

6.In the new window you can keep the location and filename or click the browse browse icon to save the file elsewhere.

7.In file type select:
       Sage Line 50 - If using Sage Line 50 version 11
       Sage Line 50 v13+ - If using Sage Accounts 50 version 12 or above, or Sage Instant Accounts
       Quick Books 2003 - If using Quick Books

8.Click the Export button

9.When asked to flag invoices click No. You should return to this screen after you have imported following step 2 below.

 
A CSV/IIF file has been created in your specified location.

 

Part 2 Import

 

Click your accounts package to see specific import instructions:

 

In Sage

 

In Quick Books

 

** All exports and imports should be carried out on a regular basis to ensure your accounts software is kept up-to-date. **

 

See Also

Exporting customers to accounts

Exporting suppliers to accounts

Exporting purchase invoices to accounts

Exporting payments to accounts