2

In Gnucash, I've been starting to use statement reconciliation for my bank & credit card accounts. Is there some way to see the statements I've already reconciled? Ideally I'd be able to see all the transactions that are assigned to it, but even just a list of the dates and beginning/ending balances would be helpful for figuring out what statements I still need to address.

UPDATE - I'm getting the idea from the two answers so far that the statements themselves (info on the closing date, starting & ending balance for each statement) aren't stored anywhere, and the only information is either per-account (date of last reconcile) or per-transaction (reconciled status). Is that so?

4

An added tip in this answer should help you achieve what you need:

On your accounts page, there is a little drop down on the right side that allows you to display more columns. One of them is "Last Reconcile Date", and then you can see directly on your account page which accounts need to be reconciled. This way you can glance at your accounts and know your numbers are "accurate as of [some-date]". If you have a lot of accounts that need to be reconciled each month this helps quickly show you which ones haven't been done yet.

You can also add a column to display the reconciled balance, and you can sort by the last reconciled date column to show which accounts you should focus on in your current session.

3

the way to do it is to create a transaction report for the dates you are interested in and set filter status to Unreconciled (see below).

You can adjust report in very handy ways, for example sorting according to dates (see sorting tab - same picture), rather than account names - if you are looking at expense accounts for example. I would typically want to display: Date | Description | Memo | Account Name | Other Account Name and Enable links - so if you find a transaction you want to look onto you just double click that link and it takes you straight into the account register. It is handy to open the report in New Window with Page on Windows menu. Then you switch between two windows - one is the report, the other is the actual account (i.e. main window). It works well also for finding duplicate transactions - they usually are within days of each other. Just set your time period of interest and choose to sort by amount - then run your eyes over the list - you will spot duplicates very quickly.

Under General Tab give the report a name. Save this by clicking OK. Then - before you close your report - use Reports - Save Report Configuration - you will have to give the name to the report in that Saved Report Configurations list again. So next time you can open the report quickly and just adjust the parameters you want to change (e.g. sorting). When you have made some changes, for example removed the duplicate transaction you found - click refresh button above the report.

If I want to print the reports I find that adjusting report stylesheets (under Edit menu) is very useful - I typically decrease font sizes by 2 to 3 points to make lines fit neatly on A4 layout.

Report Filter Tab

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.