Re: [GNC] Is there a report with transactions by date and accounts in columns?
On Wed, May 04, 2022 at 01:27:59PM +, Christopher Lam wrote: > Use the "Income & GST Statement" report. > > [image: image.png] > > [image: image.png] > Yes, thank you, I've finally got there. That provides the information (plus a few unwanted columns). :-) -- Chris Green ___ 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] Is there a report with transactions by date and accounts in columns?
On Wed, May 04, 2022 at 12:07:53AM +0800, Christopher Lam wrote: > On Tue, 3 May 2022, 11:53 pm Chris Green, wrote: > > > My auditor wants a transaction report showing transactions in date > > order one per line with the transaction amounts in columns according > > to account name. > > > > Is there anything in GnuCash that can do this? > > > I guess the report intends to show the inputs and outputs into the company, > you could use the income and GST statement report. Inputs and sales, and > outputs are purchases. You can ignore the tax accounts. Then select > detailed sales and purchase accounts in the display options. > Still no separate columns for accounts, what's wanted is something like (needs fixed width font) :- DonationsInterestMiscExpenses 01/03/21£40.00 03/03/21£25.00 07/04/21 (£23.00) 22/04/21£0.50 02/05/21£10.00 etc. etc. It doesn't have to have income and expense on the same sheet, in fact one sheet for each might well make sense, avoiding the need for a way to show -ve values (or some other debit/credit differentiation). -- Chris Green ___ 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] Is there a report with transactions by date and accounts in columns?
The Transaction Report can get you the info broken down that way, but not quite arranged in 'landscape'/'spreadsheet' fashion. You can set the primary sort order by Account, and then secondary sort by Date. This will group transactions by account and then list them in date order and you can get a subtotal by account if you want. (I think you an also get a subtotal by date for each month/year accordingly) You can swap that sorting to date-first, but that will likely be messier to read. Your only other option I can think of would be to export such a report by date only (accounts are still visible) and then manually manipulate after importing in a spreadsheet. Regards, Adrien On 5/3/22 10:53 AM, Chris Green wrote: My auditor wants a transaction report showing transactions in date order one per line with the transaction amounts in columns according to account name. Is there anything in GnuCash that can do this? The closest I can find is the Income Statment (Multicolumn) in the Experimental Reports section. However it's the wrong way round, I want dates down the page and accounts across the page. ___ 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] Is there a report with transactions by date and accounts in columns?
I guess the report intends to show the inputs and outputs into the company, you could use the income and GST statement report. Inputs and sales, and outputs are purchases. You can ignore the tax accounts. Then select detailed sales and purchase accounts in the display options. On Tue, 3 May 2022, 11:53 pm Chris Green, wrote: > My auditor wants a transaction report showing transactions in date > order one per line with the transaction amounts in columns according > to account name. > > Is there anything in GnuCash that can do this? > > The closest I can find is the Income Statment (Multicolumn) in the > Experimental Reports section. However it's the wrong way round, I > want dates down the page and accounts across the page. > > -- > Chris Green > ___ > 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.