Revision as of 13:16, 13 October 2023 by Admin (talk | contribs)

QuickBooks integration

From SimplyBook.me


Icon quickbooks.png

This easy-to-set SBPay.me integration with Quickbooks allows you to automatically create invoices or sales receipts in QuickBooks for each paid order and send them to customers.



Please note!

  • The invoices which get generated on the QuickBooks side as the result of the integration won't include information about taxes and discounts, they will contain only the total amount. While the SimplyBook invoices contain information about the item price taxes/discounts (if any), and the total amount.
  • Multi-currency must be enabled in QuickBooks for transactional documents involving different currencies.



How to set and use

1. Navigate to Custom Features page within your SBPay.me interface and click on the Enable button next to QuickBooks.

Quickbooks enable path.png

2. Once enabled, click on the Connect button to proceed with setup.

Quickbooks connect path.png

3. You will be prompted to log in to your Quickbooks account to get connected. Or, if you are already logged in there in your browser, the connection will be set automatically after confirmation. You will also see SBPay.me in the Apps -> My Apps section of QuickBooks.

Confirm quickbooks connection.png

4. After the systems are connected you will get access to the integration settings in the SBPay.me interface.

5. Choose the transactional document type: There are two options: Invoice and Sales Receipt. Invoice triggers the creation of both an invoice and its corresponding payment within QuickBooks for each fulfilled order on the SimplyBook side. Thus, you will see two records (Payment and Invoice) on the QuickBooks account associated with the same transaction. Sales Receipt results in the generation of a sales receipt (Payment) solely upon successful payment for the order.

Quickbooks select document type.png

6. You can add a Deposit Account Name and select the deposit Account Type. It should be either Other Current Assets or Bank (Cash on Hand) type. If deposit account is not specified QuickBooks will use a default account called Undeposited Funds.

Quickbooks deposit account.png

7. Skipping zero amount transactions is enabled by default to exclude zero amount orders from being transferred to QuickBooks. For example, the transactions where the discount was applied and the resulting total is 0. You can keep it as it is if you do not need to see such records in Quickbooks or disable if it is important to have them for your bookkeeping.

Quickbooks skip zero transactions.png

8. You can activate the automatic creation of a Refund Receipt entry in QuickBooks when a refund is made on the SBPay.me side. Please ensure to include the Deposit Account Name if you decide to enable this option as it is mandatory for refunds synchronisation.

Quickbooks rrefund receipts.png

9. There is also an option to send a transactional document. If enabled, the client will also receive an invoice from QuickBooks in addition to other active notifications.
You can also add a note to be reflected in the Quickbooks invoices.

Quickbooks send transactional email.png