Re: [GNC] Export files for audit
> On Jun 8, 2019, at 9:00 AM, Mike stagl wrote: > > > > Side Note- I noticed that the Running Balance column broke when I > selected Detail Level to Multi-Line in the Transaction Report. This is > in GnuCash 3.4+ (2018-12-30) on Debian 9. Does anyone know if that is > addressed in 3.5? I'm so close to the end of the fiscal year I wanted > to wait to upgrade to 3.5 until after I closed this year's books. > > Thanks for the help, > > Mike > Mike, I’m using 3.5. I don’t think the Running Balance column is ‘broken’ so much as it is now showing something you weren’t expecting. I can achieve the same effect by selecting multiple accounts to report on instead of just one and using Single as the detail level. Running Balance shows you the running balance as of that transaction *for that account*. So if you are showing splits of a transaction to other accounts, those individual lines will show the running balance of their own accounts, not the main one you are trying to report on. If you have something like this: Assets:Checking Expenses:Auto Expenses:Sales Tax Then each line will report the running balance for each account separately. Certainly, the Auto & Sales Tax splits don’t affect the running balance for Checking, just the Checking split does. (as it balances the other two, you wouldn’t include them again) What I’m guessing you are looking for is to see the transaction detail, but only show the running balance for the First split account, which would be the one you are running the report for. (Checking in the above example) I can’t find a way to suppress the Running Balance for the other splits. If you are wanting to report only a single account, but still show split detail, try opening the register of the target account and then running an Account Report. It will by default, show all splits as proper debits and credits, but only display the running balance once per transaction on the same line as the debit/credit of the target account. Regards, Adrien ___ 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] Export files for audit
Thanks. I ran across a FAQ on the wiki that explains that, and I think it will work well. I just created a Transaction Report with the detail I need, and saved it as an HTML file. Then I opened the HTML file with LibreOffice/Excel and formated it how I needed. It looks pretty similar to what our Treasurer submitted last year to the auditor. Side Note- I noticed that the Running Balance column broke when I selected Detail Level to Multi-Line in the Transaction Report. This is in GnuCash 3.4+ (2018-12-30) on Debian 9. Does anyone know if that is addressed in 3.5? I'm so close to the end of the fiscal year I wanted to wait to upgrade to 3.5 until after I closed this year's books. Thanks for the help, Mike On Fri, 2019-06-07 at 11:32 -0500, Adrien Monteleone wrote: > I say, “Ask the Auditor” but otherwise, check out the Transaction > Report. It is probably the most detailed available. > > There are also the General Journal and General Ledger Reports. > > Regards, > Adrien > > > On Jun 7, 2019, at 8:54 AM, Mike stagl wrote: > > > > This is end of my first year as Treasurer of a PTA, and my first > > year > > using gnucash. > > > > What is the best way to export or print a year's worth of gnucash > > data > > for an auditor to review? > > > > I notice the export functions do not include running balance > > information. What data does an auditor usually need and what format > > would be best? Any tips? > > > > Thanks to all the contributors, > > > > Mike > > ___ 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] Export files for audit
On 6/7/2019 9:54 AM, Mike stagl wrote: This is end of my first year as Treasurer of a PTA, and my first year using gnucash. What is the best way to export or print a year's worth of gnucash data for an auditor to review? What is the auditor asking for? Is the auditor willing to install gnucash (in which case you could send the FILE which is the books and the auditor could look at whatever). 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] Export files for audit
I say, “Ask the Auditor” but otherwise, check out the Transaction Report. It is probably the most detailed available. There are also the General Journal and General Ledger Reports. Regards, Adrien > On Jun 7, 2019, at 8:54 AM, Mike stagl wrote: > > This is end of my first year as Treasurer of a PTA, and my first year > using gnucash. > > What is the best way to export or print a year's worth of gnucash data > for an auditor to review? > > I notice the export functions do not include running balance > information. What data does an auditor usually need and what format > would be best? Any tips? > > Thanks to all the contributors, > > Mike ___ 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.