When I run a Trial Balance, the amounts are blank. When I run Profit and Loss or Balance Sheet reports, I get amounts; therefore, P&L and BS appear to work.
Here are my specifications for the Trial Balance report:
I’m checking whether it is just me or whether anybody else gets blank amounts for a Trial Balance report. Maybe someone can point out what I’m not specifying correctly if it is just me.
You may have either a corrupted installation of Manager or are not using the version you think you are. For a very long time, the Trial Balance report has included either “Accrual basis” or “Cash basis” in the heading, depending on which is selected, like this (from the same version number):
Your report does not include that element. As a first step, try deleting the report and recreating it with the same definition you showed. (That looked fine.)
EDIT: Thinking further about this, there may be one other possibility. The default data application folder location changed at version 24.3.5.1340. This resulted in apparent disappearance of businesses. A fix was supposedly introduced at v24.3.10.1347. This only affected Mac users. Possibly, the fix still requires you to re-import your businesses from the old data application folder location. In other words, you might not be looking at the business data file you think you are.
I liked your response. It made a lot of sense and showed understanding. Unfortunately, recreating the report from scratch and backing up and reimporting the business did not change the results. So, the trial balance looks the same as in my first post.
Actually, shouldn’t the specification for the trial balance be more like the specification for the balance sheet?
I’m very rusty on this. But I’m thinking that you want the trial balance to show the balance of every account as of a specified date. And the transactions should be all transactions from the beginning of time up to the specified date. So, one date should be specified, not a range.
For a profit and loss statement, you don’t want all transactions from the beginning of time. You want from the beginning of a period to the end of a period. So, for profit and loss, you need to specify two dates, the beginning and the ending.
I think my trial balance specification (the first post) looks similar to the profit and loss specification. But it ought to look like the balance sheet specification.
Am I mixed up?
For @eko, here is a portion (because of sensitive information) of the P&L:
In the samples in this post, I don’t see the From date showing. I only see the To date. So, I thought maybe you don’t need to exclude transactions before a From date. And if you would exclude transactions before a From date, wouldn’t the trial balance amounts be wrong? It just looked like Manager was only using the To date to produce a trial balance.
Cash or Accrual does not show in report headings unless there has been 1 invoice (either Sales or Purchase) entered. The OP must be using only Receipts & Payments and/or only Journal Entries.
The Trial Balance displays blank for zero balances, unlike other reports that display a “-” (dash/hyphen) for zero balances.
That does not explain why there are not amounts for Taxes and Licenses expense 346.00, and Employee Benefits expenses 17,532.41, Communications expenses 2,494.38 and Equipment expense 122.99 (as per your P&L report).
One thing that puzzles me - why have you blacked out (redacted) the Software Sales amount in the P&L report? - surely that amount would be zero and be showing as a dash.
Try changing the Trial Balance settings to exclude zero balances and see what effect that has.
This P&L Statement is very confusing. You labelled a lot Net Profit (Loss) and more surprising you have another “Net Profit/Loss After Carryovers” at the very end while Manager usually has the preceding Net Profit/Loss at the end of the form. So this raises questions about the setup of your Chart of Accounts. Also curious if Trial Balance actually ever worked for you, especially that you are on Cloud edition?
This discussion is incomplete and thus irresolvable. @Indinfer was asked to show transactions during 2023 that are not reflected in the trial balance, but has not done so. And key entries on reports are inconveniently obscured. The unfortunate reality is that, at every stage, willing collaborators have been denied necessary troubleshooting information. Several have tried to extract necessary revelations without success. The only possible conclusion is that @Indinfer has so far not proven any problems exist.
@Indinfer, please do yourself a favor and completely illustrate the situation.
Thank you to everybody for helping me figure this out.
I finally thought of trying the report on the desktop edition. I thought, “The desktop edition is free so that it won’t cost me anything. It is easy to back up and restore a business. So why not?”
I viewed the trial balance. Got the same report with blank amounts.
I viewed the P&L. I got the same report with the amounts showing properly.
So, I proved that Cloud and Desktop editions don’t make any difference in the reports. This result indicates that @Tut is correct that something is corrupted. Now, I think the difference between the trial balance I get and the correct trial balance that everyone else gets is the data file. I think the indication is that my data file is corrupted.
Does anyone know of a procedure that usually uncorrupts corrupted files? It’s got to be something other than backing up and importing because I had to do that to try the reports in the desktop edition.
