Mass Dump Reconciliation

Jrode

We are trying to get used to the reconciliation feature. Currently we like our monthly submission of reports to match our company credit card statement, but we are realizing that we don't need to do that. The reconciliation screen is nice, but we have over 30 cards that we manage and we would like to mass dump so that we can upload into our accounting system. Right now the only way that meets our needs is to export each card individually from the reconciliation screen. We have well over 50 transactions so filtering by "all cards" is not an option either. Any suggestions to help facilitate a faster export than one card at a time.

Rachael Hopkins

Hi @Jrode, next time you're in your Domain settings, try going to Settings > Domains > [Domain Name] > Reporting Tools and have a play around with the reports there. These predate the Reconciliation Dashboard, so we don't really highlight them much these days, but they may do what you need here.

Jrode

I think I may have answered my own question, I found "reports" under my domain and it appears to be a mass dump of reconciliation for all my cards that I can then use. Now my question is can this report be modified at all? I need the user defined 1 and 2 fields exported along with all of the default information that's already on it.

Rachael Hopkins

Hi @Jrode check out this guide on creating your own custom reports!

Jrode

yeah been there done that, don't work for what I'm working on. Those exports are also different than the one I found under Domains>mydomain>Reporting Tools

Rachael Hopkins

Yes, that's correct. The reporting tools report outputs are hardcoded. But if you are exporting from the Reports page you should always be able to use your own custom reports, which can include Custom Fields 1 & 2.

Jrode

Ok I just realized what I did that it didn't work before. I clicked too quickly and only marked "Select all on this page" Once I selected "Select All" then it got me what I needed for all my company cards.

Thanks for the help, I think this gets me what I needed.

Rachael Hopkins

Excellent!!