Exporting Invoice Data to CSV

Summary:

You can export your invoice and customer data from the CashFlow Payment Requests tab into a generic CSV format. This allows you to transfer your financial data into your preferred third-party accounting software (such as QuickBooks, Xero, or MYOB) for further processing and reconciliation.

This article provides a step-by-step guide on how to perform the export, along with details on the file format and the specific data points included.

Table of Contents:

• How to Export Payment Requests

• Export File Format and Compatibility

• Exported Data Fields

How to Export Payment Requests:

1. Navigate to the CashFlow page via the top navigation bar, then click into the Payment Requests tab.
2. On the far right side, just above the payment requests table, you will see an option to Export to CSV. Click this button to open the export dialog.
3. The "Export Invoice Data" dialog allows you to choose which data sets you wish to download. You can select one or both of the following options:

   1. Invoice data: Details regarding specific payment requests, amounts, and statuses.

   2. Customer data: Contact details and address information for the clients associated with the invoices.

4. Once you have made your selection, click Export. The file will be prepared and automatically downloaded to your device.

Export File Format and Compatibility:

The file format for exports is currently generic and not specific to any single accounting platform. While it is designed to be compatible with major providers, you may need to perform some reformatting to match your specific software's import requirements.

Important note: There are certain data points that are not currently captured in the automated export. Specifically, Account Codes or Ledger Account Names are not included. You will need to manually enter these details for each line item in the spreadsheet before importing the file into your accounting software to ensure it maps correctly to your general ledger.

Exported Data Fields:

The specific data columns included depend on whether you select "Invoice Data" or "Customer Data" during the export process.

Invoice Data:

The Invoice Report focuses on the transaction details and payment status.

• Customer Name

• Email Address

• Customer Phone

• Invoice Number

• Invoice Date

• Status

• Amount

• Currency

• Due Date

• Last Four (Card digits)

• Card Brand

Customer Data:

The Customer Data Report focuses on client contact and location information.

• Customer Name

• Email Address

• Customer Phone

• Address line 1

• Address line 2

• City

• State

• ZIP Code

• Country

• Tax ID