Squarespace QuickBooks Integration

QuickBooks, the leading choice of accounting software for many businesses, integrates with Squarespace, provides software as a service for website building and hosting. Integrate QuickBooks with Squarespace gives you more flexibility and automatic process for your complex tasks.

The powerful Squarespace QuickBooks Integration provides you with a robust understanding of your business; acts as an effective measure to find the components which need improvement. This guide will provide you an easy way to set up your complete integration between Squarespace and QuickBooks using a simple setup process with OneSaas.

What is Squarespace?

Squarespace is a website builder designed to help creative minds and website owner build unbelievably sites. You don’t need any coding knowledge for creating any website with Squarespace. The Squarespace company was established in 2003, in Maryland in the United States. This started as a blog hosting service. but it became really popular people love it so much that by 2006, they had already earned $1 million in revenue.

What is QuickBooks?

QuickBooks is the most popular software for accounting and managing expenses or keeping track of daily health. In this, you can prepare invoices for customers, and pay bills, reports, and taxes. Multiple solutions are available to support a variety of business requirements, including in QuickBooks Product List: QuickBooks Online, QuickBooks Desktop, QuickBooks Payroll, QuickBooks Time, or QuickBooks Checking.

How does it work with QuickBooks?

Connect Squarespace with QuickBooks to streamline your accounting. Never enter invoices, customers, or items by hand again. You can save up to 160 hours each month with this method!

Key Benefits of Squarespace Integration with QuickBooks Online and Desktop

• The Squarespace customer data can be synced by the users.
• An entire order processing might be automated.
• Creating invoices becomes easy.
• Users can process payments automatically
• other automated accounting tasks are possible
• Reduce the human error possibility.
• You can save time by avoiding manually entering data.
• The customer can take more interest in business expansion
• You may save time and money by automatically transferring data between Squarespace and QuickBooks Online.
• Connect numerous sales channels to QuickBooks Online to maintain accurate stock levels.
• Connect numerous sales channels to QuickBooks Online to maintain accurate stock levels.

When you use OneSaas to connect QuickBooks and Squarespace, you’ll never have to manually enter data again, saving you hours every day!

OneSaas by Squarespace will automatically:

• QuickBooks and Squarespace can both update stock levels.
• From Squarespace to QuickBooks, share any new or updated products.
• Create or edit a sales invoice or receipt in QuickBooks and share when an order is made in Squarespace.

Supported Triggers and Actions

Triggers

New Form Submission Triggers when form submission is submitted.
New Account Triggered when you add a new account.	New Bill Triggers when a new bill is added.
New Customer Triggered when you add a new customer.	New Estimate Triggered when you add a new estimate.
New Expense Triggers when a new expense is added.	New Invoice Triggered when you add a new invoice.
New Invoice Triggered when you add a new invoice (with line item support).	New Sales Receipt Triggered when a new sales receipt is added (with line item support).
New Payment Triggered when a payment is received (with line item support).	New Purchase Order Triggers when a new purchase order is added.
New Sales Receipt Triggered when a new sales receipt is added.	Updated Customer Triggered when an existing customer is updated.
New Vendor Triggered when a new vendor is added.

Actions

Create Bill (Item Based) Create a new bill, optionally tied to a customer.	Create Bill (Account Based) Create a new bill, optionally tied to a customer (with line item support).
Create Bill (Item Based) Create a new bill, optionally tied to a customer (with line item support).	Create Credit Memo Creates a new credit memo.
Create Customer Adds a new customer.	Create Estimate Create a new estimate (with line item support).
Create Expense Creates a new expense using check, cash, or credit card.	Create Product/Service Creates a new product or service.
Create Journal Entry Creates a new journal entry.	Create Invoice Adds a new invoice (with line item support).
Create Sales Receipt Adds a new sales receipt (with line item support).	Create Payment Creates a new payment, optionally linked to an invoice.
Create Purchase Order Creates a new purchase order.	Create Refund Receipt Creates a new refund receipt.
Send Invoice Send an existing invoice.	Send Sales Receipt Send an existing sales receipt.
Create Time Activity Creates a new single time activity.	Update Customer Updates an existing customer.
Update Invoice Updates an existing invoice (with line item support).	Create Vendor Adds a new vendor.
Find Account Find an account by name.	Find Customer Find a customer by name or email address.
Find Invoice Find an invoice by number.	Find Product(s) Find a product by name (with line item support)
Find Vendor Find a vendor by name.	Find or Create Customer Finds or creates a specific customer v2.
Find or Create Vendor Finds or creates a specific vendor.

With OneSaas: Squarespace QuickBooks Integration

Below is the step-by-step walkthrough, highlighting some useful key points throughout the process: 

Step 1: Connect 

Begin with connecting the systems that you’re looking to integrate. Below you’ll find guides on how to connect Squarespace and QuickBooks. Select “Manage” to proceed further.

Step 2: Configure 

The steps below will walk you through the configuration process, which will show you several options for how you want your Squarespace-QuickBooks integration to work. You are advised that in order to ensure that the integration settings are matched to your business and accounting procedures, you do require some basic accounting expertise.

• The first thing you’ll see is a list of major workflows. Because these are all optional, read each option carefully. In most cases, sync will allow you to do the following:
  • Squarespace sales will be automatically sent to QuickBooks
  • Squarespace products that will be imported into QuickBooks
  • OneSaas can read and update Squarespace if you have QuickBooks inventory switched on.
• Next, start the configuration process by choosing the first workflow in order to sync Squarespace orders into QuickBooks

This set of configuration settings helps you determine some basic integration actions:

• Select the “Squarespace order statuses” from which the application will retrieve sales to sync into QuickBooks 
• Now, select how Squarespace orders appear in your QuickBooks. In the case QB, you can choose if you want Squarespace orders to be sent to QuickBooks as Sales Receipts or Sale Invoice
• Choose an appropriate option for your business 
• In your next screen, there are advanced settings named “Default Product and Advanced Options”
  • Order Number Prefix: All orders retrieved from your Squarespace account will be prefixed with the prefix you choose here. Consider the following scenario: If you have order ‘1234’ in Squarespace and add the prefix ‘SQ-‘ to the setup, your order will be retrieved into OneSaas and transmitted to QuickBooks with the order number ‘SQ-1234’.
  • Use Shipping Item: It’s possible that you’re overcharging your customers for shipping. If this happens, the integration may allow you to attribute these shipping expenses to a certain “Item.” This will make it simple to trace any revenue made by shipping fees.
  • Discount Product: You can define a distinct discount ‘Item’ similar to the Shipping item option above to track your discounts on sales.
  • Gift Card Product: You can choose a specific gift card ‘Item’ to track your gift card on sales, similar to the Shipping and Discount item options above.
  • Original Customer/ Customer’s Organization/ Generic Online Sale Customer: When creating a sales invoice, most accounting systems demand that a client record be given. This option allows you to specify the type of customer record that will be produced. The default choice is Original Customer, but if your Squarespace customers provide a company name and you’d rather have that appear in your Accounting system, you can change it, The Customer’s Organization choice is then available.

If you don’t want any customer records in your Accounting system, you can choose the Generic Online Sale Customer option, which implies that all sales will be synchronized to your Accounting system against a generic “Squarespace” customer record.

• Assign Sales to class / Access Sales to Location: Within QuickBooks, you may set a default Class or Location using these two options. This is a QuickBooks-only feature that you can use if you’ve set up Classes or Locations in your QuickBooks Company file.
• Automatic Invoice Numbers: This option allows you to ignore the Squarespace order number entirely and instead use your accounting system’s sequential numbering method.
• Due Date Offset: If a transaction does not have a due date, a due date will be assigned to it. The transaction date and the Due Date Offset are used to determine this. If not set then the transaction date is used as the due date.
  • Now, you’ll be taken to the “Tax configuration page”, you must pick the relevant sales tax in your Accounting system for each tax created/defined in Squarespace.
  • Enable the “Create credit notes in QuickBooks” option, if you plan to sync refunded orders from Squarespace to QuickBooks
    • The account from which the payment money is refunded 
    • Refund the Number Prefix 
    • Partial Refund Product
  • After that, match Squarespace products with QuickBooks 
  • Enable the option, if you’d like OneSaas in order to create new items in QuickBooks
    • You must specify the Income and Expense Accounts to be utilized for Inventoried and Non-Inventoried items on the Items Settings setup page.
  • Payment configuration settings allow you to choose whether or not you want Squarespace payment data to be recorded against your sales in QuickBooks
    • You can use the “Map Individual Payment Methods” feature to map individual payment methods to different clearing accounts
    • Make sure that click on the “Save” button once you’re done with modifications 
  • Enable the option to send the “order payment fees” that were proceeded via Squarespace
  • The following workflow option allows OneSaas to read all of your Squarespace items and add them to QuickBooks. Some users would prefer that only things used in actual sales be created (which is covered above). Others, on the other hand, prefer to take all Squarespace stuff and send them through
  • Once you’re satisfied with your changes, click Save
  • Finally, you can pick this option and hit Save if you want stock-level updates from QuickBooks synchronizing back to Squarespace
  • Once you’ve made all of your changes, make sure to click Save.

Step 3: Sync

• After you’ve completed creating your integration workflow options, you can move on to customize your sync settings. This may be located under the Manage tab at the top of your workflow settings
• To ensure that your account is in sync with your store’s time zone, click the configure option to set your account’s time zone
• The Integration Starting Date option applies a filter to the date of your Squarespace order. Any orders placed prior to the stated date will not be synced
• You can turn on the automated hourly sync once you’ve agreed to the OneSaas user terms and conditions.

Squarespace Integration with QuickBooks Online

• First, you need to open the “Squarespace” website and Log into your account.
• After login, you need to explore QuickBooks extensions on the Squarespace extensions page, So that you can seamlessly integrate QuickBooks into the Squarespace website.
• You have to choose the “Connect” button after selecting “QuickBooks” from the list of alternatives. This will connect you to the QuickBooks website.
• After that, You can carry on with the login process.
• Next, choose your website.
• Make sure to provide “QuickBooks” permission to access your website.

Squarespace integration with QuickBooks Commerce

Follow the basic steps to integrate Squarespace with QuickBooks Commerce:

• First of all, you need to open the “QuickBooks Commerce” platform.
• After that, go to the navigation bar on the left and click on the “Browse Apps” button.
• Here, you can search the “Squarespace” app.
• After that, click on the “Get App” option. This will redirect you to the authorization page.
• To proceed, click the “Authorise” button
• After that, you will see a “Squarespace” account listed on your site.
• After that, you can link your website to QuickBooks Commerce by clicking the “Allow” option.

Winding-Up!

Hopefully, the above information will be helpful for you in setting up this integration process. Squarespace QuickBooks Integration is a key factor for better marketing automation and managing all your tasks more effectively.