Re: [GNC] Opening Balance on Reports
Wow, that's great. Talk about fast turn-around! Thank you very much, Paul Christopher Lam wrote > Good news; future releases where "Running Balance" is enabled, and the > sorting/grouping options include account, *will* now print the balance > brought forward. Zero-amount transaction hack isn't needed anymore. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
Good news; future releases where "Running Balance" is enabled, and the sorting/grouping options include account, *will* now print the balance brought forward. Zero-amount transaction hack isn't needed anymore. On Mon, 6 Jan 2020 at 05:01, Christopher Lam wrote: > Wouldn't seem right to offer disable zero in the transaction report. But a > "running balance brought forward" as shown is a worth while addition that > can be added imminently. > > So there won't be any need for the zero-amount transaction hack. > > On Mon, 6 Jan 2020, 10:47 am Adrien Monteleone, < > adrien.montele...@lusfiber.net> wrote: > >> Bummer. >> >> Regards, >> Adrien >> >> > On Jan 5, 2020 w2d5, at 5:35 PM, Christopher Lam < >> christopher@gmail.com> wrote: >> > >> > A disable-zero option does not feature in the transaction report though. >> > >> >> >> ___ >> gnucash-user mailing list >> gnucash-user@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. >> > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
Wouldn't seem right to offer disable zero in the transaction report. But a "running balance brought forward" as shown is a worth while addition that can be added imminently. So there won't be any need for the zero-amount transaction hack. On Mon, 6 Jan 2020, 10:47 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > Bummer. > > Regards, > Adrien > > > On Jan 5, 2020 w2d5, at 5:35 PM, Christopher Lam < > christopher@gmail.com> wrote: > > > > A disable-zero option does not feature in the transaction report though. > > > > > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
Bummer. Regards, Adrien > On Jan 5, 2020 w2d5, at 5:35 PM, Christopher Lam > wrote: > > A disable-zero option does not feature in the transaction report though. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
A disable-zero option does not feature in the transaction report though. On Mon, 6 Jan 2020, 6:15 am Adrien Monteleone, < adrien.montele...@lusfiber.net> wrote: > There is a setting to show zero amounts. If you uncheck it, then it should > be blank. (though for the entire report, not that one figure) > > Regards, > Adrien > > > On Jan 5, 2020 w2d5, at 2:51 PM, Evenmoreconfused > wrote: > > > > Thank you, this works nearly perfectly to achieve the desired effect. > > Brilliant! > > > > When I say nearly perfectly, it's only because the amount column for the > > first (artificial) line shows $0.00, whereas it would be better > > aesthetically if were blank. No matter -- in cases where I care enough I > can > > always export the report and remove it in Excel. > > > > Still, since several people have posted work-arounds, it seems a common > > enough requirement that perhaps in should eventually be a built-in > option on > > the standard Transaction Report. > > > > Thanks very much to all, > > Paul > > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
There is a setting to show zero amounts. If you uncheck it, then it should be blank. (though for the entire report, not that one figure) Regards, Adrien > On Jan 5, 2020 w2d5, at 2:51 PM, Evenmoreconfused wrote: > > Thank you, this works nearly perfectly to achieve the desired effect. > Brilliant! > > When I say nearly perfectly, it's only because the amount column for the > first (artificial) line shows $0.00, whereas it would be better > aesthetically if were blank. No matter -- in cases where I care enough I can > always export the report and remove it in Excel. > > Still, since several people have posted work-arounds, it seems a common > enough requirement that perhaps in should eventually be a built-in option on > the standard Transaction Report. > > Thanks very much to all, > Paul ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
Thank you, this works nearly perfectly to achieve the desired effect. Brilliant! When I say nearly perfectly, it's only because the amount column for the first (artificial) line shows $0.00, whereas it would be better aesthetically if were blank. No matter -- in cases where I care enough I can always export the report and remove it in Excel. Still, since several people have posted work-arounds, it seems a common enough requirement that perhaps in should eventually be a built-in option on the standard Transaction Report. Thanks very much to all, Paul DavidWhiting wrote > What I do is add a transaction on the first date of the new period with > the > transaction reference "Balance carried forward" with nothing in the > credit/debit columns. Then a transaction report with running balance has > "Balance carried forward" as the first transaction and the running balance > shows the amount carried forward. See attached example (our club financial > year runs from 1st August to 31st July). > > David -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
Doable... On Fri, 3 Jan 2020 at 11:56, Christopher Lam wrote: > This is a nice hack. > > It would be even a nicer hack that the transaction report automatically > inserts the balance brought forward on the same row as the account name. I > suspect this is doable. > > On Fri, 3 Jan 2020, 3:10 pm david whiting, wrote: > >> What I do is add a transaction on the first date of the new period with >> the >> transaction reference "Balance carried forward" with nothing in the >> credit/debit columns. Then a transaction report with running balance has >> "Balance carried forward" as the first transaction and the running balance >> shows the amount carried forward. See attached example (our club financial >> year runs from 1st August to 31st July). >> >> David >> >> On Thu, 2 Jan 2020, 23:17 Michael or Penny Novack, < >> stepbystepf...@comcast.net> wrote: >> >> > On 1/2/2020 5:33 PM, Christopher Lam wrote: >> > > If it's a single-creditor liability account, you could try adding the >> > > Display/Running Balance. However it doesn't quite give you the >> 'balance >> > > brought forward' prior to the first printed transaction. >> > > >> > I will tell you how I would do this. It would be easy for me, because I >> > don't insist that that the final printed version be printed from within >> > gnucash. >> > >> > I would use the suggestion above, but set the date range to include the >> > last transaction before. I would export the resulting report.. I would >> > then edit the date of that last transaction to be the start date, change >> > its description to "opening balance" and it's amount to zero/blank << it >> > is the running balance after this transaction that is the starting >> > balance >> >> > >> > I would then print THAT (or send THAT by electronic means >> > >> > Michael D Novack >> > >> > >> > ___ >> > gnucash-user mailing list >> > gnucash-user@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. >> > >> ___ >> gnucash-user mailing list >> gnucash-user@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. >> > Transaction Report From 14/12/19 to 31/12/20 Date Num Description Memo/Notes Account Amount Running Balance Bank-GBP £1,275.00 14/12/19 Customer-GBP Bank-GBP [1]-£66.00 [2]£1,209.00 14/12/19 num Customer-GBP memo1 Bank-GBP [3]£10.00 [4]£1,219.00 14/12/19 Customer-GBP Bank-GBP [5]£10.00 [6]£1,229.00 21/12/19 Customer-GBP Bank-GBP [7]£95.00 [8]£1,324.00 31/12/19 inv-pmt-num Cust-Easy inv-pmt-memo - $100 in GBP Bank-GBP [9]£71.43 [10]£1,395.43 Total For Bank-GBP £120.43 Bank-USD $961.80 14/12/19 Vend-USD Bank-USD [11]$100.00 [12]$1,061.80 23/12/19 num-is-identical Cust-Easy split-memo-from-bank Bank-USD [13]$100.00 [14]$1,161.80 24/12/19 P-101 Cust-Links Bank-USD [15]-$80.00 [16]$1,081.80 24/12/19 P-100 Cust-Links Bank-USD [17]$80.00 [18]$1,161.80 25/12/19 Cust-Links memo Bank-USD [19]$36.00 [20]$1,197.80 31/12/19 inv-pmt-num Cust-Easy inv-pmt-memo - $15 Bank-USD [21]$15.00 [22]$1,212.80 02/01/20 pmt-num Cust-Easy bank-memo Bank-USD [23]$304.25 [24]$1,517.05 Total For Bank-USD $555.25 __ Grand Total $555.25 £120.43 References 1. gnc-register:split-guid=b268ff596c8e47f59d20d21f39eb4203 2. gnc-register:split-guid=b268ff596c8e47f59d20d21f39eb4203 3. gnc-register:split-guid=fe2e392ffdc84c8f874f1bc0d79c3e75 4. gnc-register:split-guid=fe2e392ffdc84c8f874f1bc0d79c3e75 5. gnc-register:split-guid=105167d4cc31453d9770d84cd7c9cf7e 6. gnc-register:split-guid=105167d4cc31453d9770d84cd7c9cf7e 7. gnc-register:split-guid=e8f7d0f441d2408ebef8fff5d2120f48 8. gnc-register:split-guid=e8f7d0f441d2408ebef8fff5d2120f48 9. gnc-register:split-guid=baf7b2f7eab04a2e8cf4771280d938fc 10. gnc-register:split-guid=baf7b2f7eab04a2e8cf4771280d938fc 11. gnc-register:split-guid=aba54ee0c28b4157bb76d330c90906e8 12. gnc-register:split-guid=aba54ee0c28b4157bb76d330c90906e8 13. gnc-register:split-guid=bfd9796a84264ca98a53a76bd004c464 14. gnc-register:split-guid=bfd9796a84264ca98a53a76bd004c464 15. gnc-register:split-guid=179dca0494064776a63b992e16c4f719 16. gnc-register:split-guid=179dca0494064776a63b992e16c4f719 17. gnc-re
Re: [GNC] Opening Balance on Reports
This is a nice hack. It would be even a nicer hack that the transaction report automatically inserts the balance brought forward on the same row as the account name. I suspect this is doable. On Fri, 3 Jan 2020, 3:10 pm david whiting, wrote: > What I do is add a transaction on the first date of the new period with the > transaction reference "Balance carried forward" with nothing in the > credit/debit columns. Then a transaction report with running balance has > "Balance carried forward" as the first transaction and the running balance > shows the amount carried forward. See attached example (our club financial > year runs from 1st August to 31st July). > > David > > On Thu, 2 Jan 2020, 23:17 Michael or Penny Novack, < > stepbystepf...@comcast.net> wrote: > > > On 1/2/2020 5:33 PM, Christopher Lam wrote: > > > If it's a single-creditor liability account, you could try adding the > > > Display/Running Balance. However it doesn't quite give you the 'balance > > > brought forward' prior to the first printed transaction. > > > > > I will tell you how I would do this. It would be easy for me, because I > > don't insist that that the final printed version be printed from within > > gnucash. > > > > I would use the suggestion above, but set the date range to include the > > last transaction before. I would export the resulting report.. I would > > then edit the date of that last transaction to be the start date, change > > its description to "opening balance" and it's amount to zero/blank << it > > is the running balance after this transaction that is the starting > > balance >> > > > > I would then print THAT (or send THAT by electronic means > > > > Michael D Novack > > > > > > ___ > > gnucash-user mailing list > > gnucash-user@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. > > > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
What I do is add a transaction on the first date of the new period with the transaction reference "Balance carried forward" with nothing in the credit/debit columns. Then a transaction report with running balance has "Balance carried forward" as the first transaction and the running balance shows the amount carried forward. See attached example (our club financial year runs from 1st August to 31st July). David On Thu, 2 Jan 2020, 23:17 Michael or Penny Novack, < stepbystepf...@comcast.net> wrote: > On 1/2/2020 5:33 PM, Christopher Lam wrote: > > If it's a single-creditor liability account, you could try adding the > > Display/Running Balance. However it doesn't quite give you the 'balance > > brought forward' prior to the first printed transaction. > > > I will tell you how I would do this. It would be easy for me, because I > don't insist that that the final printed version be printed from within > gnucash. > > I would use the suggestion above, but set the date range to include the > last transaction before. I would export the resulting report.. I would > then edit the date of that last transaction to be the start date, change > its description to "opening balance" and it's amount to zero/blank << it > is the running balance after this transaction that is the starting > balance >> > > I would then print THAT (or send THAT by electronic means > > Michael D Novack > > > ___ > gnucash-user mailing list > gnucash-user@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. > Transaction Report--03_01_20.pdf Description: Adobe PDF document ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
On 1/2/2020 5:33 PM, Christopher Lam wrote: If it's a single-creditor liability account, you could try adding the Display/Running Balance. However it doesn't quite give you the 'balance brought forward' prior to the first printed transaction. I will tell you how I would do this. It would be easy for me, because I don't insist that that the final printed version be printed from within gnucash. I would use the suggestion above, but set the date range to include the last transaction before. I would export the resulting report.. I would then edit the date of that last transaction to be the start date, change its description to "opening balance" and it's amount to zero/blank << it is the running balance after this transaction that is the starting balance >> I would then print THAT (or send THAT by electronic means Michael D Novack ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
If it's a single-creditor liability account, you could try adding the Display/Running Balance. However it doesn't quite give you the 'balance brought forward' prior to the first printed transaction. On Thu, 2 Jan 2020 at 19:55, Paul Kroitor wrote: > Hello, and happy New Year to all of you using whatever the name is for the > calendar that just started the year 2020! > > I am trying to produce an annual statement for a counter-party with whom > we have a current account. It's set up in GnuCash as a liability account, > as generally the balance is in their favour. > > In 2018, which was the first year the account was open, it was easy: I > made a simple report - a modified Transaction Report - that listed all the > transactions, and a total. But for 2019, I am having a problem creating it, > because it should start with the opening balance (the total at the end of > the 2018 report) and then run forward from there. The only way I can see to > have the prior balance is to include all historical transactions (or as per > the Ps. below). > > In Quicken (for example), a register report will always have an "Opening > Balance" line which will be the total of all the transactions prior to the > start date of the report. But I cannot find any way to achieve the same > result in GnuCash. Am I missing something? > > Thanks as always for all thoughts, > Paul > > [PS: I know I could move the total liability to somewhere else on Dec > 31st, and then move it back on Jan 1st - a sort of a manual book closing, > but for a liability rather than income / expenses - but these seems tedious > and error-prone. However, I'll use this work-around if there's no way to > achieve it programmatically.] > ___ > gnucash-user mailing list > gnucash-user@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. > ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] Opening Balance on Reports
Paul, The Transaction Report has some aggregation and sorting features in the Options > Sorting tab, and you can refine the view in Options > Display. You might play with those till you find something close to what you are looking for. Optionally, export or copy/paste your report to a spreadsheet and manipulate from there. Another option is the Vendor Report (if you’ve set the counter-party up that way) You would get a ‘balance forward’ and then each transaction since then for whatever period you are reporting for. Of course, this requires use of the business features for all associated transactions. An alternative to manually ‘closing’ the account (and then reversing that) would be to report just for the current desired period (say 2019), then move the resulting report to a spreadsheet and add the balance forward manually there. If you need the balance calculated, just run a separate report for the beginning of your book to 12/31/18 and take the bottom line grand total to your spreadsheet. The Vendor Report is likely what you are looking for, but again, that would require a different workflow than manual transactions. It may or may not be worth it to you to refactor that transaction history accordingly, or else just switch to that for 2020. Regards, Adrien > On Jan 2, 2020 w1d2, at 1:45 PM, Paul Kroitor wrote: > > Hello, and happy New Year to all of you using whatever the name is for the > calendar that just started the year 2020! > > I am trying to produce an annual statement for a counter-party with whom we > have a current account. It's set up in GnuCash as a liability account, as > generally the balance is in their favour. > > In 2018, which was the first year the account was open, it was easy: I made a > simple report - a modified Transaction Report - that listed all the > transactions, and a total. But for 2019, I am having a problem creating it, > because it should start with the opening balance (the total at the end of the > 2018 report) and then run forward from there. The only way I can see to have > the prior balance is to include all historical transactions (or as per the > Ps. below). > > In Quicken (for example), a register report will always have an "Opening > Balance" line which will be the total of all the transactions prior to the > start date of the report. But I cannot find any way to achieve the same > result in GnuCash. Am I missing something? > > Thanks as always for all thoughts, > Paul > > [PS: I know I could move the total liability to somewhere else on Dec 31st, > and then move it back on Jan 1st - a sort of a manual book closing, but for a > liability rather than income / expenses - but these seems tedious and > error-prone. However, I'll use this work-around if there's no way to achieve > it programmatically.] ___ gnucash-user mailing list gnucash-user@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.