CSV Export

  • Updated
Follow

The CSV Export feature allows you to export finance data to your finance system where an integration with aXcelerate does not exist. The CSV file has been built to map with MYOB V19 and Quickbooks where aXcelerate compiles a CSV file which is then downloaded and uploaded to your Finance System.

Finance
 

Sync Finance Data

Select your Finance System

Prior to exporting the CSV file, you need to select your finance system in order for the correct CSV file to be compiled.

Settings

 

System Settings

 

Web & Other Integrations

  1. Select Finance Export Integration CSV Export
  2. Click Save Web Settings
  3. Select your Accounting Software
  4. Click Save Web Settings

Export the CSV file

Exporting your finance data will compile the selected data into a CSV file and allow you to upload it into your linked finance package. The various types of financial data are able to be compiled and exported individually. Details on the export process for each data type is listed below:

Customers
Invoices
Payments
Credit Notes
Refunds
Credit Allocations
CSV Data File
  1. Click Search Transactions
  2. Click Create New Customer Data
  3. Select the required Customers to Export
  4. Click Export Customers
  5. You are automatically directed to Create New Invoices Data
 

Warning: A green tick indicates that the contact is already exported, clicking their name again will export with updated details.

  1. Click Create New Invoices Data
  2. Select the required Invoices to Export‍
  3. Click Export Invoices
  4. You are automatically directed to Create New Payments Data
  1. Click Create New Payments Data
  2. Select the required Payments to Export
  3. Click Export Payments
  4. You are automatically directed to Create New Credit Notes Data
  1. Click Create New Credit Notes Data
  2. Select the required Credit Notes to Export
  3. Click Export Credit Notes
  4. You are automatically directed to Create New Refunds Data
  1. Click Create New Refunds Data
  2. Select the required Refunds to Export
  3. Click Export Refunds
  4. You are automatically directed to Create Credit Allocation Data
  1. Click Create New Credit Allocation Data
  2. Select the required Credit Note Allocations to Export
  3. Click Export Credit Note Allocations

After exporting all required finance data, generate the CSV file and upload it into your external finance system.

  1. Click Create CSV Data File
  2. Click Create And Download File
  3. Upload the CSV file in your Finance System
 

Tip: If there is no data on a specific tab, simply click on the next tab to continue the export.

 

Note: Filters are available to assist you with your business processes. For example you may export once a week or only export finalised invoices. Use the filters to select specific invoice dates and only find finalised invoices.

 

Warning: You may skip data if you do not wish to export it, however if you choose not to export a contact or invoice, then you cannot continue exporting any data linked. For example, you will not be able to export linked payments if the invoice has not been exported. Likewise, you will not be able to export the invoice if the contact has not been exported.

CSV Finance Export Webinar

This webinar demonstrates:

  • Exporting Finance Data
  • Viewing Exported Finance Data

Related articles