How to Import Data From Excel to QuickBooks and Xero

Synder constantly works on adding new sales channels and payment platforms to the list of supported integrations. However, if you have any unsupported providers you would like to sync to your accounting system, you will find the new Excel import feature very helpful. It allows you to import any data from an Excel spreadsheet to Synder and then operate with the uploaded data as with regular transactions by syncing them to your accounting company. Now you can consolidate transaction data import from all payment and e-commerce platforms you are using at no extra costs with Synder.

Overview:

1. Adding Excel import option to your Synder profile

2. Import Excel to QuickBooks or Xero

3. How to fill the import template with your data

4. Useful tips on Excel bulk import to accounting

Adding Excel import option to your Synder profile

First, you should connect your QuickBooks or other accounting company to Synder and then add Excel as one of your payment platforms. Follow the steps below and use Synder to its full capacity to upload Excel to your accounting company.
Step 1: Switch to the needed Organization in the top-left corner of the Synder page. Then, click on the Person icon in the upper-right corner and select My account. In the Integrations section, click Add integration.

Step 2: Select Excel in the Add integration dropdown. Then, enter the provider name for Excel, you may call it as you wish to → click Create.

Step 3: Choose an account for payouts and hit Continue to finish the set-up.

Import Excel to QuickBooks or Xero

As soon as you have finished the setup, you may proceed to the bulk transactions import from Excel to QuickBooks or Xero. 

Step 1: Go to the Platform transactions tab → click on Import historical data.

Step 2: Click on All under Select integrations you would like to import data from, and then hit Import next to Import Excel spreadsheet.

Step 3: Click on the Download template button. We recommend you download it and fill in with the data you export from the unsupported payment processor.

Step 4: Upload your Excel file from your PC by clicking on Browse. You can use it after filling in the template. Having the template filled in, you will be able to upload it to QuickBooks or Xero.

Step 5: After uploading the file, you will have two options. The first one is to upload the transactions from your spreadsheet to Synder before synchronizing them to your accounting platform. To do that, hit the Import to Synder button.
If you click on the Sync to your books button – the list of your transactions will be uploaded from the Excel file to your accounting company right away, without your prior confirmation. 
You may also select the option “send an email notification when the import is finished”.

How to fill the import template with your data

The template supports four types of transactions that may be synced to your QuickBooks or Xero company, so be sure to change the transaction types if their names differ:

Template type	QuickBooks transaction	Xero transaction
PAYMENT	Sales Receipt/Expense (*depending on the positive or negative figure in the file)	Invoice+Payment / Bill+Payment (*depending on the positive or negative figure in the file)
EXPENSE	Expense (regardless of the + or – sign)	Bill+Payment (regardless of the + or – sign)
REFUND	Refund Receipt (regardless of the + or – sign)	Credit Note (regardless of the + or – sign)
DEPOSIT	Deposit (regardless of the + or – sign)	Credit Note (regardless of the + or – sign)

Useful notes:

• Required fields are marked with *; make sure you fill them in before the import.
• The “Number” column will be synced to your accounting as the reference number of the transaction.
• The “Transaction ID” field is used to join several product lines to a single transaction.
  For instance, you can use the order number and paste it to several lines in a row to make sure the app knows these lines compose a single order.
• If you specify a value in the “Fee amount” column in addition to the sale amount, the app will create both income and expense transactions during the synchronization (for example, Sales Receipt for total sale amount and Expense for fee amount)
• If you fill in the amount, you should specify the currency for that amount (like if you specify the “Fee Amount” field, then fill in the “Fee Currency” field)
• If you leave the “Exchange rate” field blank and the currency differs from your home currency, an exchange rate will be automatically assigned by your accounting platform based on the date of the transaction.

Useful tips on Excel bulk import to accounting software

Note 1: If you close or reload the page – the upload will continue in the background. 

Note 2: You may check the transactions in your transaction list in Synder and manage the synchronization as usual.

Note 3: If you try to upload the file with the same “Transaction ID” several times, Synder will skip them as duplicates. If you would like to re-import the same transactions differently, please follow these steps:

• Archive unneeded transactions from Synder (select them → click on the Actions button → Select Archive)
• Open your Excel file, change “Transaction ID” to something that was not in the file before
• Follow the steps described above in the guide to import the file again.

Note 4: You can connect Excel several times if you have several unsupported platforms. You will be able to differentiate between them and tailor their settings with this helpful Excel to Xero or QuickBooks converter.

This is it! Now you can import sales data from any desired provider you would like to synchronize with your accounting system. Easily convert Excel to Xero or QuickBooks with the new Excel import feature, and import any data from an Excel spreadsheet to Synder. The new Import from Excel feature aims to bring even more value for Synder users that operate with multiple sales channels.

Reach out to the Synder Team via online support chat, phone, or email with any questions you have – we’re always happy to help you!