Quickbooks accounting

Splynx QuickBooks is the add-on of Splynx which is used to synchronize customers, invoices and payments with the Quickbooks accounting gateway.

Important:

It's recommended do not configure the add-on on your own. Please, contact our support team before starting the accounting integration.

The add-on can be installed in two ways:

  • via the command-line interface (CLI) and the following commands
    apt update
    apt install splynx-quickbooks
  • via the Web UI of your Splynx server in Config → Integrations → Add-ons Install add-on

After the installation process has completed, the QuickBooks addon will be available in Config → Integration (section):

Entry point 1

After that, it is necessary to obtain a Quickbooks Online account to start the integration (the screenshots related to Quickbooks were taken from its developer sandbox environment).

Entry point 1

And create your company

Entry point 1

The settings of Splynx QuickBooks Accounting add-on is located in Config → Integration → Modules list, click on the edit button in the Actions column:

Entry point 1

To open the configuration of add-on entry points click on Edit entry points icon:

Entry point 1

The general configuration of the QuickBooks integration module can be viewed and edited here:

Entry point 1

Entry point 1

Accounting API settings:

Splynx domain - the Splynx domain must be the same as the API domain URL but without last slash "/". HTTPS is required!;

Country code - Choose the required country code (US, FR or Other);

US tax code - (for US companies only) specify the tax code which will be applied to invoices. The id can be obtained from Config → Finance → Accounting tax rates;

Currency code - the currency that is used for customers, invoices and payments.

Synchronization settings:

Payment method ID - select the payment method for imported payments;

Bank statements group - group bank statements by "month" or "day";

Partners ignore list - select the partners of which will be ignored in sync process. Customers, invoices and payments of the partners selected here WILL NOT be synced with QuickBooks;

Payments synchronization direction - define the direction of syncing payments: QuickBooks → Splynx, Splynx → QuickBooks or Bidirectional;

Payments push to QuickBooks - select the payment methods to sync to QuickBooks, this selection only applies if the selected method to sync payments is set to Splynx → QuickBooks. Please note that you do not have to select QuickBooks in the list of payment methods to sync as this will grab payments from QuickBooks.;

Import payments from date - specify the date in 'Y-m-d'(2021-05-01) format, which will be used as the start date for importing all prepayments to Splynx;

Create payment without invoice - create payment in Splynx or add to bank statements only for payments without invoices (used on payments import).

Cron settings

Customers - enables/disables automatic syncing of customers;

Invoices - enables/disables automatic syncing of invoices;

Payments - enables/disables automatic syncing of payments.

It is recommended that all settings in the "Cron Settings" section should be disabled for the initial set up of the add-on to avoid syncing all these elements automatically via cron jobs, the first import and export should be done manually in Config → Integration → Splynx QuickBooks Accounting

Let's start with QuickBooks

Entry point 1

First of all, we need to connect the Add-on to our Quickbooks account:

Entry point 1

Click on the button Connect with QuickBooks, enter your account credentials and press Connect to allow Splynx to view and update the date on the QuickBooks side:

Entry point 1

When it's connected, the token will be created:

Entry point 1

We can add/edit Taxes, Products and Services in Quickbooks:

Entry point 1 Entry point 1 Entry point 1 Entry point 1

The taxes should be the same as the taxes in Splynx (Config → Finance → Taxes) to work properly.

Now, in Config → Integration → Splynx QuickBooks Accounting run Import mapping settings into Splynx

Entry point 1

After successful synchronization,

2021-05-13 09:04:28.413400 Start accounting categories synchronization
2021-05-13 09:04:31.119300 Accounting synchronization completed
2021-05-13 09:04:31.119500 Done!
2021-05-13 09:04:31.119900 Start tax rates synchronization
2021-05-13 09:04:32.157200 Tax rates synchronization completed
2021-05-13 09:04:32.157300 Done!
2021-05-13 09:04:32.157400 Start accounting bank accounts synchronization
2021-05-13 09:04:33.162500 Accounting bank accounts synchronization completed
2021-05-13 09:04:33.162600 Done!

make chnages to Accounting categories, Accounting bank accounts and Taxes settings in Config → Finance

Entry point 1

Let's look at this in more details. In Config → Finance → Accounting categories all accounting categories from QuickBooks (Sales → Products and Services) must be assigned to transactions categories (Config → Finance → Transaction categories) in Splynx

Entry point 1

As soon as the relevant categories are configured, we can proceed with bank accounts Config → Finance → Accounting bank accounts. We will follow the same steps, assign the QuickBooks bank accounts (Accounting → Chart of Accounts types) to payment methods (Config → Finance → Payment methods) in Splynx, also the default bank account should be selected.

Entry point 1.

And the last one - Config → Finance → Accounting tax rates: For US company select "NON" for zero values and "TAX" for other values

Entry point 1

And in Config → Integration → Modules list → Splynx QuickBooks Accounting set the tax rate accounting id and the currency:

Entry point 1

Entry point 1

For other countries - select the matching between taxes in Splynx and in Quickbooks:

Entry point 1

Pay attention that the invoices cannot be updated for France.

When the accounting settings are done, we can export our customers from Splynx to Quickbooks or match existing clients in the databases:

Entry point 1

We can check if all clients were pushed to QuickBooks:

Entry point 1

Once the customers export has completed, we can export the invoices:

Entry point 1

Entry point 1

And after that export the payments from Splynx to Quickbooks (depends on Payments synchronization direction setting in add-on configuration), you can check received payments via report.

Entry point 1

Entry point 1

Now we are ready to issue Invoices in Splynx and process Payments. This information will be sent to Quickbooks online immediately. All changes are also synced immediately between the two systems.

Let's issue 3 invoices in Splynx: Entry point 1

Done! they've been synced to Quickbooks as well!

Entry point 1

After processing payments in Splynx, the information is also synced to Quickbooks. Let's pay 2 invoices in Splynx:

Entry point 1

Payments are sent to QuickBooks in few seconds:

Entry point 1

Quickbooks logs

Sync logs are located in Administration → Logs → Accounting integrations

Entry point 1

If a customer/invoice/payment has an "Accounting ID", this indicates that it was synced, if not, it was not synced.

Entry point 1

The same logic is for invoices and payments, if accounting ID is present - it was synced.

Quickbooks tweaks

In Config → Integration → Modules list → Splynx QuickBooks Accounting when to click on the gear icon, we will see the drop down menu with additional settings related to QuickBooks add-on:

Entry point 1

Connect with QuickBook - if the QuickBooks Accounting addon was disconnected from the QuickBooks account, you can reconnect it here;

Refresh OAuth token - setting to refresh the OAuth token;

Manual Synchronization - used to go back to manual synchronization window;

Customers manual pairing - setting is used to open pairing window when there are existing customers in Splynx as well as in QuickBooks. Notice what the currency is set in QuickBooks add-on configuration, if Quickbooks customer currency is different, there will be synchronization errors for their related data.

In addition, there is a "Load QuickBooks customers for manual pairing" button. This feature pulls the customer list from QuickBooks into Splynx and allows the admin to manually pair the customers without having to create them in either platform again. Firstly, load customers and then, perform manual pairing.

Entry point 1

Entry point 1