This document is a step-by-step guide to integrating your Quickbooks Desktop account with ResaleAI using our Bookkeeping Assist feature. If you haven't read the overview of Bookkeeping Assist, it is a good idea to do so before you start this integration process. You will find it here: Integrate Quickbooks with ResaleAI using RAI's Bookkeeping Assist.
- On the computer that you use for Quickbooks Desktop, log into ResaleAI with an Owner or Manager account.
- Go to the Settings screen and click the Quickbooks button under Integrations. Then click the button to get started.
- Click the ‘Add new connection’, choose QB Desktop, and click next.
- Enter the full path of the Quickbooks filename and the QB company name. You can copy the full path from QB by opening QB and clicking F2. NOTE: If your filename has special characters in it (like commas) QB Webconnect will not work, even though QB does work with those characters. Intuit Support has information on how to change your QB desktop filename.
- Click ‘Connect’.
- Click the WebConnect link next to your new connection name to download a QWC file.
- Find the QWC file in your computer's Download folder and open it. The file name will begin with ResaleAI-
- QB Webconnect should open automatically when opening the QWC file. If it doesn’t open, go to Intuit Support to check Webconnect compatibility with your version of Quickbooks Desktop.
- Follow the QB Webconnect instructions and enter your ResaleAI password when prompted.
- Go back to the ResaleAI window. NOTE: Once you have connected QB and RAI, a G/L icon will appear at the bottom of the menu on the left of the Settings screen. That icon is how you can come back and make adjustments to your QB integration.
- Multi-store owners only: If you use different QB classes for each of your stores, click ‘Yes I use classes’. Then choose the appropriate class for your store from the dropdown. Keep in mind, you must have the correct store name in the upper right of the screen when configuring QB integration.
- Click ‘Next’ to map the BUYS Journal Entry to accounts from your Chart of Accounts. NOTE: If you find that you need to add an account(s) to QB to complete your mapping, use the Request Update link under the QB button on the Settings screen to pull the new accounts into RAI. RAI can only receive the new accounts when QB Desktop is running on a computer connected to the internet.
- Click ‘Next to map the COGS Journal Entry
- Click ‘Next’ to map the Sales Journal Entry
- After you have completed mapping all 3 journal entries, use the Review screen to review that your mapping is correct. Click any date on the calendar to review the journal entries for that day. If the entries for that day have not been sent to QB, you can click the 'Send to Quickbooks' button to send that day’s journal entries. This is a great way to be sure the Journal Entries are working as you want before you automate them. Note: After the ‘Send to Quickbooks’ button has been clicked, your Quickbooks Desktop account will receive the journal entries the next time QB is open and online.
- When you are comfortable that the journal entries are working as you want, choose the date that you want to start automatic updates and click Automate.
- You’re done! If you need help, just click the Support Chat bubble at the bottom left of the page, and we will help you.
Comments
0 comments
Please sign in to leave a comment.