Trial Balance to eliminate current year profit

[Panashe_Mlambo]

@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.

@Morne_Kruger

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

I agree with you here. Time spend on preparing data to ready for import into a drafting software it will be significantly reduced

@Tut

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.

This Copy to clipboard method is terrible when copying reports. Data that should be in different columns end up in one column now you have to spend time splitting it. The issue is on another topic linked below.

Account code and name need to be separate for processing in excel

I also prefer separate columns for different fields rather than merging fields into a column. It makes it easier to manipulate when exported. Even the indented transactions could be one column to the right of the account code | 0000 | Acc | | | Date | Description | Debit | Credit | Bal | I’d also prefer if the the Cr/Dr suffix on the Balance column which copies from an account transaction list would also convert to +/- on copying and pasting, as it does on the GL report, for instance, bu…