It sounds like what you’re asking for is to combine the transaction report with
a balance sheet report (showing only the desired asset of cash)
Is that correct?
If so, no, there is no such report that I can fathom out of the box.
But you can get a report that shows some info about your cash position on a
Run the Average Balance report, select only the desired cash account, set Show
Table and unset Show Plot (if not desired) in the Display tab, and set the Step
Size in the General Tab to ‘Week’. You’ll get a weekly summary of that account
for the time period chosen in the General tab. (which defaults to start and end
of accounting period - whatever that may be defined as in your Preferences)
You can copy/paste this into a spreadsheet. Then add a column on the right to
calculate the sum of the previous week and the profit amount for each week.
(which would be started off by the figure obtained from a beginning of period
balance sheet) This would give you the ending cash balance each week.
Not as nice or easy, but without writing a custom report, it will get you the
You could probably also copy in the transaction report and then write a simple
macro or cell reference to copy over the weekly cash position so you can have
it all together on the same sheet.
> On Apr 7, 2018, at 7:06 PM, Billsy <pbi...@optusnet.com.au> wrote:
> Hi all,
> This is a repost of an earlier query - I'd still like to switch to GnuCash
> and Linux, however I have one stumbling block, so perhaps someone may have
> some ideas for me....
> I currently use Quicken Personal, and use a budget report, which lists
> transactions, and a running balance of my cash account at the end of each
> week - that way I know exactly how much I have in the bank at the end of
> each week. (Amount is circled in red in the picture below).
> When I generate a transaction report with GnuCash, the transactions are
> listed and totalled for each week, but I don't have a weekly cash position
> indicated, so although I know the total of all weekly deductions, I can't
> see a running weekly balance of my cash account.
> Am I missing something in the report options?
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> gnucash-user mailing list
> To update your subscription preferences or to unsubscribe:
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
gnucash-user mailing list
To update your subscription preferences or to unsubscribe:
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.