cancel
Showing results for 
Search instead for 
Did you mean: 
jrmered
Occasional Member - Level 1

Reporting from invoice for month-end accruals

Hello

We are on standard configuration for Expense, and in the process of launching Invoice.

The way that our Invoice set up will be working is that we go through all of the invoice coding and approval in Concur then, once that is all complete, we run an extract file which posts into our accounting system (SAP).

However, we also need to record in SAP at month-end ALL of the invoices that are currently in processing (ie. not yet approved). Does anyone know of a report that will extract (with account code, cost centre etc. detail) a report of invoices in processing so that we can book a month-end accrual in SAP. I haven't managed to find one so far, but can't believe that we are the only company wanting to do this.

Thanks.

5 REPLIES 5
KevinD
Community Manager
Community Manager

@jrmered Which reporting offering are you using? Are you using Analytics or Analysis/Intelligence? If you log into SAP Concur, you should see an option at the top of the screen that says Reporting. What do you see when you mouse over that? This will help me help you. 


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
jrmered
Occasional Member - Level 1

I get 2 options - Analysis or Analysis - BI Manager.

Thanks

KevinD
Community Manager
Community Manager

@jrmered Okay, go in using the Analysis option, not the BI Manager option. From the Public Folders area you should see one folder named Analysis - Standard Reports. Click this to drill into that folder. You will see some sub-folders. Look for one named Invoice and click on it to drill into this folder. You will see a list of reports. There should be one named Request Accrual. This should show you all Payment Requests based on the date range you select that are outstanding, meaning haven't been fully approved yet. 

 

Now, this next part is very important. Do not run the report from this location. You want to copy the report and paste it into your My Folders. To do this check the little checkbox next to the report name (see screenshot). Next, click the Copy icon (see second screenshot). Then, click the My Folders tab and use the paste icon (see third screenshot) to paste a copy of the report. Once pasted, you can run the report by using the little blue triangle (looks like a play button) under the Actions column. When you run the report you should see a couple of date fields to enter the From and To dates. To see all of October, leave the To field as is (it will show today's date) and change the From field to October 1st. This will show all Invoices not yet fully approved for the month.

KevinD_0-1635283321202.png

 

KevinD_1-1635283341270.png

 

KevinD_2-1635283355678.png

 


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
jrmered
Occasional Member - Level 1

Hi Kevin

That is really helpful, thank you.

However, one thing missing from that report is the expense categories (GL codes). To book an accrual at month-end, I need to know which GL code(s) to book it to. Is there a way to add that in?

Thanks again for your help so far.

James

KevinD
Community Manager
Community Manager

@jrmered With Analysis only, you not be able to edit this report. Also, if Invoice acts like Concur Expense, GL codes won't be visible until the Invoice is fully approved. 


Thank you,
Kevin Dorsey
SAP Concur Community Manager
Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.