General Ledger Transaction by Projects or Division

Any possibility to add “Project” or “Divison” field in General Ledger Transaction. I am using Desktop version. Also select a group of accounts instead of one only. Such as Acc 01 to Acc 05.

I have to print GL by Project / Division for audit purpose. I use Custom Reports, but I have no idea how to create the column of “Balance” which will auto calc the amount as well as the Balance b/f.

Just like Trial balance that allowed to choose Division or Projects

Sounds like a good idea, but I feel there may be some complexities. With Projects and Divisions, accounts themselves are not assignable to projects or divisions. Rather, individual transaction line items can be assigned to them.

I don’t think Projects and Divisions would qualify for the General Ledger Transactions report, since the report is primarily account-based. However, I am fairly certain that we could use custom reports to generate transaction reports specifically for a project or division.

Currently I use custom Reports to generate the accounts ledger by Division / projects. However, I have no idea how to create the Balance column with auto calculation, make it looks like a normal General Ledger. ALso the balance b/f figures. Anyone can helps on this ?

Balances brought forward and carried forward are for accounts. Like I said earlier, projects and divisions are linked to transactions, not accounts.

You can also see that as there are no Advanced Queries for any of the bank accounts.