Data Exchange
Exchange files with QuickBooks Online. All files use QBO CSV format.
Open differences
Working memory only: mark a line as done once it has been handled in QBO or Odoo.
| Batch | Layer | Message | Action |
|---|---|---|---|
| 7 | error | Row 34 required column Phone is empty. | |
| 7 | review | Duplicate email robert.anderson@example.ca: Robert Anderson, Robert Wiliams | |
| 7 | review | [Field mismatch] Patricia Perez / Full Name: Odoo "Patricia Perez." vs QBO "Patricia Perez" | |
| 7 | review | [Field mismatch] John Lewis / PostalCode: Odoo "B4A 4B4" vs QBO "O4A 4B4" | |
| 7 | review | [Field mismatch] Jennifer Scott / Full Name: Odoo "Jennifer Martin" vs QBO "Jennifer Scott" | |
| 7 | review | [Field mismatch] Jennifer Scott / Email: Odoo "jennifer.martin@example.ca" vs QBO "jennifer.scott@example.ca" | |
| 7 | review | [Field mismatch] Jennifer Scott / PostalCode: Odoo "B5A 5B5" vs QBO "O5A 5B5" | |
| 7 | review | [Field mismatch] Michael Miller / Full Name: Odoo "Michael Lee" vs QBO "Michael Miller" | |
| 7 | review | [Field mismatch] Michael Miller / Email: Odoo "michael.lee@example.ca" vs QBO "michael.miller@example.ca" | |
| 7 | review | [Field mismatch] Michael Miller / PostalCode: Odoo "B6A 6B6" vs QBO "O6A 6B6" | |
| 7 | review | [Field mismatch] Linda Wilson / Email: Odoo "linda.wilson+new@example.ca" vs QBO "linda.wilson@example.ca" | |
| 7 | review | [Field mismatch] Linda Wilson / PostalCode: Odoo "B7A 7B7" vs QBO "A7A 7B7" | |
| 7 | review | [Field mismatch] David Lee / Full Name: Odoo "David Harris" vs QBO "David Lee" | |
| 7 | review | [Field mismatch] David Lee / Email: Odoo "david.harris@example.ca" vs QBO "david.lee@example.ca" | |
| 7 | review | [Field mismatch] David Lee / PostalCode: Odoo "B8A 8B8" vs QBO "A8A 8B8" | |
| 7 | review | [Field mismatch] Elizabeth Ramirez / Full Name: Odoo "Elizabeth Clark" vs QBO "Elizabeth Ramirez" | |
| 7 | review | [Field mismatch] Elizabeth Ramirez / Email: Odoo "elizabeth.clark@example.ca" vs QBO "elizabeth.ramirez@example.ca" | |
| 7 | review | [Field mismatch] Elizabeth Ramirez / PostalCode: Odoo "B9A 9B9" vs QBO "M9A 9B0" | |
| 7 | review | [QBO only] William Wright (Id=1010) has no Odoo match. | |
| 7 | review | [QBO only] Barbara Garcia (Id=1011) has no Odoo match. | |
| 7 | review | [QBO only] Richard Gonzalez (Id=1012) has no Odoo match. | |
| 7 | review | [QBO only] Susan Martin (Id=1013) has no Odoo match. | |
| 7 | review | [QBO only] Joseph Clark (Id=1014) has no Odoo match. | |
| 7 | review | [QBO only] Jessica King (Id=1015) has no Odoo match. | |
| 7 | review | [QBO only] Thomas Jones (Id=1016) has no Odoo match. | |
| 7 | review | [QBO only] Sarah Lopez (Id=1017) has no Odoo match. | |
| 7 | review | [QBO only] Charles Jackson (Id=1018) has no Odoo match. | |
| 7 | review | [QBO only] Karen Sanchez (Id=1019) has no Odoo match. | |
| 7 | review | [QBO only] Daniel Allen (Id=1020) has no Odoo match. | |
| 7 | review | [QBO only] Nancy Brown (Id=1021) has no Odoo match. | |
| 7 | review | [QBO only] Matthew Hernandez (Id=1022) has no Odoo match. | |
| 7 | review | [QBO only] Lisa Moore (Id=1023) has no Odoo match. | |
| 7 | review | [QBO only] Anthony Harris (Id=1024) has no Odoo match. | |
| 7 | review | [QBO only] Betty Young (Id=1025) has no Odoo match. | |
| 7 | review | [QBO only] Mark Williams (Id=1026) has no Odoo match. | |
| 7 | review | [QBO only] Sandra Martinez (Id=1027) has no Odoo match. | |
| 7 | review | [QBO only] Donald Taylor (Id=1028) has no Odoo match. | |
| 7 | review | [QBO only] Ashley White (Id=1029) has no Odoo match. | |
| 7 | error | QBO Id 2001 points to Robert Wiliams, which already has QBO Id 1002. | |
| 7 | review | [QBO only] Maple Ridge Supplies (Id=2002) has no Odoo match. | |
| 7 | review | [QBO only] Coastal Parts Ltd (Id=2003) has no Odoo match. | |
| 7 | review | [Pending upload] 1 Odoo records are waiting to be exported. | |
| 8 | review | Duplicate email ap@ridgeline.ca: Ridge Line Office Supply, Ridge Line Office Suppl | |
| 8 | review | [Field mismatch] Northern IT Services / Phone: Odoo "+1-416-555-2099" vs QBO "+1-416-555-2002" | |
| 8 | review | [QBO only] Prairie Safety Supplies (Id=4100) has no Odoo match. | |
| 8 | error | QBO Id 4101 points to Ridge Line Office Suppl, which already has QBO Id 4000. | |
| 8 | review | [QBO only] Old Paper Vendor (Id=4102) has no Odoo match. | |
| 8 | review | [Pending upload] 1 Odoo records are waiting to be exported. | |
| 9 | review | [Duplicate SKU] PRO001 appears 2 times in QBO. | |
| 9 | review | [QBO only] Monthly Finance Consulting (SER001) has no Odoo match. | |
| 9 | review | [QBO only] Business Laptop (PRO001) has no Odoo match. | |
| 9 | review | [QBO only] Accounting Software Training (SER002) has no Odoo match. | |
| 9 | review | [QBO only] Printing Supplies Kit (PRO002) has no Odoo match. | |
| 9 | review | [QBO only] Business Laptop (old) (PRO001) has no Odoo match. | |
| 9 | review | [QBO only] Cloud Backup Service (SER009) has no Odoo match. | |
| 9 | error | QBO product Ad-hoc Consulting has no SKU and cannot be matched. | |
| 9 | review | [Odoo only] Implementation Service is missing from the QBO file. | |
| 9 | review | [Odoo only] Support Plan is missing from the QBO file. | |
| 9 | review | [Odoo only] Training Day is missing from the QBO file. | |
| 10 | error | Duplicate account number 1000 appears 2 times. | |
| 10 | error | Duplicate account number 6000 appears 2 times. | |
| 10 | review | [New in QBO] 1000 Chequing Account has no Odoo account. | |
| 10 | review | [New in QBO] 1010 Savings Account has no Odoo account. | |
| 10 | review | [New in QBO] 1100 Accounts Receivable has no Odoo account. | |
| 10 | review | [New in QBO] 1200 Inventory has no Odoo account. | |
| 10 | review | [New in QBO] 1300 Prepaid Expenses has no Odoo account. | |
| 10 | review | [New in QBO] 1500 Computer Equipment has no Odoo account. | |
| 10 | review | [New in QBO] 2000 Accounts Payable has no Odoo account. | |
| 10 | review | [New in QBO] 2100 GST/HST Payable has no Odoo account. | |
| 10 | review | [New in QBO] 2110 Payroll Liabilities has no Odoo account. | |
| 10 | review | [New in QBO] 3000 Owner's Equity has no Odoo account. | |
| 10 | review | [New in QBO] 4000 Service Revenue has no Odoo account. | |
| 10 | review | [New in QBO] 4100 Product Sales has no Odoo account. | |
| 10 | review | [New in QBO] 4200 Training Revenue has no Odoo account. | |
| 10 | review | [New in QBO] 5000 Cost of Goods Sold has no Odoo account. | |
| 10 | review | [New in QBO] 6000 Advertising & Marketing has no Odoo account. | |
| 10 | review | [New in QBO] 6100 Bank Charges has no Odoo account. | |
| 10 | review | [New in QBO] 6200 Insurance has no Odoo account. | |
| 10 | review | [New in QBO] 6300 Professional Fees has no Odoo account. | |
| 10 | review | [New in QBO] 6400 Office Supplies has no Odoo account. | |
| 10 | review | [New in QBO] 6500 Rent has no Odoo account. | |
| 10 | review | [New in QBO] 6600 Utilities has no Odoo account. | |
| 10 | review | [New in QBO] 6000 Marketing has no Odoo account. | |
| 10 | review | [New in QBO] 1000 Old Chequing Account has no Odoo account. | |
| 10 | review | [New in QBO] 1020 Petty Cash has no Odoo account. | |
| 11 | error | Duplicate document number BILL-1003 appears 2 times. | |
| 11 | review | 11 rows / 10 purchase bills parsed. Matching to posted documents is not enabled in this prototype. | |
| 12 | error | Missing required columns: Item amount, Item tax code | |
| 12 | review | 30 rows / 30 sales invoices parsed. Matching to posted documents is not enabled in this prototype. | |
| 19 | error | Duplicate account number 6000 appears 2 times. | |
| 19 | review | [Mapped] 1000 Chequing Account -> 111311 Bank | |
| 19 | review | [Mapped] 1010 Savings Account -> 111200 Demand Deposits / Notice Deposits in Deposit Accepting Institutions | |
| 19 | review | [Mapped] 1100 Accounts Receivable -> 112110 Trade Accounts Receivable | |
| 19 | review | [Mapped] 1200 Inventory -> 121120 Goods for Sale Inventory | |
| 19 | review | [Mapped] 1300 Prepaid Expenses -> 131200 Prepaid Expenses | |
| 19 | review | [Mapped] 1500 Computer Equipment -> 124107 Machinery and Equipment | |
| 19 | review | [Mapped] 2000 Accounts Payable -> 221120 Accounts Payable - Other Trade Accounts | |
| 19 | review | [Mapped] 2100 GST/HST Payable -> 231000 GST to pay | |
| 19 | review | [Mapped] 2110 Payroll Liabilities -> 221206 Employee Deduction Payable | |
| 19 | review | [Mapped] 3000 Owner's Equity -> 313000 Owners' Equity (Owners' Investment - No Share Capital Entities) |
