The idea is to show the following in a single report.
- Opening and Closing balances
- Income/Expenses every month
This method I have found works and can be found at Using GnuCash
As of GnuCash 2.6.15, the Tutorial & Concepts Guide contains a Reports chapter. Please refer to the Guide for details about the reports included with GnuCash.
A single report that shows summary amounts for multiple months for multiple accounts
To create a single report that shows summary amounts for multiple months for multiple accounts (for example, monthly totals for expense accounts over the course of a year), you can use the Transaction Report
- Choose your Accounts as the Accounts source in the Accounts tab, e.g. highlight "Expenses" and click "Select children"
- Set sortkeys in the Sorting tab: Primary key is Account Name, Primary subtotal is enabled. Secondary key is Date, secondary subtotal for date key is Monthly
- Enable Subtotal table in the Display tab
--Provided by Anthony Dardis
I also recommend In the General Tab, enable Table for Exporting. This will allow you to copy and paste the multi-column table including totals and the Averages column into a spreadsheet program
This is desirable because there is no way presently to disable the pages long detail lines that display below the table.
This older post: GnuCash monthly income-expense report worked for me. More specifically, it is the following answer given by "trythis":
"Reports> Sample and Custom> Custom and multicolumn report> Options> Number of Columns, 12> select Income Statement under Contents > click [add>>] 12 times Click OK or Apply. (this could take some time for it to finish)
Then on the report under each column of data, click Edit Options> General> select your date ranges, for each column."
found in the above page that worked for me.
Note that: 1. setting this up the first time is not hard but takes time. However, once you save the report, you can re-run it at any time. 2. The result has the account names repeated for each month. However, if you save the report in html format, you can open it in a spreadsheet and, after a bit of formatting, delete unwanted columns. I did not find it hard. (BTW, the "clear direct formatting" feature of LO Calc has been helpful to me).
A colleague who uses QuickBooks, but not GnuCash, asked me to make this report and I was happy when I succeeded.
FYI: I used GnuCash 2.6.19 on Ubuntu 18.04