Import Airwallex Transactions To QuickBooks Online Via CSV

How can you import your Airwallex transactions into your QuickBooks account?

As of August 2022 Airwallex does not yet natively support transactions being sent to QuickBooks Online accounts.

Therefore, the only alternative available is to manually export the transactions in Airwallex and use QuickBooks Online CSV import feature of transactions.

While you could achieve this relatively easily there are a couple of things I found which made the import a little tedious. I’ve captured it all in a Google Sheet that somewhat makes the process easier.

There is a step-by-step instruction sheet to help guide you through the process. The spreadsheet referenced in this process can be found here:

Get your free copy of Airwallex to Quickbooks CSV – Google Sheets

Step By Step Process

On the Reports screen generate a “Balance activity report”

On the “Generate balance activity report” window select the date ranges you want to export.

(Optional) If you have multiple Airwallex currency accounts, set the Currency field to a specific currency as you would have individual currency Airwallex accounts in Quickbooks.

Set the output type to CSV .

(Optional) Create a filename for the CSV file.

(Optional) Tick the “Email me” checkbox if you want to be alerted when the file is ready for download.

Click the Generate button, and the file will automatically download to your computer.

Click on the


               DATA

sheet and clear all data in this sheet.

Click on cell

A1

by making it the active cell (this helps with the importing of CSV data step below).

Click on File > Import > Upload and then either drag and drop the Airwallex CSV file over (or select it from your computer).

On the “Import File” window set the “Import file location” to “Replace data at selected cell” and leave other options as default (i.e. “Detect automatically” for separator type and “Convert text, numbers, dates and formulas” ticked).

You should see the imported data from Airwallex in the


               DATA

sheet.

Go to the


               EXPORT

sheet to see if the data has come across as required.

With the


               EXPORT

sheet active click on File > Download > Comma separated values (.csv) as this will download the


               EXPORT

sheet data as a CSV file for import into Quickbooks.

From the Transactions screen, you’ll see a “Link account” button with a drop-down arrow. Click on the drop-down arrow then on the option “Upload from file”.

On the “Import bank transactions” screen, drag and drop your CSV file from the


               EXPORT

above.

(Optional) If you get an error of “Unexpected token < in JSON at position 0” you could be logged out of Quickbooks Online. Go back to the Quickbooks login step above.

Select the Quickbooks account for which these Airwallex transactions are to be posted to.

In the next screen for


               STEP 1

check the following options have been set:


               Is the first row in your file a header?
               
                Yes


               How many columns show amounts?
               
                Two columns


               What's the date format used in your file?
               
                Select the date according to the EXPORT sheet

On this same screen for


               STEP 2

check the following options have been set:


               

               

               QuickBooks Field = Columns from your file
               

               Date = Column 1: Date
               

               Description = Column 2: Detail
               

               Amount = Money received = Column 4: Credit
               

               Money spent = Column 3: Debit

After clicking on the continue button there is one final screen where you will need to select the actual transactions you want to import.

(Optional) You may also be presented with errors, if so check you’ve completed the steps above properly.

Check all the transactions to import (for ease of use you can click the topmost checkbox and it will select all options).

Scroll to the bottom and click the “Continue” button.

You should see one last final window prompt to check if you’re sure you want to import these selected transactions.

Your import should now be complete!

Follow the steps above to import your data from your Airwallex accounts into your Quickbooks

Summary

Importing your transactional data from your Airwallex account does not have to be tedious. Simply follow the basic step-by-step approach above and get the CSV file from the Google Sheet EXPORT sheet to be easily imported into your Quickbooks Online account.

Here’s a link to the spreadsheet you can use as the intermediary to get the necessary data into Quickbooks, please feel free to make your own copy:

Get your free copy of Airwallex to Quickbooks CSV – Google Sheet