how to Reconcile Concur transaction with Credit card statement

[Sashanka-guna12]

I want to reconcile our GL with credit card Statements. 

I understand that GL will not include all concur transactions as some of it will still be in concur as unapproved/ not submitted/ etc.

Is there a report in concur i could run to get a full picture of all credit card transactions? 

I checked concur accrued expense report. But transactions are missing in it. example; credit card statements has for example AUD 100,000 transactions as at 28th March but concur accrued report only shows AUD 50,000 transactions. Where has the rest of 50,000 gone? Concur accrued expense report i downloaded also includes approved, not submitted, unapproved, etc transactions.  

[KevinD]

@Sashanka-guna12 which report in Cognos did you run, exactly. The accrual by Date Range or the Expense Accrual Report? Also, what options did you select in the prompts? 

[Sashanka-guna12]

Hi Kevin, 

Thank you for your response. I ran Accrual by Date Range.  Is this the right report to use to reconcile credit card transactions to match with the credit card statement? Will it give me all transactions? 

[KevinD]

@Sashanka-guna12 I believe that report gives all outstanding expenses including entries that are not on a report, on a report but not submitted, on a report that is submitted but not fully approved. You likely would want to filter out any non-company card payment types. Likely that will be named either Out of Pocket or Cash. That way your results will only return company card transactions.

[Serskine]

Hi Stephanie! There is a report under Intelligence-Standard Reports-Finance-Credit Card Transactions that I use that shows all transactions that have posted to the card. I use this each month end