By connecting QuickBooks Online to Rentman, you can enable Rentman to seamlessly export your invoices, either on a chosen day of the week or by manual selection.

You can only connect Rentman to Quickbooks Online, not to Quickbooks Desktop.

Contacts are always imported as new contacts in Quickbooks. Contacts with the same name are added with the Rentman contact number between brackets after the name to Quickbooks.

What data is exported?

• Ledgers
  Read our article about managing ledgers in Rentman.

Note: Only ledgers are exported to Quickbooks. So in the invoices exported to Quickbooks you will not find every piece of equipment or function you planned. All lines of equipment will show up as ledger in Quickbooks. 

• Invoice information
  Invoices contain all financial information that you add in Rentman, and which is necessary for a complete overview and correct functioning in your accounting software. This includes VAT-rates, payment terms, invoice moments and invoice numbers.
  
• Contacts are always imported as new contacts in Quickbooks. Contacts with the same name are added with the Rentman contact number between brackets after the name to Quickbooks.
• Information of relevant contacts
  The information of relevant contacts for your invoice is also exported. This includes, for example, the company name, contact persons and contact number.
  Contacts in Rentman cannot be matched with contacts already entered into Quickbooks. Contacts with the same name are added with the Rentman contact number between brackets after the name to Quickbooks. 
  

Setting Up 

Connect Quickbooks

Connecting your Rentman account to Quickbooks is the first step in this integration process.

1. Go to the settings Configuration module > Account > Extensions.
2. Under External extensions, go to Quickbooks and click on the connect button.
   Make sure your browser allows pop-ups.
3. Log in with your account details in the pop-up.
4. After logging in, you can proceed with setting up automatic exporting.

Set up automatic or manual export

Choose to export your invoices on a specific day of the week or manually. 

1. Go to the settings Configuration module > Account > Extensions.
2. For the option Export automatically, choose one of the following
   1. Start manually
   2. On the following day(s)
      
      
      
3. Next, you must match your ledgers, VAT rates and Accounting software journal in Rentman to those in Quickbooks. Click on one of the buttons to do so. This is necessary, because their names may be slightly different.
   
4. Save your changes when you've matched all fields.
   If you can't click  Save , the fields were probably not correctly matched. Try this step again.

You can view the status of your invoices in the subfolder Invoices from the monetization_on Financial module (see the section below).

If you choose Start manually, you must click on the  Start export   button to send your new invoices to Quickbooks. Note: when there aren't any new invoices, this button is not available.

If you choose On the following day(s), Rentman can automatically send new invoices to Quickbooks. You select all days that this should happen on. New invoices are always exported at 02:00 AM, on the days you choose here.

View the status of your invoices

When your invoices have been exported to Quickbooks, you can check in Rentman whether this was done correctly. You do this as follows:

1. Go to the subfolder Invoices from the monetization_on Financial module.
2. Add the column "Export status" to the overview.
   Read how to add a column here.
3. In this newly added column, you can see the status of your invoices.

Update the payment status of your invoices

Invoices that are marked as paid in Quickbooks Online will automatically have their payment updated in Rentman. How it works:

1. Receive your payment in Quickbooks Online. The payment status of your invoice in QuickBooks Online should be marked as paid.
2. Your invoice will now automatically be marked as paid in Rentman. 

Please note that this information will be updated in Rentman the next time invoices are exported from your Rentman account to Quickbooks Online.

This feature is only available with Rentman’s Quoting and Invoicing add-on. You will need to have an active connection between Rentman and Quickbooks Online.

How can I resolve my export issues?

It can occur that an invoice could not be exported to your accounting software. In some cases, we can determine why this happens by included certain columns. 

1. Go to the subfolder Invoices from the monetization_on Financial module.
2. Add the column "Export remark" and "Export Status" to the overview.
   Read how to add a column here.
3. In this newly added column, you can see the status of your invoices and the reasons why it has failed .

Take a look at this article on the most export common errors and their solutions. 

FAQ