[GNC] Quicken running balances - available in GnuCash??

[Adrien Monteleone]

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 weekly basis.

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 desired figures.

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.

Regards,
Adrien

> On Apr 7, 2018, at 7:06 PM, Billsy <pbills at 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
> weekly 
> 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? 
> Thanks, 
> 
> <http://gnucash.1415818.n4.nabble.com/file/t377749/Capture.jpg> 
> 
> 
> 
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> 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.