Skip to main content
S
sshetty
March 23, 2025
Question

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?

  • March 23, 2025
  • 2 replies
  • 0 views

I am not concerned with expense header level dates such as report create date, report submit date or report approval date. I need the expense level transaction dates in QBO Bills. This will allow me to create expense invoices with actual line level transaction dates.

2 replies

L
LollyNino_C
March 23, 2025

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.

S
sshettyAuthor
March 24, 2025

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.

C
Chrea
March 23, 2025

@sshetty 

You can use an importer tool as a workaround.

S
sshettyAuthor
March 24, 2025

Hi @Chrea Can you share few options. Thanks.

C
Chrea
March 24, 2025

You can prepare your Bills data with the following template.

RefNumberAPAccountVendorPrintOnCheckNameTxnDateDueDateSalesTermLocationAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryPrivateNoteCurrencyExchangeRateExpenseAccountExpenseDescExpenseAmountExpenseBillableStatusExpenseBillableEntityExpenseClassLineItemLineDescLineQtyLineUnitPriceLineAmountLineBillableStatusLineBillableEntityLineClass
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  Office SuppliesFor Anne25,1           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use  TelephonePhone Cards50,25           
101 Staples #########15/11/2020  100 Houston StreetSuite 2000  San DiegoCA12345 Internal Use        MP3 PlayerBlue MP3 Player255    
185 Green's Taxi Service ######### Net 30 1 Main Street   San DiegoCA12345    Transportation 125,13           

 

then use an importer tool to proceed.

https://get.transactionpro.com/qbo

 

Terms & ConditionsAccessibility statement