Connex for QuickBooks Desktop User Guide
Connex for QuickBooks Online User Guide
Frequently Asked Questions
Integrations Help Guide
- Amazon Settlement Report
- Channel Advisor
- Custom Store
- Match Deposit Tool
- Other Partners
- Roaster Tools
- Spreadsheet Import Tool
Rules Engine Guide
General Troubleshooting Guide
QuickBooks Point of Sale (POS) - ARCHIVED
Can I match PayPal and Shopify orders?
You can upload a spreadsheet of PayPal sales to Connex
How does Connex know how to match fields?
You must map the PayPal transaction ID to the QuickBooks order number field. Here is how the fields map:
|Fee Amount||Merchant Fees||Aggregated and added as a line item.|
|Date||Order Date||Used to locate sales and refunds in QuickBooks.|
|Transaction ID||Order Number or Memo||Used to locate sales in QuickBooks. Each order has a unique transaction ID.|
|Type||Merchant Fees||Used to calculate total fees from PayPal.|
|Order Date||Deposit Date||We map the first order's date to the deposit date in QuickBooks.|
How do I get started?
To start the mapping, follow these steps:
- On the left, click rules > my rules. Upload this spreadsheet. We must map the PayPal transaction ID to the credit memo and credit card refund order number fields:
- On our configure page, click orders > sync orders to QuickBooks > transaction. Choose invoices, payments if paid as the mode. Connex will sync the transaction ID onto the payment reference and memo fields.
- On the PayPal spreadsheet, delete the invoice number column. If you choose sales receipts, then you must map the ref. no as the QuickBooks order number. You can perform these steps by opening the spreadsheet on step three and removing the second row.
- Contact our support to enable a setting to pull the PayPal ref. no field onto the QuickBooks payment or sales receipt.
- In QuickBooks, go to lists > other names > payment method list. Edit PayPal. As the type, choose Visa. This ensures Connex creates credit card refunds and our tool can match refunds:
- Here is the credit card refund that we match: