how do a create a report on chart of account codes
Options
Chris_7677427
Member Posts: 16 ✭
Using Reckon Hosted, cant get a report on expenses (chart of account codes), e.g., subscriptions
0
Comments
-
Hi Chris. The usual way is to go to the chart of accounts, single click on the account e.g. subscriptions, to highlight it, go down to the area below the chart of account info and click on "reports" and then click on "fast report". This will then provide you with a listing of all transactions within YOUR current FINANCIAL year period e.g. 1 July 2015 to 30 June 2016.. This report only provides details on a full financial year. If you want to go back to a previous financial year, you need to change the dates in the drop down box at the top of report (left hand side).
If you want to see a report with a far greater date range, there is another way to do this:
1. Run a report "Reports/Company & Financial/Profit & Loss Standard" and then change the date range to say something like 1/7/2010 to 30/6/2015. This will then produce a Profit and Loss report for this whole period.
2. On this report, find your "subscriptions" account and double click on the amount. This will then open a report which provides a listing of every transaction within this whole period of time.
John G0 -
That's fantastic, thanks for your help.0
-
Excellent Chris - glad that this helped you. John G0
-
John, would you also know if it normal when a transaction in entered in through "Cheques" for it to be showing as "split" even though it is a one line entry? It does not show the account coded to when looking at the bank a/c register.
0 -
Hi Chris. You may not have your viewing options set up correctly. On the bottom left hand side of the Register page there is a box called "1-Line". If you have a tick in this box you cannot generally get the detail. If you do have it ticked, try unticking this box and see what happens. Personally, I do not have this box ticked, but probably plenty of others do - just my personal preference. John G1
-
Hi, I just tried that but it doesn't change the detail. It still says "split" rather than say, printing. All cheques I have entered show up as "split" instead of account coded to.0
-
Hi Chris. I cannot say that I have noticed this before, but you are correct. The only transactions which appear show in the register with details are ones which involve balance sheet items. Why are you wanting to see this information? Are you aware that by highlighting the entry in the register and pressing Ctrl and E you will immediately open up the transaction so that you can see the splits?
I am interested in knowing why you want to see this, in case there is another option that might be available to you to fill your need. John G0 -
I believe a "split" transaction was if there were 2 or more lines. On the bank register there were transactions coded to e.g., interest and it showed this (when this had been done with a consultant here). Later when I entered a transaction through "cheque" it came up "split" and I was trying to work out what I had done differently. Cant remember how we entered them or if I downloaded those transactions...0
-
Hi Chris. I was rather intrigued by all of this and decided to do a bit of digging, including going back into a desktop version 12 months ago, I could see that sometimes the line details showed, whilst at others it came up as "split". I believe, after doing some playing around, that I now know the answer to the mystery. It seems that when the transaction involves using a GST code, the transaction becomes a split, including when using FRE or NCF. However, if no code is shown at all, and the transaction involves a single line, the account code will show up.
I did mention earlier about balance sheet items being able to be seen, but again, this was only because there was no GST code involved. As soon as a GST code is used for a balance sheet account, the same thing will happen, in that the transaction then becomes "split".
From this you can see that you weren't doing anything wrong, rather this is one of the idiosyncrasies with the program and how it treats certain transactions. The effects of this can be seen in another way. If you go to edit one of your previously entered cheques which has GST in it, with a single line transaction, then click on "Journal" on the top line of the "Write Cheques" screen, you will see that the transaction has another line in it now for the GST component, hence why it is now regarded as a split. If you do the same thing with a cheque with an item without any GST code, that extra line will not appear, hence the reason why it is not split.
I hope that this will provide some illumination for you. John G1 -
Hi John, I didn't expect to put you to so much trouble but that is great and has answered my question. Like you say, I found it odd that the gst should interpret the transaction as a split, but that's how it is. Thanks again.0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 3K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 62 About Reckon Community