Our grantors are asking for a gl detail report of our expenses on each request for reimbursement that we send to them. Previously we have included an income statement but not a gl detail.
The issue with this is we don't have a hard monthly close because we follow true accrual accounting. So we could process something through AP or create a JE in say January and its post dates will go back to December or November maybe. So the way we invoice we take total expenses minus previously invoiced expenses to get that “months” expenses. To include a GL detail of this we have to go through and manually delete lines that were invoiced in previous months. We couldn't just pull all the transactions in January for January's invoice because there may be some transactions that got posted to December but were processed after we invoiced for December so they are being picked up in the January invoice.
So we are trying to figure out a way to filter that GL detail by the transaction date or created date. But we also have to be able to limit it by project and grant t-code so we only get that specific grantors transactions. Anyone have thoughts on how to do this? Possibly with a query?
