Printable transaction detail report for grant audit

Hi all,

We are greatly enjoying Ramp for the most part - it has made many things easier in the office. The automatic workflows and expense policies ensure that we are getting the appropriate approvals and all the required information, which is GREAT!! The issue we are running into is how to compile the required info we need to submit for our grant expenses.

I work for a nonprofit that receives grants from public and private funders. For many of these grants, we have to make the purchases for the covered items/services up front, and then submit documentation of our payments to the issuing grant authority to be reimbursed. We also have to keep details for every transaction for our annual audit. Typically this would include a copy of the signed check, completed purchase order, invoice, order confirmation, etc. Since we are still getting all of the required approvals and transaction info on Ramp, that is taking the place of our paper version of a PO. The problem is that I can’t seem to get a transaction detail report that shows the approvals and accounting information for a charge we made on Ramp. If I try to print the page while on the transaction detail screen for a charge, it only prints the information currently visible on the screen. So in order to get all of the information needed from the top down through the accounting info, I have to zoom the screen way out, which makes the text nearly illegible.

We can’t be the only ones running into this issue, so I’m hoping someone here has figured out a workaround. Thanks!

2 Likes

I use the insights tab when I need to make a detailed report of information on a filtered set of transactions. You can get as granular as needed when populating the data table.

1 Like

I can only seem to get summary level info on the insights tab, not detail down to the transaction data. What values are you using for the report for type, rows, etc.? I’m looking to create a document that shows proof of the approvals and accounting information for one transaction at a time, not a combination of transactions.

When you make a report you want to click on the data header tab once you are on it. Then you click on the filter button which will give you a side bar of raw data options. One of the options is to select all of the columns you want to see. This give it to you in a table format for all of the data you are pulling.

3 Likes

Oh I was totally missing it, thank you so much!!

2 Likes

We just went through this issue this week. We do this in two steps. For Bill Pay, we just created a filtered view for our grant codes (one of seven segments in our coding structure) for the timeframe we need. That view can be downloaded as a CSV file. Even better, all the applicable invoices can be extracted as a ZIP file to send to the grantor.

You can build the same table in the Expenses view for credit cards and download the report and card receipts also.

1 Like