My auditor is requesting a detailed General Ledger Report that is “showing what makes up expense and income items”. I tried setting up a custom report with format as attached but the customer and supplier details do not start appearing until August, presumably due to later updates to Manager. The general ledger transaction report has the same problem. I would appreciate advice on what I can do.
I have resorted to making screen shots of the receipts and payments pages and there is no way to make a pdf of them. That may not be sufficient either. I have version 21.1.44.
- The “Select” portion of a custom report enables selection of particular data fields for each transaction.
- the “Where” section enables choosing which transactions are included in the report
To debug why particular transactions are not showing, please post a screenshot of
- custom report “Where” section
- edit screen of a transaction you want included in your report
Prior to the current customer/supplier/other scheme for designating the payer/payee on receipts and payments, there was a contact field. That information is still there. So the General Ledger Transactions report will give you exactly what you want. No custom reports or screen shots are necessary.
It generally gives you date, transaction type, reference number, payer/payee/contact, and description for every line item posted to any account. There are a few variations based on context. And, of course, you need to have provided all that information when you entered transactions. What more could you want?
You can also conform old entries to the new system in a few minutes via Batch Update. I gave detailed instructions in a forum thread a month or two ago.
I think the problem may be that for entering receipts and payments there are two ‘Description’ fields. I was treating the first one as unnecessary and only using the second field alongside the account name. But the GL report picks up only the first one. When I edit and enter some of them they appear. Why are there two description fields?
One is used to describe the overall transaction, for example, “Kitchen repair.” The other describes line items, such as “Electrical outlet installation.” How you use them depends partly on what you want to appear on reports. There are also situations where absence of one field triggers substitution of another, because some situations require some form of content.
Thanks for the advice. Is it possible to reorganise the General Ledger Transactions Report to order by accounts instead of dates? This is how we are used to seeing GL reports in MYOB and now the auditor is asking me to do a GLT report for each account.
I am trying to setup a custom GLT report in account order as below but my layout is not being accepted. I am rather ignorant about customising.
I managed to customise a GLT in account order but the customers and suppliers are not showing up before August.
Custom reports shown information about accounting transactions.
Please show
It already is organized that way: first by accounts, then within an account by dates.
Then choose an individual account when defining the report.
I now have a custom report for General Ledger Transactions for fields required but it still does not show customers and suppliers from Jan to July. Can they be recovered? Screen shots here before August and from August shown.
Thanks. I now have the GLT report sorted as required as per reply here to Patch but still no customers and suppliers are appearing in the report from January to July.
Most likely, that is because you have not reclassified the payers/payees as customers and suppliers, as I mentioned in post #3. Post a screen shot of the Edit screen of one of the transactions that is not showing the way you want.
Have you tried looking at the data via a Batch Update to see how these missing payers/payees are classified?
David,
Your account is correct in asking for this and as an accountant I asked Manager the same thing. You can read the my thread from last month. This should be a trial balance report for the period you are running which would list all transaction detail in each GL account. Manager calls it a General Ledger Transactions. If you run it wide open (don’t choose and account - leave that box open), fill in the dates, you will get a proper trial balance for there period you enter - all transactions for each GL account. If you provide this to your accountant, he/she will have all the transactions to view and can ask you to drill down on any for clarification. Alternatively, if he/she only needs 1 or 2 account details, you can choose them in the drop down box and provide them. You don’t need to make a special report.
Cindy
Thanks to Tut I have re-entered the missing customers and suppliers and I have a full customised GLT report with all accounts and all transaction details added. Thanks for your suggestion which includes all accounts but the normal General Ledger Transaction report does not show transaction details or customers and suppliers.
You can try also grouping by account and adding the contact field To your select - this seems to cut across payer/payer/supplier/customer.
Hope that helps.
That is a good suggestion thanks. Is there any way to get the accounts in code order instead of alphabetical? I could not get it to do that.
Are you now referring to the General Ledger Transactions report or a custom report?
That is because account codes were not selected for your report. If you add them, you can thenorder by them:
