A client prints and consolidates their subledger activity by account/source/date before retrieving it into Ledger at the end of the fiscal period. Let's not get into a discussion of whether that is a "best practice" (it's not); they are fanatical about it and I would rather save my breath for more important issues.

They accidentally retrieved last month's activity without printing/consolidating. They are apoplectic. Restoring from a backup would require hours of re-entry into subledgers, which is not only time consuming, but error-prone.

Is there any way to consolidate posted transactions in Ledger by account/source/date? I see there is an option to consolidate, but it is by account/period, which does not match what they are used to.

I'm thinking I could unpost the batches, export them to Excel, consolidate them there, and re-import them. Before I do, are there any other ideas?

Thanks

Steve