When I try the custom report, the data did not cater to my needs due to I need detail General Ledger info which custom report did not fulfil such requirements.
Most of the accounting software, provide the users to generate the account ledgers that require to printout, be it multiple selection or by range.
Single account Ledger can be exporting from the summary drill down.
New version report merge the “Transaction type” and “reference number” to single cell again. Hence, after exporting, I have to use excel formula to separate it, additional work for the monthly reporting and checking the missing data for errors. Please note that transaction type is static (meant for filtering) but the reference/invoice number is the unique number meant for tracing. Whenever, your team merged the data for reporting, I will have to demerge after exporting, double work during tight closing period.
Generally, I only have 5 to 7 days for month end closing. Moreover, I am closing for multiple companies with different currencies and thereafter need to consolidate the data to the consolidated accounts.I have already setup several formula in excel to allow the consolidation to be automatic for each month after refreshing the PL, BS and CF.
1 more additional request is please do not add the currency code to the original amount other than “Base Currency”. This is because user also require to sum up the original currency amount to cross check with the base currency amount, especially for GST reporting on quarterly basis.
For my case, I am reporting GST in SGD to the local registrar but the base amount is USD.
Thus, when I am so happy to see the new version finally populate the original amount to the ledger which I wanted to have it similar to other accounting software since 2018, it is the text value again. I am still required to segregate the data and convert it to number in the excel to fulfill my needs. This is not an easy task if the “LEN” is different for each row, manual adjustments are needed for the full “General Ledger Transactions Report”, very time consuming but it is needed to classify each transaction (row of data) to the correct account classification and to the correct corresponding date (Basic requirements for the GL when you are providing the data to the auditor. Otherwise, auditor can’t select random sampling for document vouching. That’s why please add the original amount to the above report, easier to trace the source document)
I really hope that when developer team is creating a report or ledger for exporting to excel, please do not merge the data for multiple fields.
Thank you for your kind consideration.