We are importing expense from Concur as Bills in QBO. The expense detail transaction dates are not appearing on the QBO Bill. How do we get the dates?

We appreciate you dropping by the Community forum, @sshetty. I’ll share some information regarding the integration of Concur and QuickBooks Online (QBO) when importing bills.

Please review your settings for syncing bills from Concur to QBO. When checking the configuration, make sure that the bill date is included in the data being sent to QBO. This is crucial for maintaining accurate financial records and ensuring the integrity of your accounting information.

QuickBooks depends on data imported from the third-party app. I recommend contacting the Concur support team for assistance with the integration process. This will help you easily track and manage expenses and other transaction data and guide you through the necessary steps.

Additionally, we can categorize transactions from the app and do the same for the credit card account. This will prevent double counting since the entries have already been categorized. While you determine which system works best for you, the instructions in this article can help you: Categorize online bank transactions in QuickBooks Online.

Refer to this guide for future account assessments: Reconcile an account in QuickBooks Online.

We are committed to promptly addressing your needs as you manage your Concur account in QuickBooks Online. Please return to this thread and leave a reply below so we can respond as soon as possible.

@sshetty 

You can use an importer tool as a workaround.

As per Concur Support "QB connector is pre-built and designed to offer an out-of-the-box solution." They pointed me to QBO Support for resolution.

In Concur,  the Concur Report Create Date is mapped to Bill Date. Other options are Report Submit Date and Report Approval Date.

I am wanting the QBO Bill Item Level Dates to get values from Concur Expense Detail Transaction Date. The Bill header date is fine.

Thank you again for the prompt response. Looking forward for your suggestions.

Hi @Chrea Can you share few options. Thanks.

You can prepare your Bills data with the following template.

then use an importer tool to proceed.

https://get.transactionpro.com/qbo