# Detailed Trial Balance **URL:** \ **Category:** Uncategorized\ **Created:** [November 2, 2019, 11:44am UTC](https://forum.manager.io/t/detailed-trial-balance/25067 "2019-11-02T11:44:03Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![rakesh\_kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/rakesh_kumar/32/21941_2.png) [@rakesh\_kumar](https://forum.manager.io/u/rakesh_kumar)\ **Post date:** [November 2, 2019, 11:44am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/1 "2019-11-02T11:44:03Z")
Hello Sir, Its been a month im using your Software, It is very good though, but there are few problems which are really creating trouble for to use this software in future, at first i need detailed trail balance sheet, which means, All Accounts at page page showing balances, Debit and credits both sides, And the ledger account should be presented as DEBIT/CREDIT balances like we get in REPORTS, the PLUS MINUS method is very unprofessional. Plz consider my request and make it possible to print the Trail balance report with all ledger accounts at one page in debit and credit form thanks ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [November 2, 2019, 12:35pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/2 "2019-11-02T12:35:15Z")
The purpose of a trial balance is to verify that the sum of debits equals the sum of credits, not to report account balances. If you want account balances, use the General Ledger Summary report. > [@rakesh\_kumar](#): > > And the ledger account should be presented as DEBIT/CREDIT balances What exactly are you referring to as the “ledger account?” ---
**Author:** ![rakesh\_kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/rakesh_kumar/32/21941_2.png) [@rakesh\_kumar](https://forum.manager.io/u/rakesh_kumar)\ **Post date:** [November 3, 2019, 8:32am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/3 "2019-11-03T08:32:14Z")
Dear sir thanks for your positive reply, i understand the the trial balance shows the equal debit and credit balances, but at the end of the month we need teh detailed trail balance which shows all the ledger account balances shows at one page, I am showing how my previous ERP software use to show the all the balances at one page, ![Untitled](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/3/b3cb447d2a1ded417f16e900f81fb35a5c5b4d7c.jpeg) this image is Excel report of trial balance of my previous ERP software, which all balances at one page, this is very usefull honestly ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 3, 2019, 9:20am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/4 "2019-11-03T09:20:33Z")
There are plenty of report formats available in Manager. Unfortunately if you need one in the same exact format as your previous software, I suggest that you revert to using your previous software. But a report is just a report - as long as the information is available, it should be possible to adapt your way of work to using one or more of the reports available ---
**Author:** ![rakesh\_kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/rakesh_kumar/32/21941_2.png) [@rakesh\_kumar](https://forum.manager.io/u/rakesh_kumar)\ **Post date:** [November 3, 2019, 10:02am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/5 "2019-11-03T10:02:30Z")
dear i never want the exact copy of previous soft, all i need is ladger balances at at one page, ---
**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\ **Post date:** [November 3, 2019, 10:06am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/6 "2019-11-03T10:06:42Z")
Is that not what the summary screen shows? If you want to compare actual to budget, does the profit and loss statement (budget vs actuals) achieve what you require? You will probably get a more useful answer if you describe the task you are trying to achieve rather than just replicate prior software. ---
**Author:** ![rakesh\_kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/rakesh_kumar/32/21941_2.png) [@rakesh\_kumar](https://forum.manager.io/u/rakesh_kumar)\ **Post date:** [November 3, 2019, 10:11am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/8 "2019-11-03T10:11:52Z")
dear sir, when we open costumer statement it shows the amount and balance, which is bit confusing, i suggest it should be recorded as debit and credit amount and then balances as we get in customer reports, thanks ---
**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\ **Post date:** [November 3, 2019, 11:31am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/9 "2019-11-03T11:31:48Z")
The Trial Balance report in Manager is in exactly the format you requested ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [November 3, 2019, 1:17pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/10 "2019-11-03T13:17:15Z")
@rakesh_kumar, as far as I can see, everything you have asked for is already provided by available reports. As @Joe91 wrote, the Trial Balance is in the same format you showed and gives the totals. Whether it fits on one page or not depends on how complex your chart of accounts is. As for anything else, you did not answer my question. ---
**Author:** ![sulfuror](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/sulfuror/32/4315_2.png) [@sulfuror](https://forum.manager.io/u/sulfuror)\ **Post date:** [November 3, 2019, 7:00pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/11 "2019-11-03T19:00:53Z")
The Trial Balance Report is exactly what he’s looking for. I use it as it is right now from Manager but there is something that, even when I can manipulate it in an external worksheet, it does not suppose to be there and that is the “net profit”. In a trial balance should be the balances of the accounts in the period you’re selecting, debit and credit; the net profit should not be listed. Look at this worksheet, for example: ![image](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/2/0/20726fed01de0835f123df1890d45dbff3f627ad.jpeg) I have found this online and even if you can’t see the numbers bigger, that is not important, what I want to show is the format of the Trial Balance on the left and what you can do with a trial balance, make a working trial balance with adjustments, a balance sheet and income statement in an external worksheet. Now, why the net profit should not be listed in a trial balance? The net profit is not an account. In theory, the net profit will always be part of the retained earnings account but this will be true once a fiscal year is ended. Maybe there are some things in accounting that can vary depending on what country you are from and I can understand that. At the end is basically the same, so don’t mind this comment at all if the rules are different over there. ---
**Author:** ![Shehzad](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shehzad/32/21400_2.png) [@Shehzad](https://forum.manager.io/u/Shehzad)\ **Post date:** [November 3, 2019, 8:16pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/12 "2019-11-03T20:16:28Z")
as far as i understood what @rakesh_kumar needs, is the combination of these existing reports in Manager; trial balance + customer summary + supplier summary + Inventory balance. which i think not currently exist in Manager. ---
**Author:** ![rakesh\_kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/rakesh_kumar/32/21941_2.png) [@rakesh\_kumar](https://forum.manager.io/u/rakesh_kumar)\ **Post date:** [November 5, 2019, 8:27am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/13 "2019-11-05T08:27:46Z")
yes @Shehzad, you are right dear, i am looking for a report which shows, all accounts, including, Costumer balances, supplier balances, employee balances, capital account balances, and all remain account balances in one report. thanks shehzad. ---
**Author:** ![rakesh\_kumar](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/rakesh_kumar/32/21941_2.png) [@rakesh\_kumar](https://forum.manager.io/u/rakesh_kumar)\ **Post date:** [November 5, 2019, 8:29am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/14 "2019-11-05T08:29:01Z")
Dear @sulfuror thanks for your time 🙂 can you please guide how to get detailed Trail balance report which is already avaiable here, thanks ---
**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\ **Post date:** [November 5, 2019, 12:56pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/15 "2019-11-05T12:56:53Z")
@rakesh_kumar, you have misunderstood what various forum members have said. A report like what you call a detailed trial balance report is not available in Manager. The existing Trial Balance report in the Reports tab is in exactly the format you showed in your screen shot in post #3. Contrary to what you have said, though, this does not combine customer balances, supplier balances, employee balances, and capital account balances. It shows those things because they have been set up as individual accounts in the former accounting accounting system. And what it shows is individual accounts. If they were set up as individual accounts in Manager, they would all show on Manager’s Trial Balance report. But you would lose the benefit of most of Manager’s built-in capabilities, because those capabilities make use of a structure made up of control accounts and subsidiary ledgers. For example, Manager uses a built-in control account, _Accounts receivable_. Customers are subsidiary ledgers under the _Accounts receivable_ control account. What you see on the Trial Balance are the control accounts. To see exactly what you showed in your screen shot, you would need to create custom control accounts for every customer, supplier, employee, and capital account owner. I suggest that, if this detailed trial balance report is so important to you, you should return to your previous ERP software. I note, however, that your previous software did not apparently generate such a report either, as what you showed is an Excel spreadsheet rather than a report created by that software. ---
**Author:** ![Shehzad](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shehzad/32/21400_2.png) [@Shehzad](https://forum.manager.io/u/Shehzad)\ **Post date:** [November 5, 2019, 1:21pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/16 "2019-11-05T13:21:46Z")
@rakesh_kumar, in my opinion, when Manager doesn’t give the same report you are asking for, the best way is to print all the report like suppliers summary, customers summary, inventory summary etc. on individual pages, then make a manual Excel sheet, type totals of all summaries, then do grand total giving the name of this page Summarized Trial Balance! hope it will be working satisfactory to you. ---
**Author:** ![InunnguaqZeeb](https://avatars.discourse-cdn.com/v4/letter/i/e99b99/32.png) [@InunnguaqZeeb](https://forum.manager.io/u/InunnguaqZeeb)\ **Post date:** [November 5, 2019, 1:40pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/17 "2019-11-05T13:40:11Z")
Have you ever personally done it in this way? ---
**Author:** ![Shehzad](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/shehzad/32/21400_2.png) [@Shehzad](https://forum.manager.io/u/Shehzad)\ **Post date:** [November 6, 2019, 8:26am UTC](https://forum.manager.io/t/detailed-trial-balance/25067/18 "2019-11-06T08:26:36Z")
have been doing this for years during my previous job period. 🙂 but not on _manager_ but with another software. i m running _manager_ on trial basis till now. ---
**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\ **Post date:** [January 18, 2023, 2:58pm UTC](https://forum.manager.io/t/detailed-trial-balance/25067/19 "2023-01-18T14:58:21Z")