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?

2 Answers 2

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.

8
  • This is true, but it doesn't really address the need. I'd really like to see which individual statements (reconciliation sessions) have happened, not just the date of the latest one. Mar 13, 2021 at 21:14
  • @KenWilliams the concept of reconciliation implies everything up to that date has already been reconciled, so only the single latest date would be needed. Normally you would reconcile statements in time ascending order. Is that not what you're doing? Or maybe you are but you still want to see previous reconciliation dates for some reason?
    – TTT
    Mar 14, 2021 at 5:32
  • Unfortunately this restriction (needing to reconcile in time-ascending order) can be quite inconvenient - for example if I import all my transactions for the past 2 years, then want to go back and import previous years. I've needed to do this several times, for various reasons, so I feel like I can't be the only one? Mar 15, 2021 at 6:34
  • @KenWilliams - I agree it's hard if you're that far behind. The (let's hope) one-time catch up work can indeed be daunting. In order to do it out of order, you will need a temporary place holder adjustment. For example, suppose the sum of all transactions (credits and debits) from 2015-2018 = $1234.56. In order to reconcile after that you could add an adjustment with that credit on 2018-12-31 and use account Imbalance. An example description might be "All transactions for 2015-01-01 through 2018-12-31". As you reconcile backwards, change the amount, date, and memo for that entry.
    – TTT
    Mar 15, 2021 at 14:19
  • @KenWilliams and if you then reconcile in gaps within the larger gap, you would need to keep adding temporary adjustment transactions any place they are needed to keep reconciles after that date in balance. So essentially you would have to manually do what you want with temporary adjustments until you fill in all the gaps. By the way, needing to do this isn't really a restriction in GnuCash per se, I suspect all accounting software would require this. There's no way to start from a specific date and virtual amount without the transactions up to that date adding up to that number...
    – TTT
    Mar 15, 2021 at 14:23
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .