1. Pallet Connect has the ability to connect directly with Quickbooks online to provide a simple process to export completed transactions.
This article will explain how to map accounts and carry out the export to Quickbooks online.
TIP! Read the Related article also. "1A: Initial Set Up for Exporting to Quickbooks Online"
TIP! Quickbooks desktop requires a different process, please see related article.
2. From the main menu, Click "Export Data"
3. Click "QuickBooks Online"
4. Click on "Connect to Quickbooks Online" button.
This will open the Quickbooks log-in page. Sign into account, allow permissions and "connect".
TIP! User needs to have admin permissions in Quickbooks to be able to connect from Pallet Connect.
5. Once connected, the connection will continue unless another team member connects through a different account. The banner "Connected To Quickbooks Online" will show when connected.
To stop connection, click on "Disconnect From Quickbooks Online"
6. The export report can be filtered by date type, date range and contact name.
7. The export report will only show completed activity. It is not possible to export open transactions e.g open customer order.
Choose the list view. There is an option to see 'All' transactions or to view 1 type at a time.
8. To view invoices, Click on "Sales"
9. All transactions that are ready for export will be listed and checked off. The total will appear on the export button.
10. Click here on the eye icon to view the transaction.
11. The slide out screen will show the details. Click "X" to return to the export list.
12. There are buttons to "Check All Transactions" and "Uncheck All Transactions"
13. To begin exporting, click the "Export Selected Transactions" button.
14. The system will start to process and validate the data.
15. As this is the first export, the system will ask to map accounts between Pallet Connect and Quickbooks. This will only need to be carried out once and each time a new stock category is exported.
If mapping is cleared from the export page, then this step will need to be repeated.
First the Taxes need to be mapped.
US Customer:
- map TAX to all tax rates above 0%
- map NON to all exempt or 0% rates
Non US Customers
- Map the matching tax rate to the one in QuickBooks
"Link Tax codes" to complete.
16. Next the Accounts need to be mapped.
These are the accounts the transactions are recorded under, for each stock category. The mapping accounts specifically look for account types from Chart of Accounts like this.
Asset Accounts - (account type) usually “Inventory”
Income Accounts - (account type or detail type) usually “Sales”
Expense Accounts = (account type) usually “Cost of Goods Sold”
Click "Link accounts" to complete.
17. TIP! If custom fields are present in Quickbooks these will need to be mapped also.
The mapping has to be set to one of the fields and cannot be left blank. For inactive fields "Do not map" can be chosen.
18. When mapping is complete the Confirm Export page will appear.
The items being exported will be listed for final review.
19. Click "Cancel" to return to the export list and click "Yes, process export' to continue.
20. The export will be confirmed in a banner and the transactions will be removed from the list.
When the transaction is viewed in Quickbooks it looks the same as a transaction that is manually generated.
TIP! If the export is unsuccessful then an error banner will appear instead. It will contain an error code explaining the issue.
If the error cannot be resolved, reach out to our support team for assistance.
