New Experimental Summary Screen

The latest version (20.5.72) is adding new general ledger engine and I’d like some feedback on this.

Please enable new engine on Summary screen by checking Enable New Summary Screen

image

This is harmless option. You can revert anytime back.

When you enable the option, the figures could be different (hopefully not). If they are, please let me know.

If you can, please use new Summary screen to test it out… here is what’s different (I hope better) in new Summary screen.:

  • Drilling-down now works properly into every control account. Previously when you’ve tried to drill-down into accounts such Billable time or Fixed assets - accumlated depreciation, you’d get general ledger transactions. Now transactions are grouped by their sub-account within every control account.
  • If you are using multiple currencies, drilling-down into control accounts will group sub-accounts by their currency first, then by sub-account itself. This means foreign-currency sub-accounts will now show balances and transaction amounts in their foreign currency rather than the base currency. E.g. drilling down into EUR foreign currency bank account will show transactions in EUR, not in base currency like before.
  • When viewing list of transactions while drilling-down, there are new columns based on the context. For example, drilling-down into expense accounts will show bank account or supplier name. Drilling-down into income accounts will show inventory item or customer etc. It depends on the account itself what columns will be visible.

This has thrown entries into my Suspense accounts and changed some of the account balances.

  1. When I pay my employee, I add a line to the payment for the bank charges levied when the payment is made.
    This now appears in the Suspense Account (UID rather than name) rather than the Bank Charges Account

    Payment

    New format

    Old format
  1. Purchase Invoices from one supplier are now posted to the suspense account
    Suspense account entry

    The Retained Earnings account on the New Summary Screen has been affected by this
    New format
    image
    Old format
    image

The P & L and Balance Sheet reports seem correct

Server Edition has all the symptoms mentioned above for retained earnings, Suspense, UID etc. Notice there is a variation in Tax Payble too. That maybe because of things going into suspense.

@Joe91 the version (20.5.73) should be fixing both issues. Can you check?

This had something to do with using Non-Inventory Items in the Purchase Invoice line

When I remove the Non-Inventory code and post directly to the account it seems to be fixed

I will try the new version

@Joe91 that’s correct. The new version is fixing that.

That has fixed it

No issues on my side

This causes a big change to my Foreign exchange gains (losses) account.

Before:
image

After:
image

As well as the change in the amount, I’m now not able to drill down on it.

(Desktop edition 20.5.73)

It has also caused very small changes to my Accounts receivable and Inventory - cost (23c and 3c differences).

I have a custom clearing account for dealing with freight-in costs (as described here). This had a balance of zero, but with the experimental summary screen now has a very large negative balance.

@lubos, with the new screen (v20.5.74) on a real business, every single sales invoice ever created has moved to Suspense. When drilling down on the Suspense balance, the bread crumbs show the UUID in place of the Suspense account’s name. All customers and every line item in the erroneously moved sales invoices still show correct account allocations, regardless of where else I look at them.

On multiple test businesses, I find such a strange collection of errors I cannot characterize them. Errors include:

  • Some, but not all, sales invoices moved to Suspense
  • Multiple entries in Suspense for a single sales invoice, all with amounts that do not match any line on the actual sales invoice
  • Fixed assets - depreciation balance where none exists in the regular display. Strangely, in this case, the new screen seems correct and the old one incorrect. This anomaly carries over to the Fixed assets, accumulated depreciation account.

Admittedly, some of the errors on test businesses may be the result of butchery while exploring other users’ problems and simulating test cases. (Entries sometimes bear little relationship to actual situations.) That may contribute to the difficulty in characterizing them. But there is no question there are differences between results displayed with the two engines.

@GrahamvdR can you please test with the latest version (20.5.75) ?

Journals to the Withholding Tax account are showing in Suspense account. 20.5.75

The version (20.5.78) is fixing issues raised by @Tut and @AJD

20.5.79
Withholding journals no longer in suspense, but not clearing the withholding accounts correctly. Balances should be zero:

image

Also, drill down on Withholding Tax account produces this error:

image

And, No drilldown available for Retained earnings and Foreign exchange gains

The new summary screen matches the existing summary screen when the accrual basis of accounting is selected. When the accounting method is changed to a cash basis it does not exclude billable time and billable time movement.

1 Like

I had not noticed that. @lubos, this is a major shortcoming for sole traders who have renamed Retained earnings as Owner’s equity.

Retained earnings should not require drill-down. It is arrived at by calculating undistributed net profit. Instead of drilling down on the retained earnings transactions it is more helpful to drill-down on income and expense figures that are unusual. Perhaps the equity section of the summary should show the summary of changes in equity.

Just installed V 20.5.81 and notice that a right-click does not offer the option “Open in a new tab” but only “Open in a new Window”

But maybe it was always like that