QuickBooks Integration

The accounting module is integrated with QuickBooks through a real time connection.

This is designed to eliminate double entry, as double entry increases the chances of human error. Ultimately saving time and becoming more efficient with reconciling your finances.

This integration will sync selected transactions that have been processed in our CiiRUS account, including accounts payables and accounts receivables.

Just like processing owner statements and tax reports, it is very easy to connect your CiiRUS account to your QuickBooks accounts.

Currently, CiiRUS is compatible with any Desktop Version of QuickBooks.

There are three steps you will need to complete in order to successfully connect your CiiRUS system to your QuickBooks Software.

They are the Chart of Accounts, Owners, and Vendors. These items must be configured to their full entirety in order to correctly export all bill payments, owner payments, and rental payments to the QuickBooks bank account of your choosing.

Lets get started with the connection.

 

Connecting CiiRUS to QuickBooks

In order to establish the connection, run QuickBooks and open your company file.

Always make sure QuickBooks is running on your PC and the company account file is open.

In QuickBooks, create a Vendor Type called ‘Owner

(Lists > Customer & Vendor Profile Lists > Vendor Type List > Vendor Type > New Vendor Type > Owner > OK to Save)

Connecting CiiRUS to QuickBooks

In Ciirus, go to:

  1. Accounting Functions
  2. QuickBooks
  3. Settings’ tab.
  4. Enter the Start Date that you started using the QuickBooks Module. This prevents deposits before that date, from showing up for exporting to QuickBooks.
  5. Remote Connector: The remote connector allows you or others to connect to a QuickBooks company file on a remote computer. To connect to a remote PC, select ‘Use Remote Connector’.
  6. If you are using the remote connector, enter the username, password, URL and Port. These settings are configured on the remote PC using the remote connector configuration. Make sure the port number specified is allowed through the firewall on the remote PC.
  7. If you have Quickbooks up and running, then click the ‘Connect to QB’ button, and you will see a security prompt from QB, to allow CiiRUS to access the data file. Select the option to ‘Always allow even when QuickBooks is not running’. If you are using the Remote Connector then this prompt will appear on the remote PC running QuickBooks.
  8. You will see a security prompt window from Quickbooks, to allow Ciirus to access the data file.
  9. When this window appears, select the option to Yes, always; allow access even if QuickBooks is not running. If you are using the Remote Connector, then this security prompt will appear on the remote pc running QuickBooks.

Testing the Connection

If Ciirus and QuickBooks are up and running at the same time then the connection is successful.

QuickBooks Bank Account

  1. Once the connection is established, CiiRUS will load all of your QuickBooks bank accounts select the bank account in QuickBooks that you would like to export transactions.
QuickBooks Bank Account

Create standard QuickBooks Items

You must create certain standard items in QuickBooks, which call be done automatically using the ‘Create QuickBooks Items’ option. You only need to do this once before you start to use the QuickBooks Module.

Make sure QuickBooks is running with the correct company file open (and if applicable, the Remote Connector is configured and operational).

Check each applicable box and then click Create.

  1. Customer called ‘Customer'All deposits from guests will be assigned to this customer in QuickBooks
  2. Vendor called ‘Owner’This is used if you select to export owner payments to a single QuickBooks vendor
  3. QuickBooks Accounts:    Advance Deposit, Security Deposit and Payments from Owner Accounts.These are used when exporting guest and owner payments to QuickBooks. The advance deposit and security deposit accounts will automatically be configured in QB as ‘Long Term Liability’ accounts and the Payment from Owner account will be seen in QuickBooks, as  ‘Income’ account.
  4. Payment Types:     Card, Wire and Other. These are used when exporting guest payments to QuickBooks.
  5. After checking each box, click on Create

 

Create standard QuickBooks Items

Mapping Owner Account Categories to QuickBooks Chart of Accounts

For each owner account category in Ciirus, you must map to the corresponding QuickBooks Chart of Accounts.

To do so,

  1. Click the Configure button.
  2. You will see a new window listing all the CiiRUS owner account categories.
  3. For each owner account category, choose the corresponding QuickBooks chart of account in the column to the right, assuming you have already set up the chart of accounts in QuickBooks.

Create QuickBooks accounts for Individual categories

If you want to create QuickBooks accounts for individual categories,

  1. Select each Owner Account category by checking the box,
  2. Click ‘Export to QB’. This will create a matching QuickBooks account and associate it with the appropriate Owner Account Category.
  3. Click OK to save.
Create QuickBooks accounts for Individual categories

Configuring Contacts as Vendors: Export owner payments (To a Single QuickBooks Vendor)

When exporting owner payments from CiiRUS to QuickBooks, you can either export all payments to a single QuickBooks vendor regardless of who the owner is, or you can create a matching vendor in QuickBooks for each owner in CiiRUS.

  1. Click on this button to select the "To a Single QuickBooks Vendor" option.
  2. In CiiRUS, use this drop-down menu to choose the owner created in QuickBooks. If you've recently added the owner in QuickBooks,
  3. To refresh this list, click on "Connect to QB"

 

Configuring Contacts as Vendors: Export owner payments (To a Single QuickBooks Vendor)

Configuring Contacts as Vendors: Export owner payments (To matching QuickBooks vendor)

In this mode, you must have vendors set up for each owner in CiiRUS.

CiiRUS can create owners as vendors to your QuickBooks software. In CiiRUS you can create owners as vendors to export to QuickBooks by going to:

  1. Owners and Homes
  2. Manage Owners
  3. Select or highlight the owner
  4. Click on Export to QuickBooks. This way you do not have to enter the owner twice.

Once the owner is entered into CiiRUS, it can be exported to QuickBooks to eliminate double entry. At any time in the future when you add a new owner, make sure you use the Export to QuickBooks option for that new owner.

 

 

Configuring Contacts as Vendors

For each vendor in your CiiRUS account, you must create and link to a matching vendor in QuickBooks.

To do so, go to:

  1. Management Company
  2. Contacts
  3. For each contact that is a vendor, click the ‘Show as Vendor’ check box,
  4. Enter who the ‘Check is payable to’,
  5. Specify the Category,
  6. Specify the Sub Category  
  7. Specify the Owner Account Category.
  8. Click Save.

QuickBooks Link Tab

Once the above has been completed,

  1. Click the ‘QuickBooks Link’ tab. This will show you a list of all your contacts that are configured as vendors.
  2. IN the ‘QB Vendor’ column, select the matching QuickBooks vendor for each contact.

 

 

If you do not have a vendor created in QuickBooks

If you do not have a vendor created in QuickBooks and the vendor is created in CiiRUS, you can select the vendor to export to QuickBooks to eliminate double entry.

To do so:

  1. Check on each box
  2. Click on Export to QB
If you do not have a vendor created in QuickBooks

If you already have all of your vendors created in QuickBooks

If you already have all your vendors in QuickBooks you can also import them in to CiiRUS by Clicking on:

  1. Import from QB buton
  2. Select each vendor you wish to import
  3. Click the Import button.

 

If you already have all of your vendors created in QuickBooks

Exporting Transactions

Once you have mapped the Chart of Accounts, Owners, and Contacts as vendors. You have successfully completed the configuration process.

Now you can begin to Export Checks, Bill payments, and Deposits.

To do so, go to:

  1. Accounting Functions
  2. Quickbooks
  3. Select the Exports tab.

Checks / Bill Payments

To export any type of bill or utility payment processed in CiiRUS, click on:

  1. Checks / Bill Payments tab. This table will display the date the check was paid, vendor, check or reference number, method of payment, and the amount.
  2. Select which checks you would like to export to Quickbooks.
  3. Click Export

Once the export has completed, the payments will appear on the Check Register of the QuickBooks Bank Account of your choosing. Once you double click on the transaction, all entered details will appear.

 

QuickBooks Check Register

Once the export has completed, the payments will appear on the Check Register of the QuickBooks Bank Account of your choosing.

QuickBooks Check Register

QuickBooks Operations Account

  1. Once you double click on the transaction,
  2. All entered details will appear.

Deposits

To export owner payments or rental payments, click on:

  1. Deposits tab.
  2. This table will display All receivables, Date Payment was Processed, Name of Guest or Owner, Type of Account, Amount, Payment Type, and Method of Payment.
  3. Select which items you would like to export to the QB bank account of your choosing,
  4. Then click Export. Once complete.
  1. Just like Bill Payments, the transactions will appear on the Check Register, double click to view more details.