Skip to content

How do I extract my data?

Extract Instructions for some of the most used accounting ERP systems.

If you are unable to automate your data delivery via one of out secure automated connection you are able to extract the data from your accounting system by following the below instructions.

We have instructions available for the following:

  • Quickbooks
  • Sage 100
  • Oracle
  • Sage 50
  • SAP
  • Sage 300
  • Eclipse

Quickbooks

Aging Accounts Receivables

Desktop

  • Open QuickBooks
  • Go to the report centre
  • In the navigation bar, click Reports > All Reports > Manage Accounts Receivable
  • Click to run the A/R Aging Detail or Accounts Receivable report, then click the Export dropdown at the top of the report, and select Excel.
  • When the report opens, click New Worksheet
  • Save the report on your desktop, or location of your choice, and name it: “company name” Aging

Online

  • From the QuickBooks home page, click on Reports on the menu bar on the left
  • Click on Reports from the left menu bar. This will load the Report Centre.
  • Select the Recommended Reports tab and select A/R Aging Summary.

Customer File

  • Open QuickBooks
  • Go to report centre
  • Click on customer contact list
  • Go to customize/modify report, a list of boxes with a checkmarks should appear. Uncheck Bill and check Street 1, Street2, City, State, Zip, and phone number.
  • Click OK and export to excel
  • Save the report on your desktop, or location of your choice, and name it: “company name” Customer List

 


Sage 100

Almost every report in Sage100 is now Crystal Reports based. Between reports and look ups it is becoming easier to export data directly into Excel. Any Crystal report can be exported to Excel. To export data from a Crystal Report directly to Excel, select a report and PREVIEW it. Once open click the first icon on the top left.

The design of the preview may look different depending on the version that is installed on your computer. Here’s another example of the report preview. On this version click the envelope icon.

Using the drop‐down listing, select Excel.

You can then choose to where you want the file exported. If you want to easily edit immediately after exporting, select Application (presuming you have Microsoft Excel installed on the machine from where you are exporting the report.)

You’ll then be prompted to select some options related to exporting the data.

Once you’ve selected your options and click OK, Excel will open and the data from the report will be available to be edited or reformatted. Note, sometimes the formatting from Crystal Reports is not exact when translating to Excel. You might encounter some blank lines that you might not normally expect. This is due to the translation between Crystal and Excel.


Oracle

  1. Follow the steps in Find and Run a Report
  2. Re-display the report to the desired format
    1. a. Select the view of the report you want to display. The default is All Tabs. Other options vary depending on the report. They may include Full Display or Brief Display.
      Note: Many financial reports have a Data Download tab that is specifically formatted for export.
  3. Export the report:
    1. Click Export.
    2. Click Save button.
    3. Navigate to the folder where the file is to be saved.
    4. Enter the File name if you want to change the default.
    5. Click Save button.
  4. Open the file:
    1. Open the saved file in Excel.

Sage 50

  1. From the main menu of Sage 50 accounting click on Reports, Lists, Customers.
  2. The Customer List Options box will come on.
  3. Press Select All.
  4. Click OK.
  5. It will then generate the Customer List Report.
  6. Go to the File menu on the Report.
  7. Click EXPORT.
  8. The "Export Selection" box will pop up.
  9. Make sure you save it in the C: drive and the "Save as" type box should be Comma Separated (*.CSV).
  10. Click on SAVE.

SAP

Option 1

  • You can use the icon for exporting as a shortcut.
  • All you have to do is to click on the exporting icon, which is an arrow pointing to the right, then select the spreadsheet button. Once that happens, your SAP data will be exported to Excel without a problem.

Option 2

  • The first thing is to click on the list menu. Once you do that, you should select the Export option and then the Spreadsheet option. This option works when you are in the full screen mode where the SAP screen is displaying returned data lists.
  • If you have more than one format available with regard to the spreadsheets, then you will see the Select Spreadsheet option open up.
  • Since there are many ways of saving the spreadsheets, you should specify the format, which you prefer on the dialogue box list.
  • Once you select your preferred format, you need to confirm the new settings.
  • You will have to state the name and path of the file you are dealing with then save the changes.
  • At times, you will also be required to make the relevant settings. The program linked to the selected extension on the file name will then open the file you generate after you have completed the exporting process.
 Option 3
  • You can make use of the right clicking option to expert data from SAP to Excel.
  • Once you have determined the data that you want to export, you need to place your cursor within that data. It does not matter where the cursor lies as long as it is within that data displayed on the screen.
  • You should right click using your mouse, after which you will have access to a drop-down menu. You can then select the spreadsheet option and export that SAP data to Excel.
  • Setting Excel as the Default Option
  • If you are not interested in having to follow the lengthy processes when exporting SAP data to Excel, then there are things that you can do to make the process much easier on you. Some of them are outlined below.
  • In the case of Exporting Data I, you can still use the List>Expert> Spreadsheet option. However, when the Select Spreadsheet dialogue box comes up, you should select the Always use Selected Format option. Once you confirm the settings, you can proceed as usual. Anytime you expert SAP data after that, it will be exported to the preferred settings.

Sage 300

  1. Click on Tasks
  2.  Select your module of choice (i.e. Accounts Receivable).
  3. Then select an option within the Module (i.e. Customers)
  4. Click File and scroll down to and select export
  5. A window will appear with a drop box for the Type of Export you wish to perform. For this example it will contain 3 options (Customers, Statistics and Comments)
  6. This will open the Export Selection Form and prior to making any field choices you will be required to save the excel file to a location on your computer using the Browse button.
  7. With this completed, you can now select the Export Fields that you want to appear on the Excel spreadsheet. You will note that all relevant fields are selected by default so using the right click– >Deselect All button and then choosing only the fields you need is the best way to go about this.
  8. Click OK and a report will be generated displaying the amount of records exported.
  9. Following this you will be able to open the file from the location you choose in the earlier steps and manipulate it as you would a normal Excel spread sheet.

Eclipse

  1. Create and run a report.
  2. In the report results, click the Export button in the top right corner of the report page. The format selection window opens.
  3. Select Excel as the format in which you want to export the report and click Submit and you will be prompted to save the report.
0