Please forgive my topic title follow my explanations below I use a software called Draftworx (issue is the same with Caseware) to prepare Annual Financial Statements for my clients. I export my TB into excel from manager and prepare it for import into Draftworx. The volume of my client previously …

@Panashe_Mlambo My approach with Draftworx is to leave the Net profit line in the TB and import it into Draftworx, then map the Net profit value to Retained Earnings as well. You don’t have to manually add / subtract the two values, let Draftworx do the calculation (you can map both Retained Earning…

I am wondering why you present trial balances to your clients at all. I think of trial balances as antiquated relics of manual accounting systems that used to be tools for accountants to verify debits and credits matched before preparing the actual financial statements. They hardly seem necessary wi…

Thank you for your response. [image] Tut: I am wondering why you present trial balances to your clients at all. I do not give my client the Trial Balance but I use it to prepare annual financial statements. Legislation required that the Annual Financial Statements be prepared in accordance w…

It seems questionable to modify a Manager report format to meet the input format of a completely independent software application. What happens when that software’s input format changes? And what about all the competing applications that might have different formats?

Most accounting softwares that I have used, one can extract a trial balance with current year profit excluded from retained earnings. It is presented in either formats that I have suggested. [image] Tut: And what about all the competing applications that might have different formats? Fortun…

[image] Panashe_Mlambo: I use a software called Draftworx (issue is the same with Caseware) to prepare Annual Financial Statements for my clients. I export my TB into excel from manager and prepare it for import into Draftworx. [image] Panashe_Mlambo: To ensure that these statements are c…

True, and as a first pass (which would cover most drafting software solutions) to simply have a generic CSV export function of the TB.

[image] Morne_Kruger: to simply have a generic CSV export function of the TB. Hardly necessary. Copy the report to the clipboard, paste into a spreadsheet, manipulate to your heart’s content, and save it as CSV. Then you can do whatever you want with it.

I agree, also, I would rather have access to transactional / report data in general via the API than making changes to the TB.

[image] Morne_Kruger: You don’t have to manually add / subtract the two values, let Draftworx do the calculation (you can map both Retained Earnings and Net profit / Loss to Retained Earnings). I will try this method. [image] Morne_Kruger: True, and as a first pass (which would cover mos…

[image] Panashe_Mlambo: Data that should be in different columns end up in one column That is only because the information started out on the report in one column. That’s a separate design issue, not a performance issue.

Trial Balance to eliminate current year profit

Panashe_Mlambo July 19, 2022, 3:29am 15

I think this is the issue now but can be addressed on the other topic below.

Topic		Replies	Views
Classic Trial Balance	2	83	June 2, 2026
Trial Balance Report Showing Net Loss as Profit	3	90	July 11, 2025
How do I move the net profit amount to retained earnings?	20	2744	March 10, 2024
Retained earning	29	3109	July 26, 2021
Trial Balance and other reports - wrong?	3	614	May 3, 2017

Trial Balance to eliminate current year profit

Related topics