Skip to main content

How to connect WeTravel to QuickBooks?

Learn how to download a QuickBooks-compatible CSV file.

Updated yesterday

Pro Feature: This functionality is available on the Pro plan. You can find more information here: How to update and manage your WeTravel subscription?

You can make accounting easy with WeTravel by simply downloading a QuickBooks-compatible CSV file that you can upload directly to QuickBooks.

You can access the CSV file through the Transactions Reporting section. To access the transaction reporting feature, click on the "Reports" tab. After that, choose "Transactions Reporting" on the left side. Here, click on QuickBooks CSV to download it.

Steps in QuickBooks

Disclaimer: these are just suggested rules. Please feel free to use the CSV however it best fits your business.

Step 1 - Add new accounts to the Chart of Accounts

  1. WeTravel account - under Cash on hand/bank account

  2. Sales discounts → component of Income. This will be for Refunds.

  3. Disputed Sales - sub-account under Income

Note: Your business bank account should already be in your QuickBooks chart of accounts.

Step 2 - Import data into QuickBooks as Bank Data using a CSV file download


As an example, we will create a new bank account in the Chart of Accounts for “WeTravel Account”. Choose Tools and "Import data".

Upload the CSV file here:

Select your WeTravel Account:

Mapping of Data. Follow the fields below to populate the corresponding fields:

  1. Date - Choose in this format dd/MM/yyyy

  2. Description - Type

  3. Amount - Net

Step 3 - Set up Rules to properly classify transactions.

The rules below are suggestions from the WeTravel team. Please feel free to use the rules as applicable to your organization’s internal accounting.

Payment

  1. Name of Rule - Revenue

  2. Apply to transactions - Money In to “WeTravel Account”

  3. Description Contains Exactly “Payment”

  4. Category “Sales”

Refunds

  1. Name of Rule - Refunds

  2. Apply to transactions - Money Out in “WeTravel Account”

  3. Description Contains Exactly “Refund”

  4. Transaction Type - “Expense”

  5. Category - “Discounts/Refunds Given”

Payout → Transfers from WeTravel Bank to Own Bank Account

  1. Name of Rule - Payout

  2. Apply to transactions - Money In to “WeTravel Account”

  3. Description Contains Exactly “Payout”

  4. Transaction Type - Transfer

  5. Account - Cash on Hand

International Wire Transfer → Transfers from WeTravel Bank to Own Bank Account

  1. Same rule as Payout

Top-Up

  1. Name of Rule - Top-Up

  2. Apply to transactions - Money In to “WeTravel Account”

  3. Description Contains Exactly “Payout”

  4. Transaction Type - Transfer

  5. Account - Cash on Hand

Disputes

  1. Name of Rule - Dispute

  2. Apply to transactions - Money Out in “WeTravel Account”

  3. Description Contains Exactly “Dispute”

  4. Transaction Type - Expense

  5. Account - “Disputed Sales”

Tagged Transactions based on rules will appear as follow:

Rules setup will be prospectively applied. In order to change the rule/tagging of a specific transaction, here are the steps:

  1. Categorized → Select the transaction/s, then click “Undo”. These transaction/s will be moved to the “For Review” tab.

  2. Change the Rules

  3. The new rule/s should be applied to the “For Review” items.


Sample P&L

  • Shows Revenue, refunds, and disputes as an expense

  • Vs. The total amount collected in WeTravel - the difference is the amount of fees paid to WeTravel

Sample Balance Sheet

  • The WeTravel account in QuickBooks reflects the amount available in WeTravel. Disputes are treated as a reduction to WeTravel accounts.


Please contact us if you have any other questions. We will be happy to help!

Did this answer your question?