xtraCHEF: Extract Monitor

In this Article:

• What Is the Extract Monitor?
• View Extract Details
• Re-Extract a Failed Extract
• Adjust Your Extract Date
• Initiate On-Demand Extract
• Extract Errors and Solutions

What Is the Extract Monitor?

The Extract monitor is where xtraCHEF prepares and records invoice extracts for your third-party accounting. Here, you can quickly view invoice extract statuses, re-extract failed invoices, and initiate on-demand extracts. The Extract monitor is also where you can download CSV file extracts for non-QuickBooks accounting systems.

Back to top
 

View Extract Details

1. To get started, select Extract monitor on the left side of your xtraCHEF account. Then choose your location, date range, and extract type (your extract type will be the software you want to sync your invoice data with). The From Date can only be set as far back as you have synced to.
   
   
   
   
2. Select Submit when you're ready and you'll see a record of when your invoice extracts and their batch status.
3. Any extract that occurred between your set date range will populate below. Those extract batches may include more than one invoice. The extract status will highlight any successful extracts and note failed ones.
   
   
   
   
4. Under the Invoice Extract Status column, successful extracts appear green, whereas failed extracts are color-coded orange. If there is an error with one of the invoices, it will appear as orange. Select View Details to learn more about the error with the specific invoice.
   
   
   
   
5. In most cases, you will be able to resolve the underlying issue. Invoices can then be re-extracted for your accounting to ensure there are no gaps in accounts payable.

Back to top
 

Re-Extract a Failed Extract

1. After discovering why an invoice extract failed and resolving the underlying reason, you can re-extract invoices by selecting the invoice batch and Re-Extract.
   
   
   
   
2. Then, select Yes on the confirmation message. Note: There is a limit on the amount of invoices that can re-extracted at once. The limit varies based on date range and/or invoice count.

Back to top

Adjust Your Extract Date

You may notice that some invoices are not extracting due to the invoice date being older than the xtraCHEF account's extract date. There is an easy way to correct this in xtraCHEF. Note: If QuickBooks is enabled at the location level, contact Customer Care if you need to change the start date.

1. Select the gear icon > Account Setup > Integration tab.
2. Under the Sync from QuickBooks area, you can adjust the date that you would like the syncing of invoices to begin.
3. Additionally, you can enable the on-demand option. This will only allow invoices to sync when you use the On Demand Extract Only button in the Extract monitor.

Back to top

 Initiate On-Demand Extract

You can initiate an on-demand extract via your Extract monitor. This will push any invoice in xtraCHEF that is currently processed into an extract. Running an on-demand extract will not disrupt your usual extract cadence. To do this, select On-Demand Extract. A list of qualifying invoices will be presented with the ability for users to manually exclude specific invoices (via invoice date and/or extract date) from the final extract request.
 

Back to top
 

Extract Errors and Solutions

If you get an error message while using the Extract Monitor or performing an extract, quickly jump to your error message and solution via the list below:

• "There is an invalid reference to QuickBooks Vendor "Vendor Name" in the Bill.  QuickBooks error message: Invalid argument. Or Vendor 'Vendor Name' does not exist in QuickBooks."
• "Account '1234' does not exist in QuickBooks OR There is an invalid reference to QuickBooks Account '1234' in the Bill. QuickBooks error message: Invalid argument. The specified record does not exist in the list."
• "Message=AuthenticationFailed; errorCode=003200; statusCode=401"
• "String length is either shorter or longer than supported by specification"
• "Feature Not Supported"
• "There is an invalid reference to QuickBooks Account "XCG-TAX" in the Bill. QuickBooks error message: Invalid argument."
• "Warning: Location Account number is not assigned in XtraCHEF. Bill has been pushed to QuickBooks Online without any class assignment."
• "Payment 'XXXXX' does not exist in QuickBooks."
• "Invalid account type: Check your account details before you continue. You may need to select a different type of account for your transaction."
• "QuickBooks connection not established."
• "QuickBooks Error Message: There is no row at position 0."
• "Account period closed, cannot update through services API."
• "There is an invalid reference to QuickBooks AP Account "XXXX" in the bill. QuickBooks error message: Invalid argument. The specified record does not exist in the list."
• "Invoice not in completed state"
• "Object reference not set to an instance of an object"
• "Duplicate invoice"

 "There is an invalid reference to QuickBooks Vendor "Vendor Name" in the Bill.  QuickBooks error message: Invalid argument. OR Vendor 'Vendor Name' does not exist in QuickBooks."

This type of error is due to the Tenant Vendor Code not matching what is listed as the Vendor Name or "Display Name As" for the vendor listed in QuickBooks. To resolve this, you must correct the Vendor Code in xtraCHEF's Vendors hub to match what is listed in QuickBooks.

Complete the following steps below:

1. Select Vendors from xtraCHEF's left-hand menu bar.
2. Search for the specific vendor in question.
3. Select the Vendor Code that you wish to update.
4. Ensure that the vendor code in xtraCHEF and QuickBooks are identical. To view this field, edit the vendor information in QuickBooks.
   1. QuickBooks Online: The vendor code should match the Display Name As field for the vendor.
   2. QuickBooks Desktop: The vendor code should match the Vendor Name within the desktop.
5. Once the Vendor Code is updated, you can then re-extract the failed file from the Extract monitor or Search invoices.

Back to top
 

"Warning: Location Account number is not assigned in XtraCHEF. Bill has been pushed to QuickBooks Online without any class assignment."

xtraCHEF only has location-based class assignments. Follow the steps below to extract invoices with class assignments.

1. First, import the class from QuickBooks Online or QuickBooks Desktop into xtraCHEF. If you have already imported it, you can disregard this step.
2. In xtraCHEF, navigate to the gear icon > Locations.
3. Select Edit Location Details.
4. In the account number field, enter a Class Name. Ensure that you enter the class name and not the reference number.
5. Once the class is assigned, your invoices will then reflect the associated class name. Note: If both location and class tracking are enabled, then the account number will be synced to the location in your accounting system.

Back to top
 

"Payment 'XXXXX' does not exist in QuickBooks."

This error message appears when the payment information entered in xtraCHEF does not match the information entered in QuickBooks. To resolve this, navigate to QuickBooks > Settings > All Lists > Payment Methods. Then, verify if the information entered in the Name column is an exact match of the information entered in xtraCHEF.

Back to top
 

"Invalid account type: Check your account details before you continue. You may need to select a different type of account for your transaction."

Log in to QuickBooks and verify if the GL account type and code match with the one specified in xtraCHEF. If it doesn't match, update accordingly. Once changes have been made, re-extract the invoices in xtraCHEF under Search invoices. 

Back to top

"QuickBooks connection not established."

You must first connect QuickBooks to xtraCHEF. Read xtraCHEF: Get Started With QuickBooks Online Integration or xtraCHEF: Get Started With QuickBooks Desktop Integration.

Back to top

"QuickBooks Error Message: There is no row at position 0."

This type of error indicates that no payment method has been assigned for receipts. Whenever invoices are processed under the RC (receipt) document type, it is required that you assign a payment method to extract the invoice to QuickBooks.
 

To assign a payment method:

1. Select Search invoices in xtraCHEF.
2. Enter the invoice number.
3. Then select Search > View detail > Edit invoice > Payment Details.
4. In the Payment Details tab, select the correct payment method from the drop-down menu.
5. Select Submit Invoice.

Once the payment method has been assigned, you can then re-extract all failed invoices for them to be reflected in QuickBooks.

Back to top

"Account period closed, cannot update through services API."

This invoice is not being extracted due to the accounting period being closed for the invoice date. If you need to extract the invoice from QuickBooks, you can update the invoice date to the current accounting period.
 

Back to top

"There is an invalid reference to QuickBooks AP Account "XXXX" in the bill. QuickBooks error message: Invalid argument. The specified record does not exist in the list."

This error message appears when there is a mismatch of GL code information. Please ensure that the GL code listed in both xtraCHEF and QuickBooks are identical.
 

Back to top

"Invoice not in completed state"

To resolve this, you must move the invoice status from "Pending" to "Processed".
 

Back to top
 

"Object reference not set to an instance of an object"

First, ensure that the GL code and category, vendor code, and invoice status have been assigned to the invoices.

• If there is no missing information, please re-extract the invoices. 
• If you still encounter the same error message after re-extracting, contact Customer Care.

Back to top
 

"Duplicate invoice"

This type of error indicates that the same invoice number has already been extracted into your QuickBooks. Check your accounting software if the same invoice number is already there.

Back to top