QuickBooks Desktop✨

1. Overview of Integration

Audit Sight simplifies verifying your client's QuickBooks Desktop data with two connection methods:

1. QBB File Upload (Strongly Recommended):
   Clients provide a QuickBooks Backup File (QBB) along with the Primary Admin username and password. This method is faster, easier for clients, and minimizes disruptions to their business operations.

   👉 For instructions on how to create a QBB backup file, refer to Backing Up QuickBooks Desktop.

2. Desktop Connector:
   Clients download a program to transmit their data. However, this method may significantly slow down company performance during the sync process and takes longer to complete. It must also be repeated for each data refresh. 

2. Data Availability 📊

• Data Pulled:
  • Transaction details
  • Financial statements
  • Customer and Vendor Activities including AR and AP Aging data
• Default Data Range: Last 36 months of data.

3. Connection Requirements 🛠️

• QBB File Method:

  • A backup file from QuickBooks Desktop 2020 or newer.
  • Primary Admin username and password (default username is often "Admin").

• Desktop Connector Method:

  • QuickBooks Desktop installed on the client’s computer.
  • Internet access during the entire sync process.
  • Single-user environment (not supported for hosted or multi-user setups).

4. How to Guide Your Client Through the Process 🚀

Option 1: Using a QBB File (Strongly Recommended)

1. Request a QuickBooks Backup File (QBB) from your client.
   👉 For detailed instructions, direct them to Backing Up QuickBooks Desktop.
2. Verify the client has included their Admin username and password (99% of the time, the username is "Admin").
3. Upload the QBB file to Audit Sight for processing:
   • Navigate to Select your client -> Uploads -> Accounting System -> QuickBooks Desktop QBB Upload.
   • Here you will attach the file and enter in the credentials provided by the client.

Option 2: Using the Desktop Connector

1. Look for Our Email 📧

   • Check the client’s inbox for an email from support@auditsight.com with the subject line: Data Request and the name of the firm inviting them.
   • The email will include the Company Name and Entity Name. If the client has multiple QuickBooks accounts, they will receive a separate email for each account.

2. Click the Link 🔗

   • Open the email and click on the provided link to begin the connection process.
   • Once the link is accessed, select QuickBooks Online.

3. Log In to QuickBooks Online 🛠️

   • Use Admin or Company Admin credentials to log in.
   • If the client is not an Admin, they will need to ask their company Admin to assist.

4. Select the Company (If Applicable) 🏢

   • If the client’s account manages multiple companies, they will be prompted to select the correct company to connect.

5. Complete the Connection 🎉

   • Follow the on-screen prompts to finish. The entire process takes can take minutes or hours depending upon the size of the file proviided.

5. Template Emails to Send to Your Client 📧

Email 1: Providing the QBB File

Subject: Action Required: QuickBooks Desktop Backup File for Your Audit

Hi [Client Name],

To streamline the audit process, we need your help providing a QuickBooks Backup File (QBB). This is the easiest and most efficient way to share your data with us.

Steps to Provide Your Backup File:

1. Create a QuickBooks Backup File (QBB). For detailed instructions, see Intuit’s guide: Backing Up QuickBooks Desktop.
2. Send the file to us along with your Admin username and password (usually "Admin").

If you have any questions or encounter issues, don’t hesitate to reach out.

Best regards,
[Your Name]
[Your Position]
[Your Contact Information]

Email 2: Connecting with the Desktop Connector

Subject: Action Required: QuickBooks Desktop Connection for Your Audit

Hi [Client Name],

To streamline the audit process, we need your help connecting your QuickBooks Desktop account with Audit Sight.

Next Steps:

1. Check your inbox for an email from support@auditsight.com with the subject line: Data Request.
2. Open the email, verify the Company Name and Entity Name, and click the link to begin the connection.
3. Log in to QuickBooks Desktop using your Admin or Company Admin credentials.
4. Follow the prompts to grant Audit Sight access.

Your data’s security is our top priority 🔒. Audit Sight is SOC 2 Type 2 certified, ensuring that all information is handled with the highest standards of security and privacy.

If you have any questions or encounter issues, don’t hesitate to reach out.

Best regards,
[Your Name]
[Your Position]
[Your Contact Information]

6. Common Issues and Troubleshooting Tips 🛠️

• Why can’t my client connect?

  • 🚫 Ensure the client has QuickBooks Desktop open and is connected to the internet during the sync process.
  • 💻 If using a hosted environment (e.g., Right Networks), have the client use the QBB method, as third-party hosting may block connections.

• What is the preferred connection method?

  • 🏢 The QBB File Method is strongly recommended to avoid disruptions and maximize data retrieval.

• What if the connector fails to link?

  • 🌐 Confirm only one QuickBooks file is open.
  • 🔄 Ensure the client grants full access to the Audit Sight connector.

7. FAQs ❓

Will this cost my client money? 💰
No, the integration is completely free for your client.

Why do I need the Admin username and password? 🛠️
Admin access is required to restore the QBB file or sync data via the connector.

How secure is the integration? 🔒
Audit Sight is SOC 2 Type 2 certified, ensuring secure data handling.

8. Resources 📚

• Backing Up QuickBooks Desktop