You can decide at the Integration setup stage which documents to send to QuickBooks: Purchase Orders or Invoices.
To integrate QuickBooks with Precoro, you should have a Plus, Advanced QuickBooks, or Essential subscription. A Simple Start plan does not offer such an option.
The Essential plan allows the integration of Invoices only.
TABLE OF CONTENTS
- How to Send Invoices to QuickBooks
- Revising and Editing an Invoice
- Canceling an Invoice
- How to Import Payments to Precoro
How to Send Approved Invoices to QuickBooks
On the Integrations page, choose the Approved Invoice type of document in Step 5. Save the settings, and invoices will be sent automatically after the approval.
You can also send an Invoice manually by using the Send to QuickBooks button on the right action panel:
Please note that you cannot add zip format attachments for companies integrated with QuickBooks.
If you attach a zip format file to a document in Precoro and send it to QuickBooks, it will be transferred without this attachment.
Send Pending Invoices to QuickBooks
You can send the documents with Pending Status to QuickBooks.
To activate this feature, please contact our Support Team, who will happily assist you on the matter.
This feature will work for the chosen Invoice integration document type. It will be available for users with the Create and Approve Roles for Invoices.
If you have activated the option to send documents to QuickBooks automatically, then Invoices in Pending Status will be sent automatically to QuickBooks.
Regardless, if you send the Approved or Pending Invoice from Precoro in QuickBooks, the Bill will be created, and you will be able to perform the same actions with it in QuickBooks.
What data will be sent to QuickBooks
| Precoro Field Name | QuickBooks Field Name |
| Issue Date | Bill date |
| Due Date | Due date |
| Supplier | Supplier |
| QuickBooks Locations (Documents Custom Fields) | Location |
Item and Category details:
| Precoro Field Name | QuickBooks Field Name |
| Name | Description |
| Price / Currency | Amount (Currency) |
| Tax,% | Tax |
| QuickBooks Chart of Accounts (Items Custom Fields) | Category |
| QuickBooks Customers (Items Custom Fields) | Customer / Project |
| QuickBooks Classes (Documents Custom Fields) | Class |
Notes, Attachments, and Total
| Precoro Field Name | QuickBooks Field Name |
| Note | Memo (includes a link to the Invoice document in Precoro) |
| Attachments | Attachments |
| Gross / Net Total | Total (if Taxes are enabled then includes Tax amount) |
- The discounts applied to the documents or item lines in Precoro will be synchronized with QuickBooks. Therefore, there is no need to modify the Total per line or document in QuickBooks after sending it from Precoro.
- The Invoice # (or Invoice custom number) is not displayed in QuickBooks. Instead, the Supplier Unique Code is displayed.
Revising and Editing an Invoice
If you wish to make any alterations to the Invoice document or items fields, you need to do the following:
1. Take the document in revision by pressing the Revise button on the right action panel.
2. Make the necessary changes to the document or item fields.
3. Confirm the altered document.
You will see a system message that the changes were successfully sent to QuickBooks, and the information about the update will also be available in the Integration Logs.
Please note that if you edit an Invoice in QuickBooks, the changes will not be sent to Precoro.
Canceling an Invoice
You can cancel an Invoice in Precoro, and it will be automatically removed from QuickBooks.
Please note that if you edit or cancel an Invoice in QuickBooks, the changes will not appear in Precoro.
How to Import Payments to Precoro
Consider the type of payment methods that can be imported from QuickBooks:
- Bill Payments
- Cheque
- Credit/Debit Card Payment
- Supplier Credit.
To be able to import payments, make sure that on the Integrations page in Step 5 the Import payments from QuickBooks checkbox is active.
You can import payments to Precoro in the following ways:
1. Automatically (main option)
After payment is recorded in QuickBooks, it will be imported to the Precoro account. As a result, the status of the Invoice will change to Paid.
Payments recorded in Precoro are not imported into QuickBooks.
2. Manually (in case QuickBooks did not import some payments)
If some payment has not been automatically imported to Precoro or canceled, you can use the Import from QuickBooks feature to import payments based on the selected date range:
1. On the Payments page, select a date range in the Invoice Issue Date field to get the previous payments that were not automatically imported from QuickBooks.
2. Click on the Import from QuickBooks button. All payments within the selected date range will be updated/added to Precoro.
Please note that no matter which user created a Payment in QuickBooks in Precoro, that payment will be recorded as created by the document initiator.
That is, the payment is always imported from the Invoice Initiator — even if it was created in QuickBooks by another user.
Canceling Payments in QuickBooks
If you cancel a Payment in QuickBooks, then in Precoro this document will be canceled automatically.
However, please note that if you cancel the payment in Precoro, the changes will not be sent to QuickBooks.
Integrate Credit Notes with QuickBooks
You can integrate Credit Note documents with QuickBooks. To do that, follow the steps below:
1. On the Integration page in Step 6 for Integration Options, select the Approved Invoices one.
2. You will see the Send Credit Notes checkmark. If activated, the Credit Note documents will be automatically sent to QuickBooks when Approved.
3. When the Credit Note is created in QuickBooks, you will see the corresponding message in the Integration Logs in Precoro.
In QuickBooks, you will be able to find the integrated Credit Notes in Bill Payment transactions of the Credit Card type in Expenses:
How to Use the “Close the Books” Function
Using the “Close the books” function in the financial reporting period in QuickBooks will close a certain accounting period during which users will not be able to send the documents.
For example, your closing date is 31.12.2020 in QuickBooks, but in Precoro you have an invoice on 30.12.2020. You can not send this invoice to QuickBooks after 31.12.2020 because the accounting period has already been closed.